diff options
| author | unknown <svoj@june.mysql.com> | 2007-11-29 15:45:09 +0400 |
|---|---|---|
| committer | unknown <svoj@june.mysql.com> | 2007-11-29 15:45:09 +0400 |
| commit | 157100eef065d30d25f05cbc13705f604f7f8ce9 (patch) | |
| tree | 0b54423cd538b18aea48ce98691853029f08c8cd /mysql-test/t/archive.test | |
| parent | d68d16bb3db00ca4bf09f785e0a39bfa2c202911 (diff) | |
| parent | 13ce2d7778d42a55a51350517c11b87fef90d9cd (diff) | |
| download | mariadb-git-157100eef065d30d25f05cbc13705f604f7f8ce9.tar.gz | |
Merge svojtovich@bk-internal.mysql.com:/home/bk/mysql-5.1-engines
into mysql.com:/home/svoj/devel/mysql/BUG31833/mysql-5.1-engines
mysql-test/r/archive.result:
Auto merged
mysql-test/t/archive.test:
Auto merged
Diffstat (limited to 'mysql-test/t/archive.test')
| -rw-r--r-- | mysql-test/t/archive.test | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/t/archive.test b/mysql-test/t/archive.test index a1158dbfd3b..b42c8446a32 100644 --- a/mysql-test/t/archive.test +++ b/mysql-test/t/archive.test @@ -1589,3 +1589,12 @@ SELECT * FROM t1 ORDER BY a; --enable_result_log DROP TABLE t1; + +# +# BUG#31833 - ORDER BY leads to wrong result when ARCHIVE, BLOB and table +# cache is full +# +CREATE TABLE t1(a INT NOT NULL AUTO_INCREMENT, b BLOB, KEY(a)) ENGINE=archive; +INSERT INTO t1 VALUES (NULL, NULL),(NULL, NULL); +FLUSH TABLE t1; +SELECT * FROM t1 ORDER BY a; |