Bugs item #2795951, was opened at 2009-05-23 23:23
Message generated for change (Comment added) made by nielsnes
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2795951&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: Segmentation fault on having min(...)
Initial Comment:
(gdb) bt
#0 0x0000000000750077 in ?? ()
#1 0x00007ffff751df51 in ATOMlen (t=255, src=0x12ae7c8)
at ../../../src/gdk/gdk_atoms.mx:960
#2 0x00007ffff751e4fc in ATOMdup (t=255, p=0x12ae7c8)
at ../../../src/gdk/gdk_atoms.mx:1064
#3 0x00007fffe33f0330 in res_col_create (tr=0xe57718, t=0x12aceb8,
tn=0x128bcd8 "sys.way_nds", name=0x128bd08 "to_node",
typename=0x128bd28 "int", digits=32, scale=0, mtype=255, val=0x12ae7c8)
at ../../../../src/storage/bat/res_table.mx:88
#4 0x00007fffe33746b5 in mvc_result_value (m=0x1229578,
tn=0x128bcd8 "sys.way_nds", name=0x128bd08 "to_node",
typename=0x128bd28 "int", digits=32, scale=0, p=0x12ae7c8, mtype=255)
at ../../../../src/backends/monet5/sql_result.mx:1215
#5 0x00007fffe332a906 in mvc_result_value_wrap (cntxt=0x604a20, mb=0x1291128,
stk=0x12ae0d8, pci=0x12b2ca8)
at ../../../../src/backends/monet5/sql.mx:2063
#6 0x00007ffff7cf9275 in runMALsequence (cntxt=0x604a20, mb=0x1291128,
startpc=1, stoppc=0, stk=0x12ae0d8, env=0x0, pcicaller=0x0)
at ../../../src/mal/mal_interpreter.mx:1783
#7 0x00007ffff7cf1220 in callMAL (cntxt=0x604a20, mb=0x1291128,
env=0x7fffe2cfbda8, argv=0x7fffe2cfbdf0, debug=0 '\0')
at ../../../src/mal/mal_interpreter.mx:435
#8 0x00007fffe336374f in SQLexecutePrepared (c=0x604a20, be=0x126d948,
---Type <return> to continue, or q <return> to quit---
q=0x1278d18) at ../../../../src/backends/monet5/sql_scenario.mx:1190
#9 0x00007fffe33639be in SQLengineIntern (c=0x604a20, be=0x126d948)
at ../../../../src/backends/monet5/sql_scenario.mx:1243
#10 0x00007fffe3363e88 in SQLengine (c=0x604a20)
at ../../../../src/backends/monet5/sql_scenario.mx:1353
#11 0x00007ffff7d31ed2 in runPhase (c=0x604a20, phase=4)
at ../../../src/mal/mal_scenario.mx:602
#12 0x00007ffff7d3205f in runScenarioBody (c=0x604a20)
at ../../../src/mal/mal_scenario.mx:647
#13 0x00007ffff7d321f6 in runScenario (c=0x604a20)
at ../../../src/mal/mal_scenario.mx:672
#14 0x00007ffff7cef124 in MSserveClient (dummy=0x604a20)
at ../../../src/mal/mal_session.mx:492
#15 0x0000003c1a4073da in start_thread () from /lib64/libpthread.so.0
#16 0x0000003c19ce62bd in clone () from /lib64/libc.so.6
Query:
select to_node from way_tags, way_nds where k = 'amenity' and v = 'bus_station'
and way_nds.way = way_tags.way group by way_nds.way, way_nds.to_node having
min(to_node);
CREATE TABLE "sys"."way_tags" (
"way" int,
"k" varchar(255),
"v" varchar(1024)
);
CREATE TABLE "sys"."way_nds" (
"way" int,
"idx" int,
"to_node" int
);
But because I don't want to show an active denial of cooperation I also provide
a trivial example:
select schema_id from tables group by schema_id having min(schema_id);
----------------------------------------------------------------------
>Comment By: Niels Nes (nielsnes)
Date: 2009-05-28 19:55
Message:
properly check types of having. Added test having_min_crash.SF-2795951.sql
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2795951&group_id=56967
------------------------------------------------------------------------------
Register Now for Creativity and Technology (CaT), June 3rd, NYC. CaT
is a gathering of tech-side developers & brand creativity professionals. Meet
the minds behind Google Creative Lab, Visual Complexity, Processing, &
iPhoneDevCamp as they present alongside digital heavyweights like Barbarian
Group, R/GA, & Big Spaceship. http://p.sf.net/sfu/creativitycat-com
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
