← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/information_schema.result

  • Committer: Stewart Smith
  • Date: 2009-07-02 17:18:18 UTC
  • mfrom: (1085 staging)
  • mto: This revision was merged to the branch mainline in revision 1089.
  • Revision ID: stewart@flamingspork.com-20090702171818-qrp4d403iw8tazlg
merge mainline

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/information_schema.result
85
85
select table_name, column_name, data_type from information_schema.columns
86
86
where data_type = 'datetime';
87
87
table_name      column_name     data_type
 
88
INNODB_TRX      trx_started     datetime
 
89
INNODB_TRX      trx_wait_started        datetime
88
90
TABLES  CREATE_TIME     datetime
89
91
TABLES  UPDATE_TIME     datetime
90
92
TABLES  CHECK_TIME      datetime
91
 
INNODB_TRX      trx_started     datetime
92
 
INNODB_TRX      trx_wait_started        datetime
93
93
SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES A
94
94
WHERE NOT EXISTS 
95
95
(SELECT * FROM INFORMATION_SCHEMA.COLUMNS B
244
244
        )
245
245
AND t.table_name NOT LIKE 'falcon%';
246
246
table_name      column_name
247
 
COLUMNS TABLE_SCHEMA
248
247
GLOBAL_STATUS   VARIABLE_NAME
249
248
GLOBAL_VARIABLES        VARIABLE_NAME
250
 
KEY_COLUMN_USAGE        CONSTRAINT_SCHEMA
251
 
PLUGINS PLUGIN_NAME
252
 
REFERENTIAL_CONSTRAINTS CONSTRAINT_SCHEMA
253
 
SCHEMATA        SCHEMA_NAME
254
249
SESSION_STATUS  VARIABLE_NAME
255
250
SESSION_VARIABLES       VARIABLE_NAME
256
 
STATISTICS      TABLE_SCHEMA
257
 
TABLES  TABLE_SCHEMA
258
 
TABLE_CONSTRAINTS       CONSTRAINT_SCHEMA
259
251
INNODB_TRX      trx_id
260
252
INNODB_LOCKS    lock_id
261
253
INNODB_LOCK_WAITS       requesting_trx_id
266
258
CHARACTER_SETS  CHARACTER_SET_NAME
267
259
COLLATIONS      COLLATION_NAME
268
260
COLLATION_CHARACTER_SET_APPLICABILITY   COLLATION_NAME
 
261
COLUMNS TABLE_SCHEMA
 
262
KEY_COLUMN_USAGE        CONSTRAINT_SCHEMA
 
263
PLUGINS PLUGIN_NAME
269
264
PROCESSLIST     ID
 
265
REFERENTIAL_CONSTRAINTS CONSTRAINT_SCHEMA
 
266
SCHEMATA        SCHEMA_NAME
 
267
STATISTICS      TABLE_SCHEMA
 
268
TABLE_CONSTRAINTS       CONSTRAINT_SCHEMA
 
269
TABLES  TABLE_SCHEMA
270
270
SELECT t.table_name, c1.column_name
271
271
FROM information_schema.tables t
272
272
INNER JOIN
283
283
        )
284
284
AND t.table_name NOT LIKE 'falcon%';
285
285
table_name      column_name
286
 
COLUMNS TABLE_SCHEMA
287
286
GLOBAL_STATUS   VARIABLE_NAME
288
287
GLOBAL_VARIABLES        VARIABLE_NAME
289
 
KEY_COLUMN_USAGE        CONSTRAINT_SCHEMA
290
 
PLUGINS PLUGIN_NAME
291
 
REFERENTIAL_CONSTRAINTS CONSTRAINT_SCHEMA
292
 
SCHEMATA        SCHEMA_NAME
293
288
SESSION_STATUS  VARIABLE_NAME
294
289
SESSION_VARIABLES       VARIABLE_NAME
295
 
STATISTICS      TABLE_SCHEMA
296
 
TABLES  TABLE_SCHEMA
297
 
TABLE_CONSTRAINTS       CONSTRAINT_SCHEMA
298
290
INNODB_TRX      trx_id
299
291
INNODB_LOCKS    lock_id
300
292
INNODB_LOCK_WAITS       requesting_trx_id
305
297
CHARACTER_SETS  CHARACTER_SET_NAME
306
298
COLLATIONS      COLLATION_NAME
307
299
COLLATION_CHARACTER_SET_APPLICABILITY   COLLATION_NAME
 
300
COLUMNS TABLE_SCHEMA
 
301
KEY_COLUMN_USAGE        CONSTRAINT_SCHEMA
 
302
PLUGINS PLUGIN_NAME
308
303
PROCESSLIST     ID
 
304
REFERENTIAL_CONSTRAINTS CONSTRAINT_SCHEMA
 
