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