~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/information_schema.test

  • Committer: Padraig O'Sullivan
  • Date: 2009-03-21 20:26:28 UTC
  • mto: (960.2.5 mordred)
  • mto: This revision was merged to the branch mainline in revision 961.
  • Revision ID: osullivan.padraig@gmail.com-20090321202628-nh6qsi825m4d4av6
Removing the queues.[h,cc] files from the mysys directory. The only place
where they are needed now is in the MyISAM storage engine. Thus, I moved the
files there and updated the files in the MyISAM storage engine
appropriately.

Show diffs side-by-side

added added

removed removed

Lines of Context:
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
#