55 lines
1.2 KiB
Text
55 lines
1.2 KiB
Text
|
|
# 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;
|