← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/information_schema.result

  • Committer: Brian Aker
  • Date: 2010-01-15 01:41:40 UTC
  • mfrom: (1259.8.3 i_s_work)
  • Revision ID: brian@gaz-20100115014140-0n6kh7fqhp1abqs4
Merge Joe Daly

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/information_schema.result
122
122
SELECT table_schema, count(*) FROM information_schema.TABLES
123
123
WHERE table_name NOT LIKE 'ndb_%' AND 
124
124
table_name NOT LIKE 'falcon%' AND
125
 
table_name NOT LIKE 'MEMCACHED%'
 
125
plugin_name IS NULL
126
126
GROUP BY TABLE_SCHEMA;
127
127
table_schema    count(*)
128
128
information_schema      24
247
247
c2.column_name LIKE '%SCHEMA%'
248
248
        )
249
249
AND t.table_name NOT LIKE 'falcon%'
250
 
  AND t.table_name NOT LIKE 'MEMCACHED%';
 
250
  AND t.plugin_name IS NULL;
251
251
table_name      column_name
252
252
CHARACTER_SETS  CHARACTER_SET_NAME
253
253
COLLATIONS      COLLATION_NAME
288
288
c2.column_name LIKE '%SCHEMA%'
289
289
        )
290
290
AND t.table_name NOT LIKE 'falcon%'
291
 
  AND t.table_name NOT LIKE 'MEMCACHED%';
 
291
  AND t.plugin_name IS NULL;
292
292
table_name      column_name
293
293
CHARACTER_SETS  CHARACTER_SET_NAME
294
294
COLLATIONS      COLLATION_NAME
344
344
on t.table_schema = c1.table_schema AND t.table_name = c1.table_name
345
345
where t.table_schema = 'information_schema' AND
346
346
t.table_name not like 'falcon%' AND
347
 
t.table_name not like 'MEMCACHED%' AND
 
