|
autopilot test fail to create the table for supported data types
and breaks test execution
it's found that the test table is not created due to returned Error ERROR 1178 (42000): The storage engine for the table doesn't support The syntax or the data type(s) is not supported by Columnstore
for column defined with datatype TIME .
]# ./autopilot.sh systemTest datatypes
innodb_version 5.7.24
protocol_version 10
slave_type_conversions
version 10.2.21-MariaDB-log
version_comment Columnstore 1.1.7-1
version_compile_machine x86_64
version_compile_os Linux
version_malloc_library system
version_ssl_library OpenSSL 1.0.2k-fips 26 Jan 2017
================================================
systemTest.datatypes.
================================================
Test script: /root/autopilot234/systemTest/datatypes/testcase/goAll.sh
ERROR 1051 (42S02) at line 1: Unknown table 'mytest.datatypetestm'
ERROR 1178 (42000) at line 2: The storage engine for the table doesn't support The syntax or the data type(s) is not supported by Columnstore. Please check the Columnstore syntax guid
SQL script
cat /root/autopilot234/tests/tests_2019-01-17--15-30-52/systemTest/datatypes/createDataTypeTable_c.sql
|
drop table datatypetestm;
|
create table datatypetestm (
|
snIDX INTEGER,
|
snBIGINT BIGINT ,
|
snDECIMAL1 DECIMAL(1) ,
|
snDECIMAL4 DECIMAL(4) ,
|
snDECIMAL4_2 DECIMAL(4,2) ,
|
snDECIMAL5 DECIMAL(5) ,
|
snDECIMAL9 DECIMAL(9) ,
|
snDECIMAL9_2 DECIMAL(9,2) ,
|
snDECIMAL10 DECIMAL(10) ,
|
snDECIMAL18 DECIMAL(18) ,
|
snDECIMAL18_2 DECIMAL(18,2) ,
|
snINTEGER INTEGER ,
|
snSMALLINT SMALLINT ,
|
snTINYINT TINYINT ,
|
dDATE DATE ,
|
dDATETIME DATETIME ,
|
dTIME TIME ,
|
sCHAR1 CHAR(1) ,
|
sCHAR2 CHAR(2) ,
|
sCHAR3 CHAR(3) ,
|
sCHAR4 CHAR(4) ,
|
sCHAR5 CHAR(5) ,
|
sCHAR6 CHAR(6) ,
|
sCHAR7 CHAR(7) ,
|
sCHAR8 CHAR(8) ,
|
sCHAR9 CHAR(9) ,
|
sCHAR255 CHAR(255) ,
|
sVARCHAR1 VARCHAR(1) ,
|
sVARCHAR2 VARCHAR(2) ,
|
sVARCHAR3 VARCHAR(3) ,
|
sVARCHAR4 VARCHAR(4) ,
|
sVARCHAR5 VARCHAR(5) ,
|
sVARCHAR6 VARCHAR(6) ,
|
sVARCHAR7 VARCHAR(7) ,
|
sVARCHAR8 VARCHAR(8) ,
|
sVARCHAR255 VARCHAR(255) ,
|
unBIGINT BIGINT unsigned,
|
unDECIMAL1 DECIMAL(1) unsigned,
|
unDECIMAL4 DECIMAL(4) unsigned,
|
unDECIMAL4_2 DECIMAL(4,2) unsigned,
|
unDECIMAL5 DECIMAL(5) unsigned,
|
unDECIMAL9 DECIMAL(9) unsigned,
|
unDECIMAL9_2 DECIMAL(9,2) unsigned,
|
unDECIMAL10 DECIMAL(10) unsigned,
|
unDECIMAL18 DECIMAL(18) unsigned,
|
unDECIMAL18_2 DECIMAL(18,2) unsigned,
|
unINTEGER INTEGER unsigned,
|
unSMALLINT SMALLINT unsigned,
|
unTINYINT TINYINT unsigned)
|
engine=Columnstore;
|
|
MariaDB [mytest]> create table datatypetestm (
|
-> snIDX INTEGER,
|
-> snBIGINT BIGINT ,
|
-> snDECIMAL1 DECIMAL(1) ,
|
-> snDECIMAL4 DECIMAL(4) ,
|
-> snDECIMAL4_2 DECIMAL(4,2) ,
|
-> snDECIMAL5 DECIMAL(5) ,
|
-> snDECIMAL9 DECIMAL(9) ,
|
-> snDECIMAL9_2 DECIMAL(9,2) ,
|
-> snDECIMAL10 DECIMAL(10) ,
|
-> snDECIMAL18 DECIMAL(18) ,
|
-> snDECIMAL18_2 DECIMAL(18,2) ,
|
-> snINTEGER INTEGER ,
|
-> snSMALLINT SMALLINT ,
|
-> snTINYINT TINYINT ,
|
-> dDATE DATE ,
|
-> dDATETIME DATETIME ,
|
-> dTIME TIME ,
|
-> sCHAR1 CHAR(1) ,
|
-> sCHAR2 CHAR(2) ,
|
-> sCHAR3 CHAR(3) ,
|
-> sCHAR4 CHAR(4) ,
|
-> sCHAR5 CHAR(5) ,
|
-> sCHAR6 CHAR(6) ,
|
-> sCHAR7 CHAR(7) ,
|
-> sCHAR8 CHAR(8) ,
|
-> sCHAR9 CHAR(9) ,
|
-> sCHAR255 CHAR(255) ,
|
-> sVARCHAR1 VARCHAR(1) ,
|
-> sVARCHAR2 VARCHAR(2) ,
|
-> sVARCHAR3 VARCHAR(3) ,
|
-> sVARCHAR4 VARCHAR(4) ,
|
-> sVARCHAR5 VARCHAR(5) ,
|
-> sVARCHAR6 VARCHAR(6) ,
|
-> sVARCHAR7 VARCHAR(7) ,
|
-> sVARCHAR8 VARCHAR(8) ,
|
-> sVARCHAR255 VARCHAR(255) ,
|
-> unBIGINT BIGINT unsigned,
|
-> unDECIMAL1 DECIMAL(1) unsigned,
|
-> unDECIMAL4 DECIMAL(4) unsigned,
|
-> unDECIMAL4_2 DECIMAL(4,2) unsigned,
|
-> unDECIMAL5 DECIMAL(5) unsigned,
|
-> unDECIMAL9 DECIMAL(9) unsigned,
|
-> unDECIMAL9_2 DECIMAL(9,2) unsigned,
|
-> unDECIMAL10 DECIMAL(10) unsigned,
|
-> unDECIMAL18 DECIMAL(18) unsigned,
|
-> unDECIMAL18_2 DECIMAL(18,2) unsigned,
|
-> unINTEGER INTEGER unsigned,
|
-> unSMALLINT SMALLINT unsigned,
|
-> unTINYINT TINYINT unsigned)
|
-> engine=Columnstore;
|
ERROR 1178 (42000): The storage engine for the table doesn't support The syntax or the data type(s) is not supported by Columnstore. Please check the Columnstore syntax guide for supported syntax or data types.
|
MariaDB [mytest]>
|
|
MariaDB [mytest]> create table datatypetestm7 ( snINTEGER INTEGER , snSMALLINT SMALLINT , snTINYINT TINYINT , dDATE DATE , dDATETIME DATETIME , dTIME TIME ) engine columnstore; ERROR 1178 (42000): The storage engine for the table doesn't support The syntax or the data type(s) is not supported by Columnstore. Please check the Columnstore syntax guide for supported syntax or data types.
|
MariaDB [mytest]>
|
MariaDB [mytest]>
|
MariaDB [mytest]> create table datatypetestm7 ( snINTEGER INTEGER , snSMALLINT SMALLINT , snTINYINT TINYINT , dDATE DATE , dDATETIME DATETIME ) engine columnstore;
|
Query OK, 0 rows affected (0.156 sec)
|
|
|
|