← 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: 2009-10-07 16:55:53 UTC
  • mfrom: (1161.2.1 bug444827)
  • Revision ID: brian@gaz-20091007165553-9tnp7liw1k9g6gvc
Merge Padraig

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 (
1189
1189
4       ddddddd
1190
1190
show status like 'Handler_read%';
1191
1191
Variable_name   Value
1192
 
Handler_read_first      #
1193
 
Handler_read_key        #
1194
 
Handler_read_next       #
1195
 
Handler_read_prev       #
1196
 
Handler_read_rnd        #
1197
 
Handler_read_rnd_next   #
 
1192
Handler_read_first      1
 
1193
Handler_read_key        8
 
1194
Handler_read_next       0
 
1195
Handler_read_prev       0
 
1196
Handler_read_rnd        0
 
1197
Handler_read_rnd_next   6
1198
1198
DROP TABLE t1,t2;
1199
1199
CREATE TABLE t1 (c int  PRIMARY KEY, e int NOT NULL);
1200
1200
INSERT INTO t1 VALUES (1,0), (2,1);