Bugs item #2080207, was opened at 2008-08-28 10:23
Message generated for change (Comment added) made by romulog
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2080207&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 "stable"
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Qian Qiao (drizzlerain)
Assigned to: Niels Nes (nielsnes)
Summary: The sub SELECT can't identify the outer table
Initial Comment:
OS: RedHat Linux AS 4
GCC: 3.4.6
1. setup
drop table A;
drop table B;
CREATE TABLE A
(a varchar(10),
b varchar(10));
CREATE TABLE B
(a varchar(10),
b varchar(10));
insert into a values('1','2');
insert into a values('2','2');
insert into b values('1','2');
insert into b values('3','2');
2. execute
update A set a='a' where A.a not in (select B.a from B where A.b=B.b);
3. result
select * from a;
+---+--+
| a |b |
+===+==+
| a |2 |
| a |2 |
+---+--+
4.question:
The result should be only "a 2".
----------------------------------------------------------------------
>Comment By: Romulo Goncalves (romulog)
Date: 2008-12-01 15:44
Message:
This bug is fixed in the current branch of M5-SQL without using the algebra
version.
It will not be closed because it is not fixed in the stable branch...
What happen to the propagation? Or was the fix only checked in on the
current branch?
----------------------------------------------------------------------
Comment By: Romulo Goncalves (romulog)
Date: 2008-11-17 19:03
Message:
Another additional information. If I do the following select (extracted
from the update query) for the non_algebra version:
select * from A where A.a not in (select B.a from B where A.b=B.b);
I get:MAPI = [EMAIL PROTECTED]:50000
QUERY = select * from A where A.a not in (select B.a from B where
A.b=B.b);
ERROR = !MALException:batstr.CMDcompare!=:requires bats of identical size
However, in the algebra version I get the correct result:
% sys.a, sys.a # table_name
% a, b # name
% varchar, varchar # type
% 1, 1 # length
[ "2", "2" ]
----------------------------------------------------------------------
Comment By: Niels Nes (nielsnes)
Date: 2008-08-28 12:51
Message:
Logged In: YES
user_id=43556
Originator: NO
seems related to 2080151 The result of SELECT NOT is wrong
(added test table_update.SF-2080207.sql
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2080207&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
