mirror of
https://github.com/MariaDB/server.git
synced 2025-12-08 21:35:44 +01:00
134 lines
2.6 KiB
Text
134 lines
2.6 KiB
Text
#
|
|
# Testing FIX null columns
|
|
#
|
|
CREATE TABLE t1
|
|
(
|
|
id INT NOT NULL,
|
|
nb INT,
|
|
msg VARCHAR(12)
|
|
) ENGINE=CONNECT TABLE_TYPE=FIX;
|
|
Warnings:
|
|
Warning 1105 No file name. Table will use t1.fix
|
|
INSERT INTO t1 values(NULL,1,'Hello');
|
|
ERROR 23000: Column 'id' cannot be null
|
|
INSERT INTO t1 values(10,4,NULL),(20,2,'Hello'),(0,0,'Zero');
|
|
SELECT * FROM t1;
|
|
id nb msg
|
|
10 4 NULL
|
|
20 2 Hello
|
|
0 NULL Zero
|
|
SELECT* FROM t1 WHERE id IS NULL;
|
|
id nb msg
|
|
SELECT * FROM t1 WHERE nb IS NULL;
|
|
id nb msg
|
|
0 NULL Zero
|
|
SELECT * FROM t1 WHERE msg IS NOT NULL;
|
|
id nb msg
|
|
20 2 Hello
|
|
0 NULL Zero
|
|
DROP TABLE t1;
|
|
#
|
|
# Testing CSV null columns
|
|
#
|
|
CREATE TABLE t1
|
|
(
|
|
id INT NOT NULL,
|
|
nb INT,
|
|
msg VARCHAR(12)
|
|
) ENGINE=CONNECT TABLE_TYPE=CSV HEADER=1;
|
|
Warnings:
|
|
Warning 1105 No file name. Table will use t1.csv
|
|
INSERT INTO t1 values(NULL,1,'Hello');
|
|
ERROR 23000: Column 'id' cannot be null
|
|
INSERT INTO t1 values(10,4,NULL),(20,2,'Hello'),(0,0,'Zero');
|
|
SELECT * FROM t1;
|
|
id nb msg
|
|
10 4 NULL
|
|
20 2 Hello
|
|
0 NULL Zero
|
|
SELECT* FROM t1 WHERE id IS NULL;
|
|
id nb msg
|
|
SELECT * FROM t1 WHERE nb IS NULL;
|
|
id nb msg
|
|
0 NULL Zero
|
|
SELECT * FROM t1 WHERE msg IS NOT NULL;
|
|
id nb msg
|
|
20 2 Hello
|
|
0 NULL Zero
|
|
DROP TABLE t1;
|
|
#
|
|
# Testing BIN null columns
|
|
#
|
|
CREATE TABLE t1
|
|
(
|
|
id INT NOT NULL,
|
|
nb INT,
|
|
msg VARCHAR(12)
|
|
) ENGINE=CONNECT TABLE_TYPE=BIN;
|
|
Warnings:
|
|
Warning 1105 No file name. Table will use t1.bin
|
|
INSERT INTO t1 values(NULL,1,'Hello');
|
|
ERROR 23000: Column 'id' cannot be null
|
|
INSERT INTO t1 values(10,4,NULL),(20,2,'Hello'),(0,0,'Zero');
|
|
SELECT * FROM t1;
|
|
id nb msg
|
|
10 4 NULL
|
|
20 2 Hello
|
|
0 NULL Zero
|
|
SELECT* FROM t1 WHERE id IS NULL;
|
|
id nb msg
|
|
SELECT * FROM t1 WHERE nb IS NULL;
|
|
id nb msg
|
|
0 NULL Zero
|
|
SELECT * FROM t1 WHERE msg IS NOT NULL;
|
|
id nb msg
|
|
20 2 Hello
|
|
0 NULL Zero
|
|
DROP TABLE t1;
|
|
#
|
|
# Testing DBF null columns
|
|
#
|
|
CREATE TABLE t1
|
|
(
|
|
id INT NOT NULL,
|
|
nb INT,
|
|
msg VARCHAR(12)
|
|
) ENGINE=CONNECT TABLE_TYPE=DBF;
|
|
Warnings:
|
|
Warning 1105 No file name. Table will use t1.dbf
|
|
INSERT INTO t1 values(NULL,1,'Hello');
|
|
ERROR 23000: Column 'id' cannot be null
|
|
INSERT INTO t1 values(10,4,NULL),(20,2,'Hello'),(0,0,'Zero');
|
|
SELECT * FROM t1;
|
|
id nb msg
|
|
10 4 NULL
|
|
20 2 Hello
|
|
0 NULL Zero
|
|
SELECT* FROM t1 WHERE id IS NULL;
|
|
id nb msg
|
|
SELECT * FROM t1 WHERE nb IS NULL;
|
|
id nb msg
|
|
0 NULL Zero
|
|
SELECT * FROM t1 WHERE msg IS NOT NULL;
|
|
id nb msg
|
|
20 2 Hello
|
|
0 NULL Zero
|
|
DROP TABLE t1;
|
|
#
|
|
# Testing INI null columns
|
|
#
|
|
CREATE TABLE t1
|
|
(
|
|
`sec` char(8) NOT NULL flag=1,
|
|
`key` char(12)
|
|
) ENGINE=CONNECT TABLE_TYPE=INI;
|
|
Warnings:
|
|
Warning 1105 No file name. Table will use t1.ini
|
|
INSERT INTO t1(sec) values('S1');
|
|
SELECT * FROM t1;
|
|
sec key
|
|
INSERT INTO t1 values('S1','Newval');
|
|
SELECT * FROM t1;
|
|
sec key
|
|
S1 Newval
|
|
DROP TABLE t1;
|