~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/join.test

  • Committer: Brian Aker
  • Date: 2010-10-06 07:52:09 UTC
  • mto: (1821.1.2 build)
  • mto: This revision was merged to the branch mainline in revision 1822.
  • Revision ID: brian@tangent.org-20101006075209-0fu3u7zg9r8rw3i8
Fix issue with divide by zero not being an error.

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