drop table if exists datatypetestm;
Create table datatypetestm (
CIDX 		INTEGER,
CBIGINT 	BIGINT,
CDECIMAL1 	DECIMAL(1),
CDECIMAL4 	DECIMAL(4),
CDECIMAL4_2 	DECIMAL(4,2),
CDECIMAL5 	DECIMAL(5),
CDECIMAL9 	DECIMAL(9),
CDECIMAL9_2 	DECIMAL(9,2),
CDECIMAL10 	DECIMAL(10),
CDECIMAL18 	DECIMAL(18),
CDECIMAL18_2 	DECIMAL(18,2),
CINTEGER 	INTEGER,
CSMALLINT 	SMALLINT,
CTINYINT 	TINYINT,
CDOUBLE 	DOUBLE,
CFLOAT		FLOAT,
CDATE 		DATE,
CDATETIME 	DATETIME,
CCHAR1 	CHAR(1),
CCHAR2 	CHAR(2),
CCHAR3 	CHAR(3),
CCHAR4 	CHAR(4),
CCHAR5 	CHAR(5),
CCHAR6 	CHAR(6),
CCHAR7 	CHAR(7),
CCHAR8 	CHAR(8),
CCHAR9 	CHAR(9),
CCHAR255 	CHAR(255),
CVCHAR1 	VARCHAR(1),
CVCHAR2 	VARCHAR(2),
CVCHAR3 	VARCHAR(3),
CVCHAR4 	VARCHAR(4),
CVCHAR5 	VARCHAR(5),
CVCHAR6 	VARCHAR(6),
CVCHAR7 	VARCHAR(7),
CVCHAR8 	VARCHAR(8),
CVCHAR255 	VARCHAR(255),
CTEXT		TEXT,
CLONGTEXT	LONGTEXT,
CBLOB		BLOB,
CLONGBLOB	LONGBLOB
) engine=columnstore;



