← Back to branch summary

~ubuntu-branches/ubuntu/hardy/mysql-dfsg-5.0/hardy-updates

« back to all changes in this revision

Viewing changes to mysql-test/t/func_in.test

  • Committer: Bazaar Package Importer
  • Author(s): sean finney
  • Date: 2007-05-13 12:32:45 UTC
  • mfrom: (1.1.11 upstream)
  • Revision ID: james.westby@ubuntu.com-20070513123245-8c3l187dk34cz2ar
Tags: 5.0.41-2
the previous "translation changes" inadvertently introduced unrelated
changes in the package control file.

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/t/func_in.test
360
360
 
361
361
DROP TABLE t1,t2,t3,t4;
362
362
 
 
363
#
 
364
# BUG#27362: IN with a decimal expression that may return NULL
 
365
#
 
366
 
 
367
CREATE TABLE t1 (id int not null);
 
368
INSERT INTO t1 VALUES (1),(2);
 
369
 
 
370
SELECT id FROM t1 WHERE id IN(4564, (SELECT IF(1=0,1,1/0)) );
 
371
 
 
372
DROP TABLE t1;
 
373
 
363
374
--echo End of 5.0 tests