10
SELECT ASSERT(ASSERT(TRUE));
16
SELECT (SELECT 1) UNION SELECT (SELECT ASSERT(TRUE));
19
SELECT (SELECT ASSERT(TRUE)) UNION SELECT (SELECT ASSERT(TRUE));
22
SELECT (SELECT ASSERT(TRUE)) UNION SELECT (SELECT 1);
26
ERROR HY000: Assertion 'FALSE' failed.
27
SELECT ASSERT(ASSERT(FALSE));
28
ERROR HY000: Assertion 'FALSE' failed.
30
ERROR HY000: Assertion 'NULL' failed, the result was NULL.
32
ERROR HY000: Assertion '(1 - 1)' failed.
34
ERROR HY000: Assertion '(1 < 0)' failed.
35
SELECT (SELECT (SELECT (ASSERT(1 -1))));
36
ERROR HY000: Assertion '(1 - 1)' failed.
37
SELECT 1 FROM (SELECT ASSERT(FALSE)) failure;
38
ERROR HY000: Assertion 'FALSE' failed.
39
SELECT (SELECT 1) UNION SELECT (SELECT ASSERT(FALSE));
40
ERROR HY000: Assertion 'FALSE' failed.
41
SELECT (SELECT ASSERT(FALSE)) UNION SELECT (SELECT ASSERT(FALSE));
42
ERROR HY000: Assertion 'FALSE' failed.
43
SELECT (SELECT ASSERT(FALSE)) UNION SELECT (SELECT 1);
44
ERROR HY000: Assertion 'FALSE' failed.
45
select ASSERT(IF((0 > 1),1, NULL));
46
ERROR HY000: Assertion 'if((0 > 1),1,NULL)' failed, the result was NULL.
47
CREATE TABLE t1 (a int);
48
SELECT ASSERT(COUNT(a)) FROM t1;
49
ERROR HY000: Assertion 'count(`test`.`t1`.`a`)' failed.
50
INSERT INTO t1 VALUES ();
51
SELECT ASSERT(COUNT(*)) FROM t1;
54
SELECT ASSERT(COUNT(a)) FROM t1;
55
ERROR HY000: Assertion 'count(`test`.`t1`.`a`)' failed.
57
CREATE TABLE t1 AS SELECT ASSERT(TRUE);
62
CREATE TABLE t1 AS SELECT ASSERT(FALSE);
63
ERROR HY000: Assertion 'FALSE' failed.
64
SELECT ASSERT(COUNT(*) = 0) FROM DATA_DICTIONARY.TABLES WHERE TABLE_NAME="t1" AND TABLE_SCHEMA=SCHEMA();