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: Closed
>Resolution: Fixed
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 = mone...@localhost:50000
ACTION= read_line
QUERY = SELECT DISTINCT EMPNUM
ERROR = Connection terminated
----------------------------------------------------------------------
>Comment By: Romulo Goncalves (romulog)
Date: 2009-02-09 15:08
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: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
------------------------------------------------------------------------------
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
