← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/errors.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:
tests/t/errors.test
44
44
# Bug #27513: mysql 5.0.x + NULL pointer DoS
45
45
#
46
46
CREATE TABLE t1 (a INT);
 
47
--error ER_DIVISION_BY_ZERO
47
48
SELECT a FROM t1 WHERE a IN(1, (SELECT IF(1=0,1,2/0)));
48
49
INSERT INTO t1 VALUES(1);
 
50
--error ER_DIVISION_BY_ZERO
49
51
SELECT a FROM t1 WHERE a IN(1, (SELECT IF(1=0,1,2/0)));
50
52
INSERT INTO t1 VALUES(2),(3);
 
53
--error ER_DIVISION_BY_ZERO
51
54
SELECT a FROM t1 WHERE a IN(1, (SELECT IF(1=0,1,2/0)));
52
55
DROP TABLE t1;
53
56