« back to all changes in this revision
Viewing changes to tests/r/information_schema.result
- browse files at revision 1303
- compare with another revision
- compare with revision 1219
- download diff
- download tarball
- view history from revision 1303
- Committer: Brian Aker
- Date: 2010-02-17 01:56:39 UTC
- mfrom: (1273.13.69 build)
- Revision ID: brian@gaz-20100217015639-ou3s722vekucn5fd
Many updates. Brian, Monty.
- files removed:
- plugin/info_schema/status.cc
- files modified:
- drizzled/item.h
added
removed
tests/r/information_schema.result
113
113
table_name NOT LIKE 'falcon%'
114
114
GROUP BY TABLE_SCHEMA ORDER BY table_schema;
115
115
table_schema count(*)
116
information_schema 16
116
information_schema 12
117
117
show create database information_schema;
118
118
Database Create Database
119
119
information_schema CREATE DATABASE `information_schema`
244
244
INNODB_LOCK_WAITS requesting_trx_id
245
245
INNODB_TRX trx_id
246
246
OLD_COLUMNS TABLE_SCHEMA
247
OLD_GLOBAL_STATUS VARIABLE_NAME
248
OLD_GLOBAL_VARIABLES VARIABLE_NAME
249
247
OLD_KEY_COLUMN_USAGE CONSTRAINT_SCHEMA
250
248
OLD_REFERENTIAL_CONSTRAINTS CONSTRAINT_SCHEMA
251
OLD_SESSION_VARIABLES VARIABLE_NAME
252
249
OLD_STATISTICS TABLE_SCHEMA
253
250
OLD_TABLE_CONSTRAINTS CONSTRAINT_SCHEMA
254
OPEN_SESSION_STATUS VARIABLE_NAME
255
251
SELECT t.table_name, c1.column_name
256
252
FROM data_dictionary.tables t
257
253
INNER JOIN
277
273
INNODB_LOCK_WAITS requesting_trx_id
278
274
INNODB_TRX trx_id
279
275
OLD_COLUMNS TABLE_SCHEMA
280
OLD_GLOBAL_STATUS VARIABLE_NAME
281
OLD_GLOBAL_VARIABLES VARIABLE_NAME
282
276
OLD_KEY_COLUMN_USAGE CONSTRAINT_SCHEMA
283
277
OLD_REFERENTIAL_CONSTRAINTS CONSTRAINT_SCHEMA
284
OLD_SESSION_VARIABLES VARIABLE_NAME
285
278
OLD_STATISTICS TABLE_SCHEMA
286
279
OLD_TABLE_CONSTRAINTS CONSTRAINT_SCHEMA
287
OPEN_SESSION_STATUS VARIABLE_NAME
288
280
SELECT MAX(table_name) FROM data_dictionary.tables;
289
281
MAX(table_name)
290
OPEN_SESSION_STATUS
282
OLD_TABLE_CONSTRAINTS
291
283
SELECT table_name from data_dictionary.tables
292
284
WHERE table_name=(SELECT MAX(table_name)
293
285
FROM data_dictionary.tables)
294
286
ORDER BY table_name;
295
287
table_name
296
OPEN_SESSION_STATUS
288
OLD_TABLE_CONSTRAINTS
297
289
create table t1 (f1 int);
298
290
create table t2 (f1 int, f2 int);
299
291
select table_name from data_dictionary.tables
376
368
WHERE TABLE_SCHEMA='mysql' and TABLE_NAME= 'db';
377
369
TABLE_COLLATION
378
370
select * from data_dictionary.columns where table_schema = NULL;
379
TABLE_SCHEMA TABLE_NAME COLUMN_NAME ORDINAL_POSITION COLUMN_DEFAULT IS_NULLABLE DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE COLLATION_NAME COLUMN_COMMENT
371
TABLE_SCHEMA TABLE_NAME COLUMN_NAME ORDINAL_POSITION COLUMN_DEFAULT IS_NULLABLE DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE COLLATION_NAME COLUMN_KEY EXTRA COLUMN_COMMENT
380
372
select * from `data_dictionary`.`columns` where `TABLE_NAME` = NULL;
381
TABLE_SCHEMA TABLE_NAME COLUMN_NAME ORDINAL_POSITION COLUMN_DEFAULT IS_NULLABLE DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE COLLATION_NAME COLUMN_COMMENT
373
TABLE_SCHEMA TABLE_NAME COLUMN_NAME ORDINAL_POSITION COLUMN_DEFAULT IS_NULLABLE DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE COLLATION_NAME COLUMN_KEY EXTRA COLUMN_COMMENT
382
374
select * from `information_schema`.`OLD_KEY_COLUMN_USAGE` where `TABLE_SCHEMA` = NULL;
383
375
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
384
376
select * from `information_schema`.`OLD_KEY_COLUMN_USAGE` where `TABLE_NAME` = NULL;
523
515
OLD_COLUMNS IS_NULLABLE
524
516
OLD_COLUMNS DATA_TYPE
525
517
OLD_COLUMNS CHARACTER_MAXIMUM_LENGTH
526
OLD_GLOBAL_STATUS VARIABLE_VALUE
527
OLD_GLOBAL_STATUS VARIABLE_NAME
528
OLD_GLOBAL_VARIABLES VARIABLE_NAME
529
OLD_GLOBAL_VARIABLES VARIABLE_VALUE
518
OLD_KEY_COLUMN_USAGE ORDINAL_POSITION
519
OLD_KEY_COLUMN_USAGE POSITION_IN_UNIQUE_CONSTRAINT
520
OLD_KEY_COLUMN_USAGE REFERENCED_TABLE_SCHEMA
521
OLD_KEY_COLUMN_USAGE REFERENCED_TABLE_NAME
530
522
OLD_KEY_COLUMN_USAGE REFERENCED_COLUMN_NAME
531
OLD_KEY_COLUMN_USAGE REFERENCED_TABLE_NAME
532
OLD_KEY_COLUMN_USAGE REFERENCED_TABLE_SCHEMA
533
OLD_KEY_COLUMN_USAGE POSITION_IN_UNIQUE_CONSTRAINT
534
OLD_KEY_COLUMN_USAGE ORDINAL_POSITION
535
523
OLD_KEY_COLUMN_USAGE COLUMN_NAME
536
524
OLD_KEY_COLUMN_USAGE TABLE_NAME
537
525
OLD_KEY_COLUMN_USAGE CONSTRAINT_CATALOG
550
538
OLD_REFERENTIAL_CONSTRAINTS CONSTRAINT_NAME
551
539
OLD_REFERENTIAL_CONSTRAINTS CONSTRAINT_SCHEMA
552
540
OLD_REFERENTIAL_CONSTRAINTS CONSTRAINT_CATALOG
553
OLD_SESSION_VARIABLES VARIABLE_VALUE
554
OLD_SESSION_VARIABLES VARIABLE_NAME
541
OLD_STATISTICS COLUMN_NAME
542
OLD_STATISTICS COLLATION
543
OLD_STATISTICS CARDINALITY
544
OLD_STATISTICS SUB_PART
545
OLD_STATISTICS SEQ_IN_INDEX
546
OLD_STATISTICS INDEX_NAME
547
OLD_STATISTICS INDEX_SCHEMA
548
OLD_STATISTICS NON_UNIQUE
549
OLD_STATISTICS TABLE_NAME
550
OLD_STATISTICS TABLE_SCHEMA
555
551
OLD_STATISTICS TABLE_CATALOG
556
OLD_STATISTICS TABLE_SCHEMA
557
OLD_STATISTICS TABLE_NAME
558
OLD_STATISTICS NON_UNIQUE
559
OLD_STATISTICS INDEX_SCHEMA
560
OLD_STATISTICS INDEX_NAME
561
OLD_STATISTICS SEQ_IN_INDEX
552
OLD_STATISTICS PACKED
553
OLD_STATISTICS NULLABLE
554
OLD_STATISTICS INDEX_TYPE
555
OLD_STATISTICS COMMENT
562
556
OLD_STATISTICS INDEX_COMMENT
563
OLD_STATISTICS COMMENT
564
OLD_STATISTICS INDEX_TYPE
565
OLD_STATISTICS NULLABLE
566
OLD_STATISTICS PACKED
567
OLD_STATISTICS SUB_PART
568
OLD_STATISTICS CARDINALITY
569
OLD_STATISTICS COLLATION
570
OLD_STATISTICS COLUMN_NAME
571
OLD_TABLE_CONSTRAINTS CONSTRAINT_TYPE
572
557
OLD_TABLE_CONSTRAINTS TABLE_NAME
573
558
OLD_TABLE_CONSTRAINTS TABLE_SCHEMA
574
559
OLD_TABLE_CONSTRAINTS CONSTRAINT_NAME
575
560
OLD_TABLE_CONSTRAINTS CONSTRAINT_SCHEMA
576
561
OLD_TABLE_CONSTRAINTS CONSTRAINT_CATALOG
577
OPEN_SESSION_STATUS VARIABLE_NAME
578
OPEN_SESSION_STATUS VARIABLE_VALUE
562
OLD_TABLE_CONSTRAINTS CONSTRAINT_TYPE
579
563
SELECT *
580
564
FROM information_schema.old_key_column_usage;
581
565
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
642
626
# #
643
627
# #
644
628
# #
645
# #
646
# #
647
# #
648
# #
649
# #
650
# #
651
# #
652
# #
653
# #
654
# #
655
# #
656
# #
657
# #
658
# #
659
# #
660
# #
661
# #
662
# #
663
# #
664
# #
665
# #
666
# #
667
# #
668
# #
669
# #
670
# #
671
# #
672
# #
673
# #
674
# #
675
# #
676
# #
677
# #
678
# #
679
# #
680
# #
681
# #
682
# #
683
# #
684
# #
685
# #
686
# #
687
# #
688
# #
689
# #
690
# #
691
SELECT *
692
FROM information_schema.old_global_status
693
ORDER BY variable_name;
694
VARIABLE_NAME VARIABLE_VALUE
629
SELECT *
630
FROM data_dictionary.session_variables
631
ORDER BY variable_name;
632
VARIABLE_NAME VARIABLE_VALUE
633
# #
634
# #
635
# #
636
# #
637
# #
638
# #
639
# #
640
# #
641
# #
642
# #
643
# #
644
# #
645
# #
646
# #
647
# #
648
# #
649
# #
650
# #
651
# #
652
# #
653
# #
654
# #
655
# #
656
# #
657
# #
658
# #
659
# #
660
# #
661
# #
662
# #
663
# #
664
# #
665
# #
666
# #
667
# #
668
# #
669
# #
670
# #
671
# #
672
# #
673
# #
674
# #
675
# #
676
# #
677
# #
678
# #
679
# #
680
# #
681
# #
682
# #
683
# #
684
# #
685
# #
686
# #
687
# #
688
# #
689
# #
690
# #
691
# #
692
# #
693
# #
694
# #
695
# #
696
# #
697
# #
698
# #
699
# #
700
# #
701
# #
702
# #
703
# #
704
# #
705
# #
706
# #
707
# #
708
# #
709
# #
710
# #
711
# #
712
# #
713
# #
714
# #
715
# #
716
# #
717
# #
718
# #
719
# #
720
# #
721
# #
722
# #
723
# #
724
# #
725
# #
726
# #
727
# #
728
# #
729
# #
730
# #
731
# #
732
# #
733
# #
734
# #
735
# #
736
# #
737
# #
738
# #
739
# #
740
# #
741
# #
742
# #
743
# #
744
# #
745
# #
746
# #
747
# #
748
# #
749
# #
750
# #
751
# #
752
# #
753
# #
754
# #
755
# #
756
# #
757
# #
758
# #
759
# #
760
# #
761
# #
762
# #
763
# #
764
# #
765
# #
766
# #
767
# #
768
# #
769
# #
770
# #
771
# #
772
# #
773
# #
774
# #
775
# #
776
# #
777
# #
778
# #
779
# #
780
# #
781
# #
782
# #
783
# #
784
# #
785
# #
786
SELECT *
787
FROM data_dictionary.global_status
788
ORDER BY variable_name;
789
VARIABLE_NAME VARIABLE_VALUE
790
# #
791
# #
792
# #
793
# #
794
# #
795
# #
796
# #
797
# #
798
# #
799
# #
800
# #
801
# #
802
# #
803
# #
804
# #
805
# #
806
# #
807
# #
808
# #
809
# #
810
# #
811
# #
812
# #
813
# #
814
# #
815
# #
816
# #
817
# #
818
# #
819
# #
820
# #
821
# #
822
# #
823
# #
824
# #
825
# #
826
# #
827
# #
828
# #
829
# #
830
# #
831
# #
832
# #
833
# #
834
# #
835
# #
836
# #
837
# #
838
# #
839
# #
840
# #
841
# #
842
# #
843
# #
844
# #
845
SELECT *
846
FROM data_dictionary.global_variables
847
ORDER BY variable_name;
848
VARIABLE_NAME VARIABLE_VALUE
849
# #
850
# #
851
# #
852
# #
853
# #
854
# #
855
# #
856
# #
857
# #
858
# #
859
# #
860
# #
861
# #
862
# #
863
# #
864
# #
865
# #
866
# #
867
# #
868
# #
869
# #
870
# #
871
# #
872
# #
873
# #
874
# #
875
# #
876
# #
877
# #
878
# #
879
# #
880
# #
881
# #
882
# #
883
# #
884
# #
885
# #
886
# #
887
# #
888
# #
889
# #
890
# #
891
# #
892
# #
893
# #
894
# #
895
# #
896
# #
897
# #
898
# #
899
# #
900
# #
695
901
# #
696
902
# #
697
903
# #
Loggerhead is a web-based interface for Breezy
Version: 2.0.1