Bugs item #2837561, was opened at 2009-08-14 11:42
Message generated for change (Comment added) made by nielsnes
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2837561&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 "stable"
>Status: Closed
>Resolution: Fixed
Priority: 5
Private: No
Submitted By: Wouter Alink (vzzzbx)
Assigned to: Niels Nes (nielsnes)
Summary: SQL: group by on view with constants
Initial Comment:
The following query sequence makes the server crash on the May2009 branch:
CREATE VIEW test AS SELECT 'none' AS score, 'none' AS avalue, 'none' AS
displayname;
SELECT avalue FROM test GROUP BY avalue;
The debugger says:
(gdb) bt
#0 0x0000000000750077 in ?? ()
#1 0x00007f2b36dcf675 in ATOMlen (t=255, src=0x7f2b240f9c28) at
/home/alink/workspace/MonetDB/MonetDB/src/gdk/gdk_atoms.mx:960
#2 0x00007f2b36dcfc20 in ATOMdup (t=255, p=0x7f2b240f9c28) at
/home/alink/workspace/MonetDB/MonetDB/src/gdk/gdk_atoms.mx:1064
#3 0x00007f2b247bdff8 in res_col_create (tr=0x7f2b24140aa8, t=0x7f2b23ae7b68,
tn=0x7f2b23af8f98 ".find_NE_from_DOC_2_RESULT_facet7",
name=0x7f2b23af3be8 "score", typename=0x7f2b23af3848 "char", digits=4,
scale=0, mtype=255, val=0x7f2b240f9c28)
at /home/alink/workspace/MonetDB/sql/src/storage/bat/res_table.mx:88
#4 0x00007f2b2473e21d in mvc_result_value (m=0x7f2b24145b38, tn=0x7f2b23af8f98
".find_NE_from_DOC_2_RESULT_facet7", name=0x7f2b23af3be8 "score",
typename=0x7f2b23af3848 "char", digits=4, scale=0, p=0x7f2b240f9c28,
mtype=255)
at /home/alink/workspace/MonetDB/sql/src/backends/monet5/sql_result.mx:1215
#5 0x00007f2b246f3beb in mvc_result_value_wrap (cntxt=0x604a20,
mb=0x7f2b240fa2e8, stk=0x7f2b240f9a98, pci=0x7f2b23af38c8)
at /home/alink/workspace/MonetDB/sql/src/backends/monet5/sql.mx:2067
#6 0x0000000000970fb4 in runMALsequence (cntxt=0x604a20, mb=0x7f2b240fa2e8,
startpc=1, stoppc=0, stk=0x7f2b240f9a98, env=0x0, pcicaller=0x0)
at /home/alink/workspace/MonetDB/MonetDB5/src/mal/mal_interpreter.mx:1740
#7 0x0000000000968d0d in callMAL (cntxt=0x604a20, mb=0x7f2b240fa2e8,
env=0x7f2b23d64da8, argv=0x7f2b23d64df0, debug=0 '\0')
at /home/alink/workspace/MonetDB/MonetDB5/src/mal/mal_interpreter.mx:394
#8 0x00007f2b2472d498 in SQLexecutePrepared (c=0x604a20, be=0x7f2b23a6cfc8,
q=0x7f2b23ae6768)
at
/home/alink/workspace/MonetDB/sql/src/backends/monet5/sql_scenario.mx:1190
#9 0x00007f2b2472d707 in SQLengineIntern (c=0x604a20, be=0x7f2b23a6cfc8)
at
/home/alink/workspace/MonetDB/sql/src/backends/monet5/sql_scenario.mx:1243
#10 0x00007f2b2472dbd1 in SQLengine (c=0x604a20) at
/home/alink/workspace/MonetDB/sql/src/backends/monet5/sql_scenario.mx:1353
#11 0x00000000009aa07d in runPhase (c=0x604a20, phase=4) at
/home/alink/workspace/MonetDB/MonetDB5/src/mal/mal_scenario.mx:602
#12 0x00000000009aa20a in runScenarioBody (c=0x604a20) at
/home/alink/workspace/MonetDB/MonetDB5/src/mal/mal_scenario.mx:647
#13 0x00000000009aa3a1 in runScenario (c=0x604a20) at
/home/alink/workspace/MonetDB/MonetDB5/src/mal/mal_scenario.mx:672
#14 0x0000000000966cf1 in MSserveClient (dummy=0x604a20) at
/home/alink/workspace/MonetDB/MonetDB5/src/mal/mal_session.mx:493
#15 0x00000036f06073da in start_thread () from /lib64/libpthread.so.0
#16 0x00000036efae62bd in clone () from /lib64/libc.so.6
(gdb)
----------------------------------------------------------------------
>Comment By: Niels Nes (nielsnes)
Date: 2009-08-16 14:24
Message:
fixed we now make sure we always group on bats. Added test
group_by_on_values.SF-2837561.sql
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2837561&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
