diff options
| author | unknown <gkodinov/kgeorge@macbook.gmz> | 2007-03-06 18:52:00 +0200 |
|---|---|---|
| committer | unknown <gkodinov/kgeorge@macbook.gmz> | 2007-03-06 18:52:00 +0200 |
| commit | a232d81e803b60dc60934c19f0a329b7ed53f612 (patch) | |
| tree | 9daa10be5e6f08a5b2f0653f95b36a27d416d417 /mysql-test/t/func_in.test | |
| parent | 68915daf31d7eee6d61f0cce7950c83382209ba8 (diff) | |
| download | mariadb-git-a232d81e803b60dc60934c19f0a329b7ed53f612.tar.gz | |
Bug#19342: additional test case for code coverage
Diffstat (limited to 'mysql-test/t/func_in.test')
| -rw-r--r-- | mysql-test/t/func_in.test | 6 |
1 files changed, 5 insertions, 1 deletions
diff --git a/mysql-test/t/func_in.test b/mysql-test/t/func_in.test index 7ba54747d4b..f9749662ec1 100644 --- a/mysql-test/t/func_in.test +++ b/mysql-test/t/func_in.test @@ -354,6 +354,10 @@ INSERT INTO t3 VALUES (9223372036854775551); SELECT HEX(a) FROM t3 WHERE a IN (9223372036854775807, 42); -DROP TABLE t1,t2,t3; +CREATE TABLE t4 (a DATE); +INSERT INTO t4 VALUES ('1972-02-06'), ('1972-07-29'); +SELECT * FROM t4 WHERE a IN ('1972-02-06','19772-07-29'); + +DROP TABLE t1,t2,t3,t4; --echo End of 5.0 tests |