diff options
author | Seppo Jaakola <seppo.jaakola@codership.com> | 2012-08-09 01:47:21 +0300 |
---|---|---|
committer | Seppo Jaakola <seppo.jaakola@codership.com> | 2012-08-09 01:47:21 +0300 |
commit | ebfa24b1d24377a241b79883da96969a9150f22c (patch) | |
tree | ef1198f9dfb1838cbdbc5056f2b84e399b446bfd /mysql-test/suite/storage_engine/delete_with_keys.test | |
parent | 1fd2e10736d6fd198e62054cb9006a3dc13fd55e (diff) | |
parent | a7123f507598690ef0fce68b5d8dc58e63635024 (diff) | |
download | mariadb-git-ebfa24b1d24377a241b79883da96969a9150f22c.tar.gz |
References lp:1034621 - Merge up to mysql-5.5.25 level
merged codership-mysql/5.5 revisions: bzr diff -r3759..3767
merged codership-mysql/5.5 revisions: bzr diff -r3768..3771
Diffstat (limited to 'mysql-test/suite/storage_engine/delete_with_keys.test')
-rw-r--r-- | mysql-test/suite/storage_engine/delete_with_keys.test | 74 |
1 files changed, 74 insertions, 0 deletions
diff --git a/mysql-test/suite/storage_engine/delete_with_keys.test b/mysql-test/suite/storage_engine/delete_with_keys.test new file mode 100644 index 00000000000..274801b6d0e --- /dev/null +++ b/mysql-test/suite/storage_engine/delete_with_keys.test @@ -0,0 +1,74 @@ +# +# DELETE statements for tables with keys +# +--source have_engine.inc +--source have_default_index.inc + +--disable_warnings +DROP TABLE IF EXISTS t1; +--enable_warnings + +--let $create_definition = a $int_col, b $char_indexed_col, $default_index (b) +--source create_table.inc +if ($mysql_errname) +{ + --let $functionality = Index on a CHAR column + --source unexpected_result.inc +} +if (!$mysql_errname) +{ + INSERT INTO t1 (a,b) VALUES (1,'a'),(2,'b'),(3,'c'),(4,'d'),(5,'e'),(6,'x'),(7,'y'),(8,'z'); + DELETE FROM t1 WHERE b > 'y'; + if ($mysql_errname) + { + --let $functionality = DELETE + --source unexpected_result.inc + } + if (!$mysql_errname) + { + DELETE FROM t1 WHERE a=2; + + --sorted_result + SELECT * FROM t1; + DELETE FROM t1; + } + DROP TABLE t1; +} + +--let $create_definition = a $int_indexed_col PRIMARY KEY, b $char_col +--source create_table.inc +if ($mysql_errname) +{ + --let $functionality = PRIMARY KEY + --source unexpected_result.inc +} +if (!$mysql_errname) +{ + INSERT INTO t1 (a,b) VALUES (1,'a'),(2,'b'),(3,'c'),(4,'d'),(5,'e'),(6,'x'),(7,'y'),(8,'z'); + DELETE FROM t1 WHERE b > 'y'; + DELETE FROM t1 WHERE a=2; + + --sorted_result + SELECT * FROM t1; + DELETE FROM t1; + DROP TABLE t1; +} + +--let $create_definition = a $int_indexed_col, b $int_col, c $int_indexed_col, $default_index(a), $default_index(b) +--source create_table.inc +if ($mysql_errname) +{ + --let $functionality = Multiple indexes + --source unexpected_result.inc +} +if (!$mysql_errname) +{ + INSERT INTO t1 (a,b,c) VALUES (1,2,3),(4,5,6),(7,8,9); + DELETE FROM t1 WHERE a = 10 OR b = 20 ORDER BY c LIMIT 1; + --sorted_result + SELECT * FROM t1; + DROP TABLE t1; +} + +--source cleanup_engine.inc + |