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: Closed
>Resolution: Fixed
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: 2009-02-09 15:07
Message:
The algebra version became the default one in the stable branch as well.
So the bug is fixed and it can be closed.
----------------------------------------------------------------------
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 = mone...@localhost: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
------------------------------------------------------------------------------
Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM)
software. With Adobe AIR, Ajax developers can use existing skills and code to
build responsive, highly engaging applications that combine the power of local
resources and data with the reach of the web. Download the Adobe AIR SDK and
Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