305
SCHEMATA        SCHEMA_NAME
 
306
STATISTICS      TABLE_SCHEMA
 
307
TABLE_CONSTRAINTS       CONSTRAINT_SCHEMA
 
308
TABLES  TABLE_SCHEMA
309
309
SELECT MAX(table_name) FROM information_schema.tables;
310
310
MAX(table_name)
311
311
TABLE_CONSTRAINTS
495
495
utf8_hungarian_ci       utf8    242     0       Yes     8       0
496
496
utf8_sinhala_ci utf8    243     0       Yes     8       0
497
497
binary  binary  63      0       Yes     1       0
498
 
SELECT *
 
498
SELECT * 
499
499
FROM information_schema.collation_character_set_applicability;
500
500
COLLATION_NAME  CHARACTER_SET_NAME
501
501
utf8_general_ci utf8
521
521
utf8_hungarian_ci       utf8
522
522
utf8_sinhala_ci utf8
523
523
binary  binary
 
524
SELECT table_name, column_name
 
525
FROM information_schema.columns;
 
526
table_name      column_name
 
527
GLOBAL_STATUS   VARIABLE_NAME
 
528
GLOBAL_STATUS   VARIABLE_VALUE
 
529
GLOBAL_VARIABLES        VARIABLE_NAME
 
530
GLOBAL_VARIABLES        VARIABLE_VALUE
 
531
SESSION_STATUS  VARIABLE_NAME
 
532
SESSION_STATUS  VARIABLE_VALUE
 
533
SESSION_VARIABLES       VARIABLE_NAME
 
534
SESSION_VARIABLES       VARIABLE_VALUE
 
535
INNODB_TRX      trx_id
 
536
INNODB_TRX      trx_state
 
537
INNODB_TRX      trx_started
 
538
INNODB_TRX      trx_requested_lock_id
 
539
INNODB_TRX      trx_wait_started
 
540
INNODB_TRX      trx_weight
 
541
INNODB_TRX      trx_mysql_thread_id
 
542
INNODB_TRX      trx_query
 
543
INNODB_LOCKS    lock_id
 
544
INNODB_LOCKS    lock_trx_id
 
545
INNODB_LOCKS    lock_mode
 
546
INNODB_LOCKS    lock_type
 
547
INNODB_LOCKS    lock_table
 
548
INNODB_LOCKS    lock_index
 
549
INNODB_LOCKS    lock_space
 
550
INNODB_LOCKS    lock_page
 
551
INNODB_LOCKS    lock_rec
 
552
INNODB_LOCKS    lock_data
 
553
INNODB_LOCK_WAITS       requesting_trx_id
 
554
INNODB_LOCK_WAITS       requested_lock_id
 
555
INNODB_LOCK_WAITS       blocking_trx_id
 
556
INNODB_LOCK_WAITS       blocking_lock_id
 
557
INNODB_CMP      page_size
 
558
INNODB_CMP      compress_ops
 
559
INNODB_CMP      compress_ops_ok
 
560
INNODB_CMP      compress_time
 
561
INNODB_CMP      uncompress_ops
 
562
INNODB_CMP      uncompress_time
 
563
INNODB_CMP_RESET        page_size
 
564
INNODB_CMP_RESET        compress_ops
 
565
INNODB_CMP_RESET        compress_ops_ok
 
566
INNODB_CMP_RESET        compress_time
 
567
INNODB_CMP_RESET        uncompress_ops
 
568
INNODB_CMP_RESET        uncompress_time
 
569
INNODB_CMPMEM   page_size
 
570
INNODB_CMPMEM   pages_used
 
571
INNODB_CMPMEM   pages_free
 
572
INNODB_CMPMEM   relocation_ops
 
573
INNODB_CMPMEM   relocation_time
 
574
INNODB_CMPMEM_RESET     page_size
 
575
INNODB_CMPMEM_RESET     pages_used
 
576
INNODB_CMPMEM_RESET     pages_free
 
577
INNODB_CMPMEM_RESET     relocation_ops
 
578
INNODB_CMPMEM_RESET     relocation_time
 
579
CHARACTER_SETS  CHARACTER_SET_NAME
 
580
CHARACTER_SETS  DEFAULT_COLLATE_NAME
 
581
CHARACTER_SETS  DESCRIPTION
 
582
CHARACTER_SETS  MAXLEN
 
583
COLLATIONS      COLLATION_NAME
 
584
COLLATIONS      CHARACTER_SET_NAME
 
585
COLLATIONS      DESCRIPTION
 
586
COLLATIONS      ID
 
587
COLLATIONS      IS_DEFAULT
 
588
COLLATIONS      IS_COMPILED
 
589
COLLATIONS      SORTLEN
 
