~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/subselect.test

  • Committer: Brian Aker
  • Date: 2009-01-28 19:37:25 UTC
  • mfrom: (779.3.11 devel)
  • Revision ID: brian@tangent.org-20090128193725-pz7g7dnp2dx0863e
Merge from Monty.

Show diffs side-by-side

added added

removed removed

Lines of Context:
3036
3036
#
3037
3037
CREATE TABLE t1 (s1 char(1)) ENGINE=MyISAM;
3038
3038
INSERT INTO t1 VALUES ('a');
3039
 
SELECT * FROM t1 WHERE _utf8'a' = ANY (SELECT s1 FROM t1);
 
3039
SELECT * FROM t1 WHERE 'a' = ANY (SELECT s1 FROM t1);
3040
3040
DROP TABLE t1;
3041
3041
 
3042
3042
#