diff options
| author | unknown <bell@sanja.is.com.ua> | 2002-11-13 13:10:40 +0200 |
|---|---|---|
| committer | unknown <bell@sanja.is.com.ua> | 2002-11-13 13:10:40 +0200 |
| commit | e0ad88a2ff751d62853fa4f81d007d1b55fc71f4 (patch) | |
| tree | 80b4336f838cbc52af9eba038d7230af51d4f395 /mysql-test/r/subselect.result | |
| parent | a464676f64a4a6e61f17b75c6ec1693ac948b303 (diff) | |
| parent | 0fb5b32422b5dbf624660dec70aa617364cd884c (diff) | |
| download | mariadb-git-e0ad88a2ff751d62853fa4f81d007d1b55fc71f4.tar.gz | |
Merge abelkin@work.mysql.com:/home/bk/mysql-4.1
into sanja.is.com.ua:/home/bell/mysql/mysql-4.1
Diffstat (limited to 'mysql-test/r/subselect.result')
| -rw-r--r-- | mysql-test/r/subselect.result | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/r/subselect.result b/mysql-test/r/subselect.result index 77499625bcd..5820c3259be 100644 --- a/mysql-test/r/subselect.result +++ b/mysql-test/r/subselect.result @@ -256,4 +256,12 @@ UNIQUE KEY `maxnumrep` (`maxnumrep`) INSERT INTO forumconthardwarefr7 (numeropost,maxnumrep) VALUES (1,0),(2,1); select numeropost as a FROM forumconthardwarefr7 GROUP BY (SELECT 1 FROM forumconthardwarefr7 HAVING a=1); Subselect returns more than 1 record +select numeropost as a FROM forumconthardwarefr7 ORDER BY (SELECT 1 FROM forumconthardwarefr7 HAVING a=1); +Subselect returns more than 1 record drop table if exists forumconthardwarefr7; +drop table if exists iftest; +CREATE TABLE iftest (field char(1) NOT NULL DEFAULT 'b'); +INSERT INTO iftest VALUES (); +SELECT field FROM iftest WHERE 1=(SELECT 1 UNION ALL SELECT 1 FROM (SELECT 1) HAVING field='b'); +Subselect returns more than 1 record +drop table iftest; |