Bugs item #1907048, was opened at 2008-03-04 14:37 Message generated for change (Comment added) made by nielsnes You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1907048&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: Closed >Resolution: Fixed Priority: 5 Private: No Submitted By: Romulo Goncalves (romulog) Assigned to: Niels Nes (nielsnes) Summary: a huge mathematical expression... Initial Comment: The following sql statements crash the mserver: sql>create table t1 (z real); sql>create table t2 (name string, dered_g real, dered_r real); sql>SELECT p.name FROM t1 as s, t2 as p WHERE (-0.399*(dered_g-4.79*LOG10(s.z/0.03)-3.65*(dered_g-dered_r)-39.55))> 10.7 LIMIT 100000; >[New Thread 1107310928 (LWP 15947)] mserver5: /ufs/goncalve/MonetDB/sql/src/server/sql_scope.mx:229: find_pivot: Assertion `0' failed. Program received signal SIGABRT, Aborted. [Switching to Thread 1107310928 (LWP 15947)] 0x0000003c4bc30ec5 in raise () from /lib64/libc.so.6 (gdb) Romulo ---------------------------------------------------------------------- >Comment By: Niels Nes (nielsnes) Date: 2008-06-02 10:46 Message: Logged In: YES user_id=43556 Originator: NO now also the default SQL compiler works, ie closing. ---------------------------------------------------------------------- Comment By: Stefan Manegold (stmane) Date: 2008-06-01 19:49 Message: Logged In: YES user_id=572415 Originator: NO Update: The problem seems to persist with the default SQL compiler on both M4 & M5: http://monetdb.cwi.nl/testing/projects/monetdb/Stable/sql/.mTests4103/GNU.64.64.d-Fedora8/src_test_BugTracker/huge_math_expre.SF-1907048.err.00.html http://monetdb.cwi.nl/testing/projects/monetdb/Stable/sql/.mTests5103/GNU.64.64.d-Fedora8/src_test_BugTracker/huge_math_expre.SF-1907048.err.00.html However, it seems to be solved with the new (not yet default) algebra-based SQL compiler: http://monetdb.cwi.nl/testing/projects/monetdb/Stable/sql/.mTestsG103/GNU.64.64.d-Fedora8/src_test_BugTracker/huge_math_expre.SF-1907048.out.00.html http://monetdb.cwi.nl/testing/projects/monetdb/Stable/sql/.mTestsG103/GNU.64.64.d-Fedora8/src_test_BugTracker/huge_math_expre.SF-1907048.err.00.html ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1907048&group_id=56967 ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
