diff options
author | unknown <gshchepa/uchum@gleb.loc> | 2007-10-28 01:27:47 +0500 |
---|---|---|
committer | unknown <gshchepa/uchum@gleb.loc> | 2007-10-28 01:27:47 +0500 |
commit | 639e35d031c7f21919de03445b025b7822bf242e (patch) | |
tree | ca057938d520a85e77ce381658efed1f51a7ada5 /mysql-test/t/archive.test | |
parent | e2bd6c6b124098f55066ba64be05f8219fdaedc0 (diff) | |
parent | b9ecbb7e5c764158b81597b4197a926732c31004 (diff) | |
download | mariadb-git-639e35d031c7f21919de03445b025b7822bf242e.tar.gz |
Merge gleb.loc:/home/uchum/work/bk/PA/5.1-opt-31036-v
into gleb.loc:/home/uchum/work/bk/5.1-opt
mysql-test/r/archive.result:
Auto merged
mysql-test/t/archive.test:
Auto merged
storage/archive/azio.c:
Auto merged
Diffstat (limited to 'mysql-test/t/archive.test')
-rw-r--r-- | mysql-test/t/archive.test | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/mysql-test/t/archive.test b/mysql-test/t/archive.test index e0a2e877af5..f8eff10e30a 100644 --- a/mysql-test/t/archive.test +++ b/mysql-test/t/archive.test @@ -1567,3 +1567,25 @@ insert into t1 set a=''; insert into t1 set a='a'; check table t1 extended; drop table t1; + +# +# BUG#31036 - Using order by with archive table crashes server +# + +CREATE TABLE t1(a VARCHAR(510)) ENGINE = ARCHIVE; + +let $bug31036=41; +--disable_query_log +while($bug31036) +{ + INSERT INTO t1(a) VALUES (REPEAT('a', 510)); + dec $bug31036; +} +--enable_query_log +INSERT INTO t1(a) VALUES (''); + +--disable_result_log +SELECT * FROM t1 ORDER BY a; +--enable_result_log + +DROP TABLE t1; |