← Back to branch summary

~ubuntu-branches/ubuntu/trusty/drizzle/trusty

« back to all changes in this revision

Viewing changes to tests/r/func_in.result

  • Committer: Bazaar Package Importer
  • Author(s): Monty Taylor
  • Date: 2010-10-02 14:17:48 UTC
  • mfrom: (1.1.1 upstream)
  • mto: (2.1.17 sid)
  • mto: This revision was merged to the branch mainline in revision 3.
  • Revision ID: james.westby@ubuntu.com-20101002141748-m6vbfbfjhrw1153e
Tags: 2010.09.1802-1
* New upstream release.
* Removed pid-file argument hack.
* Updated GPL-2 address to be new address.
* Directly copy in drizzledump.1 since debian doesn't have sphinx 1.0 yet.
* Link to jquery from libjs-jquery. Add it as a depend.
* Add drizzled.8 symlink to the install files.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/func_in.result
349
349
JOIN t2 ON t3.a=t2.a
350
350
JOIN t4 WHERE t4.a IN (t1.b, t2.b);
351
351
id      select_type     table   type    possible_keys   key     key_len ref     rows    Extra
352
 
1       SIMPLE  t3      index   PRIMARY PRIMARY 4       NULL    4       Using index
353
352
1       SIMPLE  t1      eq_ref  PRIMARY PRIMARY 4       test.t3.a       1       
354
353
1       SIMPLE  t2      ALL     PRIMARY NULL    NULL    NULL    5       Using where; Using join buffer
 
354
1       SIMPLE  t3      index   PRIMARY PRIMARY 4       NULL    4       Using index
355
355
1       SIMPLE  t4      ALL     PRIMARY NULL    NULL    NULL    7       Range checked for each record (index map: 0x1)
356
356
SELECT STRAIGHT_JOIN * FROM t3 
357
357
JOIN t1 ON t3.a=t1.a 
367
367
FROM t3, t1, t2
368
368
WHERE t3.a=t1.a AND t3.a=t2.a;
369
369
id      select_type     table   type    possible_keys   key     key_len ref     rows    Extra
370
 
1       PRIMARY t3      index   PRIMARY PRIMARY 4       NULL    4       Using index
371
370
1       PRIMARY t1      eq_ref  PRIMARY PRIMARY 4       test.t3.a       1       
372
371
1       PRIMARY t2      ALL     PRIMARY NULL    NULL    NULL    5       Using where; Using join buffer
 
372
1       PRIMARY t3      index   PRIMARY PRIMARY 4       NULL    4       Using index
373
373
2       DEPENDENT SUBQUERY      t4      index   NULL    PRIMARY 4       NULL    7       Using where; Using index
374
374
SELECT STRAIGHT_JOIN 
375
375
(SELECT SUM(t4.a) FROM t4 WHERE t4.a IN (t1.b, t2.b))