← Back to branch summary

~ubuntu-branches/ubuntu/trusty/mysql-5.6/trusty

« back to all changes in this revision

Viewing changes to mysql-test/suite/funcs_1/datadict/tables2.inc

  • Committer: Package Import Robot
  • Author(s): James Page
  • Date: 2014-02-12 11:54:27 UTC
  • Revision ID: package-import@ubuntu.com-20140212115427-oq6tfsqxl1wuwehi
Tags: upstream-5.6.15
Import upstream version 5.6.15

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/funcs_1/datadict/tables2.inc
 
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
#                    + NDB: "number_of_replicas: <number>" appended
 
25
#                    + InnoDB: "InnoDB free: <number_kB> kB" appended
 
26
#                      <number_kB> depends on tablespace history!
 
27
#                    The LEFT/INSTR/IF/LENGTH stuff should remove these
 
28
#                    storage engine specific part.
 
29
let $innodb_pattern = 'InnoDB free';
 
30
let $ndb_pattern    = 'number_of_replicas';
 
31
--vertical_results
 
32
# We do not unify the engine name here, because the rowformat is
 
33
# specific to the engine.
 
34
--replace_column  8 "#TBLR#" 9 "#ARL#" 10 "#DL#" 11 "#MDL#" 12 "#IL#" 13 "#DF#" 15 "#CRT#" 16 "#UT#" 17 "#CT#" 20 "#CO#" 21 "#TC#"
 
35
eval
 
36
SELECT *,
 
37
       LEFT( table_comment,
 
38
             IF(INSTR(table_comment,$innodb_pattern) = 0
 
39
                     AND INSTR(table_comment,$ndb_pattern) = 0,
 
40
                LENGTH(table_comment),
 
41
                INSTR(table_comment,$innodb_pattern)
 
42
                     + INSTR(table_comment,$ndb_pattern) - 1))
 
43
       AS "user_comment",
 
44
       '-----------------------------------------------------' AS "Separator"
 
45
FROM information_schema.tables
 
46
$my_where
 
47
ORDER BY table_schema,table_name;
 
48
--horizontal_results