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-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
