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
56
57
58
59
60
61
62
63
64
65
66
67
|
SHOW GLOBAL VARIABLES WHERE Variable_name LIKE "abc";
Variable_name Value
SHOW GLOBAL VARIABLES LIKE "abc";
Variable_name Value
SHOW SESSION VARIABLES WHERE Variable_name LIKE "abc";
Variable_name Value
SHOW SESSION VARIABLES LIKE "abc";
Variable_name Value
SHOW VARIABLES WHERE Variable_name LIKE "abc";
Variable_name Value
SHOW VARIABLES LIKE "abc";
Variable_name Value
#
# Bug#29664758: REGRESSION: ASSERTION FAILED: M_WHERE_COND->IS_BOOL_FUNC()
#
CREATE TABLE t1 (i INT);
SHOW DATABASES WHERE 0;
Database
SHOW TABLES WHERE 0;
Tables_in_test
SHOW TRIGGERS WHERE 0;
Trigger Event Table Statement Timing Created sql_mode Definer character_set_client collation_connection Database Collation
SHOW EVENTS WHERE 0;
Db Name Definer Time zone Type Execute at Interval value Interval field Starts Ends Status Originator character_set_client collation_connection Database Collation
SHOW TABLE STATUS WHERE 0;
Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment
SHOW OPEN TABLES WHERE 0;
Database Table In_use Name_locked
SHOW COLUMNS FROM t1 WHERE 0;
Field Type Null Key Default Extra
SHOW KEYS FROM t1 WHERE 0;
Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment Visible Expression
SHOW STATUS WHERE 0;
Variable_name Value
SHOW VARIABLES WHERE 0;
Variable_name Value
SHOW CHARACTER SET WHERE 0;
Charset Description Default collation Maxlen
SHOW COLLATION WHERE 0;
Collation Charset Id Default Compiled Sortlen Pad_attribute
SHOW PROCEDURE STATUS WHERE 0;
Db Name Type Definer Modified Created Security_type Comment character_set_client collation_connection Database Collation
SHOW FUNCTION STATUS WHERE 0;
Db Name Type Definer Modified Created Security_type Comment character_set_client collation_connection Database Collation
DROP TABLE t1;
# Bug#31667061: Inconsistent behavior of @@SQL_SELECT_LIMIT
# 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;
Field Type Null Key Default Extra
a int YES NULL
set @@sql_select_limit=2;
EXECUTE stmt;
Field Type Null Key Default Extra
a int YES NULL
b int YES NULL
set @@sql_select_limit=DEFAULT;
EXECUTE stmt;
Field Type Null Key Default Extra
a int YES NULL
b int YES NULL
c int YES NULL
d int YES NULL
DEALLOCATE PREPARE stmt;
DROP TABLE t1;
|
