Bugs item #2080151, was opened at 2008-08-28 07:44
Message generated for change (Comment added) made by nielsnes
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2080151&group_id=56967
Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: SQL/Core
Group: MonetDB5 5.6
>Status: Closed
>Resolution: Fixed
Priority: 5
Private: No
Submitted By: Qian Qiao (drizzlerain)
Assigned to: Niels Nes (nielsnes)
Summary: The result of SELECT NOT is wrong
Initial Comment:
OS: RedHat Linux AS 4
GCC: 3.4.6
1.setup:
CREATE TABLE A (
a varchar(10)
);
INSERT INTO A VALUES ('a1');
INSERT INTO A VALUES ('a2');
CREATE TABLE B (
a varchar(10)
);
INSERT INTO B VALUES ('a1');
INSERT INTO B VALUES ('a2');
INSERT INTO B VALUES ('a3');
2.execute:
SELECT COUNT(*)
FROM A
WHERE NOT (A.a =
(SELECT B.a
FROM B
WHERE a > 'a4' ));
3.result:
+--------+
| count_ |
+========+
| 2 |
+--------+
4.question:
The count should be 0;
----------------------------------------------------------------------
>Comment By: Niels Nes (nielsnes)
Date: 2008-09-09 12:39
Message:
a sub query within a not wasn't correctly handled.
----------------------------------------------------------------------
Comment By: Niels Nes (nielsnes)
Date: 2008-08-28 10:39
Message:
Logged In: YES
user_id=43556
Originator: NO
Added test select_not_wrong_result.SF-2080151.sql
It seems to work correctly on the algebra backend (mclient -G)
The handling of the NOT in the binary algebra case goes wrong.
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2080151&group_id=56967
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
