EVOLUTION-MANAGER

Edit File: 1st.result

DROP TABLE IF EXISTS t1; CREATE TABLE t1 (pk INT PRIMARY KEY DEFAULT '0', a INT(11), b CHAR(8)) ENGINE=rocksdb; SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `pk` int(11) NOT NULL DEFAULT 0, `a` int(11) DEFAULT NULL, `b` char(8) DEFAULT NULL, PRIMARY KEY (`pk`) ) ENGINE=ROCKSDB DEFAULT CHARSET=latin1 SHOW COLUMNS IN t1; Field Type Null Key Default Extra pk int(11) NO PRI 0 a int(11) YES NULL b char(8) YES NULL INSERT INTO t1 VALUES (1, 1,'a'); INSERT INTO t1 (a,b) VALUES (2,'b'); SELECT a,b FROM t1; a b 1 a 2 b DROP TABLE t1;