1
1
DROP DATABASE IF EXISTS test1;
2
DROP DATABASE IF EXISTS test2;
2
3
CREATE DATABASE test1;
6
DROP TABLE IF EXISTS t1, t2, t4, t10, t11;
7
CREATE TABLE t1 (f1 char(20), f2 char(25), f3 date, f4 int, f5 char(25), f6 int) ENGINE = NDB;
8
CREATE TABLE t2 (f1 char(20), f2 char(25), f3 date, f4 int, f5 char(25), f6 int) ENGINE = NDB;
9
CREATE TABLE t4 (f1 char(20), f2 char(25), f3 date, f4 int, f5 char(25), f6 int) ENGINE = NDB;
10
CREATE TABLE t10 (f1 char(20), f2 char(25), f3 date, f4 int, f5 char(25), f6 int) ENGINE = NDB;
11
CREATE TABLE t11 (f1 char(20), f2 char(25), f3 date, f4 int, f5 char(25), f6 int) ENGINE = NDB;
12
LOAD DATA INFILE 'MYSQL_TEST_DIR/suite/funcs_1/data/t4.txt' INTO TABLE t1;
13
LOAD DATA INFILE 'MYSQL_TEST_DIR/suite/funcs_1/data/t4.txt' INTO TABLE t2;
14
LOAD DATA INFILE 'MYSQL_TEST_DIR/suite/funcs_1/data/t4.txt' INTO TABLE t4;
15
LOAD DATA INFILE 'MYSQL_TEST_DIR/suite/funcs_1/data/t4.txt' INTO TABLE t10;
16
LOAD DATA INFILE 'MYSQL_TEST_DIR/suite/funcs_1/data/t4.txt' INTO TABLE t11;
17
drop TABLE if exists t3;
18
CREATE TABLE t3 (f1 char(20), f2 char(20), f3 integer) ENGINE = NDB;
19
LOAD DATA INFILE 'MYSQL_TEST_DIR/suite/funcs_1/data/t3.txt' INTO TABLE t3;
20
drop database if exists test4;
21
CREATE database test4;
23
CREATE TABLE t6 (f1 char(20), f2 char(25), f3 date, f4 int, f5 char(25), f6 int) ENGINE = NDB;
24
LOAD DATA INFILE 'MYSQL_TEST_DIR/suite/funcs_1/data/t4.txt' INTO TABLE t6;
26
drop TABLE if exists t7, t8;
27
CREATE TABLE t7 (f1 char(20), f2 char(25), f3 date, f4 int) ENGINE = NDB;
28
CREATE TABLE t8 (f1 char(20), f2 char(25), f3 date, f4 int) ENGINE = NDB;
29
LOAD DATA INFILE 'MYSQL_TEST_DIR/suite/funcs_1/data/t7.txt' INTO TABLE t7;
31
Warning 1265 Data truncated for column 'f3' at row 1
32
Warning 1265 Data truncated for column 'f3' at row 2
33
Warning 1265 Data truncated for column 'f3' at row 3
34
Warning 1265 Data truncated for column 'f3' at row 4
35
Warning 1265 Data truncated for column 'f3' at row 5
36
Warning 1265 Data truncated for column 'f3' at row 6
37
Warning 1265 Data truncated for column 'f3' at row 7
38
Warning 1265 Data truncated for column 'f3' at row 8
39
Warning 1265 Data truncated for column 'f3' at row 9
40
Warning 1265 Data truncated for column 'f3' at row 10
41
LOAD DATA INFILE 'MYSQL_TEST_DIR/suite/funcs_1/data/t7.txt' INTO TABLE t8;
43
Warning 1265 Data truncated for column 'f3' at row 1
44
Warning 1265 Data truncated for column 'f3' at row 2
45
Warning 1265 Data truncated for column 'f3' at row 3
46
Warning 1265 Data truncated for column 'f3' at row 4
47
Warning 1265 Data truncated for column 'f3' at row 5
48
Warning 1265 Data truncated for column 'f3' at row 6
49
Warning 1265 Data truncated for column 'f3' at row 7
50
Warning 1265 Data truncated for column 'f3' at row 8
51
Warning 1265 Data truncated for column 'f3' at row 9
52
Warning 1265 Data truncated for column 'f3' at row 10
53
drop TABLE if exists t9;
54
CREATE TABLE t9 (f1 int, f2 char(25), f3 int) ENGINE = NDB;
55
LOAD DATA INFILE 'MYSQL_TEST_DIR/suite/funcs_1/data/t9.txt' INTO TABLE t9;
56
DROP DATABASE IF EXISTS db_datadict;
57
CREATE DATABASE db_datadict;
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>;
59
9
LEFT( table_comment,
60
10
IF(INSTR(table_comment,'InnoDB free') = 0
68
18
WHERE table_schema LIKE 'test%' AND table_type = 'BASE TABLE'
69
19
ORDER BY table_schema,table_name;
73
23
TABLE_TYPE BASE TABLE
87
TABLE_COLLATION latin1_swedish_ci
92
Separator -----------------------------------------------------
103
MAX_DATA_LENGTH #MDL#
110
TABLE_COLLATION latin1_swedish_ci
115
Separator -----------------------------------------------------
119
TABLE_TYPE BASE TABLE
126
MAX_DATA_LENGTH #MDL#
133
TABLE_COLLATION latin1_swedish_ci
138
Separator -----------------------------------------------------
26
ROW_FORMAT DYNAMIC_OR_PAGE
37
TABLE_COLLATION latin1_swedish_ci
42
Separator -----------------------------------------------------
142
46
TABLE_TYPE BASE TABLE
149
MAX_DATA_LENGTH #MDL#
156
TABLE_COLLATION latin1_swedish_ci
161
Separator -----------------------------------------------------
165
TABLE_TYPE BASE TABLE
172
MAX_DATA_LENGTH #MDL#
179
TABLE_COLLATION latin1_swedish_ci
184
Separator -----------------------------------------------------
188
TABLE_TYPE BASE TABLE
195
MAX_DATA_LENGTH #MDL#
202
TABLE_COLLATION latin1_swedish_ci
207
Separator -----------------------------------------------------
211
TABLE_TYPE BASE TABLE
218
MAX_DATA_LENGTH #MDL#
225
TABLE_COLLATION latin1_swedish_ci
230
Separator -----------------------------------------------------
234
TABLE_TYPE BASE TABLE
241
MAX_DATA_LENGTH #MDL#
248
TABLE_COLLATION latin1_swedish_ci
253
Separator -----------------------------------------------------
257
TABLE_TYPE BASE TABLE
264
MAX_DATA_LENGTH #MDL#
271
TABLE_COLLATION latin1_swedish_ci
276
Separator -----------------------------------------------------
280
TABLE_TYPE BASE TABLE
287
MAX_DATA_LENGTH #MDL#
294
TABLE_COLLATION latin1_swedish_ci
299
Separator -----------------------------------------------------
49
ROW_FORMAT DYNAMIC_OR_PAGE
60
TABLE_COLLATION latin1_swedish_ci
65
Separator -----------------------------------------------------
72
ROW_FORMAT DYNAMIC_OR_PAGE
83
TABLE_COLLATION latin1_swedish_ci
88
Separator -----------------------------------------------------
89
SHOW TABLES FROM test1;
93
SHOW TABLES FROM test2;
300
96
DROP USER testuser1@localhost;
301
97
CREATE USER testuser1@localhost;
302
GRANT SELECT ON db_datadict.* TO testuser1@localhost;
98
GRANT SELECT ON test1.* TO testuser1@localhost;
303
99
# Establish connection testuser1 (user=testuser1)
305
101
LEFT( table_comment,
314
110
WHERE table_schema LIKE 'test%' AND table_type = 'BASE TABLE'
315
111
ORDER BY table_schema,table_name;
316
112
TABLE_CATALOG NULL
319
115
TABLE_TYPE BASE TABLE
320
116
ENGINE ndbcluster
326
MAX_DATA_LENGTH #MDL#
333
TABLE_COLLATION latin1_swedish_ci
338
Separator -----------------------------------------------------
342
TABLE_TYPE BASE TABLE
349
MAX_DATA_LENGTH #MDL#
356
TABLE_COLLATION latin1_swedish_ci
361
Separator -----------------------------------------------------
365
TABLE_TYPE BASE TABLE
372
MAX_DATA_LENGTH #MDL#
379
TABLE_COLLATION latin1_swedish_ci
384
Separator -----------------------------------------------------
118
ROW_FORMAT DYNAMIC_OR_PAGE
122
MAX_DATA_LENGTH #MDL#
129
TABLE_COLLATION latin1_swedish_ci
134
Separator -----------------------------------------------------
388
138
TABLE_TYPE BASE TABLE
389
139
ENGINE ndbcluster
395
MAX_DATA_LENGTH #MDL#
402
TABLE_COLLATION latin1_swedish_ci
407
Separator -----------------------------------------------------
411
TABLE_TYPE BASE TABLE
418
MAX_DATA_LENGTH #MDL#
425
TABLE_COLLATION latin1_swedish_ci
430
Separator -----------------------------------------------------
434
TABLE_TYPE BASE TABLE
441
MAX_DATA_LENGTH #MDL#
448
TABLE_COLLATION latin1_swedish_ci
453
Separator -----------------------------------------------------
457
TABLE_TYPE BASE TABLE
464
MAX_DATA_LENGTH #MDL#
471
TABLE_COLLATION latin1_swedish_ci
476
Separator -----------------------------------------------------
480
TABLE_TYPE BASE TABLE
487
MAX_DATA_LENGTH #MDL#
494
TABLE_COLLATION latin1_swedish_ci
499
Separator -----------------------------------------------------
503
TABLE_TYPE BASE TABLE
510
MAX_DATA_LENGTH #MDL#
517
TABLE_COLLATION latin1_swedish_ci
522
Separator -----------------------------------------------------
141
ROW_FORMAT DYNAMIC_OR_PAGE
145
MAX_DATA_LENGTH #MDL#
152
TABLE_COLLATION latin1_swedish_ci
157
Separator -----------------------------------------------------
158
SHOW TABLES FROM test1;
162
SHOW TABLES FROM test2;
163
ERROR 42000: Access denied for user 'testuser1'@'localhost' to database 'test2'
523
164
# Switch to connection default and close connection testuser1
524
165
DROP USER testuser1@localhost;
525
DROP DATABASE db_datadict;
526
166
DROP DATABASE test1;