← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/join_outer.result

  • Committer: Brian Aker
  • Date: 2010-08-18 19:37:19 UTC
  • mto: This revision was merged to the branch mainline in revision 1720.
  • Revision ID: brian@tangent.org-20100818193719-bxxzn1pi22styowd
created function that can be used to simply crash the server.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/join_outer.result
462
462
7       green
463
463
select * from t2 natural join t1;
464
464
color   count   name
465
 
black   5       grape
466
465
green   10      lime
467
466
green   7       lime
 
467
black   5       grape
468
468
select t2.count, t1.name from t2 natural join t1;
469
469
count   name
470
470
10      lime
 
471
7       lime
471
472
5       grape
472
 
7       lime
473
473
select t2.count, t1.name from t2 inner join t1 using (color);
474
474
count   name
475
475
10      lime
 
476
7       lime
476
477
5       grape
477
 
7       lime
478
478
drop table t1;
479
479
drop table t2;
480
480
CREATE TABLE t1 (