summaryrefslogtreecommitdiff
path: root/mysql-test/t/func_in.test
diff options
context:
space:
mode:
authormonty@mashka.mysql.fi <>2003-01-06 01:48:59 +0200
committermonty@mashka.mysql.fi <>2003-01-06 01:48:59 +0200
commit1f6ecc0cd3d9acf4751ebbbf8db8b6ee468d3abf (patch)
tree5fe133480d7e74a88990405ae324694fb8797fa5 /mysql-test/t/func_in.test
parentf9772317eefe95fe8152d69593082b2864164e16 (diff)
downloadmariadb-git-1f6ecc0cd3d9acf4751ebbbf8db8b6ee468d3abf.tar.gz
Changed mysql-test to print warnings for not existing table to DROP TABLE
Cleaned up test; Removed wrong DROP TABLE commands and use standard table and database names. changed store_warning() -> push_warning_print()
Diffstat (limited to 'mysql-test/t/func_in.test')
-rw-r--r--mysql-test/t/func_in.test6
1 files changed, 5 insertions, 1 deletions
diff --git a/mysql-test/t/func_in.test b/mysql-test/t/func_in.test
index 7bbc560276f..723f1707a42 100644
--- a/mysql-test/t/func_in.test
+++ b/mysql-test/t/func_in.test
@@ -1,3 +1,7 @@
+# Initialise
+--disable_warnings
+drop table if exists t1;
+--enable_warnings
#
# test of IN (NULL)
#
@@ -14,7 +18,7 @@ select NULL in (1.5,2.5,3.5);
select 1.5 in (1.5,NULL,3.5);
select 3.5 in (1.5,NULL,3.5);
select 10.5 in (1.5,NULL,3.5);
-drop table if exists t1;
+
CREATE TABLE t1 (a int, b int, c int);
insert into t1 values (1,2,3), (1,NULL,3);
select 1 in (a,b,c) from t1;