← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/information_schema.result

Merged trunk.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/information_schema.result
1
1
DROP TABLE IF EXISTS t0,t1,t2,t3,t4,t5;
2
 
select count(*) from data_dictionary.schemas where schema_name > 'm';
3
 
count(*)
4
 
#
5
 
select schema_name from data_dictionary.schemas;
6
 
schema_name
7
 
information_schema
8
 
mysql
9
 
test
10
 
show databases like 't%';
11
 
Database (t%)
12
 
test
13
 
show databases;
14
 
Database
15
 
information_schema
16
 
mysql
17
 
test
18
2
create database mysqltest;
19
3
create table mysqltest.t1(a int, b VARCHAR(30), KEY string_data (b));
20
4
create table test.t2(a int);
53
37
b       varchar(30)     YES     MUL     NULL    
54
38
drop tables mysqltest.t4, mysqltest.t1, t2, t3, t5;
55
39
drop database mysqltest;
56
 
select * from data_dictionary.CHARACTER_SETS
57
 
where CHARACTER_SET_NAME like 'latin1%';
58
 
CHARACTER_SET_NAME      DEFAULT_COLLATE_NAME    DESCRIPTION     MAXLEN
59
 
select * from data_dictionary.COLLATIONS
60
 
where COLLATION_NAME like 'latin1%';
61
 
CHARACTER_SET_NAME      COLLATION_NAME  DESCRIPTION     ID      IS_DEFAULT      IS_COMPILED     SORTLEN
62
40
select * from information_schema.old_table_names;
63
41
ERROR 42S02: Unknown table 'old_table_names' in information_schema
64
42
select column_type from information_schema.old_columns
77
55
table_schema    table_name      column_name
78
56
select table_name, column_name, data_type from data_dictionary.columns where data_type = 'datetime';
79
57
table_name      column_name     data_type
 
58
INNODB_TRX      trx_started     DATETIME
 
