~drizzle-trunk/drizzle/development

« back to all changes in this revision

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

  • Committer: Lee Bieber
  • Date: 2011-02-24 03:20:47 UTC
  • mfrom: (2196.1.4 build)
  • Revision ID: kalebral@gmail.com-20110224032047-avmw06iwww3m73cw
Merge Andrew - 723653: Docs day first pass fixes 
Merge Brian - Puts back in support for COM_KILL, Also adds back in the INTERACTIVE flag, and creates a DD to track sessions/check on usage
Merge Olaf - Use List::size()

Show diffs side-by-side

added added

removed removed

Lines of Context:
1
1
use data_dictionary;
2
2
SELECT count(*) FROM columns;
3
3
count(*)
4
 
568
 
4
580
5
5
SELECT count(*) FROM indexes;
6
6
count(*)
7
7
2
105
105
COLUMN_NUMBER
106
106
COLUMN_TYPE
107
107
COMMAND
 
108
COMMAND
108
109
COMMIT_ID
109
110
COMMIT_ID
110
111
COMPARE_LENGTH
227
228
GRANTOR
228
229
HANDLES_OPENED
229
230
HAS_GLOBAL_LOCK
 
231
HAS_GLOBAL_LOCK
230
232
HOST
231
233
ID
232
234
ID
249
251
INTERVAL_TYPE
250
252
IP
251
253
IS_ACTIVE
 
254
IS_ADMIN
252
255
IS_AUTO_INCREMENT
253
256
IS_BUILTIN
254
257
IS_COMPILED
 
258
IS_CONSOLE
255
259
IS_DEFAULT
256
260
IS_DEFERRABLE
257
261
IS_DEFERRABLE
261
265
IS_GRANTABLE
262
266
IS_IMPLICITLY_INVOCABLE
263
267
IS_INDEXED
 
268
IS_INTERACTIVE
264
269
IS_MULTI
265
270
IS_NAME_LOCKED
266
271
IS_NAME_LOCKED
373
378
PRIVILEGE_TYPE
374
379
PROTOCOL
375
380
PRTYPE
 
381
QUERY
376
382
REFERENCED_TABLE_COLUMNS
377
383
REFERENCED_TABLE_NAME
378
384
REF_COL_NAME
414
420
SCOREBOARD_SIZE
415
421
SEGID
416
422
SEQUENCE_IN_INDEX
417
 
SESSION_ID
418
 
SESSION_ID
419
 
SESSION_ID
 
423
SESION_USERNAME
 
424
SESSION_CATALOG
 
425
SESSION_HOST
 
426
SESSION_ID
 
427
SESSION_ID
 
428
SESSION_ID
 
429
SESSION_ID
 
430
SESSION_SCHEMA
420
431
SORTLEN
421
432
SPACE
422
433
SPACE
429
440
SQL_DATA_ACCESS
430
441
SQL_PATH
431
442
STATE
 
443
STATE
432
444
STATS_INITIALIZED
433
445
TABLE_ARCHETYPE
434
446
TABLE_CATALOG
960
972
DATA_DICTIONARY SCOREBOARD_STATISTICS   MEMORY_USAGE_BYTES
961
973
DATA_DICTIONARY SCOREBOARD_STATISTICS   NUMBER_OF_RANGE_LOCKS
962
974
DATA_DICTIONARY SCOREBOARD_STATISTICS   SCOREBOARD_SIZE
 
975
DATA_DICTIONARY SESSIONS        COMMAND
 
976
DATA_DICTIONARY SESSIONS        HAS_GLOBAL_LOCK
 
977
DATA_DICTIONARY SESSIONS        IS_ADMIN
 
978
DATA_DICTIONARY SESSIONS        IS_CONSOLE
 
979
DATA_DICTIONARY SESSIONS        IS_INTERACTIVE
 
980
DATA_DICTIONARY SESSIONS        QUERY
 
981
DATA_DICTIONARY SESSIONS        SESION_USERNAME
 
