← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/func_in.result

  • 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:
tests/r/func_in.result
457
457
CREATE TABLE t1 (id int not null);
458
458
INSERT INTO t1 VALUES (1),(2);
459
459
SELECT id FROM t1 WHERE id IN(4564, (SELECT IF(1=0,1,1/0)) );
460
 
id
461
 
Warnings:
462
 
Error   1365    Division by 0
 
460
ERROR 22012: Division by 0
463
461
DROP TABLE t1;
464
462
End of 5.0 tests
465
463
create TEMPORARY table t1(f1 char(1)) ENGINE=MYISAM;