From 1f6ecc0cd3d9acf4751ebbbf8db8b6ee468d3abf Mon Sep 17 00:00:00 2001 From: "monty@mashka.mysql.fi" <> Date: Mon, 6 Jan 2003 01:48:59 +0200 Subject: 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() --- mysql-test/t/row.test | 9 +++++++-- 1 file changed, 7 insertions(+), 2 deletions(-) (limited to 'mysql-test/t/row.test') diff --git a/mysql-test/t/row.test b/mysql-test/t/row.test index 593e2342856..099eaa95c77 100644 --- a/mysql-test/t/row.test +++ b/mysql-test/t/row.test @@ -1,3 +1,8 @@ +# Initialise +--disable_warnings +drop table if exists t1; +--enable_warnings + select row(1,2,3) IN (row(3,2,3), row(1,2,3), row(1,3,3)); select row(10,2,3) IN (row(3,2,3), row(1,2,3), row(1,3,3)); select row(1,2,3) IN (row(3,NULL,3), row(1,2,3), row(1,3,3)); @@ -33,7 +38,7 @@ SELECT ROW('test',2,ROW(3,33))=ROW('test',2,ROW(3,3)); SELECT ROW('test',2,ROW(3,33))=ROW('test',2,ROW(3,NULL)); -- error 1239 SELECT ROW('test',2,ROW(3,33))=ROW('test',2,4); -drop table if exists t1; + create table t1 ( a int, b int, c int); insert into t1 values (1,2,3), (2,3,1), (3,2,1), (1,2,NULL); select * from t1 where ROW(1,2,3)=ROW(a,b,c); @@ -47,7 +52,7 @@ drop table t1; -- error 1239 select ROW(1,1); -drop table if exists t1; + create table t1 (i int); -- error 1239 select 1 from t1 where ROW(1,1); -- cgit v1.2.1