Bugs item #2130710, was opened at 2008-09-26 20:36
Message generated for change (Comment added) made by romulog
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2130710&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: SQL "stable"
>Status: Closed
>Resolution: Fixed
Priority: 5
Private: No
Submitted By: Hendrike Peetz (hpeetz)
Assigned to: Niels Nes (nielsnes)
Summary: SQL: Aborting process

Initial Comment:
Operating system: Windows XP, 32 bit on parallels (running on Leopard 64bit 
processor)
Using the 32 bit stable version, 20080624

The query that causes this problem:

select i.name, v1.name,  v1.name
from scene s, scene b, victim v1, victim v2, inspector i where
not s.id=b.id and v1.id=s.victim_id and v2.id=b.victim_id;

The result:

System aborts, the client and the server, no error message.

----------------------------------------------------------------------

>Comment By: Romulo Goncalves (romulog)
Date: 2009-02-09 15:04

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

Message:
This bug is fixed in the algebra version for the stable and current branch
of M5-SQL. 
I can't close the bug until it is fixed in the normal version as well.

To use the algebra version just call mclient with option "-G":
mclient -G 

----------------------------------------------------------------------

Comment By: Romulo Goncalves (romulog)
Date: 2008-11-17 21:02

Message:
Test added at:
/sql/src/test/BugTracker-2008/Tests/aborting_process.SF-2130710.sql


The name does not describe about what is the bug. I would like to rename
it, but then I decided to leave like this to simplify the identification of
the bug report. 

----------------------------------------------------------------------

Comment By: Niels Nes (nielsnes)
Date: 2008-10-07 13:57

Message:
indeed crashes with default version. But with the algebra version (mclient
-lsql -G) it runs fine.

----------------------------------------------------------------------

Comment By: Stefan Manegold (stmane)
Date: 2008-09-26 21:00

Message:
With assertions enabled, the query triggers the following assertion:

mserver5:
/ufs/manegold/_/scratch0/Monet/Testing/Stable/source/sql/src/server/sql_optimize.mx:1489:
set2pivot: Assertion `0' failed.
Aborted


----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2130710&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

Reply via email to