Debian Codegraph @

mysql-test/suite/funcs_1/r/is_tables_myisam.result

raw
1 SET @@session.sql_mode = 'NO_ENGINE_SUBSTITUTION';
2 DROP DATABASE IF EXISTS test1;
3 DROP DATABASE IF EXISTS test2;
4 CREATE DATABASE test1;
5 CREATE DATABASE test2;
6 CREATE TABLE test1.t1 (f1 VARCHAR(20)) ENGINE = <engine_to_be_used>;
7 CREATE TABLE test1.t2 (f1 VARCHAR(20)) ENGINE = <engine_to_be_used>;
8 CREATE TABLE test2.t1 (f1 VARCHAR(20)) ENGINE = <engine_to_be_used>;
9 SELECT *,
10 LEFT( table_comment,
11 IF(INSTR(table_comment,'InnoDB free') = 0,
12 LENGTH(table_comment),
13 INSTR(table_comment,'InnoDB free') - 1))
14 AS "user_comment",
15 '-----------------------------------------------------' AS "Separator"
16 FROM information_schema.tables
17 WHERE table_schema LIKE 'test%' AND table_type = 'BASE TABLE'
18 ORDER BY table_schema,table_name;
19 TABLE_CATALOG def
20 TABLE_SCHEMA test1
21 TABLE_NAME t1
22 TABLE_TYPE BASE TABLE
23 ENGINE MYISAM_OR_MARIA
24 VERSION 10
25 ROW_FORMAT DYNAMIC_OR_PAGE
26 TABLE_ROWS #TBLR#
27 AVG_ROW_LENGTH #ARL#
28 DATA_LENGTH #DL#
29 MAX_DATA_LENGTH #MDL#
30 INDEX_LENGTH #IL#
31 DATA_FREE #DF#
32 AUTO_INCREMENT NULL
33 CREATE_TIME #CRT#
34 UPDATE_TIME #UT#
35 CHECK_TIME #CT#
36 TABLE_COLLATION utf8mb4_uca1400_ai_ci
37 CHECKSUM NULL
38 CREATE_OPTIONS #CO#
39 TABLE_COMMENT #TC#
40 MAX_INDEX_LENGTH #MIL#
41 TEMPORARY N
42 user_comment
43 Separator -----------------------------------------------------
44 TABLE_CATALOG def
45 TABLE_SCHEMA test1
46 TABLE_NAME t2
47 TABLE_TYPE BASE TABLE
48 ENGINE MYISAM_OR_MARIA
49 VERSION 10
50 ROW_FORMAT DYNAMIC_OR_PAGE
51 TABLE_ROWS #TBLR#
52 AVG_ROW_LENGTH #ARL#
53 DATA_LENGTH #DL#
54 MAX_DATA_LENGTH #MDL#
55 INDEX_LENGTH #IL#
56 DATA_FREE #DF#
57 AUTO_INCREMENT NULL
58 CREATE_TIME #CRT#
59 UPDATE_TIME #UT#
60 CHECK_TIME #CT#
61 TABLE_COLLATION utf8mb4_uca1400_ai_ci
62 CHECKSUM NULL
63 CREATE_OPTIONS #CO#
64 TABLE_COMMENT #TC#
65 MAX_INDEX_LENGTH #MIL#
66 TEMPORARY N
67 user_comment
68 Separator -----------------------------------------------------
69 TABLE_CATALOG def
70 TABLE_SCHEMA test2
71 TABLE_NAME t1
72 TABLE_TYPE BASE TABLE
73 ENGINE MYISAM_OR_MARIA
74 VERSION 10
75 ROW_FORMAT DYNAMIC_OR_PAGE
76 TABLE_ROWS #TBLR#
77 AVG_ROW_LENGTH #ARL#
78 DATA_LENGTH #DL#
79 MAX_DATA_LENGTH #MDL#
80 INDEX_LENGTH #IL#
81 DATA_FREE #DF#
82 AUTO_INCREMENT NULL
83 CREATE_TIME #CRT#
84 UPDATE_TIME #UT#
85 CHECK_TIME #CT#
86 TABLE_COLLATION utf8mb4_uca1400_ai_ci
87 CHECKSUM NULL
88 CREATE_OPTIONS #CO#
89 TABLE_COMMENT #TC#
90 MAX_INDEX_LENGTH #MIL#
91 TEMPORARY N
92 user_comment
93 Separator -----------------------------------------------------
94 SHOW TABLES FROM test1;
95 Tables_in_test1
96 t1
97 t2
98 SHOW TABLES FROM test2;
99 Tables_in_test2
100 t1
101 DROP USER testuser1@localhost;
102 CREATE USER testuser1@localhost;
103 GRANT SELECT ON test1.* TO testuser1@localhost;
104 connect testuser1,localhost,testuser1,,test1;
105 SELECT *,
106 LEFT( table_comment,
107 IF(INSTR(table_comment,'InnoDB free') = 0,
108 LENGTH(table_comment),
109 INSTR(table_comment,'InnoDB free') - 1))
110 AS "user_comment",
111 '-----------------------------------------------------' AS "Separator"
112 FROM information_schema.tables
113 WHERE table_schema LIKE 'test%' AND table_type = 'BASE TABLE'
114 ORDER BY table_schema,table_name;
115 TABLE_CATALOG def
116 TABLE_SCHEMA test1
117 TABLE_NAME t1
118 TABLE_TYPE BASE TABLE
119 ENGINE MYISAM_OR_MARIA
120 VERSION 10
121 ROW_FORMAT DYNAMIC_OR_PAGE
122 TABLE_ROWS #TBLR#
123 AVG_ROW_LENGTH #ARL#
124 DATA_LENGTH #DL#
125 MAX_DATA_LENGTH #MDL#
126 INDEX_LENGTH #IL#
127 DATA_FREE #DF#
128 AUTO_INCREMENT NULL
129 CREATE_TIME #CRT#
130 UPDATE_TIME #UT#
131 CHECK_TIME #CT#
132 TABLE_COLLATION utf8mb4_uca1400_ai_ci
133 CHECKSUM NULL
134 CREATE_OPTIONS #CO#
135 TABLE_COMMENT #TC#
136 MAX_INDEX_LENGTH #MIL#
137 TEMPORARY N
138 user_comment
139 Separator -----------------------------------------------------
140 TABLE_CATALOG def
141 TABLE_SCHEMA test1
142 TABLE_NAME t2
143 TABLE_TYPE BASE TABLE
144 ENGINE MYISAM_OR_MARIA
145 VERSION 10
146 ROW_FORMAT DYNAMIC_OR_PAGE
147 TABLE_ROWS #TBLR#
148 AVG_ROW_LENGTH #ARL#
149 DATA_LENGTH #DL#
150 MAX_DATA_LENGTH #MDL#
151 INDEX_LENGTH #IL#
152 DATA_FREE #DF#
153 AUTO_INCREMENT NULL
154 CREATE_TIME #CRT#
155 UPDATE_TIME #UT#
156 CHECK_TIME #CT#
157 TABLE_COLLATION utf8mb4_uca1400_ai_ci
158 CHECKSUM NULL
159 CREATE_OPTIONS #CO#
160 TABLE_COMMENT #TC#
161 MAX_INDEX_LENGTH #MIL#
162 TEMPORARY N
163 user_comment
164 Separator -----------------------------------------------------
165 SHOW TABLES FROM test1;
166 Tables_in_test1
167 t1
168 t2
169 SHOW TABLES FROM test2;
170 ERROR 42000: Access denied for user 'testuser1'@'localhost' to database 'test2'
171 connection default;
172 disconnect testuser1;
173 DROP USER testuser1@localhost;
174 DROP DATABASE test1;
175 DROP DATABASE test2;