summaryrefslogtreecommitdiff
path: root/mysql-test/t/delete.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/t/delete.test')
-rw-r--r--mysql-test/t/delete.test5
1 files changed, 3 insertions, 2 deletions
diff --git a/mysql-test/t/delete.test b/mysql-test/t/delete.test
index 704fb7ada1c..57321739bfb 100644
--- a/mysql-test/t/delete.test
+++ b/mysql-test/t/delete.test
@@ -2,7 +2,9 @@
# Check for problems with delete
#
+--disable_warnings
drop table if exists t1;
+--enable_warnings
CREATE TABLE t1 (a tinyint(3), b tinyint(5));
INSERT INTO t1 VALUES (1,1);
INSERT LOW_PRIORITY INTO t1 VALUES (1,2);
@@ -36,7 +38,6 @@ insert into t1 values (2),(4),(6),(8),(10),(12),(14),(16),(18),(20),(22),(24),(2
delete from t1 where a=27;
drop table t1;
-drop table if exists t;
CREATE TABLE `t` (
`i` int(10) NOT NULL default '0',
`i2` int(10) NOT NULL default '0',
@@ -44,4 +45,4 @@ CREATE TABLE `t` (
) TYPE=MyISAM CHARSET=latin1;
-- error 1054
DELETE FROM t USING t WHERE post='1';
-drop table if exists t; \ No newline at end of file
+drop table if exists t;