Bugs item #2728891, was opened at 2009-04-03 23:12
Message generated for change (Tracker Item Submitted) made by skinkie
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2728891&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 CVS Head
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Stefan de Konink (skinkie)
Assigned to: Niels Nes (nielsnes)
Summary: where IN (....) crashes mserver5
Initial Comment:
A very long IN part crashes the mserver5 code; gdb return the 'mcount' issue.
I rewrote the query in 'OR' and that resulted in a 'nice' error message.
QUERY = delete from nodes_legacy where id = 1278
ERROR = !memory exhausted in: "delete from nodes_legacy where id = 1278
! or id = 1279
! or id = 1280
! or id = 1281
...
Never the less, the individual deletes are very slow. I would like to know how
I could optimise this problem.
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2728891&group_id=56967
------------------------------------------------------------------------------
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
