← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/derived.result

  • Committer: Brian Aker
  • Date: 2011-02-22 23:14:37 UTC
  • mfrom: (2192.1.2 drizzle-staging)
  • Revision ID: brian@tangent.org-20110222231437-s9vawppxyq1s6ldk
Rollup changes in build.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/derived.result
40
40
select * from t1 as x1, (select * from t1) as x2 where x1.a != 0;
41
41
a       b       a       b
42
42
1       a       1       a
 
43
1       a       2       b
 
44
1       a       3       c
 
45
1       a       3       c
43
46
2       b       1       a
44
 
3       c       1       a
45
 
3       c       1       a
46
 
1       a       2       b
47
47
2       b       2       b
48
 
3       c       2       b
49
 
3       c       2       b
50
 
1       a       3       c
51
 
2       b       3       c
52
 
3       c       3       c
53
 
3       c       3       c
54
 
1       a       3       c
55
 
2       b       3       c
 
48
2       b       3       c
 
49
2       b       3       c
 
50
3       c       1       a
 
51
3       c       1       a
 
52
3       c       2       b
 
53
3       c       2       b
 
54
3       c       3       c
 
55
3       c       3       c
56
56
3       c       3       c
57
57
3       c       3       c
58
58
explain select * from t1 as x1, (select * from t1) as x2 where x1.a != 0;
228
228
select * from ( select * from t1 union select * from t1) a,(select * from t1 union select * from t1) b where a.a != 0;
229
229
a       a
230
230
1       1
 
231
1       2
231
232
2       1
232
 
1       2
233
233
2       2
234
234
explain select * from ( select * from t1 union select * from t1) a,(select * from t1 union select * from t1) b where a.a != 0;
235
235
id      select_type     table   type    possible_keys   key     key_len ref     rows    Extra