Bugs item #1959357, was opened at 2008-05-07 11:23
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1959357&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: sql_div
Initial Comment:
The following sql statements crash the mserver5:
sql>create table t1 (id int);
sql>create table t2 (age int);
sql>select age from t1, t2 where (age-id)/id<0.01;
Some debig information to see from where comes the crash:
Program received signal SIGABRT, Aborted.
[Switching to Thread 1107310928 (LWP 5293)]
0x0000003c6d030ec5 in raise () from /lib64/libc.so.6
Missing separate debuginfos, use: debuginfo-install bzip2.x86_64
e2fsprogs.x86_64 glibc.x86_64 keyutils.x86_64 krb5.x86_64 libselinux.x86_64
ncurses.x86_64 openssl.x86_64 pcre.x86_64 readline.x86_64 zlib.x86_64
(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 0x00002aaabe72364b in find_pivot (scp=0x4fe7308, t=0x50279e8)
at /ufs/goncalve/MonetDB/current/sql/src/server/sql_scope.mx:229
229 assert(0);
(gdb) up
#4 0x00002aaabe72366e in scope_find_pivot (scp=0x4fe7308, t=0x50279e8)
at /ufs/goncalve/MonetDB/current/sql/src/server/sql_scope.mx:237
237 return find_pivot(scp, t);
(gdb) up
#5 0x00002aaabe73b773 in sql_binop_ (sql=0x246d0d8, scp=0x4fe7308,
s=0xc1a808, fname=0x5029f58 "sql_div", ls=0x50ea698, rs=0x50dac18)
at /ufs/goncalve/MonetDB/current/sql/src/server/sql_select.mx:879
879 ls = stmt_join(scope_find_pivot(scp, ls->h), ls,
cmp_equal);
(gdb) up
#6 0x00002aaabe73c27f in sql_binop (sql=0x246d0d8, scp=0x4fe7308,
se=0x502a048, grp=0x0, subset=0x0, f=1)
at /ufs/goncalve/MonetDB/current/sql/src/server/sql_select.mx:1069
1069 return sql_binop_(sql, scp, s, fname, ls, rs);
(gdb) p fname
$1 = 0x5029f58 "sql_div"
Romulo
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1959357&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
