Bugs item #2847106, was opened at 2009-08-30 00:21
Message generated for change (Settings changed) made by nielsnes
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2847106&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: Stefan de Konink (skinkie)
Assigned to: Niels Nes (nielsnes)
Summary: SQL: crash upon join with advanced between
Initial Comment:
CREATE TABLE "sys"."way_nds" (
"way" int,
"idx" int,
"to_node" int
);
CREATE TABLE "sys"."nodes_legacy" (
"id" int NOT NULL,
"long" double,
"lat" double,
"uid" int,
"timestamp" TIMESTAMP WITH TIME ZONE,
"zcurve" bigint
);
select way_nds.way, zcurve from way_nds, nodes_legacy where to_node = id and
zcurve between (zcurve - 4096) and (zcurve + 4096);
mserver5: ../../../src/server/rel_bin.mx:517: exp_bin: Assertion `0' failed.
Program received signal SIGABRT, Aborted.
[Switching to Thread 0x7fce851046f0 (LWP 7486)]
0x00007fce821ae645 in raise () from /lib/libc.so.6
(gdb) bt
#0 0x00007fce821ae645 in raise () from /lib/libc.so.6
#1 0x00007fce821afb63 in abort () from /lib/libc.so.6
#2 0x00007fce821a76d9 in __assert_fail () from /lib/libc.so.6
#3 0x00007fce72ee5ff1 in exp_bin (sql=0x2c1cfe8, e=0x2d00fd8, left=0x2cf0cb8,
right=0x2d26998, grp=0x0, sel=0x0) at ../../../src/server/rel_bin.mx:517
#4 0x00007fce72ee717d in rel2bin_join (sql=0x2c1cfe8, rel=0x2d03ac8,
refs=0x2d0e758) at ../../../src/server/rel_bin.mx:797
#5 0x00007fce72ef0d60 in subrel_bin (sql=0x2c1cfe8, rel=0x2d03ac8,
refs=0x2d0e758) at ../../../src/server/rel_bin.mx:3389
#6 0x00007fce72ee9680 in rel2bin_project (sql=0x2c1cfe8, rel=0x2d01108,
refs=0x2d0e758) at ../../../src/server/rel_bin.mx:1409
#7 0x00007fce72ef0e46 in subrel_bin (sql=0x2c1cfe8, rel=0x2d01108,
refs=0x2d0e758) at ../../../src/server/rel_bin.mx:3410
#8 0x00007fce72eea6df in rel2bin_topn (sql=0x2c1cfe8, rel=0x2d013c8,
refs=0x2d0e758) at ../../../src/server/rel_bin.mx:1735
#9 0x00007fce72ef0ed0 in subrel_bin (sql=0x2c1cfe8, rel=0x2d013c8,
refs=0x2d0e758) at ../../../src/server/rel_bin.mx:3422
#10 0x00007fce72ef10bf in output_rel_bin (sql=0x2c1cfe8, rel=0x2d013c8) at
../../../src/server/rel_bin.mx:3469
#11 0x00007fce72e35158 in sql_symbol2stmt (c=0x2c1cfe8, sym=0x2d17058) at
../../../../src/backends/monet5/sql.mx:1243
#12 0x00007fce72e708cb in SQLparser (c=0x605560) at
../../../../src/backends/monet5/sql_scenario.mx:1030
#13 0x00007fce84c56f85 in runPhase (c=0x605560, phase=1) at
../../../src/mal/mal_scenario.mx:602
#14 0x00007fce84c57082 in runScenarioBody (c=0x605560) at
../../../src/mal/mal_scenario.mx:639
#15 0x00007fce84c572e1 in runScenario (c=0x605560) at
../../../src/mal/mal_scenario.mx:672
#16 0x00007fce84c0e185 in MSserveClient (dummy=0x605560) at
../../../src/mal/mal_session.mx:496
#17 0x00000000004035ba in main (argc=2, av=0x7fffc3780878) at
../../../src/tools/mserver5.mx:637
ps. yes binary operations would be more than welcome ;)
----------------------------------------------------------------------
Comment By: Niels Nes (nielsnes)
Date: 2009-09-03 20:45
Message:
fixed bug by properly handling this special case of a select (its a buggy
query, the selections doesn't do anything). Added a test
crash_on_complex_join.SF-2847106
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2847106&group_id=56967
------------------------------------------------------------------------------
Come build with us! The BlackBerry® Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9-12, 2009. Register now!
http://p.sf.net/sfu/devconf
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
