summaryrefslogtreecommitdiff
path: root/mysql-test/t/archive.test
diff options
context:
space:
mode:
authorunknown <gshchepa/uchum@gleb.loc>2007-10-28 01:27:47 +0500
committerunknown <gshchepa/uchum@gleb.loc>2007-10-28 01:27:47 +0500
commit639e35d031c7f21919de03445b025b7822bf242e (patch)
treeca057938d520a85e77ce381658efed1f51a7ada5 /mysql-test/t/archive.test
parente2bd6c6b124098f55066ba64be05f8219fdaedc0 (diff)
parentb9ecbb7e5c764158b81597b4197a926732c31004 (diff)
downloadmariadb-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.test22
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;