Debian Codegraph @

mysql-test/suite/funcs_1/datadict/tables2.inc

raw
1 # suite/funcs_1/datadict/tables2.inc
2 #
3 # Auxiliary script to be sourced by suite/funcs_1/datadict/tables1.inc.
4 #
5 # Author:
6 # 2008-01-23 mleich WL#4203 Reorganize and fix the data dictionary tests of
7 # testsuite funcs_1
8 # Create this script based on older scripts and new code.
9 #
10 ################################################################################
11
12 # 8 TABLE_ROWS
13 # 9 AVG_ROW_LENGTH
14 # 10 DATA_LENGTH
15 # 11 MAX_DATA_LENGTH
16 # 12 INDEX_LENGTH
17 # 13 DATA_FREE
18 # 14 AUTO_INCREMENT
19 # 15 CREATE_TIME
20 # 16 UPDATE_TIME
21 # 17 CHECK_TIME
22 # 20 CREATE_OPTIONS
23 # 21 TABLE_COMMENT User defined comment
24 # + InnoDB
25 # + NDB: "number_of_replicas: <number>" appended
26 # + InnoDB: "InnoDB free: <number_kB> kB" appended
27 # <number_kB> depends on tablespace history!
28 # The LEFT/INSTR/IF/LENGTH stuff should remove these
29 # storage engine specific part.
30 let $innodb_pattern = 'InnoDB free';
31 let $ndb_pattern = 'number_of_replicas';
32 --vertical_results
33 # We do not unify the engine name here, because the rowformat is
34 # specific to the engine.
35 --replace_column 8 "#TBLR#" 9 "#ARL#" 10 "#DL#" 11 "#MDL#" 12 "#IL#" 13 "#DF#" 14 "#AI#" 15 "#CRT#" 16 "#UT#" 17 "#CT#" 20 "#CO#" 21 "#TC#"
36 --replace_result InnoDB TMP_TABLE_ENGINE MyISAM TMP_TABLE_ENGINE
37 eval
38 SELECT *,
39 LEFT( table_comment,
40 IF(INSTR(table_comment,$innodb_pattern) = 0
41 AND INSTR(table_comment,$ndb_pattern) = 0,
42 LENGTH(table_comment),
43 INSTR(table_comment,$innodb_pattern)
44 + INSTR(table_comment,$ndb_pattern) - 1))
45 AS "user_comment",
46 '-----------------------------------------------------' AS "Separator"
47 FROM information_schema.tables
48 $my_where
49 ORDER BY table_schema,table_name COLLATE utf8_general_ci;
50 --horizontal_results