1let $MYSQLD_DATADIR= `select @@datadir`; 2 3--echo # 4--echo # Testing FIX null columns 5--echo # 6CREATE TABLE t1 7( 8 id INT NOT NULL, 9 nb INT, 10 msg VARCHAR(12) 11) ENGINE=CONNECT TABLE_TYPE=FIX; 12--error ER_BAD_NULL_ERROR 13INSERT INTO t1 values(NULL,1,'Hello'); 14INSERT INTO t1 values(10,4,NULL),(20,2,'Hello'),(0,0,'Zero'); 15SELECT * FROM t1; 16SELECT* FROM t1 WHERE id IS NULL; 17SELECT * FROM t1 WHERE nb IS NULL; 18SELECT * FROM t1 WHERE msg IS NOT NULL; 19DROP TABLE t1; 20 21--echo # 22--echo # Testing CSV null columns 23--echo # 24CREATE TABLE t1 25( 26 id INT NOT NULL, 27 nb INT, 28 msg VARCHAR(12) 29) ENGINE=CONNECT TABLE_TYPE=CSV HEADER=1; 30--error ER_BAD_NULL_ERROR 31INSERT INTO t1 values(NULL,1,'Hello'); 32INSERT INTO t1 values(10,4,NULL),(20,2,'Hello'),(0,0,'Zero'); 33SELECT * FROM t1; 34SELECT* FROM t1 WHERE id IS NULL; 35SELECT * FROM t1 WHERE nb IS NULL; 36SELECT * FROM t1 WHERE msg IS NOT NULL; 37DROP TABLE t1; 38 39--echo # 40--echo # Testing BIN null columns 41--echo # 42CREATE TABLE t1 43( 44 id INT NOT NULL, 45 nb INT, 46 msg VARCHAR(12) 47) ENGINE=CONNECT TABLE_TYPE=BIN; 48--error ER_BAD_NULL_ERROR 49INSERT INTO t1 values(NULL,1,'Hello'); 50INSERT INTO t1 values(10,4,NULL),(20,2,'Hello'),(0,0,'Zero'); 51SELECT * FROM t1; 52SELECT* FROM t1 WHERE id IS NULL; 53SELECT * FROM t1 WHERE nb IS NULL; 54SELECT * FROM t1 WHERE msg IS NOT NULL; 55DROP TABLE t1; 56 57--echo # 58--echo # Testing DBF null columns 59--echo # 60CREATE TABLE t1 61( 62 id INT NOT NULL, 63 nb INT, 64 msg VARCHAR(12) 65) ENGINE=CONNECT TABLE_TYPE=DBF; 66--error ER_BAD_NULL_ERROR 67INSERT INTO t1 values(NULL,1,'Hello'); 68INSERT INTO t1 values(10,4,NULL),(20,2,'Hello'),(0,0,'Zero'); 69SELECT * FROM t1; 70SELECT* FROM t1 WHERE id IS NULL; 71SELECT * FROM t1 WHERE nb IS NULL; 72SELECT * FROM t1 WHERE msg IS NOT NULL; 73DROP TABLE t1; 74 75--echo # 76--echo # Testing INI null columns 77--echo # 78CREATE TABLE t1 79( 80 `sec` char(8) NOT NULL flag=1, 81 `key` char(12) 82) ENGINE=CONNECT TABLE_TYPE=INI; 83INSERT INTO t1(sec) values('S1'); 84SELECT * FROM t1; 85INSERT INTO t1 values('S1','Newval'); 86SELECT * FROM t1; 87DROP TABLE t1; 88