summaryrefslogtreecommitdiff
path: root/mysql-test/t/csv.test
diff options
context:
space:
mode:
authorpetr@mysql.com <>2005-11-06 02:11:12 +0300
committerpetr@mysql.com <>2005-11-06 02:11:12 +0300
commit038b300753440a9cc24da56c2ba9ff477726243c (patch)
tree26cfc43e4f5200a600ec917cf0ceba7232e21053 /mysql-test/t/csv.test
parenta1f56ea5a6414947dc17f565e98f102248e9f286 (diff)
downloadmariadb-git-038b300753440a9cc24da56c2ba9ff477726243c.tar.gz
Fix Bug#14672 Bug in deletion
Diffstat (limited to 'mysql-test/t/csv.test')
-rw-r--r--mysql-test/t/csv.test19
1 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/t/csv.test b/mysql-test/t/csv.test
index 61b4f9607a5..5b693335a43 100644
--- a/mysql-test/t/csv.test
+++ b/mysql-test/t/csv.test
@@ -1332,4 +1332,23 @@ UPDATE bug13894 SET val=6 WHERE val=10;
SELECT * FROM bug13894;
DROP TABLE bug13894;
+#
+# Bug #14672 Bug in deletion
+#
+
+--disable_warnings
+DROP TABLE IF EXISTS bug14672;
+--enable_warnings
+
+CREATE TABLE bug14672 (c1 integer) engine = CSV;
+INSERT INTO bug14672 VALUES (1), (2), (3);
+SELECT * FROM bug14672;
+DELETE FROM bug14672 WHERE c1 = 2;
+SELECT * FROM bug14672;
+INSERT INTO bug14672 VALUES (4);
+SELECT * FROM bug14672;
+INSERT INTO bug14672 VALUES (5);
+SELECT * FROM bug14672;
+DROP TABLE bug14672;
+
# End of 4.1 tests