diff options
| author | Michael Widenius <monty@askmonty.org> | 2011-03-09 15:47:59 +0200 |
|---|---|---|
| committer | Michael Widenius <monty@askmonty.org> | 2011-03-09 15:47:59 +0200 |
| commit | 2fd0b7546a282540de4d7c08ccf1cc1b427044a0 (patch) | |
| tree | 7d77d6f1073f8090f275b30cb3f10254497da243 /mysql-test/r/derived.result | |
| parent | dc9706fc13d56cde0d33102a9fa2732f72edf5da (diff) | |
| parent | 1e41824569fb3d26200b0c219edeadd48801f074 (diff) | |
| download | mariadb-git-2fd0b7546a282540de4d7c08ccf1cc1b427044a0.tar.gz | |
Merge with 5.2
Diffstat (limited to 'mysql-test/r/derived.result')
| -rw-r--r-- | mysql-test/r/derived.result | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/r/derived.result b/mysql-test/r/derived.result index e707f01edbf..043231fd268 100644 --- a/mysql-test/r/derived.result +++ b/mysql-test/r/derived.result @@ -400,4 +400,15 @@ SELECT 0 FROM (SELECT 0) t61; 0 0 +# +# A nested materialized derived table is used before being populated. +# (addon for bug#19077) +# +CREATE TABLE t1 (i INT, j BIGINT); +INSERT INTO t1 VALUES (1, 2), (2, 2), (3, 2); +SELECT * FROM (SELECT MIN(i) FROM t1 +WHERE j = SUBSTRING('12', (SELECT * FROM (SELECT MIN(j) FROM t1) t2))) t3; +MIN(i) +1 +DROP TABLE t1; # End of 5.0 tests |