Bugs item #1959391, was opened at 2008-05-07 10:03
Message generated for change (Comment added) made by nielsnes
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1959391&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: between_having_problem
Initial Comment:
The following sql code crash Mserver5:
create table t3 (id float);
select id from t3 where (id between 0 and 62) having (id = id+.1 or id = id -
.1);
drop table t3;
Some debug information to see where is the problem:
Program received signal SIGABRT, Aborted.
[Switching to Thread 1107310928 (LWP 6471)]
0x0000003c6d030ec5 in raise () from /lib64/libc.so.6
(gdb) up
#1 0x0000003c6d032970 in abort () from /lib64/libc.so.6
(gdb) up
#2 0x0000003c6d02a11f in __assert_fail () from /lib64/libc.so.6
(gdb) up
#3 0x00002aaabe7ae64d in sql_ref_inc (r=0x26abf18)
at /ufs/goncalve/MonetDB/current/sql/src/common/sql_mem.mx:43
43 assert(r->refcnt > 0);
Romulo
----------------------------------------------------------------------
>Comment By: Niels Nes (nielsnes)
Date: 2008-06-02 08:19
Message:
Logged In: YES
user_id=43556
Originator: NO
having without group by defaults to a single aggregated result. The having
is a filter on this result, ie it cannot use full columns but should use
aggregated columns. This is now fixed.
----------------------------------------------------------------------
Comment By: Stefan Manegold (stmane)
Date: 2008-06-01 19:56
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/between_having_problem.SF-1959391.err.00.html
http://monetdb.cwi.nl/testing/projects/monetdb/Stable/sql/.mTests5103/GNU.64.64.d-Fedora8/src_test_BugTracker/between_having_problem.SF-1959391.err.00.html
However, it seems to be solved with the new (not yet default)
algebra-based SQL compiler --- on all platfroms except Solaris 10/x86:
http://monetdb.cwi.nl/testing/projects/monetdb/Stable/sql/.mTestsG103/GNU.64.64.d-Fedora8/src_test_BugTracker/between_having_problem.SF-1959391.out.00.html
http://monetdb.cwi.nl/testing/projects/monetdb/Stable/sql/.mTestsG103/GNU.32.32.d-SunOS5.10/src_test_BugTracker/between_having_problem.SF-1959391.err.00.html
----------------------------------------------------------------------
Comment By: Romulo Goncalves (romulog)
Date: 2008-05-08 08:41
Message:
Logged In: YES
user_id=1498628
Originator: YES
Test added at:
sql/src/test/BugTracker/between_having_problem.SF-1959391.sql
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1959391&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
