1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
|
# Deprecation warning
SHOW GLOBAL VARIABLES WHERE Variable_name LIKE "abc";
# No warnings
SHOW GLOBAL VARIABLES LIKE "abc";
# Deprecation warning
SHOW SESSION VARIABLES WHERE Variable_name LIKE "abc";
# No warnings
SHOW SESSION VARIABLES LIKE "abc";
# Deprecation warning
SHOW VARIABLES WHERE Variable_name LIKE "abc";
# No warnings
SHOW VARIABLES LIKE "abc";
--echo #
--echo # Bug#29664758: REGRESSION: ASSERTION FAILED: M_WHERE_COND->IS_BOOL_FUNC()
--echo #
CREATE TABLE t1 (i INT);
SHOW DATABASES WHERE 0;
SHOW TABLES WHERE 0;
SHOW TRIGGERS WHERE 0;
SHOW EVENTS WHERE 0;
SHOW TABLE STATUS WHERE 0;
SHOW OPEN TABLES WHERE 0;
SHOW COLUMNS FROM t1 WHERE 0;
SHOW KEYS FROM t1 WHERE 0;
SHOW STATUS WHERE 0;
SHOW VARIABLES WHERE 0;
SHOW CHARACTER SET WHERE 0;
SHOW COLLATION WHERE 0;
SHOW PROCEDURE STATUS WHERE 0;
SHOW FUNCTION STATUS WHERE 0;
DROP TABLE t1;
--echo # Bug#31667061: Inconsistent behavior of @@SQL_SELECT_LIMIT
--echo # with prepared statements
CREATE TABLE t1(a INTEGER, b INTEGER, c INTEGER, d INTEGER);
SET @@sql_select_limit=1;
PREPARE stmt FROM "SHOW COLUMNS FROM t1";
EXECUTE stmt;
set @@sql_select_limit=2;
EXECUTE stmt;
set @@sql_select_limit=DEFAULT;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;
DROP TABLE t1;
|
