← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/information_schema.test

Removing global errbuff and cleaning up two remaining instances that referenced it.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/information_schema.test
33
33
 
34
34
show tables like 't%';
35
35
--replace_column 8 # 12 # 13 #
36
 
show table status;
 
36
#show table status;
37
37
show full columns from t3 like "a%";
38
38
select * from information_schema.COLUMNS where table_name="t1"
39
39
and column_name= "a";
55
55
 
56
56
select * from information_schema.CHARACTER_SETS
57
57
where CHARACTER_SET_NAME like 'latin1%';
58
 
SHOW CHARACTER SET LIKE 'latin1%';
59
58
 
60
59
# Test for information_schema.COLLATIONS &
61
60
# SHOW COLLATION
63
62
--replace_column 5 #
64
63
select * from information_schema.COLLATIONS
65
64
where COLLATION_NAME like 'latin1%';
66
 
--replace_column 5 #
67
 
SHOW COLLATION LIKE 'latin1%';
68
65
 
69
66
select * from information_schema.COLLATION_CHARACTER_SET_APPLICABILITY
70
67
where COLLATION_NAME like 'latin1%';
91
88
where table_schema="mysql" and table_name="user";
92
89
 
93
90
#
94
 
# Bug #7981:SHOW GLOBAL STATUS crashes server
95
 
#
96
 
# We don't actually care about the value, just that it doesn't crash.
97
 
--replace_column 2 #
98
 
show global status like "Threads_running";
99
 
 
100
 
#
101
91
# Bug #7215  information_schema: columns are longtext instead of varchar
102
92
# Bug #7217  information_schema: columns are varbinary() instead of timestamp
103
93
#
398
388
select * from information_schema.tables where table_name = NULL;
399
389
select * from `information_schema`.`TABLE_CONSTRAINTS` where `TABLE_SCHEMA` = NULL;
400
390
select * from `information_schema`.`TABLE_CONSTRAINTS` where `TABLE_NAME` = NULL;
 
391
 
 
392
--echo #
 
393
--echo # Test that the query is visible to self and others.
 
394
--echo #
 
395
 
 
396
SELECT info FROM information_schema.processlist WHERE id = CONNECTION_ID();