1
CREATE TABLE t1 (A BOOLEAN DEFAULT TRUE);
5
`A` BOOLEAN DEFAULT 'TRUE'
6
) ENGINE=InnoDB COLLATE = utf8_general_ci
7
INSERT INTO t1 VALUES ();
12
CREATE TABLE t1 (A BOOLEAN DEFAULT FALSE);
15
t1 CREATE TABLE `t1` (
16
`A` BOOLEAN DEFAULT 'FALSE'
17
) ENGINE=InnoDB COLLATE = utf8_general_ci
18
INSERT INTO t1 VALUES ();
23
CREATE TABLE t1 (A BOOLEAN DEFAULT NULL);
26
t1 CREATE TABLE `t1` (
27
`A` BOOLEAN DEFAULT NULL
28
) ENGINE=InnoDB COLLATE = utf8_general_ci
29
INSERT INTO t1 VALUES ();
34
CREATE TABLE t1 (A BOOLEAN DEFAULT "");
35
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near '"")' at line 1
36
CREATE TABLE t1 (A BOOLEAN DEFAULT "false");
37
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near '"false")' at line 1
38
CREATE TABLE t1 (A BOOLEAN DEFAULT 0);
39
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near '0)' at line 1
40
CREATE TABLE t1 (A BOOLEAN DEFAULT 1);
41
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near '1)' at line 1