590
COLLATION_CHARACTER_SET_APPLICABILITY   COLLATION_NAME
 
591
COLLATION_CHARACTER_SET_APPLICABILITY   CHARACTER_SET_NAME
 
592
COLUMNS TABLE_CATALOG
 
593
COLUMNS TABLE_SCHEMA
 
594
COLUMNS TABLE_NAME
 
595
COLUMNS COLUMN_NAME
 
596
COLUMNS ORDINAL_POSITION
 
597
COLUMNS COLUMN_DEFAULT
 
598
COLUMNS IS_NULLABLE
 
599
COLUMNS DATA_TYPE
 
600
COLUMNS CHARACTER_MAXIMUM_LENGTH
 
601
COLUMNS CHARACTER_OCTET_LENGTH
 
602
COLUMNS NUMERIC_PRECISION
 
603
COLUMNS NUMERIC_SCALE
 
604
COLUMNS CHARACTER_SET_NAME
 
605
COLUMNS COLLATION_NAME
 
606
COLUMNS COLUMN_TYPE
 
607
COLUMNS COLUMN_KEY
 
608
COLUMNS EXTRA
 
609
COLUMNS PRIVILEGES
 
610
COLUMNS COLUMN_COMMENT
 
611
COLUMNS STORAGE
 
612
COLUMNS FORMAT
 
613
KEY_COLUMN_USAGE        CONSTRAINT_CATALOG
 
614
KEY_COLUMN_USAGE        CONSTRAINT_SCHEMA
 
615
KEY_COLUMN_USAGE        CONSTRAINT_NAME
 
616
KEY_COLUMN_USAGE        TABLE_CATALOG
 
617
KEY_COLUMN_USAGE        TABLE_SCHEMA
 
618
KEY_COLUMN_USAGE        TABLE_NAME
 
619
KEY_COLUMN_USAGE        COLUMN_NAME
 
620
KEY_COLUMN_USAGE        ORDINAL_POSITION
 
621
KEY_COLUMN_USAGE        POSITION_IN_UNIQUE_CONSTRAINT
 
622
KEY_COLUMN_USAGE        REFERENCED_TABLE_SCHEMA
 
623
KEY_COLUMN_USAGE        REFERENCED_TABLE_NAME
 
624
KEY_COLUMN_USAGE        REFERENCED_COLUMN_NAME
 
625
PLUGINS PLUGIN_NAME
 
626
PLUGINS PLUGIN_VERSION
 
627
PLUGINS PLUGIN_STATUS
 
628
PLUGINS PLUGIN_AUTHOR
 
629
PLUGINS PLUGIN_DESCRIPTION
 
630
PLUGINS PLUGIN_LICENSE
 
631
PROCESSLIST     ID
 
632
PROCESSLIST     USER
 
633
PROCESSLIST     HOST
 
634
PROCESSLIST     DB
 
635
PROCESSLIST     COMMAND
 
636
PROCESSLIST     TIME
 
637
PROCESSLIST     STATE
 
638
PROCESSLIST     INFO
 
639
REFERENTIAL_CONSTRAINTS CONSTRAINT_CATALOG
 
640
REFERENTIAL_CONSTRAINTS CONSTRAINT_SCHEMA
 
641
REFERENTIAL_CONSTRAINTS CONSTRAINT_NAME
 
642
REFERENTIAL_CONSTRAINTS UNIQUE_CONSTRAINT_CATALOG
 
643
REFERENTIAL_CONSTRAINTS UNIQUE_CONSTRAINT_SCHEMA
 
644
REFERENTIAL_CONSTRAINTS UNIQUE_CONSTRAINT_NAME
 
645
REFERENTIAL_CONSTRAINTS MATCH_OPTION
 
646
REFERENTIAL_CONSTRAINTS UPDATE_RULE
 
647
REFERENTIAL_CONSTRAINTS DELETE_RULE
 
648
REFERENTIAL_CONSTRAINTS TABLE_NAME
 
649
REFERENTIAL_CONSTRAINTS REFERENCED_TABLE_NAME
 
650
SCHEMATA        CATALOG_NAME
 
651
SCHEMATA        SCHEMA_NAME
 
652
SCHEMATA        DEFAULT_CHARACTER_SET_NAME
 
653
SCHEMATA        DEFAULT_COLLATION_NAME
 
654
SCHEMATA        SQL_PATH
 
655
STATISTICS      TABLE_CATALOG
 
656
STATISTICS      TABLE_SCHEMA
 
657
STATISTICS      TABLE_NAME
 
658
STATISTICS      NON_UNIQUE
 
659
STATISTICS      INDEX_SCHEMA
 
660
STATISTICS      INDEX_NAME
 
661
STATISTICS      SEQ_IN_INDEX
 
