← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to plugin/schema_dictionary/tests/r/data_dictionary.result

Merge Joe

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/schema_dictionary/tests/r/data_dictionary.result
463
463
#
464
464
#
465
465
#
 
466
#
 
467
#
 
468
#
 
469
#
 
470
#
 
471
#
 
472
#
 
473
#
 
474
#
 
475
#
 
476
#
 
477
#
 
478
#
 
479
#
 
480
#
 
481
#
 
482
#
 
483
#
 
484
#
 
485
#
 
486
#
 
487
#
 
488
#
 
489
#
 
490
#
 
491
#
 
492
#
466
493
SELECT count(*) FROM REFERENTIAL_CONSTRAINTS;
467
494
count(*)
468
495
#
1023
1050
#       #       #
1024
1051
#       #       #
1025
1052
#       #       #
 
1053
#       #       #
 
1054
#       #       #
 
1055
#       #       #
 
1056
#       #       #
 
1057
#       #       #
 
1058
#       #       #
 
1059
#       #       #
 
1060
#       #       #
 
1061
#       #       #
 
1062
#       #       #
 
1063
#       #       #
 
1064
#       #       #
 
1065
#       #       #
 
1066
#       #       #
 
1067
#       #       #
 
1068
#       #       #
 
1069
#       #       #
 
1070
#       #       #
 
1071
#       #       #
 
1072
#       #       #
 
1073
#       #       #
 
1074
#       #       #
 
1075
#       #       #
 
1076
#       #       #
 
1077
#       #       #
 
1078
#       #       #
 
1079
#       #       #
1026
1080
SELECT TABLE_NAME,TABLE_SCHEMA,COLUMN_NAME from COLUMNS ORDER BY TABLE_SCHEMA,TABLE_NAME;
1027
1081
TABLE_NAME      TABLE_SCHEMA    COLUMN_NAME
1028
1082
#       #       #
1473
1527
#       #       #
1474
1528
#       #       #
1475
1529
#       #       #
 
1530
#       #       #
 
1531
#       #       #
 
1532
#       #       #
 
1533
#       #       #
 
1534
#       #       #
 
1535
#       #       #
 
1536
#       #       #
 
1537
#       #       #
 
1538
#       #       #
 
1539
#       #       #
 
1540
#       #       #
 
1541
#       #       #
 
1542
#       #       #
 
1543
#       #       #
 
1544
#       #       #
 
1545
#       #       #
 
1546
#       #       #
 
1547
#       #       #
 
1548
#       #       #
 
1549
#       #       #
 
1550
#       #       #
 
1551
#       #       #
 
1552
#       #       #
 
1553
#       #       #
 
1554
#       #       #
 
1555
#       #       #
 
1556
#       #       #
1476
1557
SELECT TABLE_NAME,TABLE_SCHEMA,COLUMN_NAME from COLUMNS ORDER BY TABLE_NAME,TABLE_SCHEMA;
1477
1558
TABLE_NAME      TABLE_SCHEMA    COLUMN_NAME
1478
1559
#       #       #
1923
2004
#       #       #
1924
2005
#       #       #
1925
2006
#       #       #
 
2007
#       #       #
 
2008
#       #       #
 
2009
#       #       #
 
2010
#       #       #
 
2011
#       #       #
 
2012
#       #       #
 
2013
#       #       #
 
2014
#       #       #
 
2015
#       #       #
 
2016
#       #       #
 
2017
#       #       #
 
2018
#       #       #
 
2019
#       #       #
 
2020
#       #       #
 
2021
#       #       #
 
2022
#       #       #
 
2023
#       #       #
 
2024
#       #       #
 
2025
#       #       #
 
2026
#       #       #
 
2027
#       #       #
 
2028
#       #       #
 
2029
#       #       #
 
2030
#       #       #
 
2031
#       #       #
 
2032
#       #       #
 
2033
#       #       #
1926
2034
DROP SCHEMA A;