diff options
| author | Georgi Kodinov <joro@sun.com> | 2009-06-15 17:36:51 +0300 |
|---|---|---|
| committer | Georgi Kodinov <joro@sun.com> | 2009-06-15 17:36:51 +0300 |
| commit | 3fe572dd062741a407b749b3529b9eccecca5003 (patch) | |
| tree | c629048eb6a2e05db4c7b3e0049dbd72427ede71 /mysql-test/include | |
| parent | 1ad8016974bab985781041bd791f9f97a294d998 (diff) | |
| parent | b1560b9f2f0c8d64e256a7305e066df161f8d10d (diff) | |
| download | mariadb-git-3fe572dd062741a407b749b3529b9eccecca5003.tar.gz | |
automerge
Diffstat (limited to 'mysql-test/include')
| -rw-r--r-- | mysql-test/include/index_merge1.inc | 26 |
1 files changed, 26 insertions, 0 deletions
diff --git a/mysql-test/include/index_merge1.inc b/mysql-test/include/index_merge1.inc index 5837df67a75..d137b0957c0 100644 --- a/mysql-test/include/index_merge1.inc +++ b/mysql-test/include/index_merge1.inc @@ -527,4 +527,30 @@ where exists (select 1 from t2, t3 drop table t0, t1, t2, t3; +--echo # +--echo # BUG#44810: index merge and order by with low sort_buffer_size +--echo # crashes server! +--echo # +CREATE TABLE t1(a VARCHAR(128),b VARCHAR(128),KEY(A),KEY(B)); +INSERT INTO t1 VALUES (REPEAT('a',128),REPEAT('b',128)); +INSERT INTO t1 SELECT * FROM t1; +INSERT INTO t1 SELECT * FROM t1; +INSERT INTO t1 SELECT * FROM t1; +INSERT INTO t1 SELECT * FROM t1; +INSERT INTO t1 SELECT * FROM t1; +INSERT INTO t1 SELECT * FROM t1; +SET SESSION sort_buffer_size=1; +EXPLAIN +SELECT * FROM t1 FORCE INDEX(a,b) WHERE a LIKE 'a%' OR b LIKE 'b%' + ORDER BY a,b; +# we don't actually care about the result : we're checking if it crashes +--disable_result_log +SELECT * FROM t1 FORCE INDEX(a,b) WHERE a LIKE 'a%' OR b LIKE 'b%' + ORDER BY a,b; +--enable_result_log + +SET SESSION sort_buffer_size=DEFAULT; +DROP TABLE t1; + + --echo End of 5.0 tests |