← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/information_schema.result

Remove processlist from old I_S.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/information_schema.result
119
119
plugin_name IS NULL
120
120
GROUP BY TABLE_SCHEMA;
121
121
table_schema    count(*)
122
 
information_schema      19
 
122
information_schema      18
123
123
show create database information_schema;
124
124
Database        Create Database
125
125
information_schema      CREATE DATABASE `information_schema`
253
253
OLD_GLOBAL_STATUS       VARIABLE_NAME
254
254
OLD_GLOBAL_VARIABLES    VARIABLE_NAME
255
255
OLD_KEY_COLUMN_USAGE    CONSTRAINT_SCHEMA
256
 
OLD_PROCESSLIST ID
257
256
OLD_REFERENTIAL_CONSTRAINTS     CONSTRAINT_SCHEMA
258
257
OLD_SCHEMATA    SCHEMA_NAME
259
258
OLD_SESSION_VARIABLES   VARIABLE_NAME
289
288
OLD_GLOBAL_STATUS       VARIABLE_NAME
290
289
OLD_GLOBAL_VARIABLES    VARIABLE_NAME
291
290
OLD_KEY_COLUMN_USAGE    CONSTRAINT_SCHEMA
292
 
OLD_PROCESSLIST ID
293
291
OLD_REFERENTIAL_CONSTRAINTS     CONSTRAINT_SCHEMA
294
292
OLD_SCHEMATA    SCHEMA_NAME
295
293
OLD_SESSION_VARIABLES   VARIABLE_NAME
417
415
#
418
416
# Test that the query is visible to self and others.
419
417
#
420
 
SELECT info FROM information_schema.old_processlist WHERE id = CONNECTION_ID();
 
418
SELECT info FROM data_dictionary.processlist WHERE id = CONNECTION_ID();
421
419
info
422
 
SELECT info FROM information_schema.old_processlist WHERE id = CONNECTION_ID()
 
420
SELECT info FROM data_dictionary.processlist WHERE id = CONNECTION_ID()
423
421
show processlist;
424
422
Id      User    Host    db      Command Time    State   Info
425
423
#       #       #       test    Query   #       #       show processlist
426
424
#       #       #       test    Sleep   #       #       
427
425
#       #       #       mysqltest       Sleep   #       #       
428
426
SELECT info, command, db
429
 
FROM information_schema.old_processlist
 
427
FROM data_dictionary.processlist
430
428
WHERE id = CONNECTION_ID();
431
429
info    command db
432
430
SELECT info, command, db
433
 
FROM information_schema.old_processlist
 
431
FROM data_dictionary.processlist
434
432
WHERE id = CONNECTION_ID()      Query   test
435
433
SELECT *
436
434
FROM data_dictionary.character_sets
553
551
OLD_KEY_COLUMN_USAGE    CONSTRAINT_NAME
554
552
OLD_KEY_COLUMN_USAGE    TABLE_CATALOG
555
553
OLD_KEY_COLUMN_USAGE    TABLE_SCHEMA
556
 
OLD_PROCESSLIST INFO
557
 
OLD_PROCESSLIST STATE
558
 
OLD_PROCESSLIST TIME
559
 
OLD_PROCESSLIST COMMAND
560
 
OLD_PROCESSLIST DB
561
 
OLD_PROCESSLIST HOST
562
 
OLD_PROCESSLIST USER
563
 
OLD_PROCESSLIST ID
564
554
OLD_REFERENTIAL_CONSTRAINTS     REFERENCED_TABLE_NAME
565
555
OLD_REFERENTIAL_CONSTRAINTS     TABLE_NAME
566
556
OLD_REFERENTIAL_CONSTRAINTS     DELETE_RULE
865
855
information_schema      OLD_GLOBAL_STATUS
866
856
information_schema      OLD_GLOBAL_VARIABLES
867
857
information_schema      OLD_KEY_COLUMN_USAGE
868
 
information_schema      OLD_PROCESSLIST
869
858
information_schema      OLD_REFERENTIAL_CONSTRAINTS
870
859
information_schema      OLD_SCHEMATA
871
860
information_schema      OLD_SESSION_VARIABLES