~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/join.test

  • Committer: lbieber
  • Date: 2010-10-07 21:44:19 UTC
  • mfrom: (1812.4.2 staging)
  • mto: This revision was merged to the branch mainline in revision 1822.
  • Revision ID: lbieber@orisndriz08-20101007214419-0w3k9dlvlnt57tah
Merge Brian - fixu bug #655558: SELECT 102/(1-1) should error on divide by zero          

Show diffs side-by-side

added added

removed removed

Lines of Context:
151
151
SELECT * FROM t1 LEFT JOIN t2 USING (d) WHERE t2.d IS NULL;
152
152
SELECT * FROM t1 LEFT JOIN t2 USING (d) WHERE d IS NULL;
153
153
SELECT * from t1 WHERE t1.d IS NULL;
 
154
--error ER_DIVISION_BY_ZERO
154
155
SELECT * FROM t1 WHERE 1/0 IS NULL;
155
156
DROP TABLE t1,t2;
156
157