Debian Codegraph @

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

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