[MDEV-3586] LP:985667 - Wrong result with subquery in SELECT clause, and constant table in main query and implicit grouping Created: 2012-04-19  Updated: 2015-02-02  Resolved: 2012-10-04

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug Priority: Major
Reporter: Timour Katchaounov (Inactive) Assignee: Timour Katchaounov (Inactive)
Resolution: Fixed Votes: 0
Labels: Launchpad

Attachments: XML File LPexportBug985667.xml    

 Description   

The following test case, extracted from the test for bug lp:680846 produces wrong result:

CREATE TABLE t1 (f1 int) ;
INSERT INTO t1 VALUES (7),(8);

CREATE TABLE t2 (f2 int, f3 varchar(32)) ;
INSERT INTO t2 VALUES (1,'f');

SELECT COUNT(f2), (SELECT f1 FROM t1 WHERE t2.f2 limit 1) AS f4
FROM t2, t1
WHERE 'v'= t2.f3;

---------------+

COUNT(f2) f4

---------------+

0 7

---------------+

The correct result is:

---------------+

COUNT(f2) f4

---------------+

0 NULL

---------------+

 Comments   
Comment by Rasmus Johansson (Inactive) [ 2012-04-27 ]

Launchpad bug id: 985667

Generated at Thu Feb 08 06:49:43 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.