Details
-
Type:
Bug
-
Status:
Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: CM8.4.1.201208, CQB8.4.1.201208
-
Fix Version/s: CM8.4.1.201208, CQB8.4.1.201208
-
Component/s: CUBRID Manager, CUBRID Query Browser
-
Labels:
Description
1 We can input the sql in query editor. But cannot input the range in UI.
CREATE TABLE "traffic_log"(
"user_id" character varying(30),
"file_url" character varying(256),
"file_size" bigint,
"action" smallint,
"client" smallint,
"state" character(1),
"ip" character varying(15),
"log_dt" timestamp
)
partition by range (log_dt)(
PARTITION P00 VALUES LESS THAN (timestamp '12:00:00 AM 01/01/2011'),
PARTITION P20 VALUES LESS THAN (timestamp '12:00:00 AM 05/21/2011'),
PARTITION P21 VALUES LESS THAN (timestamp '12:00:00 AM 05/22/2011'),
PARTITION P22 VALUES LESS THAN (timestamp '12:00:00 AM 05/23/2011'),
PARTITION P23 VALUES LESS THAN (timestamp '12:00:00 AM 05/24/2011')
);
2 In edit table, add one partition as attached image, it will pop “The expression range value can only be an integer.”