← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/union.result

  • Committer: Andrew Hutchings
  • Date: 2011-02-07 17:01:15 UTC
  • mto: (2148.2.3 build)
  • mto: This revision was merged to the branch mainline in revision 2149.
  • Revision ID: andrew@linuxjedi.co.uk-20110207170115-e4sryp5nkb3n2vhy
https://launchpad.net/bugs/713347
Implicit joins of the form "SELECT * FROM t1, t2" without WHERE or ON now error.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/union.result
515
515
insert into t2 (group_name) values ('Group A');
516
516
insert into t2 (group_name) values ('Group B');
517
517
insert into t3 (user_id, group_id) values (1,1);
518
 
select 1 'is_in_group', a.user_name, c.group_name, b.id from t1 a, t3 b, t2 c where a.id = b.user_id and b.group_id = c.id UNION  select 0 'is_in_group', a.user_name, c.group_name, null from t1 a, t2 c;
 
518
select 1 'is_in_group', a.user_name, c.group_name, b.id from t1 a, t3 b, t2 c where a.id = b.user_id and b.group_id = c.id UNION  select 0 'is_in_group', a.user_name, c.group_name, null from t1 a CROSS JOIN t2 c;
519
519
is_in_group     user_name       group_name      id
520
520
1       Tester  Group A 1
521
521
0       Tester  Group A NULL