diff options
| author | unknown <petr@mysql.com> | 2005-11-06 02:11:12 +0300 |
|---|---|---|
| committer | unknown <petr@mysql.com> | 2005-11-06 02:11:12 +0300 |
| commit | b0829011b8053058f0419aee48da03970654cbc6 (patch) | |
| tree | 26cfc43e4f5200a600ec917cf0ceba7232e21053 /mysql-test/t/csv.test | |
| parent | 1b65c7041383073eee99deebe8569399f06e83ee (diff) | |
| download | mariadb-git-b0829011b8053058f0419aee48da03970654cbc6.tar.gz | |
Fix Bug#14672 Bug in deletion
mysql-test/r/csv.result:
correct result file
mysql-test/t/csv.test:
Add test for a bug
sql/examples/ha_tina.cc:
Add O_APPEND flag to my_open. We should always add rows to the end of file
Diffstat (limited to 'mysql-test/t/csv.test')
| -rw-r--r-- | mysql-test/t/csv.test | 19 |
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 |