982
DATA_DICTIONARY SESSIONS        SESSION_CATALOG
 
983
DATA_DICTIONARY SESSIONS        SESSION_HOST
 
984
DATA_DICTIONARY SESSIONS        SESSION_ID
 
985
DATA_DICTIONARY SESSIONS        SESSION_SCHEMA
 
986
DATA_DICTIONARY SESSIONS        STATE
963
987
DATA_DICTIONARY SESSION_STATEMENTS      VARIABLE_NAME
964
988
DATA_DICTIONARY SESSION_STATEMENTS      VARIABLE_VALUE
965
989
DATA_DICTIONARY SESSION_STATUS  VARIABLE_NAME
1740
1764
SCOREBOARD_STATISTICS   DATA_DICTIONARY MEMORY_USAGE_BYTES
1741
1765
SCOREBOARD_STATISTICS   DATA_DICTIONARY NUMBER_OF_RANGE_LOCKS
1742
1766
SCOREBOARD_STATISTICS   DATA_DICTIONARY SCOREBOARD_SIZE
 
1767
SESSIONS        DATA_DICTIONARY COMMAND
 
1768
SESSIONS        DATA_DICTIONARY HAS_GLOBAL_LOCK
 
1769
SESSIONS        DATA_DICTIONARY IS_ADMIN
 
1770
SESSIONS        DATA_DICTIONARY IS_CONSOLE
 
1771
SESSIONS        DATA_DICTIONARY IS_INTERACTIVE
 
1772
SESSIONS        DATA_DICTIONARY QUERY
 
1773
SESSIONS        DATA_DICTIONARY SESION_USERNAME
 
1774
SESSIONS        DATA_DICTIONARY SESSION_CATALOG
 
1775
SESSIONS        DATA_DICTIONARY SESSION_HOST
 
1776
SESSIONS        DATA_DICTIONARY SESSION_ID
 
1777
SESSIONS        DATA_DICTIONARY SESSION_SCHEMA
 
1778
SESSIONS        DATA_DICTIONARY STATE
1743
1779
SESSION_STATEMENTS      DATA_DICTIONARY VARIABLE_NAME
1744
1780
SESSION_STATEMENTS      DATA_DICTIONARY VARIABLE_VALUE
1745
1781
SESSION_STATUS  DATA_DICTIONARY VARIABLE_NAME
2311
2347
SCOREBOARD_STATISTICS   DATA_DICTIONARY MEMORY_USAGE_BYTES
2312
2348
SCOREBOARD_STATISTICS   DATA_DICTIONARY NUMBER_OF_RANGE_LOCKS
2313
2349
SCOREBOARD_STATISTICS   DATA_DICTIONARY SCOREBOARD_SIZE
 
2350
SESSIONS        DATA_DICTIONARY COMMAND
 
2351
SESSIONS        DATA_DICTIONARY HAS_GLOBAL_LOCK
 
2352
SESSIONS        DATA_DICTIONARY IS_ADMIN
 
2353
SESSIONS        DATA_DICTIONARY IS_CONSOLE
 
2354
SESSIONS        DATA_DICTIONARY IS_INTERACTIVE
 
2355
SESSIONS        DATA_DICTIONARY QUERY
 
2356
SESSIONS        DATA_DICTIONARY SESION_USERNAME
 
2357
SESSIONS        DATA_DICTIONARY SESSION_CATALOG
 
2358
SESSIONS        DATA_DICTIONARY SESSION_HOST
 
2359
SESSIONS        DATA_DICTIONARY SESSION_ID
 
2360
SESSIONS        DATA_DICTIONARY SESSION_SCHEMA
 
2361
SESSIONS        DATA_DICTIONARY STATE
2314
2362
SESSION_STATEMENTS      DATA_DICTIONARY VARIABLE_NAME
2315
2363
SESSION_STATEMENTS      DATA_DICTIONARY VARIABLE_VALUE
2316
2364
SESSION_STATUS  DATA_DICTIONARY VARIABLE_NAME