| 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 |