~drizzle-trunk/drizzle/development
» Revision
1876
: plugin/schema_dictionary/tests/r/data_dictionary.result
« back to all changes in this revision
Viewing changes to plugin/schema_dictionary/tests/r/data_dictionary.result
- browse files at revision 1876
- compare with another revision
- compare with revision 2241.3.11
- download diff
- download tarball
- view history from revision 1876
- Committer: Brian Aker
- Date: 2010-10-24 11:37:53 UTC
- mfrom: (1874.2.4 bison)
- Revision ID: brian@tangent.org-20101024113753-sdw59ktv6lyk0r22
Merge in show update.
- files added:
- drizzled/statement/show.cc
- files modified:
- .bzrignore
added
removed
plugin/schema_dictionary/tests/r/data_dictionary.result
1
1
use data_dictionary;
2
2
SELECT count(*) FROM columns;
3
3
count(*)
4
510
4
478
5
5
SELECT count(*) FROM indexes;
6
6
count(*)
7
7
0
22
22
AUTO_INCREMENT
23
23
AUTO_INCREMENT
24
24
AVG_ROW_LENGTH
25
Auto_increment
26
Avg_row_length
27
25
BLOCKING_LOCK_ID
28
26
BLOCKING_TRX_ID
29
27
BYTES_RECEIVED
155
153
COUNT_UPDATE
156
154
COUNT_UPDATE
157
155
CREATED
158
Column_name
159
156
DATA_TYPE
160
157
DATA_TYPE
161
158
DATA_TYPE
195
192
DOMAIN_SCHEMA
196
193
DOMAIN_SCHEMA
197
194
DTD_IDENTIFIER
198
Default
199
Default_is_NULL
200
ENGINE
201
195
ENGINE
202
196
ENUM_VALUES
203
197
EXECUTION_TIME_NSEC
204
198
EXTERNAL_LANGUAGE
205
199
EXTERNAL_NAME
206
Engine
207
Field
208
200
GRANTEE
209
201
GRANTEE
210
202
GRANTOR
258
250
IS_USED_IN_PRIMARY
259
251
IS_USER_DEFINED_CAST
260
252
KEY_LENGTH
261
Key_name
262
253
LAST_ALTERED
263
254
LOCK_DATA
264
255
LOCK_ID
306
297
NUMERIC_SCALE
307
298
NUMERIC_SCALE
308
299
NUMERIC_SCALE
309
Name
310
Null
311
ORDINAL_POSITION
312
ORDINAL_POSITION
313
ORDINAL_POSITION
314
ORDINAL_POSITION
315
ORDINAL_POSITION
316
On_Update
300
ORDINAL_POSITION
301
ORDINAL_POSITION
302
ORDINAL_POSITION
303
ORDINAL_POSITION
304
ORDINAL_POSITION
317
305
PAGES_FREE
318
306
PAGES_FREE
319
307
PAGES_USED
329
317
PLUGIN_TYPE
330
318
PRIVILEGE_TYPE
331
319
PRIVILEGE_TYPE
332
RECORDS
333
RECORD_LENGTH
334
320
REFERENCED_TABLE_COLUMNS
335
321
REFERENCED_TABLE_NAME
336
322
RELOCATION_OPS
351
337
ROWS_INSERTED
352
338
ROWS_UPDATED
353
339
ROW_FORMAT
354
Rows
355
340
SCHEMA_CREATION_TIME
356
341
SCHEMA_LEVEL_ROUTINE
357
342
SCHEMA_NAME
358
343
SCHEMA_NAME
359
SCHEMA_NAME
360
SCHEMA_NAME
361
344
SCHEMA_OWNER
362
SCHEMA_SQL_DEFINITION
363
345
SCHEMA_UPDATE_TIME
364
346
SCHEMA_USE_COUNT
365
347
SCHEMA_UUID
384
366
SQL_DATA_ACCESS
385
367
SQL_PATH
386
368
STATE
387
Schema
388
Seq_in_index
389
Session
390
369
TABLE_ARCHETYPE
391
370
TABLE_CATALOG
392
371
TABLE_CATALOG
428
407
TABLE_NAME
429
408
TABLE_NAME
430
409
TABLE_NAME
431
TABLE_NAME
432
TABLE_NAME
433
TABLE_NAME
434
TABLE_SCHEMA
435
410
TABLE_SCHEMA
436
411
TABLE_SCHEMA
437
412
TABLE_SCHEMA
454
429
TABLE_SCHEMA
455
430
TABLE_SCHEMA
456
431
TABLE_SIZE
457
TABLE_SQL_DEFINITION
458
432
TABLE_TYPE
459
433
TABLE_TYPE
460
434
TABLE_UPDATE_TIME
472
446
TYPE_UDT_CATALOG
473
447
TYPE_UDT_NAME
474
448
TYPE_UDT_SCHEMA
475
Table
476
Table_size
477
Type
478
Type
479
449
UDT_CATALOG
480
450
UDT_NAME
481
451
UDT_SCHEMA
497
467
USER_DEFINED_TYPE_SCHEMA
498
468
USER_LOCK_NAME
499
469
USER_NAME
500
Unique
501
470
VARIABLE_NAME
502
471
VARIABLE_NAME
503
472
VARIABLE_NAME
525
494
VIEW_NAME
526
495
VIEW_SCHEMA
527
496
VIEW_SCHEMA
528
Version
529
497
SELECT count(*) FROM FOREIGN_KEYS;
530
498
count(*)
531
499
0
821
789
DATA_DICTIONARY SCHEMAS SCHEMA_USE_COUNT
822
790
DATA_DICTIONARY SCHEMAS SCHEMA_UUID
823
791
DATA_DICTIONARY SCHEMAS SCHEMA_VERSION
824
DATA_DICTIONARY SCHEMA_SQL_DEFINITION SCHEMA_NAME
825
DATA_DICTIONARY SCHEMA_SQL_DEFINITION SCHEMA_SQL_DEFINITION
826
792
DATA_DICTIONARY SCOREBOARD_STATISTICS MAX_USERS_LOGGED
827
793
DATA_DICTIONARY SCOREBOARD_STATISTICS MEMORY_USAGE_BYTES
828
794
DATA_DICTIONARY SCOREBOARD_STATISTICS NUMBER_OF_RANGE_LOCKS
833
799
DATA_DICTIONARY SESSION_STATUS VARIABLE_VALUE
834
800
DATA_DICTIONARY SESSION_VARIABLES VARIABLE_NAME
835
801
DATA_DICTIONARY SESSION_VARIABLES VARIABLE_VALUE
836
DATA_DICTIONARY SHOW_COLUMNS Default
837
DATA_DICTIONARY SHOW_COLUMNS Default_is_NULL
838
DATA_DICTIONARY SHOW_COLUMNS Field
839
DATA_DICTIONARY SHOW_COLUMNS Null
840
DATA_DICTIONARY SHOW_COLUMNS On_Update
841
DATA_DICTIONARY SHOW_COLUMNS Type
842
DATA_DICTIONARY SHOW_INDEXES Column_name
843
DATA_DICTIONARY SHOW_INDEXES Key_name
844
DATA_DICTIONARY SHOW_INDEXES Seq_in_index
845
DATA_DICTIONARY SHOW_INDEXES Table
846
DATA_DICTIONARY SHOW_INDEXES Unique
847
DATA_DICTIONARY SHOW_SCHEMAS SCHEMA_NAME
848
DATA_DICTIONARY SHOW_TABLES TABLE_NAME
849
DATA_DICTIONARY SHOW_TABLE_STATUS Auto_increment
850
DATA_DICTIONARY SHOW_TABLE_STATUS Avg_row_length
851
DATA_DICTIONARY SHOW_TABLE_STATUS Engine
852
DATA_DICTIONARY SHOW_TABLE_STATUS Name
853
DATA_DICTIONARY SHOW_TABLE_STATUS Rows
854
DATA_DICTIONARY SHOW_TABLE_STATUS Schema
855
DATA_DICTIONARY SHOW_TABLE_STATUS Session
856
DATA_DICTIONARY SHOW_TABLE_STATUS Table_size
857
DATA_DICTIONARY SHOW_TABLE_STATUS Type
858
DATA_DICTIONARY SHOW_TABLE_STATUS Version
859
DATA_DICTIONARY SHOW_TEMPORARY_TABLES ENGINE
860
DATA_DICTIONARY SHOW_TEMPORARY_TABLES RECORDS
861
DATA_DICTIONARY SHOW_TEMPORARY_TABLES RECORD_LENGTH
862
DATA_DICTIONARY SHOW_TEMPORARY_TABLES TABLE_NAME
863
DATA_DICTIONARY SHOW_TEMPORARY_TABLES TABLE_SCHEMA
864
802
DATA_DICTIONARY TABLES AUTO_INCREMENT
865
803
DATA_DICTIONARY TABLES ENGINE
866
804
DATA_DICTIONARY TABLES ROW_FORMAT
893
831
DATA_DICTIONARY TABLE_DEFINITION_CACHE TABLE_NAME
894
832
DATA_DICTIONARY TABLE_DEFINITION_CACHE TABLE_SCHEMA
895
833
DATA_DICTIONARY TABLE_DEFINITION_CACHE VERSION
896
DATA_DICTIONARY TABLE_SQL_DEFINITION TABLE_NAME
897
DATA_DICTIONARY TABLE_SQL_DEFINITION TABLE_SQL_DEFINITION
898
834
DATA_DICTIONARY USER_LOCKS SESSION_ID
899
835
DATA_DICTIONARY USER_LOCKS USER_LOCK_NAME
900
836
DATA_DICTIONARY USER_LOCKS USER_NAME
1542
1478
SCHEMATA INFORMATION_SCHEMA DEFAULT_CHARACTER_SET_SCHEMA
1543
1479
SCHEMATA INFORMATION_SCHEMA SCHEMA_NAME
1544
1480
SCHEMATA INFORMATION_SCHEMA SCHEMA_OWNER
1545
SCHEMA_SQL_DEFINITION DATA_DICTIONARY SCHEMA_NAME
1546
SCHEMA_SQL_DEFINITION DATA_DICTIONARY SCHEMA_SQL_DEFINITION
1547
1481
SCOREBOARD_STATISTICS DATA_DICTIONARY MAX_USERS_LOGGED
1548
1482
SCOREBOARD_STATISTICS DATA_DICTIONARY MEMORY_USAGE_BYTES
1549
1483
SCOREBOARD_STATISTICS DATA_DICTIONARY NUMBER_OF_RANGE_LOCKS
1554
1488
SESSION_STATUS DATA_DICTIONARY VARIABLE_VALUE
1555
1489
SESSION_VARIABLES DATA_DICTIONARY VARIABLE_NAME
1556
1490
SESSION_VARIABLES DATA_DICTIONARY VARIABLE_VALUE
1557
SHOW_COLUMNS DATA_DICTIONARY Default
1558
SHOW_COLUMNS DATA_DICTIONARY Default_is_NULL
1559
SHOW_COLUMNS DATA_DICTIONARY Field
1560
SHOW_COLUMNS DATA_DICTIONARY Null
1561
SHOW_COLUMNS DATA_DICTIONARY On_Update
1562
SHOW_COLUMNS DATA_DICTIONARY Type
1563
SHOW_INDEXES DATA_DICTIONARY Column_name
1564
SHOW_INDEXES DATA_DICTIONARY Key_name
1565
SHOW_INDEXES DATA_DICTIONARY Seq_in_index
1566
SHOW_INDEXES DATA_DICTIONARY Table
1567
SHOW_INDEXES DATA_DICTIONARY Unique
1568
SHOW_SCHEMAS DATA_DICTIONARY SCHEMA_NAME
1569
SHOW_TABLES DATA_DICTIONARY TABLE_NAME
1570
SHOW_TABLE_STATUS DATA_DICTIONARY Auto_increment
1571
SHOW_TABLE_STATUS DATA_DICTIONARY Avg_row_length
1572
SHOW_TABLE_STATUS DATA_DICTIONARY Engine
1573
SHOW_TABLE_STATUS DATA_DICTIONARY Name
1574
SHOW_TABLE_STATUS DATA_DICTIONARY Rows
1575
SHOW_TABLE_STATUS DATA_DICTIONARY Schema
1576
SHOW_TABLE_STATUS DATA_DICTIONARY Session
1577
SHOW_TABLE_STATUS DATA_DICTIONARY Table_size
1578
SHOW_TABLE_STATUS DATA_DICTIONARY Type
1579
SHOW_TABLE_STATUS DATA_DICTIONARY Version
1580
SHOW_TEMPORARY_TABLES DATA_DICTIONARY ENGINE
1581
SHOW_TEMPORARY_TABLES DATA_DICTIONARY RECORDS
1582
SHOW_TEMPORARY_TABLES DATA_DICTIONARY RECORD_LENGTH
1583
SHOW_TEMPORARY_TABLES DATA_DICTIONARY TABLE_NAME
1584
SHOW_TEMPORARY_TABLES DATA_DICTIONARY TABLE_SCHEMA
1585
1491
TABLES DATA_DICTIONARY AUTO_INCREMENT
1586
1492
TABLES DATA_DICTIONARY ENGINE
1587
1493
TABLES DATA_DICTIONARY ROW_FORMAT
1635
1541
TABLE_PRIVILEGES INFORMATION_SCHEMA TABLE_CATALOG
1636
1542
TABLE_PRIVILEGES INFORMATION_SCHEMA TABLE_NAME
1637
1543
TABLE_PRIVILEGES INFORMATION_SCHEMA TABLE_SCHEMA
1638
TABLE_SQL_DEFINITION DATA_DICTIONARY TABLE_NAME
1639
TABLE_SQL_DEFINITION DATA_DICTIONARY TABLE_SQL_DEFINITION
1640
1544
USER_LOCKS DATA_DICTIONARY SESSION_ID
1641
1545
USER_LOCKS DATA_DICTIONARY USER_LOCK_NAME
1642
1546
USER_LOCKS DATA_DICTIONARY USER_NAME
2055
1959
SCHEMATA INFORMATION_SCHEMA DEFAULT_CHARACTER_SET_SCHEMA
2056
1960
SCHEMATA INFORMATION_SCHEMA SCHEMA_NAME
2057
1961
SCHEMATA INFORMATION_SCHEMA SCHEMA_OWNER
2058
SCHEMA_SQL_DEFINITION DATA_DICTIONARY SCHEMA_NAME
2059
SCHEMA_SQL_DEFINITION DATA_DICTIONARY SCHEMA_SQL_DEFINITION
2060
1962
SCOREBOARD_STATISTICS DATA_DICTIONARY MAX_USERS_LOGGED
2061
1963
SCOREBOARD_STATISTICS DATA_DICTIONARY MEMORY_USAGE_BYTES
2062
1964
SCOREBOARD_STATISTICS DATA_DICTIONARY NUMBER_OF_RANGE_LOCKS
2067
1969
SESSION_STATUS DATA_DICTIONARY VARIABLE_VALUE
2068
1970
SESSION_VARIABLES DATA_DICTIONARY VARIABLE_NAME
2069
1971
SESSION_VARIABLES DATA_DICTIONARY VARIABLE_VALUE
2070
SHOW_COLUMNS DATA_DICTIONARY Default
2071
SHOW_COLUMNS DATA_DICTIONARY Default_is_NULL
2072
SHOW_COLUMNS DATA_DICTIONARY Field
2073
SHOW_COLUMNS DATA_DICTIONARY Null
2074
SHOW_COLUMNS DATA_DICTIONARY On_Update
2075
SHOW_COLUMNS DATA_DICTIONARY Type
2076
SHOW_INDEXES DATA_DICTIONARY Column_name
2077
SHOW_INDEXES DATA_DICTIONARY Key_name
2078
SHOW_INDEXES DATA_DICTIONARY Seq_in_index
2079
SHOW_INDEXES DATA_DICTIONARY Table
2080
SHOW_INDEXES DATA_DICTIONARY Unique
2081
SHOW_SCHEMAS DATA_DICTIONARY SCHEMA_NAME
2082
SHOW_TABLES DATA_DICTIONARY TABLE_NAME
2083
SHOW_TABLE_STATUS DATA_DICTIONARY Auto_increment
2084
SHOW_TABLE_STATUS DATA_DICTIONARY Avg_row_length
2085
SHOW_TABLE_STATUS DATA_DICTIONARY Engine
2086
SHOW_TABLE_STATUS DATA_DICTIONARY Name
2087
SHOW_TABLE_STATUS DATA_DICTIONARY Rows
2088
SHOW_TABLE_STATUS DATA_DICTIONARY Schema
2089
SHOW_TABLE_STATUS DATA_DICTIONARY Session
2090
SHOW_TABLE_STATUS DATA_DICTIONARY Table_size
2091
SHOW_TABLE_STATUS DATA_DICTIONARY Type
2092
SHOW_TABLE_STATUS DATA_DICTIONARY Version
2093
SHOW_TEMPORARY_TABLES DATA_DICTIONARY ENGINE
2094
SHOW_TEMPORARY_TABLES DATA_DICTIONARY RECORDS
2095
SHOW_TEMPORARY_TABLES DATA_DICTIONARY RECORD_LENGTH
2096
SHOW_TEMPORARY_TABLES DATA_DICTIONARY TABLE_NAME
2097
SHOW_TEMPORARY_TABLES DATA_DICTIONARY TABLE_SCHEMA
2098
1972
TABLES DATA_DICTIONARY AUTO_INCREMENT
2099
1973
TABLES DATA_DICTIONARY ENGINE
2100
1974
TABLES DATA_DICTIONARY ROW_FORMAT
2148
2022
TABLE_PRIVILEGES INFORMATION_SCHEMA TABLE_CATALOG
2149
2023
TABLE_PRIVILEGES INFORMATION_SCHEMA TABLE_NAME
2150
2024
TABLE_PRIVILEGES INFORMATION_SCHEMA TABLE_SCHEMA
2151
TABLE_SQL_DEFINITION DATA_DICTIONARY TABLE_NAME
2152
TABLE_SQL_DEFINITION DATA_DICTIONARY TABLE_SQL_DEFINITION
2153
2025
USER_LOCKS DATA_DICTIONARY SESSION_ID
2154
2026
USER_LOCKS DATA_DICTIONARY USER_LOCK_NAME
2155
2027
USER_LOCKS DATA_DICTIONARY USER_NAME
Loggerhead is a web-based interface for Breezy
Version: 2.0.1