← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/subselect_sj2.result

  • Committer: Padraig O'Sullivan
  • Date: 2009-09-18 00:22:38 UTC
  • mto: This revision was merged to the branch mainline in revision 1139.
  • Revision ID: osullivan.padraig@gmail.com-20090918002238-zq7mui4r2yzoidz1
Extracted KeyUse into its own header file and placed it within the
drizzled::optimizer namespace.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/subselect_sj2.result
343
343
SELECT t2.CountryCode FROM t2 WHERE Population > 5000000);
344
344
Name
345
345
drop table t1, t2;
346
 
#
347
 
# MySQL BUG #42742: crash in setup_sj_materialization, Copy_field::set
348
 
# 
349
 
create table t3 ( c1 date) engine=innodb;
350
 
insert into t3 values ('2009-10-22'),('2142-10-22');
351
 
create table t2 (c1 tinytext,c2 text,c6 timestamp) engine=innodb;
352
 
select * from t3;
353
 
c1
354
 
2009-10-22
355
 
2142-10-22
356
 
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);
357
 
id      select_type     table   type    possible_keys   key     key_len ref     rows    Extra
358
 
1       PRIMARY t2      ALL     NULL    NULL    NULL    NULL    1       Using where
359
 
3       SUBQUERY        t2      ALL     NULL    NULL    NULL    NULL    1       
360
 
2       SUBQUERY        t2      ALL     NULL    NULL    NULL    NULL    1       
361
 
2       SUBQUERY        t3      ALL     NULL    NULL    NULL    NULL    2       Using join buffer
362
 
drop table t2, t3;