Bugs item #2075147, was opened at 2008-08-26 08:30
Message generated for change (Comment added) made by romulog
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2075147&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: after executing the sql below,the mclient quit
Initial Comment:
OS:RedHat Linux AS 4
GCC :3.4.6
1.setup:
CREATE TABLE WORKS
(EMPNUM CHAR(3) NOT NULL,
PNUM CHAR(3) NOT NULL,
HOURS DECIMAL(5),
UNIQUE(EMPNUM,PNUM));
2.execute:
SELECT DISTINCT EMPNUM FROM WORKS WORKSX WHERE NOT EXISTS (SELECT * FROM
WORKS WORKSY WHERE EMPNUM = 'E2' AND NOT EXISTS (SELECT * FROM WORKS WORKSZ
WHERE WORKSZ.EMPNUM = WORKSX.EMPNUM AND WORKSZ.PNUM = WORKSY.PNUM));
3.result:
MAPI = [EMAIL PROTECTED]:50000
ACTION= read_line
QUERY = SELECT DISTINCT EMPNUM
ERROR = Connection terminated
----------------------------------------------------------------------
>Comment By: Romulo Goncalves (romulog)
Date: 2008-12-01 15:38
Message:
This bug is fixed in the algebra version for the stable and current version
of M5-SQL.
I can't close the bug until it is fixed in the normal version.
To use the algebra version just call mclient with option "-G":
mclient -G
----------------------------------------------------------------------
Comment By: Niels Nes (nielsnes)
Date: 2008-08-26 15:04
Message:
Logged In: YES
user_id=43556
Originator: NO
Added correlated_exists.SF-2075147.sql test. This test gives problems both
on the relational and binary relational version
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2075147&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
