Details
-
Type:
Bug
-
Status:
Closed
-
Priority:
Minor
-
Resolution: Fixed
-
Affects Version/s: CM8.4.1.201210, CQB8.4.1.201210
-
Fix Version/s: CM8.4.3.201211, CQB8.4.3.201211
-
Component/s: CUBRID Manager, CUBRID Query Browser
-
Labels:
Description
1. Create table by following ddl:
CREATE TABLE "nw_rsv3"(
"rsv_no" bigint AUTO_INCREMENT NOT NULL,
"prj_code" character varying(20),
"sdate" character varying(8),
"edate" character varying(8),
"last_updated" character varying(14),
"leadtime" bigint,
"rev_counts" integer DEFAULT 0,
"status_code" character(1) DEFAULT 'N',
CONSTRAINT pk_nw_rsv_rsv_no PRIMARY KEY("rsv_no")
);
CREATE INDEX"ix_rsv_status" ON "nw_rsv3"("status_code","rsv_no");
2. Edit column "rsv_no" change current value to "5".
3. Then go to SQL script tab, you will find the sql is incorrect.
Fixed in CM8.4.3.3005 and CQB8.4.3.3005