← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/select.test

  • Committer: Brian Aker
  • Date: 2011-01-26 00:31:58 UTC
  • mto: (2115.1.1 drizzle-build)
  • mto: This revision was merged to the branch mainline in revision 2116.
  • Revision ID: brian@tangent.org-20110126003158-wciipy0fd4i6tcxt
Next pass through of tests (remove number, use label for error).

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/select.test
2487
2487
INSERT INTO t1 VALUES (1),(2),(3);
2488
2488
INSERT INTO t2 VALUES (2);
2489
2489
INSERT INTO t3 VALUES (3);
 
2490
--error ER_NON_UNIQ_ERROR
2490
2491
SELECT t1.id,t3.id FROM t1 JOIN t2 ON (t2.id=t1.id) LEFT JOIN t3 USING (id);
 
2492
--error ER_NON_UNIQ_ERROR
2491
2493
SELECT t1.id,t3.id FROM t1 JOIN t2 ON (t2.notacolumn=t1.id) LEFT JOIN t3 USING (id);
 
2494
--error ER_NON_UNIQ_ERROR
2492
2495
SELECT id,t3.id FROM t1 JOIN t2 ON (t2.id=t1.id) LEFT JOIN t3 USING (id);
 
2496
--error ER_NON_UNIQ_ERROR
2493
2497
SELECT id,t3.id FROM (t1 JOIN t2 ON (t2.id=t1.id)) LEFT JOIN t3 USING (id);
2494
2498
 
2495
2499
drop table t1, t2, t3;