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 | f26469708414278f56f77fa4cee6aa90dbec7e2f (patch) | |
| tree | c629048eb6a2e05db4c7b3e0049dbd72427ede71 /mysql-test/include/index_merge1.inc | |
| parent | 66398a877a19b56496f706fd131046a5ad257ce8 (diff) | |
| parent | 6df6c8ee95976a53c0c054c86ad38dfa710c4ab5 (diff) | |
| download | mariadb-git-f26469708414278f56f77fa4cee6aa90dbec7e2f.tar.gz | |
automerge
Diffstat (limited to 'mysql-test/include/index_merge1.inc')
| -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 |