diff options
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 + |