diff options
author | petr@mysql.com <> | 2005-11-05 15:08:15 +0300 |
---|---|---|
committer | petr@mysql.com <> | 2005-11-05 15:08:15 +0300 |
commit | a1f56ea5a6414947dc17f565e98f102248e9f286 (patch) | |
tree | a6335f069379fe5794cf0e612aec3dac43c25755 /mysql-test | |
parent | 085b48427dc79339e6c9801d08881606fa8b4ec6 (diff) | |
download | mariadb-git-a1f56ea5a6414947dc17f565e98f102248e9f286.tar.gz |
Fix Bug#13894 Server crashes on update of CSV table
Diffstat (limited to 'mysql-test')
-rw-r--r-- | mysql-test/r/csv.result | 20 | ||||
-rw-r--r-- | mysql-test/t/csv.test | 18 |
2 files changed, 38 insertions, 0 deletions
diff --git a/mysql-test/r/csv.result b/mysql-test/r/csv.result index ea0d34271b5..78a1f34636c 100644 --- a/mysql-test/r/csv.result +++ b/mysql-test/r/csv.result @@ -4929,3 +4929,23 @@ Warnings: Note 1051 Unknown table 't2' Note 1051 Unknown table 't3' Note 1051 Unknown table 't4' +DROP TABLE IF EXISTS bug13894; +CREATE TABLE bug13894 ( val integer ) ENGINE = CSV; +INSERT INTO bug13894 VALUES (5); +INSERT INTO bug13894 VALUES (10); +INSERT INTO bug13894 VALUES (11); +INSERT INTO bug13894 VALUES (10); +SELECT * FROM bug13894; +val +5 +10 +11 +10 +UPDATE bug13894 SET val=6 WHERE val=10; +SELECT * FROM bug13894; +val +5 +11 +6 +6 +DROP TABLE bug13894; diff --git a/mysql-test/t/csv.test b/mysql-test/t/csv.test index 2ac46d75f9a..61b4f9607a5 100644 --- a/mysql-test/t/csv.test +++ b/mysql-test/t/csv.test @@ -1314,4 +1314,22 @@ select period from t1; drop table if exists t1,t2,t3,t4; +# +# Bug #13894 Server crashes on update of CSV table +# + +--disable_warnings +DROP TABLE IF EXISTS bug13894; +--enable_warnings + +CREATE TABLE bug13894 ( val integer ) ENGINE = CSV; +INSERT INTO bug13894 VALUES (5); +INSERT INTO bug13894 VALUES (10); +INSERT INTO bug13894 VALUES (11); +INSERT INTO bug13894 VALUES (10); +SELECT * FROM bug13894; +UPDATE bug13894 SET val=6 WHERE val=10; +SELECT * FROM bug13894; +DROP TABLE bug13894; + # End of 4.1 tests |