diff options
| author | Martin Hansson <martin.hansson@oracle.com> | 2012-02-07 17:32:04 +0100 |
|---|---|---|
| committer | Martin Hansson <martin.hansson@oracle.com> | 2012-02-07 17:32:04 +0100 |
| commit | bb9a3be632cd25ce0a832228f9a7b3af90075957 (patch) | |
| tree | 11fdcbfb8396e9b0f7ff70efe4d22cfe2d2089a4 /mysql-test/r/join_outer.result | |
| parent | b3c10e2ca9e2932a9cea877eedf07bc6a323b279 (diff) | |
| parent | 9ada2f8ec5d29c036bcd185a411f64eea17d8132 (diff) | |
| download | mariadb-git-bb9a3be632cd25ce0a832228f9a7b3af90075957.tar.gz | |
Merge of fix for Bug#11765810.
Diffstat (limited to 'mysql-test/r/join_outer.result')
| -rw-r--r-- | mysql-test/r/join_outer.result | 58 |
1 files changed, 58 insertions, 0 deletions
diff --git a/mysql-test/r/join_outer.result b/mysql-test/r/join_outer.result index 2320d399078..673014385f0 100644 --- a/mysql-test/r/join_outer.result +++ b/mysql-test/r/join_outer.result @@ -1644,4 +1644,62 @@ NULL NULL NULL DROP TABLE h,m,k; + +# BUG#12567331 - INFINITE LOOP WHEN RESOLVING AN ALIASED COLUMN +# USED IN GROUP BY + +CREATE TABLE t1 ( +col_varchar_1024_latin1_key varchar(1024), +col_varchar_10_latin1 varchar(10), +col_int int(11), +pk int(11) +); +CREATE TABLE t2 ( +col_int_key int(11), +col_int int(11), +pk int(11) +); +PREPARE prep_stmt_9846 FROM ' +SELECT alias1.pk AS field1 FROM +t1 AS alias1 +LEFT JOIN +( + t2 AS alias2 + RIGHT JOIN + ( + t2 AS alias3 + JOIN t1 AS alias4 + ON 1 + ) + ON 1 +) +ON 1 +GROUP BY field1'; +execute prep_stmt_9846; +field1 +execute prep_stmt_9846; +field1 +drop table t1,t2; +# +# Bug #11765810 58813: SERVER THREAD HANGS WHEN JOIN + WHERE + GROUP BY +# IS EXECUTED TWICE FROM P +# +CREATE TABLE t1 ( a INT ) ENGINE = MYISAM; +INSERT INTO t1 VALUES (1); +PREPARE prep_stmt FROM ' + SELECT 1 AS f FROM t1 + LEFT JOIN t1 t2 + RIGHT JOIN t1 t3 + JOIN t1 t4 + ON 1 + ON 1 + ON 1 + GROUP BY f'; +EXECUTE prep_stmt; +f +1 +EXECUTE prep_stmt; +f +1 +DROP TABLE t1; End of 5.1 tests |