summaryrefslogtreecommitdiff
path: root/mysql-test/t/csv.test
diff options
context:
space:
mode:
authorunknown <serg@serg.mylan>2005-11-17 22:52:31 +0100
committerunknown <serg@serg.mylan>2005-11-17 22:52:31 +0100
commitf2af624e4514078a7cb8aac973777f1dc9b10b9b (patch)
treed8d084fac2edf719bb5f0ed8d2db29cfa7df4f66 /mysql-test/t/csv.test
parent57ad6b20ed8b22b010af1c354b23591570f12b09 (diff)
downloadmariadb-git-f2af624e4514078a7cb8aac973777f1dc9b10b9b.tar.gz
BUG#13406 - incorrect amount of "records deleted" in CSV.
Fallback to row-wise delete if number or rows in the table is unknown mysql-test/r/csv.result: BUG#13406 - incorrect amount of "records deleted" mysql-test/t/csv.test: BUG#13406 - incorrect amount of "records deleted" sql/examples/ha_tina.cc: BUG#13406 - incorrect amount of "records deleted". Fallback to row-wise delete if number or rows in the table is unknown sql/examples/ha_tina.h: BUG#13406 - incorrect amount of "records deleted". Fallback to row-wise delete if number or rows in the table is unknown
Diffstat (limited to 'mysql-test/t/csv.test')
-rw-r--r--mysql-test/t/csv.test32
1 files changed, 32 insertions, 0 deletions
diff --git a/mysql-test/t/csv.test b/mysql-test/t/csv.test
index 5b693335a43..a028f6ced6d 100644
--- a/mysql-test/t/csv.test
+++ b/mysql-test/t/csv.test
@@ -1352,3 +1352,35 @@ SELECT * FROM bug14672;
DROP TABLE bug14672;
# End of 4.1 tests
+
+#
+# BUG#13406 - incorrect amount of "records deleted"
+#
+
+create table t1 (a int) engine=csv;
+insert t1 values (1);
+--enable_info
+delete from t1; -- delete_row
+delete from t1; -- delete_all_rows
+--disable_info
+insert t1 values (1),(2);
+--enable_info
+delete from t1; -- delete_all_rows
+--disable_info
+insert t1 values (1),(2),(3);
+flush tables;
+--enable_info
+delete from t1; -- delete_row
+--disable_info
+insert t1 values (1),(2),(3),(4);
+flush tables;
+select count(*) from t1;
+--enable_info
+delete from t1; -- delete_all_rows
+--disable_info
+insert t1 values (1),(2),(3),(4),(5);
+--enable_info
+truncate table t1; -- truncate
+--disable_info
+drop table t1;
+