Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
None
-
None
Description
create table fact ( |
i1 tinyint,
|
i2 smallint, |
-- i3 mediumint,
|
i4 int, |
i8 bigint, |
i1u tinyint unsigned,
|
i2u smallint unsigned, |
-- i3u mediumint unsigned,
|
i4u int unsigned, |
i8u bigint unsigned, |
d1 decimal(65), |
d2 decimal(65,1), |
d3 decimal(65,30), |
d5 decimal(5,5), |
f1 float, |
f2 float(2,1), |
f23 float(23,4), |
f24 float(24,10), |
f53 float(53,20), |
r1 real, |
r23 real(23,4), |
r24 real(24,10), |
r53 real(53,20), |
-- dp1 double precision,
|
-- b0 bit(0),
|
-- b1 bit(1),
|
-- b64 bit(64),
|
d date, |
dt datetime,
|
-- ts timestamp,
|
-- t time,
|
-- y2 year(2),
|
-- y4 year(4),
|
c0 char(0), |
c1 char(1), |
c2 char(255), |
vc0 varchar(0), |
vc1 varchar(1), |
vc2 varchar(255) |
-- vb0 varbinary(0),
|
-- vb1 varbinary(1),
|
-- vb2 varbinary(255),
|
-- bi0 binary(0),
|
-- bi1 binary(1),
|
-- bi2 binary(255)
|
-- bl0 blob(0),
|
-- bl1 blob(1),
|
-- bl2 blob(255),
|
-- tx0 text(0),
|
-- tx1 text(1),
|
-- tx2 text(255),
|
-- e1 enum('a'),
|
-- e2 enum(' ', 'a'),
|
-- e3 enum(' ', 'a', 'abc'),
|
-- s1 set('a'),
|
-- s2 set(' ', 'a'),
|
-- s3 set(' ', 'a', 'abc')
|
) ENGINE=COLUMNSTORE
|
1815Internal error: CAL0009: (3)Create table failed due to Syntax error: The maximum precision (total number of digits) that can be specified is 18
|