1
DROP DATABASE IF EXISTS 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;
60
IF(INSTR(table_comment,'InnoDB free') = 0
61
AND INSTR(table_comment,'number_of_replicas') = 0,
62
LENGTH(table_comment),
63
INSTR(table_comment,'InnoDB free')
64
+ INSTR(table_comment,'number_of_replicas') - 1))
66
'-----------------------------------------------------' AS "Separator"
67
FROM information_schema.tables
68
WHERE table_schema LIKE 'test%' AND table_type = 'BASE TABLE'
69
ORDER BY table_schema,table_name;
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 -----------------------------------------------------
142
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 -----------------------------------------------------
300
DROP USER testuser1@localhost;
301
CREATE USER testuser1@localhost;
302
GRANT SELECT ON db_datadict.* TO testuser1@localhost;
303
# Establish connection testuser1 (user=testuser1)
306
IF(INSTR(table_comment,'InnoDB free') = 0
307
AND INSTR(table_comment,'number_of_replicas') = 0,
308
LENGTH(table_comment),
309
INSTR(table_comment,'InnoDB free')
310
+ INSTR(table_comment,'number_of_replicas') - 1))
312
'-----------------------------------------------------' AS "Separator"
313
FROM information_schema.tables
314
WHERE table_schema LIKE 'test%' AND table_type = 'BASE TABLE'
315
ORDER BY table_schema,table_name;
319
TABLE_TYPE BASE TABLE
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 -----------------------------------------------------
388
TABLE_TYPE BASE TABLE
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 -----------------------------------------------------
523
# Switch to connection default and close connection testuser1
524
DROP USER testuser1@localhost;
525
DROP DATABASE db_datadict;