347
t.plugin_name IS NULL AND
348
348
c1.ordinal_position =
349
349
(select isnull(c2.column_type) -
350
350
isnull(group_concat(c2.table_schema, '.', c2.table_name)) +
447
447
select * from `information_schema`.`STATISTICS` where `TABLE_NAME` = NULL;
448
448
TABLE_CATALOG   TABLE_SCHEMA    TABLE_NAME      NON_UNIQUE      INDEX_SCHEMA    INDEX_NAME      SEQ_IN_INDEX    COLUMN_NAME     COLLATION       CARDINALITY     SUB_PART        PACKED  NULLABLE        INDEX_TYPE      COMMENT INDEX_COMMENT
449
449
select * from information_schema.tables where table_schema = NULL;
450
 
TABLE_CATALOG   TABLE_SCHEMA    TABLE_NAME      TABLE_TYPE      ENGINE  VERSION ROW_FORMAT      TABLE_ROWS      AVG_ROW_LENGTH  DATA_LENGTH     MAX_DATA_LENGTH INDEX_LENGTH    DATA_FREE       AUTO_INCREMENT  CREATE_TIME     UPDATE_TIME     CHECK_TIME      TABLE_COLLATION CHECKSUM        CREATE_OPTIONS  TABLE_COMMENT
 
450
TABLE_CATALOG   TABLE_SCHEMA    TABLE_NAME      TABLE_TYPE      ENGINE  VERSION ROW_FORMAT      TABLE_ROWS      AVG_ROW_LENGTH  DATA_LENGTH     MAX_DATA_LENGTH INDEX_LENGTH    DATA_FREE       AUTO_INCREMENT  CREATE_TIME     UPDATE_TIME     CHECK_TIME      TABLE_COLLATION CHECKSUM        CREATE_OPTIONS  TABLE_COMMENT   PLUGIN_NAME
451
451
select * from information_schema.tables where table_catalog = NULL;
452
 
TABLE_CATALOG   TABLE_SCHEMA    TABLE_NAME      TABLE_TYPE      ENGINE  VERSION ROW_FORMAT      TABLE_ROWS      AVG_ROW_LENGTH  DATA_LENGTH     MAX_DATA_LENGTH INDEX_LENGTH    DATA_FREE       AUTO_INCREMENT  CREATE_TIME     UPDATE_TIME     CHECK_TIME      TABLE_COLLATION CHECKSUM        CREATE_OPTIONS  TABLE_COMMENT
 
452
TABLE_CATALOG   TABLE_SCHEMA    TABLE_NAME      TABLE_TYPE      ENGINE  VERSION ROW_FORMAT      TABLE_ROWS      AVG_ROW_LENGTH  DATA_LENGTH     MAX_DATA_LENGTH INDEX_LENGTH    DATA_FREE       AUTO_INCREMENT  CREATE_TIME     UPDATE_TIME     CHECK_TIME      TABLE_COLLATION CHECKSUM        CREATE_OPTIONS  TABLE_COMMENT   PLUGIN_NAME
453
453
select * from information_schema.tables where table_name = NULL;
454
 
TABLE_CATALOG   TABLE_SCHEMA    TABLE_NAME      TABLE_TYPE      ENGINE  VERSION ROW_FORMAT      TABLE_ROWS      AVG_ROW_LENGTH  DATA_LENGTH     MAX_DATA_LENGTH INDEX_LENGTH    DATA_FREE       AUTO_INCREMENT  CREATE_TIME     UPDATE_TIME     CHECK_TIME      TABLE_COLLATION CHECKSUM        CREATE_OPTIONS  TABLE_COMMENT
 
454
TABLE_CATALOG   TABLE_SCHEMA    TABLE_NAME      TABLE_TYPE      ENGINE  VERSION ROW_FORMAT      TABLE_ROWS      AVG_ROW_LENGTH  DATA_LENGTH     MAX_DATA_LENGTH INDEX_LENGTH    DATA_FREE       AUTO_INCREMENT  CREATE_TIME     UPDATE_TIME     CHECK_TIME      TABLE_COLLATION CHECKSUM        CREATE_OPTIONS  TABLE_COMMENT   PLUGIN_NAME
455
455
select * from `information_schema`.`TABLE_CONSTRAINTS` where `TABLE_SCHEMA` = NULL;
456
456
CONSTRAINT_CATALOG      CONSTRAINT_SCHEMA       CONSTRAINT_NAME TABLE_SCHEMA    TABLE_NAME      CONSTRAINT_TYPE
457
457
select * from `information_schema`.`TABLE_CONSTRAINTS` where `TABLE_NAME` = NULL;
536
536
utf8_unicode_ci utf8
537
537
SELECT table_name, column_name
538
538
FROM information_schema.columns
539
 
WHERE table_name NOT LIKE 'MEMCACHED%'
 
539
WHERE table_name IN
 
540
(SELECT table_name FROM information_schema.tables 
 
541
WHERE plugin_name IS NULL)
540
542
ORDER BY table_name;
541
543
table_name      column_name
542
544
CHARACTER_SETS  CHARACTER_SET_NAME
697
699
TABLES  CHECKSUM
698
700
TABLES  CREATE_OPTIONS
699
701
TABLES  TABLE_COMMENT
 
702
TABLES  PLUGIN_NAME
700
703
TABLES  INDEX_LENGTH
701
704
TABLES  MAX_DATA_LENGTH
702
 
TABLES  DATA_LENGTH
703
705
TABLES  TABLE_CATALOG
704
706
TABLES  TABLE_SCHEMA
705
707
TABLES  TABLE_NAME
709
711
TABLES  ROW_FORMAT
710
712
TABLES  TABLE_ROWS
711
713
TABLES  AVG_ROW_LENGTH
 
714
TABLES  DATA_LENGTH
712
715
TABLE_CONSTRAINTS       TABLE_NAME
713
716
TABLE_CONSTRAINTS       TABLE_SCHEMA
714
717
TABLE_CONSTRAINTS       CONSTRAINT_NAME
1052
1055
CONSTRAINT_CATALOG      CONSTRAINT_SCHEMA       CONSTRAINT_NAME TABLE_SCHEMA    TABLE_NAME      CONSTRAINT_TYPE
1053
1056
SELECT table_schema, table_name
1054
1057
FROM information_schema.tables
1055
 
WHERE table_name NOT LIKE 'MEMCACHED%'
 
1058
WHERE plugin_name IS NULL
1056
1059
ORDER BY table_name;
1057
1060
table_schema    table_name
1058
1061
information_schema      CHARACTER_SETS