From 6ed18d1c9fa444eec6cbb5c5662a13ce7f759e4d Mon Sep 17 00:00:00 2001 From: unknown Date: Wed, 13 Nov 2002 11:59:03 +0200 Subject: fixed bug of derived table in subselect fixed bug in error handling mysql-test/r/subselect.result: test of error handling test of derived tables inside subselect mysql-test/t/subselect.test: test of error handling test of derived tables inside subselect sql/sql_class.cc: fixed error handling error sql/sql_lex.h: fifex layout sql/sql_parse.cc: fixed processing of derived tables sql/sql_select.cc: more quick abort on error --- mysql-test/r/subselect.result | 8 ++++++++ 1 file changed, 8 insertions(+) (limited to 'mysql-test/r/subselect.result') 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; -- cgit v1.2.1