Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: None
-
Labels:
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 |
---------------+
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
Launchpad bug id: 985667