diff options
| author | unknown <dlenev@brandersnatch.localdomain> | 2004-12-20 09:55:06 +0300 |
|---|---|---|
| committer | unknown <dlenev@brandersnatch.localdomain> | 2004-12-20 09:55:06 +0300 |
| commit | 5db116af7a818141a475a8b8cf8a4ea5caf53cc0 (patch) | |
| tree | d61c4ea2d66a5a9f22d311b16c06a67d155f1e93 /mysql-test/r/derived.result | |
| parent | fb69c85183fa51a3a7ed95297c2b9f8a98ba6b48 (diff) | |
| download | mariadb-git-5db116af7a818141a475a8b8cf8a4ea5caf53cc0.tar.gz | |
Added test which covers nicely recent cleanup in derived tables
processing.
Diffstat (limited to 'mysql-test/r/derived.result')
| -rw-r--r-- | mysql-test/r/derived.result | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/mysql-test/r/derived.result b/mysql-test/r/derived.result index ddd8f82de2c..da2bb9081de 100644 --- a/mysql-test/r/derived.result +++ b/mysql-test/r/derived.result @@ -330,3 +330,8 @@ SELECT MIN(price) min, MAX(price) max, AVG(price) avg FROM (SELECT SUBSTRING( MA min max avg 10.00 10.00 10 DROP TABLE t1; +CREATE TABLE t1 (a char(10), b char(10)); +INSERT INTO t1 VALUES ('root','localhost'), ('root','%'); +SELECT * FROM (SELECT (SELECT a.a FROM t1 AS a WHERE a.a = b.a) FROM t1 AS b) AS c; +ERROR 21000: Subquery returns more than 1 row +DROP TABLE t1; |