← Back to branch summary

~mathiaz/ubuntu/lucid/mysql-dfsg-5.1/zap-bug-552053

« back to all changes in this revision

Viewing changes to mysql-test/suite/funcs_1/r/is_columns_is_embedded.result

  • Committer: Bazaar Package Importer
  • Author(s): Mathias Gug
  • Date: 2009-06-25 12:55:45 UTC
  • mfrom: (1.1.2 upstream) (0.1.3 experimental)
  • Revision ID: james.westby@ubuntu.com-20090625125545-m8ogs96zzsri74xe
Tags: 5.1.34-1ubuntu1
https://launchpad.net/bugs/319843
https://launchpad.net/bugs/259477
https://launchpad.net/bugs/310211
https://launchpad.net/bugs/201799
https://launchpad.net/bugs/316974
http://bugs.debian.org/314785
http://bugs.debian.org/324834
http://bugs.debian.org/435165
http://bugs.debian.org/444216
https://launchpad.net/bugs/344816
https://launchpad.net/bugs/323755
* Merge from debian experimental (and 5.0 from main), remaining changes:
  - debian/mysql-server-5.1.config:
    + ask for MySQL root password at priority high instead of medium so
      that the password prompt is seen on a default install. (LP: #319843)
    + don't ask for root password when upgrading from a 5.0 install.
  - debian/control:
    + Make libmysqlclient16-dev a transitional package depending on
      libmysqlclient-dev.
    + Make libmysqlclient-dev conflict with libmysqlclient15-dev.
    + Don't build mysql-server, mysql-client, mysql-common and
      libmysqlclient15-dev binary packages since they're still provided
      by mysql-dfsg-5.0.
    + Make mysql-{client,server}-5.1 packages conflict and
      replace mysql-{client,server}-5.0, but not provide
      mysql-{client,server}.
    + Depend on a specific version of mysql-common rather than the src
      version of mysql-dfsg-5.1 since mysql-common is currently part of
      mysql-dfsg-5.0.
    + Lower mailx from a Recommends to a Suggests to avoid pulling in
      a full MTA on all installs of mysql-server. (LP: #259477)
  - debian/rules:
    + added -fno-strict-aliasing to CFLAGS to get around mysql testsuite
      build failures.
    + install mysql-test and sql-bench to /usr/share/mysql/ rather than
      /usr/.
  - debian/additions/debian-start.inc.sh: support ANSI mode (LP: #310211)
  - Add AppArmor profile:
    - debian/apparmor-profile: apparmor profile.
    - debian/rules, debian/mysql-server-5.0.files: install apparmor profile.
    - debian/mysql-server-5.0.dirs: add etc/apparmor.d/force-complain
    - debian/mysql-server-5.0.postrm: remove symlink in force-complain/ on
      purge.
    - debian/mysql-server-5.1.README.Debian: add apparmor documentation.
    - debian/additions/my.cnf: Add warning about apparmor. (LP: #201799)
    - debian/mysql-server-5.1.postinst: reload apparmor profiles.
  - debian/additions/my.cnf: remove language option. Error message files are
    located in a different directory in MySQL 5.0. Setting the language
    option to use /usr/share/mysql/english breaks 5.0. Both 5.0 and 5.1
    use a default value that works. (LP: #316974)
  - debian/mysql-server-5.1.mysql.init:
    + Clearly indicate that we do not support running multiple instances
      of mysqld by duplicating the init script.
      (closes: #314785, #324834, #435165, #444216)
    + Properly parameterize all existing references to the mysql config
      file (/etc/mysql/my.cnf).
  - debian/mysql-server-5.0.postinst: Clear out the second password
    when setting up mysql. (LP: #344816)
  - mysql-server-core-5.1 package for files needed by Akonadi:
    + debian/control: create mysql-server-core-5.1 package.
    + debian/mysql-server-core-5.1.files, debian/mysql-server-5.1.files:
      move core mysqld files to mysql-server-core-5.1 package.
  - Don't package sql-bench and mysql-test file.
* Dropped changes:
  - debian/patches/92_ssl_test_cert.dpatch: certificate expiration in
    test suite (LP: #323755). Included upstream.
* Dropped from 5.0:
  - apparmor profile:
    - debian/control: Recommends apparmor >= 2.1+1075-0ubuntu6. All version
      of apparmor-profile (>hardy) are higher than this version.
    - debian/mysql-server-5.0.preinst: create symlink for force-complain/
      on pre-feisty upgrades, upgrades where apparmor-profiles profile is
      unchanged (ie non-enforcing) and upgrades where the profile
      doesn't exist. Support for pre-hardy upgrades is no longer needed.
* debian/mysql-server-5.1.postinst: fix debian-sys-maint user creation.

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/funcs_1/r/is_columns_is_embedded.result
3
3
AND table_name <> 'profiling'
4
4
ORDER BY table_schema, table_name, column_name;
5
5
TABLE_CATALOG   TABLE_SCHEMA    TABLE_NAME      COLUMN_NAME     ORDINAL_POSITION        COLUMN_DEFAULT  IS_NULLABLE     DATA_TYPE       CHARACTER_MAXIMUM_LENGTH        CHARACTER_OCTET_LENGTH  NUMERIC_PRECISION       NUMERIC_SCALE   CHARACTER_SET_NAME      COLLATION_NAME  COLUMN_TYPE     COLUMN_KEY      EXTRA   PRIVILEGES      COLUMN_COMMENT
6
 
NULL    information_schema      CHARACTER_SETS  CHARACTER_SET_NAME      1               NO      varchar 64      192     NULL    NULL    utf8    utf8_general_ci varchar(64)                             
7
 
NULL    information_schema      CHARACTER_SETS  DEFAULT_COLLATE_NAME    2               NO      varchar 64      192     NULL    NULL    utf8    utf8_general_ci varchar(64)                             
 
6
NULL    information_schema      CHARACTER_SETS  CHARACTER_SET_NAME      1               NO      varchar 32      96      NULL    NULL    utf8    utf8_general_ci varchar(32)                             
 
7
NULL    information_schema      CHARACTER_SETS  DEFAULT_COLLATE_NAME    2               NO      varchar 32      96      NULL    NULL    utf8    utf8_general_ci varchar(32)                             
8
8
NULL    information_schema      CHARACTER_SETS  DESCRIPTION     3               NO      varchar 60      180     NULL    NULL    utf8    utf8_general_ci varchar(60)                             
9
9
NULL    information_schema      CHARACTER_SETS  MAXLEN  4       0       NO      bigint  NULL    NULL    19      0       NULL    NULL    bigint(3)                               
10
 
NULL    information_schema      COLLATIONS      CHARACTER_SET_NAME      2               NO      varchar 64      192     NULL    NULL    utf8    utf8_general_ci varchar(64)                             
11
 
NULL    information_schema      COLLATIONS      COLLATION_NAME  1               NO      varchar 64      192     NULL    NULL    utf8    utf8_general_ci varchar(64)                             
 
10
NULL    information_schema      COLLATIONS      CHARACTER_SET_NAME      2               NO      varchar 32      96      NULL    NULL    utf8    utf8_general_ci varchar(32)                             
 
11
NULL    information_schema      COLLATIONS      COLLATION_NAME  1               NO      varchar 32      96      NULL    NULL    utf8    utf8_general_ci varchar(32)                             
12
12
NULL    information_schema      COLLATIONS      ID      3       0       NO      bigint  NULL    NULL    19      0       NULL    NULL    bigint(11)                              
13
13
NULL    information_schema      COLLATIONS      IS_COMPILED     5               NO      varchar 3       9       NULL    NULL    utf8    utf8_general_ci varchar(3)                              
14
14
NULL    information_schema      COLLATIONS      IS_DEFAULT      4               NO      varchar 3       9       NULL    NULL    utf8    utf8_general_ci varchar(3)                              
15
15
NULL    information_schema      COLLATIONS      SORTLEN 6       0       NO      bigint  NULL    NULL    19      0       NULL    NULL    bigint(3)                               
16
 
NULL    information_schema      COLLATION_CHARACTER_SET_APPLICABILITY   CHARACTER_SET_NAME      2               NO      varchar 64      192     NULL    NULL    utf8    utf8_general_ci varchar(64)                             
17
 
NULL    information_schema      COLLATION_CHARACTER_SET_APPLICABILITY   COLLATION_NAME  1               NO      varchar 64      192     NULL    NULL    utf8    utf8_general_ci varchar(64)                             
 
16
NULL    information_schema      COLLATION_CHARACTER_SET_APPLICABILITY   CHARACTER_SET_NAME      2               NO      varchar 32      96      NULL    NULL    utf8    utf8_general_ci varchar(32)                             
 
17
NULL    information_schema      COLLATION_CHARACTER_SET_APPLICABILITY   COLLATION_NAME  1               NO      varchar 32      96      NULL    NULL    utf8    utf8_general_ci varchar(32)                             
18
18
NULL    information_schema      COLUMNS CHARACTER_MAXIMUM_LENGTH        9       NULL    YES     bigint  NULL    NULL    19      0       NULL    NULL    bigint(21) unsigned                             
19
19
NULL    information_schema      COLUMNS CHARACTER_OCTET_LENGTH  10      NULL    YES     bigint  NULL    NULL    19      0       NULL    NULL    bigint(21) unsigned                             
20
 
NULL    information_schema      COLUMNS CHARACTER_SET_NAME      13      NULL    YES     varchar 64      192     NULL    NULL    utf8    utf8_general_ci varchar(64)                             
21
 
NULL    information_schema      COLUMNS COLLATION_NAME  14      NULL    YES     varchar 64      192     NULL    NULL    utf8    utf8_general_ci varchar(64)                             
 
20
NULL    information_schema      COLUMNS CHARACTER_SET_NAME      13      NULL    YES     varchar 32      96      NULL    NULL    utf8    utf8_general_ci varchar(32)                             
 
21
NULL    information_schema      COLUMNS COLLATION_NAME  14      NULL    YES     varchar 32      96      NULL    NULL    utf8    utf8_general_ci varchar(32)                             
22
22
NULL    information_schema      COLUMNS COLUMN_COMMENT  19              NO      varchar 255     765     NULL    NULL    utf8    utf8_general_ci varchar(255)                            
23
23
NULL    information_schema      COLUMNS COLUMN_DEFAULT  6       NULL    YES     longtext        4294967295      4294967295      NULL    NULL    utf8    utf8_general_ci longtext                                
24
24
NULL    information_schema      COLUMNS COLUMN_KEY      16              NO      varchar 3       9       NULL    NULL    utf8    utf8_general_ci varchar(3)                              
43
43
NULL    information_schema      COLUMN_PRIVILEGES       TABLE_SCHEMA    3               NO      varchar 64      192     NULL    NULL    utf8    utf8_general_ci varchar(64)                             
44
44
NULL    information_schema      ENGINES COMMENT 3               NO      varchar 80      240     NULL    NULL    utf8    utf8_general_ci varchar(80)                             
45
45
NULL    information_schema      ENGINES ENGINE  1               NO      varchar 64      192     NULL    NULL    utf8    utf8_general_ci varchar(64)                             
46
 
NULL    information_schema      ENGINES SAVEPOINTS      6               NO      varchar 3       9       NULL    NULL    utf8    utf8_general_ci varchar(3)                              
 
46
NULL    information_schema      ENGINES SAVEPOINTS      6       NULL    YES     varchar 3       9       NULL    NULL    utf8    utf8_general_ci varchar(3)                              
47
47
NULL    information_schema      ENGINES SUPPORT 2               NO      varchar 8       24      NULL    NULL    utf8    utf8_general_ci varchar(8)                              
48
 
NULL    information_schema      ENGINES TRANSACTIONS    4               NO      varchar 3       9       NULL    NULL    utf8    utf8_general_ci varchar(3)                              
49
 
NULL    information_schema      ENGINES XA      5               NO      varchar 3       9       NULL    NULL    utf8    utf8_general_ci varchar(3)                              
 
48
NULL    information_schema      ENGINES TRANSACTIONS    4       NULL    YES     varchar 3       9       NULL    NULL    utf8    utf8_general_ci varchar(3)                              
 
49
NULL    information_schema      ENGINES XA      5       NULL    YES     varchar 3       9       NULL    NULL    utf8    utf8_general_ci varchar(3)                              
50
50
NULL    information_schema      EVENTS  CHARACTER_SET_CLIENT    22              NO      varchar 32      96      NULL    NULL    utf8    utf8_general_ci varchar(32)                             
51
51
NULL    information_schema      EVENTS  COLLATION_CONNECTION    23              NO      varchar 32      96      NULL    NULL    utf8    utf8_general_ci varchar(32)                             
52
52
NULL    information_schema      EVENTS  CREATED 17      0000-00-00 00:00:00     NO      datetime        NULL    NULL    NULL    NULL    NULL    NULL    datetime                                
67
67
NULL    information_schema      EVENTS  LAST_EXECUTED   19      NULL    YES     datetime        NULL    NULL    NULL    NULL    NULL    NULL    datetime                                
68
68
NULL    information_schema      EVENTS  ON_COMPLETION   16              NO      varchar 12      36      NULL    NULL    utf8    utf8_general_ci varchar(12)                             
69
69
NULL    information_schema      EVENTS  ORIGINATOR      21      0       NO      bigint  NULL    NULL    19      0       NULL    NULL    bigint(10)                              
70
 
NULL    information_schema      EVENTS  SQL_MODE        12      NULL    NO      longtext        4294967295      4294967295      NULL    NULL    utf8    utf8_general_ci longtext                                
 
70
NULL    information_schema      EVENTS  SQL_MODE        12              NO      varchar 8192    24576   NULL    NULL    utf8    utf8_general_ci varchar(8192)                           
71
71
NULL    information_schema      EVENTS  STARTS  13      NULL    YES     datetime        NULL    NULL    NULL    NULL    NULL    NULL    datetime                                
72
72
NULL    information_schema      EVENTS  STATUS  15              NO      varchar 18      54      NULL    NULL    utf8    utf8_general_ci varchar(18)                             
73
73
NULL    information_schema      EVENTS  TIME_ZONE       5               NO      varchar 64      192     NULL    NULL    utf8    utf8_general_ci varchar(64)                             
110
110
NULL    information_schema      FILES   UPDATE_TIME     34      NULL    YES     datetime        NULL    NULL    NULL    NULL    NULL    NULL    datetime                                
111
111
NULL    information_schema      FILES   VERSION 25      NULL    YES     bigint  NULL    NULL    19      0       NULL    NULL    bigint(21) unsigned                             
112
112
NULL    information_schema      GLOBAL_STATUS   VARIABLE_NAME   1               NO      varchar 64      192     NULL    NULL    utf8    utf8_general_ci varchar(64)                             
113
 
NULL    information_schema      GLOBAL_STATUS   VARIABLE_VALUE  2       NULL    YES     varchar 20480   61440   NULL    NULL    utf8    utf8_general_ci varchar(20480)                          
 
113
NULL    information_schema      GLOBAL_STATUS   VARIABLE_VALUE  2       NULL    YES     varchar 1024    3072    NULL    NULL    utf8    utf8_general_ci varchar(1024)                           
114
114
NULL    information_schema      GLOBAL_VARIABLES        VARIABLE_NAME   1               NO      varchar 64      192     NULL    NULL    utf8    utf8_general_ci varchar(64)                             
115
 
NULL    information_schema      GLOBAL_VARIABLES        VARIABLE_VALUE  2       NULL    YES     varchar 20480   61440   NULL    NULL    utf8    utf8_general_ci varchar(20480)                          
 
115
NULL    information_schema      GLOBAL_VARIABLES        VARIABLE_VALUE  2       NULL    YES     varchar 1024    3072    NULL    NULL    utf8    utf8_general_ci varchar(1024)                           
116
116
NULL    information_schema      KEY_COLUMN_USAGE        COLUMN_NAME     7               NO      varchar 64      192     NULL    NULL    utf8    utf8_general_ci varchar(64)                             
117
117
NULL    information_schema      KEY_COLUMN_USAGE        CONSTRAINT_CATALOG      1       NULL    YES     varchar 512     1536    NULL    NULL    utf8    utf8_general_ci varchar(512)                            
118
118
NULL    information_schema      KEY_COLUMN_USAGE        CONSTRAINT_NAME 3               NO      varchar 64      192     NULL    NULL    utf8    utf8_general_ci varchar(64)                             
200
200
NULL    information_schema      ROUTINES        SECURITY_TYPE   15              NO      varchar 7       21      NULL    NULL    utf8    utf8_general_ci varchar(7)                              
201
201
NULL    information_schema      ROUTINES        SPECIFIC_NAME   1               NO      varchar 64      192     NULL    NULL    utf8    utf8_general_ci varchar(64)                             
202
202
NULL    information_schema      ROUTINES        SQL_DATA_ACCESS 13              NO      varchar 64      192     NULL    NULL    utf8    utf8_general_ci varchar(64)                             
203
 
NULL    information_schema      ROUTINES        SQL_MODE        18      NULL    NO      longtext        4294967295      4294967295      NULL    NULL    utf8    utf8_general_ci longtext                                
 
203
NULL    information_schema      ROUTINES        SQL_MODE        18              NO      varchar 8192    24576   NULL    NULL    utf8    utf8_general_ci varchar(8192)                           
204
204
NULL    information_schema      ROUTINES        SQL_PATH        14      NULL    YES     varchar 64      192     NULL    NULL    utf8    utf8_general_ci varchar(64)                             
205
205
NULL    information_schema      SCHEMATA        CATALOG_NAME    1       NULL    YES     varchar 512     1536    NULL    NULL    utf8    utf8_general_ci varchar(512)                            
206
 
NULL    information_schema      SCHEMATA        DEFAULT_CHARACTER_SET_NAME      3               NO      varchar 64      192     NULL    NULL    utf8    utf8_general_ci varchar(64)                             
207
 
NULL    information_schema      SCHEMATA        DEFAULT_COLLATION_NAME  4               NO      varchar 64      192     NULL    NULL    utf8    utf8_general_ci varchar(64)                             
 
206
NULL    information_schema      SCHEMATA        DEFAULT_CHARACTER_SET_NAME      3               NO      varchar 32      96      NULL    NULL    utf8    utf8_general_ci varchar(32)                             
 
207
NULL    information_schema      SCHEMATA        DEFAULT_COLLATION_NAME  4               NO      varchar 32      96      NULL    NULL    utf8    utf8_general_ci varchar(32)                             
208
208
NULL    information_schema      SCHEMATA        SCHEMA_NAME     2               NO      varchar 64      192     NULL    NULL    utf8    utf8_general_ci varchar(64)                             
209
209
NULL    information_schema      SCHEMATA        SQL_PATH        5       NULL    YES     varchar 512     1536    NULL    NULL    utf8    utf8_general_ci varchar(512)                            
210
210
NULL    information_schema      SCHEMA_PRIVILEGES       GRANTEE 1               NO      varchar 81      243     NULL    NULL    utf8    utf8_general_ci varchar(81)                             
213
213
NULL    information_schema      SCHEMA_PRIVILEGES       TABLE_CATALOG   2       NULL    YES     varchar 512     1536    NULL    NULL    utf8    utf8_general_ci varchar(512)                            
214
214
NULL    information_schema      SCHEMA_PRIVILEGES       TABLE_SCHEMA    3               NO      varchar 64      192     NULL    NULL    utf8    utf8_general_ci varchar(64)                             
215
215
NULL    information_schema      SESSION_STATUS  VARIABLE_NAME   1               NO      varchar 64      192     NULL    NULL    utf8    utf8_general_ci varchar(64)                             
216
 
NULL    information_schema      SESSION_STATUS  VARIABLE_VALUE  2       NULL    YES     varchar 20480   61440   NULL    NULL    utf8    utf8_general_ci varchar(20480)                          
 
216
NULL    information_schema      SESSION_STATUS  VARIABLE_VALUE  2       NULL    YES     varchar 1024    3072    NULL    NULL    utf8    utf8_general_ci varchar(1024)                           
217
217
NULL    information_schema      SESSION_VARIABLES       VARIABLE_NAME   1               NO      varchar 64      192     NULL    NULL    utf8    utf8_general_ci varchar(64)                             
218
 
NULL    information_schema      SESSION_VARIABLES       VARIABLE_VALUE  2       NULL    YES     varchar 20480   61440   NULL    NULL    utf8    utf8_general_ci varchar(20480)                          
 
218
NULL    information_schema      SESSION_VARIABLES       VARIABLE_VALUE  2       NULL    YES     varchar 1024    3072    NULL    NULL    utf8    utf8_general_ci varchar(1024)                           
219
219
NULL    information_schema      STATISTICS      CARDINALITY     10      NULL    YES     bigint  NULL    NULL    19      0       NULL    NULL    bigint(21)                              
220
220
NULL    information_schema      STATISTICS      COLLATION       9       NULL    YES     varchar 1       3       NULL    NULL    utf8    utf8_general_ci varchar(1)                              
221
221
NULL    information_schema      STATISTICS      COLUMN_NAME     8               NO      varchar 64      192     NULL    NULL    utf8    utf8_general_ci varchar(64)                             
244
244
NULL    information_schema      TABLES  MAX_DATA_LENGTH 11      NULL    YES     bigint  NULL    NULL    19      0       NULL    NULL    bigint(21) unsigned                             
245
245
NULL    information_schema      TABLES  ROW_FORMAT      7       NULL    YES     varchar 10      30      NULL    NULL    utf8    utf8_general_ci varchar(10)                             
246
246
NULL    information_schema      TABLES  TABLE_CATALOG   1       NULL    YES     varchar 512     1536    NULL    NULL    utf8    utf8_general_ci varchar(512)                            
247
 
NULL    information_schema      TABLES  TABLE_COLLATION 18      NULL    YES     varchar 64      192     NULL    NULL    utf8    utf8_general_ci varchar(64)                             
 
247
NULL    information_schema      TABLES  TABLE_COLLATION 18      NULL    YES     varchar 32      96      NULL    NULL    utf8    utf8_general_ci varchar(32)                             
248
248
NULL    information_schema      TABLES  TABLE_COMMENT   21              NO      varchar 80      240     NULL    NULL    utf8    utf8_general_ci varchar(80)                             
249
249
NULL    information_schema      TABLES  TABLE_NAME      3               NO      varchar 64      192     NULL    NULL    utf8    utf8_general_ci varchar(64)                             
250
250
NULL    information_schema      TABLES  TABLE_ROWS      8       NULL    YES     bigint  NULL    NULL    19      0       NULL    NULL    bigint(21) unsigned                             
277
277
NULL    information_schema      TRIGGERS        COLLATION_CONNECTION    21              NO      varchar 32      96      NULL    NULL    utf8    utf8_general_ci varchar(32)                             
278
278
NULL    information_schema      TRIGGERS        CREATED 17      NULL    YES     datetime        NULL    NULL    NULL    NULL    NULL    NULL    datetime                                
279
279
NULL    information_schema      TRIGGERS        DATABASE_COLLATION      22              NO      varchar 32      96      NULL    NULL    utf8    utf8_general_ci varchar(32)                             
280
 
NULL    information_schema      TRIGGERS        DEFINER 19      NULL    NO      longtext        4294967295      4294967295      NULL    NULL    utf8    utf8_general_ci longtext                                
 
280
NULL    information_schema      TRIGGERS        DEFINER 19              NO      varchar 77      231     NULL    NULL    utf8    utf8_general_ci varchar(77)                             
281
281
NULL    information_schema      TRIGGERS        EVENT_MANIPULATION      4               NO      varchar 6       18      NULL    NULL    utf8    utf8_general_ci varchar(6)                              
282
282
NULL    information_schema      TRIGGERS        EVENT_OBJECT_CATALOG    5       NULL    YES     varchar 512     1536    NULL    NULL    utf8    utf8_general_ci varchar(512)                            
283
283
NULL    information_schema      TRIGGERS        EVENT_OBJECT_SCHEMA     6               NO      varchar 64      192     NULL    NULL    utf8    utf8_general_ci varchar(64)                             
284
284
NULL    information_schema      TRIGGERS        EVENT_OBJECT_TABLE      7               NO      varchar 64      192     NULL    NULL    utf8    utf8_general_ci varchar(64)                             
285
 
NULL    information_schema      TRIGGERS        SQL_MODE        18      NULL    NO      longtext        4294967295      4294967295      NULL    NULL    utf8    utf8_general_ci longtext                                
 
285
NULL    information_schema      TRIGGERS        SQL_MODE        18              NO      varchar 8192    24576   NULL    NULL    utf8    utf8_general_ci varchar(8192)                           
286
286
NULL    information_schema      TRIGGERS        TRIGGER_CATALOG 1       NULL    YES     varchar 512     1536    NULL    NULL    utf8    utf8_general_ci varchar(512)                            
287
287
NULL    information_schema      TRIGGERS        TRIGGER_NAME    3               NO      varchar 64      192     NULL    NULL    utf8    utf8_general_ci varchar(64)                             
288
288
NULL    information_schema      TRIGGERS        TRIGGER_SCHEMA  2               NO      varchar 64      192     NULL    NULL    utf8    utf8_general_ci varchar(64)                             
357
357
AND table_name <> 'profiling'
358
358
ORDER BY TABLE_SCHEMA, TABLE_NAME, ORDINAL_POSITION;
359
359
COL_CML TABLE_SCHEMA    TABLE_NAME      COLUMN_NAME     DATA_TYPE       CHARACTER_MAXIMUM_LENGTH        CHARACTER_OCTET_LENGTH  CHARACTER_SET_NAME      COLLATION_NAME  COLUMN_TYPE
360
 
3.0000  information_schema      CHARACTER_SETS  CHARACTER_SET_NAME      varchar 64      192     utf8    utf8_general_ci varchar(64)
361
 
3.0000  information_schema      CHARACTER_SETS  DEFAULT_COLLATE_NAME    varchar 64      192     utf8    utf8_general_ci varchar(64)
 
360
3.0000  information_schema      CHARACTER_SETS  CHARACTER_SET_NAME      varchar 32      96      utf8    utf8_general_ci varchar(32)
 
361
3.0000  information_schema      CHARACTER_SETS  DEFAULT_COLLATE_NAME    varchar 32      96      utf8    utf8_general_ci varchar(32)
362
362
3.0000  information_schema      CHARACTER_SETS  DESCRIPTION     varchar 60      180     utf8    utf8_general_ci varchar(60)
363
363
NULL    information_schema      CHARACTER_SETS  MAXLEN  bigint  NULL    NULL    NULL    NULL    bigint(3)
364
 
3.0000  information_schema      COLLATIONS      COLLATION_NAME  varchar 64      192     utf8    utf8_general_ci varchar(64)
365
 
3.0000  information_schema      COLLATIONS      CHARACTER_SET_NAME      varchar 64      192     utf8    utf8_general_ci varchar(64)
 
364
3.0000  information_schema      COLLATIONS      COLLATION_NAME  varchar 32      96      utf8    utf8_general_ci varchar(32)
 
365
3.0000  information_schema      COLLATIONS      CHARACTER_SET_NAME      varchar 32      96      utf8    utf8_general_ci varchar(32)
366
366
NULL    information_schema      COLLATIONS      ID      bigint  NULL    NULL    NULL    NULL    bigint(11)
367
367
3.0000  information_schema      COLLATIONS      IS_DEFAULT      varchar 3       9       utf8    utf8_general_ci varchar(3)
368
368
3.0000  information_schema      COLLATIONS      IS_COMPILED     varchar 3       9       utf8    utf8_general_ci varchar(3)
369
369
NULL    information_schema      COLLATIONS      SORTLEN bigint  NULL    NULL    NULL    NULL    bigint(3)
370
 
3.0000  information_schema      COLLATION_CHARACTER_SET_APPLICABILITY   COLLATION_NAME  varchar 64      192     utf8    utf8_general_ci varchar(64)
371
 
3.0000  information_schema      COLLATION_CHARACTER_SET_APPLICABILITY   CHARACTER_SET_NAME      varchar 64      192     utf8    utf8_general_ci varchar(64)
 
370
3.0000  information_schema      COLLATION_CHARACTER_SET_APPLICABILITY   COLLATION_NAME  varchar 32      96      utf8    utf8_general_ci varchar(32)
 
371
3.0000  information_schema      COLLATION_CHARACTER_SET_APPLICABILITY   CHARACTER_SET_NAME      varchar 32      96      utf8    utf8_general_ci varchar(32)
372
372
3.0000  information_schema      COLUMNS TABLE_CATALOG   varchar 512     1536    utf8    utf8_general_ci varchar(512)
373
373
3.0000  information_schema      COLUMNS TABLE_SCHEMA    varchar 64      192     utf8    utf8_general_ci varchar(64)
374
374
3.0000  information_schema      COLUMNS TABLE_NAME      varchar 64      192     utf8    utf8_general_ci varchar(64)
381
381
NULL    information_schema      COLUMNS CHARACTER_OCTET_LENGTH  bigint  NULL    NULL    NULL    NULL    bigint(21) unsigned
382
382
NULL    information_schema      COLUMNS NUMERIC_PRECISION       bigint  NULL    NULL    NULL    NULL    bigint(21) unsigned
383
383
NULL    information_schema      COLUMNS NUMERIC_SCALE   bigint  NULL    NULL    NULL    NULL    bigint(21) unsigned
384
 
3.0000  information_schema      COLUMNS CHARACTER_SET_NAME      varchar 64      192     utf8    utf8_general_ci varchar(64)
385
 
3.0000  information_schema      COLUMNS COLLATION_NAME  varchar 64      192     utf8    utf8_general_ci varchar(64)
 
384
3.0000  information_schema      COLUMNS CHARACTER_SET_NAME      varchar 32      96      utf8    utf8_general_ci varchar(32)
 
385
3.0000  information_schema      COLUMNS COLLATION_NAME  varchar 32      96      utf8    utf8_general_ci varchar(32)
386
386
1.0000  information_schema      COLUMNS COLUMN_TYPE     longtext        4294967295      4294967295      utf8    utf8_general_ci longtext
387
387
3.0000  information_schema      COLUMNS COLUMN_KEY      varchar 3       9       utf8    utf8_general_ci varchar(3)
388
388
3.0000  information_schema      COLUMNS EXTRA   varchar 27      81      utf8    utf8_general_ci varchar(27)
412
412
NULL    information_schema      EVENTS  EXECUTE_AT      datetime        NULL    NULL    NULL    NULL    datetime
413
413
3.0000  information_schema      EVENTS  INTERVAL_VALUE  varchar 256     768     utf8    utf8_general_ci varchar(256)
414
414
3.0000  information_schema      EVENTS  INTERVAL_FIELD  varchar 18      54      utf8    utf8_general_ci varchar(18)
415
 
1.0000  information_schema      EVENTS  SQL_MODE        longtext        4294967295      4294967295      utf8    utf8_general_ci longtext
 
415
3.0000  information_schema      EVENTS  SQL_MODE        varchar 8192    24576   utf8    utf8_general_ci varchar(8192)
416
416
NULL    information_schema      EVENTS  STARTS  datetime        NULL    NULL    NULL    NULL    datetime
417
417
NULL    information_schema      EVENTS  ENDS    datetime        NULL    NULL    NULL    NULL    datetime
418
418
3.0000  information_schema      EVENTS  STATUS  varchar 18      54      utf8    utf8_general_ci varchar(18)
464
464
3.0000  information_schema      FILES   STATUS  varchar 20      60      utf8    utf8_general_ci varchar(20)
465
465
3.0000  information_schema      FILES   EXTRA   varchar 255     765     utf8    utf8_general_ci varchar(255)
466
466
3.0000  information_schema      GLOBAL_STATUS   VARIABLE_NAME   varchar 64      192     utf8    utf8_general_ci varchar(64)
467
 
3.0000  information_schema      GLOBAL_STATUS   VARIABLE_VALUE  varchar 20480   61440   utf8    utf8_general_ci varchar(20480)
 
467
3.0000  information_schema      GLOBAL_STATUS   VARIABLE_VALUE  varchar 1024    3072    utf8    utf8_general_ci varchar(1024)
468
468
3.0000  information_schema      GLOBAL_VARIABLES        VARIABLE_NAME   varchar 64      192     utf8    utf8_general_ci varchar(64)
469
 
3.0000  information_schema      GLOBAL_VARIABLES        VARIABLE_VALUE  varchar 20480   61440   utf8    utf8_general_ci varchar(20480)
 
469
3.0000  information_schema      GLOBAL_VARIABLES        VARIABLE_VALUE  varchar 1024    3072    utf8    utf8_general_ci varchar(1024)
470
470
3.0000  information_schema      KEY_COLUMN_USAGE        CONSTRAINT_CATALOG      varchar 512     1536    utf8    utf8_general_ci varchar(512)
471
471
3.0000  information_schema      KEY_COLUMN_USAGE        CONSTRAINT_SCHEMA       varchar 64      192     utf8    utf8_general_ci varchar(64)
472
472
3.0000  information_schema      KEY_COLUMN_USAGE        CONSTRAINT_NAME varchar 64      192     utf8    utf8_general_ci varchar(64)
550
550
3.0000  information_schema      ROUTINES        SECURITY_TYPE   varchar 7       21      utf8    utf8_general_ci varchar(7)
551
551
NULL    information_schema      ROUTINES        CREATED datetime        NULL    NULL    NULL    NULL    datetime
552
552
NULL    information_schema      ROUTINES        LAST_ALTERED    datetime        NULL    NULL    NULL    NULL    datetime
553
 
1.0000  information_schema      ROUTINES        SQL_MODE        longtext        4294967295      4294967295      utf8    utf8_general_ci longtext
 
553
3.0000  information_schema      ROUTINES        SQL_MODE        varchar 8192    24576   utf8    utf8_general_ci varchar(8192)
554
554
3.0000  information_schema      ROUTINES        ROUTINE_COMMENT varchar 64      192     utf8    utf8_general_ci varchar(64)
555
555
3.0000  information_schema      ROUTINES        DEFINER varchar 77      231     utf8    utf8_general_ci varchar(77)
556
556
3.0000  information_schema      ROUTINES        CHARACTER_SET_CLIENT    varchar 32      96      utf8    utf8_general_ci varchar(32)
558
558
3.0000  information_schema      ROUTINES        DATABASE_COLLATION      varchar 32      96      utf8    utf8_general_ci varchar(32)
559
559
3.0000  information_schema      SCHEMATA        CATALOG_NAME    varchar 512     1536    utf8    utf8_general_ci varchar(512)
560
560
3.0000  information_schema      SCHEMATA        SCHEMA_NAME     varchar 64      192     utf8    utf8_general_ci varchar(64)
561
 
3.0000  information_schema      SCHEMATA        DEFAULT_CHARACTER_SET_NAME      varchar 64      192     utf8    utf8_general_ci varchar(64)
562
 
3.0000  information_schema      SCHEMATA        DEFAULT_COLLATION_NAME  varchar 64      192     utf8    utf8_general_ci varchar(64)
 
561
3.0000  information_schema      SCHEMATA        DEFAULT_CHARACTER_SET_NAME      varchar 32      96      utf8    utf8_general_ci varchar(32)
 
562
3.0000  information_schema      SCHEMATA        DEFAULT_COLLATION_NAME  varchar 32      96      utf8    utf8_general_ci varchar(32)
563
563
3.0000  information_schema      SCHEMATA        SQL_PATH        varchar 512     1536    utf8    utf8_general_ci varchar(512)
564
564
3.0000  information_schema      SCHEMA_PRIVILEGES       GRANTEE varchar 81      243     utf8    utf8_general_ci varchar(81)
565
565
3.0000  information_schema      SCHEMA_PRIVILEGES       TABLE_CATALOG   varchar 512     1536    utf8    utf8_general_ci varchar(512)
567
567
3.0000  information_schema      SCHEMA_PRIVILEGES       PRIVILEGE_TYPE  varchar 64      192     utf8    utf8_general_ci varchar(64)
568
568
3.0000  information_schema      SCHEMA_PRIVILEGES       IS_GRANTABLE    varchar 3       9       utf8    utf8_general_ci varchar(3)
569
569
3.0000  information_schema      SESSION_STATUS  VARIABLE_NAME   varchar 64      192     utf8    utf8_general_ci varchar(64)
570
 
3.0000  information_schema      SESSION_STATUS  VARIABLE_VALUE  varchar 20480   61440   utf8    utf8_general_ci varchar(20480)
 
570
3.0000  information_schema      SESSION_STATUS  VARIABLE_VALUE  varchar 1024    3072    utf8    utf8_general_ci varchar(1024)
571
571
3.0000  information_schema      SESSION_VARIABLES       VARIABLE_NAME   varchar 64      192     utf8    utf8_general_ci varchar(64)
572
 
3.0000  information_schema      SESSION_VARIABLES       VARIABLE_VALUE  varchar 20480   61440   utf8    utf8_general_ci varchar(20480)
 
572
3.0000  information_schema      SESSION_VARIABLES       VARIABLE_VALUE  varchar 1024    3072    utf8    utf8_general_ci varchar(1024)
573
573
3.0000  information_schema      STATISTICS      TABLE_CATALOG   varchar 512     1536    utf8    utf8_general_ci varchar(512)
574
574
3.0000  information_schema      STATISTICS      TABLE_SCHEMA    varchar 64      192     utf8    utf8_general_ci varchar(64)
575
575
3.0000  information_schema      STATISTICS      TABLE_NAME      varchar 64      192     utf8    utf8_general_ci varchar(64)
602
602
NULL    information_schema      TABLES  CREATE_TIME     datetime        NULL    NULL    NULL    NULL    datetime
603
603
NULL    information_schema      TABLES  UPDATE_TIME     datetime        NULL    NULL    NULL    NULL    datetime
604
604
NULL    information_schema      TABLES  CHECK_TIME      datetime        NULL    NULL    NULL    NULL    datetime
605
 
3.0000  information_schema      TABLES  TABLE_COLLATION varchar 64      192     utf8    utf8_general_ci varchar(64)
 
605
3.0000  information_schema      TABLES  TABLE_COLLATION varchar 32      96      utf8    utf8_general_ci varchar(32)
606
606
NULL    information_schema      TABLES  CHECKSUM        bigint  NULL    NULL    NULL    NULL    bigint(21) unsigned
607
607
3.0000  information_schema      TABLES  CREATE_OPTIONS  varchar 255     765     utf8    utf8_general_ci varchar(255)
608
608
3.0000  information_schema      TABLES  TABLE_COMMENT   varchar 80      240     utf8    utf8_general_ci varchar(80)
635
635
3.0000  information_schema      TRIGGERS        ACTION_REFERENCE_OLD_ROW        varchar 3       9       utf8    utf8_general_ci varchar(3)
636
636
3.0000  information_schema      TRIGGERS        ACTION_REFERENCE_NEW_ROW        varchar 3       9       utf8    utf8_general_ci varchar(3)
637
637
NULL    information_schema      TRIGGERS        CREATED datetime        NULL    NULL    NULL    NULL    datetime
638
 
1.0000  information_schema      TRIGGERS        SQL_MODE        longtext        4294967295      4294967295      utf8    utf8_general_ci longtext
639
 
1.0000  information_schema      TRIGGERS        DEFINER longtext        4294967295      4294967295      utf8    utf8_general_ci longtext
 
638
3.0000  information_schema      TRIGGERS        SQL_MODE        varchar 8192    24576   utf8    utf8_general_ci varchar(8192)
 
639
3.0000  information_schema      TRIGGERS        DEFINER varchar 77      231     utf8    utf8_general_ci varchar(77)
640
640
3.0000  information_schema      TRIGGERS        CHARACTER_SET_CLIENT    varchar 32      96      utf8    utf8_general_ci varchar(32)
641
641
3.0000  information_schema      TRIGGERS        COLLATION_CONNECTION    varchar 32      96      utf8    utf8_general_ci varchar(32)
642
642
3.0000  information_schema      TRIGGERS        DATABASE_COLLATION      varchar 32      96      utf8    utf8_general_ci varchar(32)