← Back to branch summary

~ubuntu-branches/ubuntu/maverick/mysql-5.1/maverick-proposed

« back to all changes in this revision

Viewing changes to mysql-test/t/lowercase_view.test

  • Committer: Package Import Robot
  • Author(s): Marc Deslauriers
  • Date: 2012-02-22 14:16:05 UTC
  • mto: This revision was merged to the branch mainline in revision 20.
  • Revision ID: package-import@ubuntu.com-20120222141605-nxlu9yzc6attylc2
Tags: upstream-5.1.61
Import upstream version 5.1.61

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/t/lowercase_view.test
160
160
DROP VIEW v1;
161
161
DROP TABLE t1;
162
162
 
163
 
--echo End of 5.0 tests.
 
163
 
 
164
--echo End of 5.0 tests.
 
165
 
 
166
 
 
167
--echo #
 
168
--echo # Bug #53095: SELECT column_name FROM INFORMATION_SCHEMA.STATISTICS
 
169
--echo #  returns nothing
 
170
--echo #
 
171
 
 
172
CREATE TABLE `ttt` (
 
173
  `f1` char(3) NOT NULL,
 
174
  PRIMARY KEY (`f1`)
 
175
) ENGINE=myisam DEFAULT CHARSET=latin1;
 
176
 
 
177
SELECT count(COLUMN_NAME) FROM INFORMATION_SCHEMA.STATISTICS WHERE TABLE_NAME =
 
178
'TTT';
 
179
SELECT count(*) FROM INFORMATION_SCHEMA.STATISTICS WHERE TABLE_NAME = 'TTT';
 
180
 
 
181
DROP TABLE `ttt`;
 
182
 
 
183
 
 
184
--echo End of 5.0 tests.
 
185