Bugs item #1959410, was opened at 2008-05-07 13:05
Message generated for change (Comment added) made by romulog
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1959410&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: Romulo Goncalves (romulog)
Assigned to: Niels Nes (nielsnes)
Summary: between with column
Initial Comment:
The following sql code crashes the mserver 5:
create table t4 (id int);
create table t5 (age float, yea int);
select yea from t4, t5 where age between 0.03 and id < 30 ;
drop table t4;
drop table t5;
Some debug information to help in the error location:
Program received signal SIGSEGV, Segmentation fault.
[Switching to Thread 1107310928 (LWP 7995)]
0x00002aaabe743666 in sql_logical_exp_ (sql=0x24ff678, scp=0x2766cb8,
sc=0x2502008, grp=0x0, subset=0x0, f=1, ek=
{type = 0 '\0', card = 4 '\004', reduce = 1 '\001'})
at /ufs/goncalve/MonetDB/current/sql/src/server/sql_select.mx:3222
3222 if (rs1->nrcols > 0 || rs2->nrcols > 0 || f == sql_sel)
{
(gdb) p rs1
$3 = (stmt *) 0x27707d8
(gdb) p rs2
$4 = (stmt *) 0x0
(gdb) up
#1 0x00002aaabe744e97 in sql_logical_exp (sql=0x24ff678, scp=0x2766cb8,
sc=0x2502008, grp=0x0, subset=0x0, f=1, ek=
{type = 0 '\0', card = 4 '\004', reduce = 1 '\001'})
at /ufs/goncalve/MonetDB/current/sql/src/server/sql_select.mx:3595
3595 stmt *s = sql_logical_exp_(sql, scp, sc, grp, subset, f, ek);
(gdb) up
#2 0x00002aaabe745ba3 in sql_select (sql=0x24ff678, scp=0x2766cb8,
sn=0x2502108, ek={type = 0 '\0', card = 4 '\004', reduce = 1 '\001'})
at /ufs/goncalve/MonetDB/current/sql/src/server/sql_select.mx:3848
3848 s = sql_logical_exp(sql, scp, sn->where, NULL, NULL,
sql_where, iek);
(gdb)
Romulo
----------------------------------------------------------------------
>Comment By: Romulo Goncalves (romulog)
Date: 2008-05-08 10:43
Message:
Logged In: YES
user_id=1498628
Originator: YES
test added at:
sql/src/test/BugTracker/between_with_column.SF-1959410.sql
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1959410&group_id=56967
-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
Don't miss this year's exciting event. There's still time to save $100.
Use priority code J8TL2D2.
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
