← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/subselect_sj2.test

  • Committer: Padraig O'Sullivan
  • Date: 2009-08-07 14:14:58 UTC
  • mfrom: (1112 staging)
  • mto: (1115.3.4 captain)
  • mto: This revision was merged to the branch mainline in revision 1117.
  • Revision ID: osullivan.padraig@gmail.com-20090807141458-qrc3don58s304ore
Merge from trunk.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/subselect_sj2.test
364
364
 
365
365
drop table t1, t2;
366
366
 
367
 
--echo #
368
 
--echo # MySQL BUG #42742: crash in setup_sj_materialization, Copy_field::set
369
 
--echo # 
370
 
create table t3 ( c1 date) engine=innodb;
371
 
insert into t3 values ('2009-10-22'),('2142-10-22');
372
 
create table t2 (c1 tinytext,c2 text,c6 timestamp) engine=innodb;
373
 
select * from t3;
374
 
explain select 1 from t2 where  c2 in (select 1 from t3 CROSS JOIN t2) and  c1 in (select convert(c6,char(1)) from t2); 
375
 
drop table t2, t3;
376
 
 
377
367
#
378
368
# Bug#33062: subquery in stored routine cause crash
379
369
#