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 # 15 CREATE_TIME
19 # 16 UPDATE_TIME
20 # 17 CHECK_TIME
21 # 20 CREATE_OPTIONS
22 # 21 TABLE_COMMENT User defined comment
23 # + InnoDB
24 # + InnoDB: "InnoDB free: <number_kB> kB" appended
25 # <number_kB> depends on tablespace history!
26 # The LEFT/INSTR/IF/LENGTH stuff should remove these
27 # storage engine specific part.
28 let $innodb_pattern = 'InnoDB free';
29 --vertical_results
30 # We do not unify the engine name here, because the rowformat is
31 # specific to the engine.
32 --replace_result Dynamic DYNAMIC_OR_PAGE Page DYNAMIC_OR_PAGE MyISAM MYISAM_OR_MARIA Aria MYISAM_OR_MARIA
33 --replace_column 8 "#TBLR#" 9 "#ARL#" 10 "#DL#" 11 "#MDL#" 12 "#IL#" 13 "#DF#" 15 "#CRT#" 16 "#UT#" 17 "#CT#" 20 "#CO#" 21 "#TC#" 22 "#MIL#"
34 eval
35 SELECT *,
36 LEFT( table_comment,
37 IF(INSTR(table_comment,$innodb_pattern) = 0,
38 LENGTH(table_comment),
39 INSTR(table_comment,$innodb_pattern) - 1))
40 AS "user_comment",
41 '-----------------------------------------------------' AS "Separator"
42 FROM information_schema.tables
43 $my_where
44 ORDER BY table_schema,table_name;
45 --horizontal_results