662
STATISTICS      COLUMN_NAME
 
663
STATISTICS      COLLATION
 
664
STATISTICS      CARDINALITY
 
665
STATISTICS      SUB_PART
 
666
STATISTICS      PACKED
 
667
STATISTICS      NULLABLE
 
668
STATISTICS      INDEX_TYPE
 
669
STATISTICS      COMMENT
 
670
STATISTICS      INDEX_COMMENT
 
671
TABLE_CONSTRAINTS       CONSTRAINT_CATALOG
 
672
TABLE_CONSTRAINTS       CONSTRAINT_SCHEMA
 
673
TABLE_CONSTRAINTS       CONSTRAINT_NAME
 
674
TABLE_CONSTRAINTS       TABLE_SCHEMA
 
675
TABLE_CONSTRAINTS       TABLE_NAME
 
676
TABLE_CONSTRAINTS       CONSTRAINT_TYPE
 
677
TABLES  TABLE_CATALOG
 
678
TABLES  TABLE_SCHEMA
 
679
TABLES  TABLE_NAME
 
680
TABLES  TABLE_TYPE
 
681
TABLES  ENGINE
 
682
TABLES  VERSION
 
683
TABLES  ROW_FORMAT
 
684
TABLES  TABLE_ROWS
 
685
TABLES  AVG_ROW_LENGTH
 
686
TABLES  DATA_LENGTH
 
687
TABLES  MAX_DATA_LENGTH
 
688
TABLES  INDEX_LENGTH
 
689
TABLES  DATA_FREE
 
690
TABLES  AUTO_INCREMENT
 
691
TABLES  CREATE_TIME
 
692
TABLES  UPDATE_TIME
 
693
TABLES  CHECK_TIME
 
694
TABLES  TABLE_COLLATION
 
695
TABLES  CHECKSUM
 
696
TABLES  CREATE_OPTIONS
 
697
TABLES  TABLE_COMMENT
 
698
SELECT *
 
699
FROM information_schema.key_column_usage;
 
700
CONSTRAINT_CATALOG      CONSTRAINT_SCHEMA       CONSTRAINT_NAME TABLE_CATALOG   TABLE_SCHEMA    TABLE_NAME      COLUMN_NAME     ORDINAL_POSITION        POSITION_IN_UNIQUE_CONSTRAINT   REFERENCED_TABLE_SCHEMA REFERENCED_TABLE_NAME   REFERENCED_COLUMN_NAME
 
701
SELECT * 
 
702
FROM information_schema.referential_constraints;
 
703
CONSTRAINT_CATALOG      CONSTRAINT_SCHEMA       CONSTRAINT_NAME UNIQUE_CONSTRAINT_CATALOG       UNIQUE_CONSTRAINT_SCHEMA        UNIQUE_CONSTRAINT_NAME  MATCH_OPTION    UPDATE_RULE     DELETE_RULE     TABLE_NAME      REFERENCED_TABLE_NAME
 
704
SELECT catalog_name, schema_name
 
705
FROM information_schema.schemata;
 
706
catalog_name    schema_name
 
707
NULL    information_schema
 
708
NULL    mysql
 
709
NULL    test
 
710
SELECT *
 
711
FROM information_schema.table_constraints;
 
712
CONSTRAINT_CATALOG      CONSTRAINT_SCHEMA       CONSTRAINT_NAME TABLE_SCHEMA    TABLE_NAME      CONSTRAINT_TYPE
 
713
SELECT table_schema, table_name
 
714
FROM information_schema.tables;
 
715
table_schema    table_name
 
716
information_schema      GLOBAL_STATUS
 
717
information_schema      GLOBAL_VARIABLES
 
718
information_schema      SESSION_STATUS
 
719
information_schema      SESSION_VARIABLES
 
720
information_schema      INNODB_TRX
 
721
information_schema      INNODB_LOCKS
 
722
information_schema      INNODB_LOCK_WAITS
 
723
information_schema      INNODB_CMP
 
724
information_schema      INNODB_CMP_RESET
 
725
information_schema      INNODB_CMPMEM
 
726
information_schema      INNODB_CMPMEM_RESET
 
727
information_schema      CHARACTER_SETS
 
728
information_schema      COLLATIONS
 
729
information_schema      COLLATION_CHARACTER_SET_APPLICABILITY
 
730
information_schema      COLUMNS
 
731
information_schema      KEY_COLUMN_USAGE
 
732
information_schema      PLUGINS
 
733
information_schema      PROCESSLIST
 
734
information_schema      REFERENTIAL_CONSTRAINTS
 
735
information_schema      SCHEMATA
 
736
information_schema      STATISTICS
 
737
information_schema      TABLE_CONSTRAINTS
 
738
information_schema      TABLES