1
2
3
4
5
6
7
8
9
10
11
12
13
|
CREATE TABLE t1 (A BOOLEAN);
insert into t1 VALUES ("no");
insert into t1 VALUES ("false");
insert into t1 VALUES ("true");
insert into t1 VALUES ("yes");
--error ER_INVALID_BOOLEAN_VALUE
insert into t1 VALUES ("from");
SELECT A from t1 ORDER BY a;
DROP TABLE t1;
|