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: Open
>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
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
