← Back to branch summary

~drizzle-developers/ubuntu/karmic/drizzle/ppa

« back to all changes in this revision

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

  • Committer: Monty Taylor
  • Date: 2010-11-24 18:44:57 UTC
  • mfrom: (1308.1.31 trunk)
  • Revision ID: mordred@inaugust.com-20101124184457-qd6jvoe2wgnvl3yq
Tags: 2010.11.04-0ubuntu1~karmic1
http://bugs.debian.org/602662
* New upstream release.
* Turn off -Werror for packaging builds. (Closes: #602662)

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/schema_dictionary/tests/r/data_dictionary.result
1
1
use data_dictionary;
2
2
SELECT count(*) FROM columns;
3
3
count(*)
4
 
478
 
4
488
5
5
SELECT count(*) FROM indexes;
6
6
count(*)
7
7
0
197
197
EXECUTION_TIME_NSEC
198
198
EXTERNAL_LANGUAGE
199
199
EXTERNAL_NAME
 
200
GENERATION
200
201
GRANTEE
201
202
GRANTEE
202
203
GRANTOR
297
298
NUMERIC_SCALE
298
299
NUMERIC_SCALE
299
300
NUMERIC_SCALE
 
301
OBSERVERS
300
302
ORDINAL_POSITION
301
303
ORDINAL_POSITION
302
304
ORDINAL_POSITION
337
339
ROWS_INSERTED
338
340
ROWS_UPDATED
339
341
ROW_FORMAT
 
342
SAVEPOINT_NAME
340
343
SCHEMA_CREATION_TIME
341
344
SCHEMA_LEVEL_ROUTINE
342
345
SCHEMA_NAME
356
359
SEQUENCE_IN_INDEX
357
360
SESSION_ID
358
361
SESSION_ID
 
362
SESSION_ID
359
363
SORTLEN
360
364
SPECIFIC_CATALOG
361
365
SPECIFIC_CATALOG
462
466
USER
463
467
USER
464
468
USER
 
469
USER_BARRIER_NAME
465
470
USER_DEFINED_TYPE_CATALOG
466
471
USER_DEFINED_TYPE_NAME
467
472
USER_DEFINED_TYPE_SCHEMA
468
473
USER_LOCK_NAME
469
474
USER_NAME
470
 
VARIABLE_NAME
471
 
VARIABLE_NAME
472
 
VARIABLE_NAME
473
 
VARIABLE_NAME
474
 
VARIABLE_NAME
475
 
VARIABLE_NAME
476
 
VARIABLE_NAME
477
 
VARIABLE_NAME
478
 
VARIABLE_NAME
 
475
USER_NAME
 
476
VARIABLE_NAME
 
477
VARIABLE_NAME
 
478
VARIABLE_NAME
 
479
VARIABLE_NAME
 
480
VARIABLE_NAME
 
481
VARIABLE_NAME
 
482
VARIABLE_NAME
 
483
VARIABLE_NAME
 
484
VARIABLE_NAME
 
485
VARIABLE_NAME
 
486
VARIABLE_VALUE
479
487
VARIABLE_VALUE
480
488
VARIABLE_VALUE
481
489
VARIABLE_VALUE
494
502
VIEW_NAME
495
503
VIEW_SCHEMA
496
504
VIEW_SCHEMA
 
505
WAITERS
 
506
WAITER_LIMIT
497
507
SELECT count(*) FROM FOREIGN_KEYS;
498
508
count(*)
499
509
0
604
614
use data_dictionary;
605
615
SELECT TABLE_SCHEMA,TABLE_NAME,COLUMN_NAME from COLUMNS ORDER BY TABLE_SCHEMA,TABLE_NAME, COLUMN_NAME;
606
616
TABLE_SCHEMA    TABLE_NAME      COLUMN_NAME
607
 
A       a       a
 
617
A       A       a
608
618
DATA_DICTIONARY CHARACTER_SETS  CHARACTER_SET_NAME
609
619
DATA_DICTIONARY CHARACTER_SETS  DEFAULT_COLLATE_NAME
610
620
DATA_DICTIONARY CHARACTER_SETS  DESCRIPTION
831
841
DATA_DICTIONARY TABLE_DEFINITION_CACHE  TABLE_NAME
832
842
DATA_DICTIONARY TABLE_DEFINITION_CACHE  TABLE_SCHEMA
833
843
DATA_DICTIONARY TABLE_DEFINITION_CACHE  VERSION
 
844
DATA_DICTIONARY USER_BARRIERS   GENERATION
 
845
DATA_DICTIONARY USER_BARRIERS   OBSERVERS
 
846
DATA_DICTIONARY USER_BARRIERS   SESSION_ID
 
847
DATA_DICTIONARY USER_BARRIERS   USER_BARRIER_NAME
 
848
DATA_DICTIONARY USER_BARRIERS   USER_NAME
 
849
DATA_DICTIONARY USER_BARRIERS   WAITERS
 
850
DATA_DICTIONARY USER_BARRIERS   WAITER_LIMIT
 
851
DATA_DICTIONARY USER_DEFINED_VARIABLES  VARIABLE_NAME
 
852
DATA_DICTIONARY USER_DEFINED_VARIABLES  VARIABLE_VALUE
834
853
DATA_DICTIONARY USER_LOCKS      SESSION_ID
835
854
DATA_DICTIONARY USER_LOCKS      USER_LOCK_NAME
836
855
DATA_DICTIONARY USER_LOCKS      USER_NAME
 
856
DATA_DICTIONARY USER_SAVEPOINTS SAVEPOINT_NAME
837
857
INFORMATION_SCHEMA      CHECK_CONSTRAINTS       CHECK_CLAUSE
838
858
INFORMATION_SCHEMA      CHECK_CONSTRAINTS       CONSTRAINT_CATALOG
839
859
INFORMATION_SCHEMA      CHECK_CONSTRAINTS       CONSTRAINT_NAME
1085
1105
INFORMATION_SCHEMA      VIEW_TABLE_USAGE        VIEW_DEFINITION
1086
1106
SELECT TABLE_NAME,TABLE_SCHEMA,COLUMN_NAME from COLUMNS ORDER BY TABLE_SCHEMA,TABLE_NAME, COLUMN_NAME;
1087
1107
TABLE_NAME      TABLE_SCHEMA    COLUMN_NAME
 
1108
A       A       a
1088
1109
CHARACTER_SETS  DATA_DICTIONARY CHARACTER_SET_NAME
1089
1110
CHARACTER_SETS  DATA_DICTIONARY DEFAULT_COLLATE_NAME
1090
1111
CHARACTER_SETS  DATA_DICTIONARY DESCRIPTION
1541
1562
TABLE_PRIVILEGES        INFORMATION_SCHEMA      TABLE_CATALOG
1542
1563
TABLE_PRIVILEGES        INFORMATION_SCHEMA      TABLE_NAME
1543
1564
TABLE_PRIVILEGES        INFORMATION_SCHEMA      TABLE_SCHEMA
 
1565
USER_BARRIERS   DATA_DICTIONARY GENERATION
 
1566
USER_BARRIERS   DATA_DICTIONARY OBSERVERS
 
1567
USER_BARRIERS   DATA_DICTIONARY SESSION_ID
 
1568
USER_BARRIERS   DATA_DICTIONARY USER_BARRIER_NAME
 
1569
USER_BARRIERS   DATA_DICTIONARY USER_NAME
 
1570
USER_BARRIERS   DATA_DICTIONARY WAITERS
 
1571
USER_BARRIERS   DATA_DICTIONARY WAITER_LIMIT
 
1572
USER_DEFINED_VARIABLES  DATA_DICTIONARY VARIABLE_NAME
 
1573
USER_DEFINED_VARIABLES  DATA_DICTIONARY VARIABLE_VALUE
1544
1574
USER_LOCKS      DATA_DICTIONARY SESSION_ID
1545
1575
USER_LOCKS      DATA_DICTIONARY USER_LOCK_NAME
1546
1576
USER_LOCKS      DATA_DICTIONARY USER_NAME
 
1577
USER_SAVEPOINTS DATA_DICTIONARY SAVEPOINT_NAME
1547
1578
VIEWS   INFORMATION_SCHEMA      TABLE_CATALOG
1548
1579
VIEWS   INFORMATION_SCHEMA      TABLE_NAME
1549
1580
VIEWS   INFORMATION_SCHEMA      TABLE_SCHEMA
1563
1594
VIEW_TABLE_USAGE        INFORMATION_SCHEMA      TABLE_NAME
1564
1595
VIEW_TABLE_USAGE        INFORMATION_SCHEMA      TABLE_SCHEMA
1565
1596
VIEW_TABLE_USAGE        INFORMATION_SCHEMA      VIEW_DEFINITION
1566
 
a       A       a
1567
1597
SELECT TABLE_NAME,TABLE_SCHEMA,COLUMN_NAME from COLUMNS ORDER BY TABLE_NAME,TABLE_SCHEMA, COLUMN_NAME;
1568
1598
TABLE_NAME      TABLE_SCHEMA    COLUMN_NAME
 
1599
A       A       a
1569
1600
CHARACTER_SETS  DATA_DICTIONARY CHARACTER_SET_NAME
1570
1601
CHARACTER_SETS  DATA_DICTIONARY DEFAULT_COLLATE_NAME
1571
1602
CHARACTER_SETS  DATA_DICTIONARY DESCRIPTION
2022
2053
TABLE_PRIVILEGES        INFORMATION_SCHEMA      TABLE_CATALOG
2023
2054
TABLE_PRIVILEGES        INFORMATION_SCHEMA      TABLE_NAME
2024
2055
TABLE_PRIVILEGES        INFORMATION_SCHEMA      TABLE_SCHEMA
 
2056
USER_BARRIERS   DATA_DICTIONARY GENERATION
 
2057
USER_BARRIERS   DATA_DICTIONARY OBSERVERS
 
2058
USER_BARRIERS   DATA_DICTIONARY SESSION_ID
 
2059
USER_BARRIERS   DATA_DICTIONARY USER_BARRIER_NAME
 
2060
USER_BARRIERS   DATA_DICTIONARY USER_NAME
 
2061
USER_BARRIERS   DATA_DICTIONARY WAITERS
 
2062
USER_BARRIERS   DATA_DICTIONARY WAITER_LIMIT
 
2063
USER_DEFINED_VARIABLES  DATA_DICTIONARY VARIABLE_NAME
 
2064
USER_DEFINED_VARIABLES  DATA_DICTIONARY VARIABLE_VALUE
2025
2065
USER_LOCKS      DATA_DICTIONARY SESSION_ID
2026
2066
USER_LOCKS      DATA_DICTIONARY USER_LOCK_NAME
2027
2067
USER_LOCKS      DATA_DICTIONARY USER_NAME
 
2068
USER_SAVEPOINTS DATA_DICTIONARY SAVEPOINT_NAME
2028
2069
VIEWS   INFORMATION_SCHEMA      TABLE_CATALOG
2029
2070
VIEWS   INFORMATION_SCHEMA      TABLE_NAME
2030
2071
VIEWS   INFORMATION_SCHEMA      TABLE_SCHEMA
2044
2085
VIEW_TABLE_USAGE        INFORMATION_SCHEMA      TABLE_NAME
2045
2086
VIEW_TABLE_USAGE        INFORMATION_SCHEMA      TABLE_SCHEMA
2046
2087
VIEW_TABLE_USAGE        INFORMATION_SCHEMA      VIEW_DEFINITION
2047
 
a       A       a
2048
2088
DROP SCHEMA A;