59
INNODB_TRX      trx_wait_started        DATETIME
80
60
SELECT COUNT(*) FROM data_dictionary.tables A
81
61
WHERE NOT EXISTS 
82
62
(SELECT * FROM data_dictionary.columns B
111
91
table_name NOT LIKE 'falcon%'
112
92
GROUP BY TABLE_SCHEMA ORDER BY table_schema;
113
93
table_schema    count(*)
114
 
information_schema      16
 
94
information_schema      12
115
95
show create database information_schema;
116
96
Database        Create Database
117
97
information_schema      CREATE DATABASE `information_schema`
242
222
INNODB_LOCK_WAITS       requesting_trx_id
243
223
INNODB_TRX      trx_id
244
224
OLD_COLUMNS     TABLE_SCHEMA
245
 
OLD_GLOBAL_STATUS       VARIABLE_NAME
246
 
OLD_GLOBAL_VARIABLES    VARIABLE_NAME
247
225
OLD_KEY_COLUMN_USAGE    CONSTRAINT_SCHEMA
248
226
OLD_REFERENTIAL_CONSTRAINTS     CONSTRAINT_SCHEMA
249
 
OLD_SESSION_VARIABLES   VARIABLE_NAME
250
227
OLD_STATISTICS  TABLE_SCHEMA
251
228
OLD_TABLE_CONSTRAINTS   CONSTRAINT_SCHEMA
252
 
OPEN_SESSION_STATUS     VARIABLE_NAME
253
229
SELECT t.table_name, c1.column_name
254
230
FROM data_dictionary.tables t
255
231
INNER JOIN
275
251
INNODB_LOCK_WAITS       requesting_trx_id
276
252
INNODB_TRX      trx_id
277
253
OLD_COLUMNS     TABLE_SCHEMA
278
 
OLD_GLOBAL_STATUS       VARIABLE_NAME
279
 
OLD_GLOBAL_VARIABLES    VARIABLE_NAME
280
254
OLD_KEY_COLUMN_USAGE    CONSTRAINT_SCHEMA
281
255
OLD_REFERENTIAL_CONSTRAINTS     CONSTRAINT_SCHEMA
282
 
OLD_SESSION_VARIABLES   VARIABLE_NAME
283
256
OLD_STATISTICS  TABLE_SCHEMA
284
257
OLD_TABLE_CONSTRAINTS   CONSTRAINT_SCHEMA
285
 
OPEN_SESSION_STATUS     VARIABLE_NAME
286
258
SELECT MAX(table_name) FROM data_dictionary.tables;
287
259
MAX(table_name)
288
 
OPEN_SESSION_STATUS
 
260
OLD_TABLE_CONSTRAINTS
289
261
SELECT table_name from data_dictionary.tables
290
262
WHERE table_name=(SELECT MAX(table_name)
291
263
FROM data_dictionary.tables)
292
264
ORDER BY table_name;
293
265
table_name
294
 
OPEN_SESSION_STATUS
 
266
OLD_TABLE_CONSTRAINTS
295
267
create table t1 (f1 int);
296
268
create table t2 (f1 int, f2 int);
297
 
select table_name from data_dictionary.tables
298
 
where table_schema = 'test' and table_name not in
299
 
(select table_name from information_schema.old_columns
300
 
where table_schema = 'test' and column_name = 'f3')
301
 
ORDER BY table_name;
302
 
table_name
303
 
t1
304
 
t2
305
269
drop table t1,t2;
306
270
select 1 as f1 from data_dictionary.tables  where "CHARACTER_SETS"=
307
271
(select cast(table_name as char)  from data_dictionary.tables
338
302
f7 datetime not null,
339
303
f8 datetime default '2006-01-01'
340
304
);
341
 
select column_default from information_schema.old_columns where table_name= 't1' ORDER BY column_default;
342
 
column_default
343
 
NULL
344
 
NULL
345
 
NULL
346
 
NULL
347
 
NULL
348
 
 
349
 
10
350
 
2006-01-01 00:00:00
351
305
show columns from t1;
352
306
Field   Type    Null    Key     Default Extra
353
307
f1      varchar(50)     YES             NULL    
374
328
WHERE TABLE_SCHEMA='mysql' and TABLE_NAME= 'db';
375
329
TABLE_COLLATION
376
330
select * from data_dictionary.columns where table_schema = NULL;
377
 
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
 
331
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
378
332
select * from `data_dictionary`.`columns` where `TABLE_NAME` = 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
 
333
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
334
select * from `information_schema`.`OLD_KEY_COLUMN_USAGE` where `TABLE_SCHEMA` = NULL;
381
335
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
382
336
select * from `information_schema`.`OLD_KEY_COLUMN_USAGE` where `TABLE_NAME` = NULL;
405
359
SELECT info FROM data_dictionary.processlist WHERE id = CONNECTION_ID();
406
360
info
407
361
SELECT info FROM data_dictionary.processlist WHERE id = CONNECTION_ID()
408
 
show processlist;
409
 
ID      USER    HOST    DB      COMMAND TIME    STATE   INFO
410
 
#       #       #       test    Query   #       #       show processlist
411
 
#       #       #       test    Sleep   #       #       show processlist
412
 
#       #       #       mysqltest       Sleep   #       #       show processlist
413
362
SELECT info, command, db
414
363
FROM data_dictionary.processlist
415
364
WHERE id = CONNECTION_ID();
418
367
FROM data_dictionary.processlist
419
368
WHERE id = CONNECTION_ID()      Query   test
420
369
SELECT *
421
 
FROM data_dictionary.character_sets
422
 
ORDER BY character_set_name;
423
 
CHARACTER_SET_NAME      DEFAULT_COLLATE_NAME    DESCRIPTION     MAXLEN
424
 
binary  binary  UTF-8 Unicode   1
425
 
utf8    utf8_general_ci UTF-8 Unicode   4
426
 
SELECT *
427
 
FROM data_dictionary.collations
428
 
ORDER BY collation_name;
429
 
CHARACTER_SET_NAME      COLLATION_NAME  DESCRIPTION     ID      IS_DEFAULT      IS_COMPILED     SORTLEN
430
 
binary  binary  binary  63      TRUE    TRUE    1
431
 
utf8_general_ci utf8_bin        utf8    46      FALSE   TRUE    1
432
 
utf8_general_ci utf8_czech_ci   utf8    234     FALSE   TRUE    8
433
 
utf8_general_ci utf8_danish_ci  utf8    235     FALSE   TRUE    8
434
 
utf8_general_ci utf8_esperanto_ci       utf8    241     FALSE   TRUE    8
435
 
utf8_general_ci utf8_estonian_ci        utf8    230     FALSE   TRUE    8
436
 
utf8_general_ci utf8_general_ci utf8    45      TRUE    TRUE    1
437
 
utf8_general_ci utf8_hungarian_ci       utf8    242     FALSE   TRUE    8
438
 
utf8_general_ci utf8_icelandic_ci       utf8    225     FALSE   TRUE    8
439
 
utf8_general_ci utf8_latvian_ci utf8    226     FALSE   TRUE    8
440
 
utf8_general_ci utf8_lithuanian_ci      utf8    236     FALSE   TRUE    8
441
 
utf8_general_ci utf8_persian_ci utf8    240     FALSE   TRUE    8
442
 
utf8_general_ci utf8_polish_ci  utf8    229     FALSE   TRUE    8
443
 
utf8_general_ci utf8_romanian_ci        utf8    227     FALSE   TRUE    8
444
 
utf8_general_ci utf8_roman_ci   utf8    239     FALSE   TRUE    8
445
 
utf8_general_ci utf8_sinhala_ci utf8    243     FALSE   TRUE    8
446
 
utf8_general_ci utf8_slovak_ci  utf8    237     FALSE   TRUE    8
447
 
utf8_general_ci utf8_slovenian_ci       utf8    228     FALSE   TRUE    8
448
 
utf8_general_ci utf8_spanish2_ci        utf8    238     FALSE   TRUE    8
449
 
utf8_general_ci utf8_spanish_ci utf8    231     FALSE   TRUE    8
450
 
utf8_general_ci utf8_swedish_ci utf8    232     FALSE   TRUE    8
451
 
utf8_general_ci utf8_turkish_ci utf8    233     FALSE   TRUE    8
452
 
utf8_general_ci utf8_unicode_ci utf8    224     FALSE   TRUE    8
453
 
SELECT table_name, column_name
454
 
FROM data_dictionary.columns
455
 
WHERE table_name IN
456
 
(SELECT table_name FROM data_dictionary.tables )
457
 
ORDER BY table_name;
458
 
table_name      column_name
459
 
INNODB_CMP      page_size
460
 
INNODB_CMP      compress_ops
461
 
INNODB_CMP      compress_ops_ok
462
 
INNODB_CMP      compress_time
463
 
INNODB_CMP      uncompress_ops
464
 
INNODB_CMP      uncompress_time
465
 
INNODB_CMPMEM   relocation_time
466
 
INNODB_CMPMEM   relocation_ops
467
 
INNODB_CMPMEM   pages_free
468
 
INNODB_CMPMEM   pages_used
469
 
INNODB_CMPMEM   page_size
470
 
INNODB_CMPMEM_RESET     relocation_time
471
 
INNODB_CMPMEM_RESET     relocation_ops
472
 
INNODB_CMPMEM_RESET     pages_free
473
 
INNODB_CMPMEM_RESET     pages_used
474
 
INNODB_CMPMEM_RESET     page_size
475
 
INNODB_CMP_RESET        uncompress_time
476
 
INNODB_CMP_RESET        uncompress_ops
477
 
INNODB_CMP_RESET        compress_time
478
 
INNODB_CMP_RESET        compress_ops_ok
479
 
INNODB_CMP_RESET        compress_ops
480
 
INNODB_CMP_RESET        page_size
481
 
INNODB_LOCKS    lock_data
482
 
INNODB_LOCKS    lock_rec
483
 
INNODB_LOCKS    lock_page
484
 
INNODB_LOCKS    lock_space
485
 
INNODB_LOCKS    lock_index
486
 
INNODB_LOCKS    lock_table
487
 
INNODB_LOCKS    lock_type
488
 
INNODB_LOCKS    lock_mode
489
 
INNODB_LOCKS    lock_trx_id
490
 
INNODB_LOCKS    lock_id
491
 
INNODB_LOCK_WAITS       blocking_lock_id
492
 
INNODB_LOCK_WAITS       blocking_trx_id
493
 
INNODB_LOCK_WAITS       requested_lock_id
494
 
INNODB_LOCK_WAITS       requesting_trx_id
495
 
INNODB_TRX      trx_query
496
 
INNODB_TRX      trx_mysql_thread_id
497
 
INNODB_TRX      trx_weight
498
 
INNODB_TRX      trx_wait_started
499
 
INNODB_TRX      trx_requested_lock_id
500
 
INNODB_TRX      trx_started
501
 
INNODB_TRX      trx_state
502
 
INNODB_TRX      trx_id
503
 
OLD_COLUMNS     CHARACTER_SET_NAME
504
 
OLD_COLUMNS     COLLATION_NAME
505
 
OLD_COLUMNS     COLUMN_TYPE
506
 
OLD_COLUMNS     COLUMN_KEY
507
 
OLD_COLUMNS     EXTRA
508
 
OLD_COLUMNS     PRIVILEGES
509
 
OLD_COLUMNS     COLUMN_COMMENT
510
 
OLD_COLUMNS     STORAGE
511
 
OLD_COLUMNS     FORMAT
512
 
OLD_COLUMNS     NUMERIC_SCALE
513
 
OLD_COLUMNS     NUMERIC_PRECISION
514
 
OLD_COLUMNS     CHARACTER_OCTET_LENGTH
515
 
OLD_COLUMNS     TABLE_CATALOG
516
 
OLD_COLUMNS     TABLE_SCHEMA
517
 
OLD_COLUMNS     TABLE_NAME
518
 
OLD_COLUMNS     COLUMN_NAME
519
 
OLD_COLUMNS     ORDINAL_POSITION
520
 
OLD_COLUMNS     COLUMN_DEFAULT
521
 
OLD_COLUMNS     IS_NULLABLE
522
 
OLD_COLUMNS     DATA_TYPE
523
 
OLD_COLUMNS     CHARACTER_MAXIMUM_LENGTH
524
 
OLD_GLOBAL_STATUS       VARIABLE_VALUE
525
 
OLD_GLOBAL_STATUS       VARIABLE_NAME
526
 
OLD_GLOBAL_VARIABLES    VARIABLE_NAME
527
 
OLD_GLOBAL_VARIABLES    VARIABLE_VALUE
528
 
OLD_KEY_COLUMN_USAGE    REFERENCED_COLUMN_NAME
529
 
OLD_KEY_COLUMN_USAGE    REFERENCED_TABLE_NAME
530
 
OLD_KEY_COLUMN_USAGE    REFERENCED_TABLE_SCHEMA
531
 
OLD_KEY_COLUMN_USAGE    POSITION_IN_UNIQUE_CONSTRAINT
532
 
OLD_KEY_COLUMN_USAGE    ORDINAL_POSITION
533
 
OLD_KEY_COLUMN_USAGE    COLUMN_NAME
534
 
OLD_KEY_COLUMN_USAGE    TABLE_NAME
535
 
OLD_KEY_COLUMN_USAGE    CONSTRAINT_CATALOG
536
 
OLD_KEY_COLUMN_USAGE    CONSTRAINT_SCHEMA
537
 
OLD_KEY_COLUMN_USAGE    CONSTRAINT_NAME
538
 
OLD_KEY_COLUMN_USAGE    TABLE_CATALOG
539
 
OLD_KEY_COLUMN_USAGE    TABLE_SCHEMA
540
 
OLD_REFERENTIAL_CONSTRAINTS     REFERENCED_TABLE_NAME
541
 
OLD_REFERENTIAL_CONSTRAINTS     TABLE_NAME
542
 
OLD_REFERENTIAL_CONSTRAINTS     DELETE_RULE
543
 
OLD_REFERENTIAL_CONSTRAINTS     UPDATE_RULE
544
 
OLD_REFERENTIAL_CONSTRAINTS     MATCH_OPTION
545
 
OLD_REFERENTIAL_CONSTRAINTS     UNIQUE_CONSTRAINT_NAME
546
 
OLD_REFERENTIAL_CONSTRAINTS     UNIQUE_CONSTRAINT_SCHEMA
547
 
OLD_REFERENTIAL_CONSTRAINTS     UNIQUE_CONSTRAINT_CATALOG
548
 
OLD_REFERENTIAL_CONSTRAINTS     CONSTRAINT_NAME
549
 
OLD_REFERENTIAL_CONSTRAINTS     CONSTRAINT_SCHEMA
550
 
OLD_REFERENTIAL_CONSTRAINTS     CONSTRAINT_CATALOG
551
 
OLD_SESSION_VARIABLES   VARIABLE_VALUE
552
 
OLD_SESSION_VARIABLES   VARIABLE_NAME
553
 
OLD_STATISTICS  TABLE_CATALOG
554
 
OLD_STATISTICS  TABLE_SCHEMA
555
 
OLD_STATISTICS  TABLE_NAME
556
 
OLD_STATISTICS  NON_UNIQUE
557
 
OLD_STATISTICS  INDEX_SCHEMA
558
 
OLD_STATISTICS  INDEX_NAME
559
 
OLD_STATISTICS  SEQ_IN_INDEX
560
 
OLD_STATISTICS  INDEX_COMMENT
561
 
OLD_STATISTICS  COMMENT
562
 
OLD_STATISTICS  INDEX_TYPE
563
 
OLD_STATISTICS  NULLABLE
564
 
OLD_STATISTICS  PACKED
565
 
OLD_STATISTICS  SUB_PART
566
 
OLD_STATISTICS  CARDINALITY
567
 
OLD_STATISTICS  COLLATION
568
 
OLD_STATISTICS  COLUMN_NAME
569
 
OLD_TABLE_CONSTRAINTS   CONSTRAINT_TYPE
570
 
OLD_TABLE_CONSTRAINTS   TABLE_NAME
571
 
OLD_TABLE_CONSTRAINTS   TABLE_SCHEMA
572
 
OLD_TABLE_CONSTRAINTS   CONSTRAINT_NAME
573
 
OLD_TABLE_CONSTRAINTS   CONSTRAINT_SCHEMA
574
 
OLD_TABLE_CONSTRAINTS   CONSTRAINT_CATALOG
575
 
OPEN_SESSION_STATUS     VARIABLE_NAME
576
 
OPEN_SESSION_STATUS     VARIABLE_VALUE
577
 
SELECT *
578
370
FROM information_schema.old_key_column_usage;
579
371
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
580
372
SELECT * 
581
373
FROM information_schema.old_referential_constraints;
582
374
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
583
 
SELECT count(schema_name) FROM data_dictionary.schemas ORDER BY schema_name;
584
 
count(schema_name)
585
 
#
586
 
SHOW STATUS;
587
 
Variable_name   Value
588
 
#       #
589
 
#       #
590
 
#       #
591
 
#       #
592
 
#       #
593
 
#       #
594
 
#       #
595
 
#       #
596
 
#       #
597
 
#       #
598
 
#       #
599
 
#       #
600
 
#       #
601
 
#       #
602
 
#       #
603
 
#       #
604
 
#       #
605
 
#       #
606
 
#       #
607
 
#       #
608
 
#       #
609
 
#       #
610
 
#       #
611
 
#       #
612
 
#       #
613
 
#       #
614
 
#       #
615
 
#       #
616
 
#       #
617
 
#       #
618
 
#       #
619
 
#       #
620
 
#       #
621
 
#       #
622
 
#       #
623
 
#       #
624
 
#       #
625
 
#       #
626
 
#       #
627
 
#       #
628
 
#       #
629
 
#       #
630
 
#       #
631
 
#       #
632
 
#       #
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
 
SELECT *
690
 
FROM information_schema.old_global_status
691
 
ORDER BY variable_name;
692
 
VARIABLE_NAME   VARIABLE_VALUE
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
 
#       #
787
 
#       #
788
 
#       #
789
 
#       #
790
 
#       #
791
 
#       #
792
 
#       #
793
 
#       #
794
375
SELECT *
795
376
FROM information_schema.old_table_constraints;
796
377
CONSTRAINT_CATALOG      CONSTRAINT_SCHEMA       CONSTRAINT_NAME TABLE_SCHEMA    TABLE_NAME      CONSTRAINT_TYPE
797
 
SELECT table_schema, table_name
798
 
FROM data_dictionary.tables
799
 
WHERE table_schema="data_dictionary"
800
 
ORDER BY table_name;
801
 
table_schema    table_name
802
 
SELECT count(*) FROM data_dictionary.plugins;
803
 
count(*)
804
 
#