Debian Codegraph @

mysql-test/suite/innodb/include/print_instant_metadata.inc

raw
1 #-------------------------------------------------------
2 # Prints instant metadata of table and it's columns from
3 # - DD Tables
4 # - Information_schema tables
5 # NOTE : $table_name needs to be set.
6 # : $is_debug to be set for debug build
7 #-------------------------------------------------------
8 let $table_id = `SELECT TABLE_ID FROM INFORMATION_SCHEMA.INNODB_TABLES WHERE NAME='test/$table_name'`;
9 --disable_query_log
10
11 if ($is_debug) {
12 --echo # Metadata from INFORMATION_SCHEMA.TABLES
13 eval SELECT NAME, N_COLS, INSTANT_COLS, TOTAL_ROW_VERSIONS,
14 INITIAL_COLUMN_COUNTS, CURRENT_COLUMN_COUNTS, TOTAL_COLUMN_COUNTS
15 FROM INFORMATION_SCHEMA.INNODB_TABLES
16 WHERE TABLE_ID=$table_id;
17
18 --echo # Metadata from INFORMATION_SCHEMA.COLUMNS
19 SET SESSION debug= '+d,show_dropped_column';
20 eval SELECT NAME, POS, MTYPE, PRTYPE, HAS_DEFAULT,
21 VERSION_ADDED, VERSION_DROPPED
22 FROM INFORMATION_SCHEMA.INNODB_COLUMNS
23 WHERE TABLE_ID=$table_id;
24
25 SET SESSION debug= '+d,skip_dd_table_access_check';
26 eval SELECT ID INTO @tid FROM mysql.tables WHERE NAME='$table_name';
27 --echo # DD Metadata of table
28 SELECT NAME, SE_PRIVATE_DATA FROM mysql.tables WHERE ID=@tid;
29
30 --echo # DD Metadata of columns in table
31 --replace_regex /table_id=[0-9]+;/table_id=TABLE_ID;/
32 SELECT NAME, ORDINAL_POSITION, TYPE, HAS_NO_DEFAULT, HIDDEN, SE_PRIVATE_DATA
33 FROM mysql.columns
34 WHERE TABLE_ID=@tid
35 ORDER BY ORDINAL_POSITION;
36 }
37
38 if (!$is_debug) {
39 --echo # Metadata from INFORMATION_SCHEMA.TABLES
40 eval SELECT NAME, N_COLS, INSTANT_COLS, TOTAL_ROW_VERSIONS
41 FROM INFORMATION_SCHEMA.INNODB_TABLES
42 WHERE TABLE_ID=$table_id;
43
44 --echo # Metadata from INFORMATION_SCHEMA.COLUMNS
45 eval SELECT NAME, POS, MTYPE, PRTYPE, HAS_DEFAULT
46 FROM INFORMATION_SCHEMA.INNODB_COLUMNS
47 WHERE TABLE_ID=$table_id;
48 }
49
50 --enable_query_log