diff options
author | monty@mysql.com <> | 2004-02-16 10:03:25 +0200 |
---|---|---|
committer | monty@mysql.com <> | 2004-02-16 10:03:25 +0200 |
commit | f43093ec0e1ca391f0cdde589418d19c4b82241a (patch) | |
tree | 44dc172194086edaeef7da9c9ed059171579a886 /mysql-test/t/delete.test | |
parent | ce145789092b294a562f565671478ae2bf51d14a (diff) | |
download | mariadb-git-f43093ec0e1ca391f0cdde589418d19c4b82241a.tar.gz |
After merge fixes
Added more DBUG statements
Ensure that we are comparing end space with BINARY strings
Use 'any_db' instead of '' to mean any database. (For HANDLER command)
Only strip ' ' when comparing CHAR, not other space-like characters (like \t)
Diffstat (limited to 'mysql-test/t/delete.test')
-rw-r--r-- | mysql-test/t/delete.test | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/t/delete.test b/mysql-test/t/delete.test index bd5d9e5c0d9..e370b545eff 100644 --- a/mysql-test/t/delete.test +++ b/mysql-test/t/delete.test @@ -84,7 +84,7 @@ insert into t2 values (1, 21),(2, 12),(3, 23); select * from t11; select * from t12; select * from t2; --- error 1241 +-- error 1242 delete t11.*, t12.* from t11,t12 where t11.a = t12.a and t11.b <> (select b from t2 where t11.a < t2.a); select * from t11; select * from t12; @@ -92,7 +92,7 @@ delete ignore t11.*, t12.* from t11,t12 where t11.a = t12.a and t11.b <> (select select * from t11; select * from t12; insert into t11 values (2, 12); --- error 1241 +-- error 1242 delete from t11 where t11.b <> (select b from t2 where t11.a < t2.a); select * from t11; delete ignore from t11 where t11.b <> (select b from t2 where t11.a < t2.a); |