Bugs item #1688915, was opened at 2007-03-27 06:01
Message generated for change (Settings changed) made by nielsnes
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1688915&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: Martin Kersten (mlkersten)
Assigned to: Niels Nes (nielsnes)
Summary: SQL: crash on nested query
Initial Comment:
The following query leads to a crash
select name from (select name, id from tables order by id) as x;
partial stack trace.
0x00002aaabc1d4a55 in sql2str (s=0x0)
at /ufs/mk/monet5//package/sql/src/common/sql_string.mx:115
#1 0x00002aaabc15bfbd in stmt_atom_string (S=0x0)
at /ufs/mk/monet5//package/sql/src/server/sql_statement.mx:414
#2 0x00002aaabc15f652 in stmt_alias (op1=0x1088e18, tname=0x10892c8 "x",
alias=0x0) at /ufs/mk/monet5//package/sql/src/server/sql_statement.mx:1984
#3 0x00002aaabc16f10b in table_optname (sql=0xea62e8, scp=0xa71f28,
sq=0x1088a38, optname=0xea8d28)
at /ufs/mk/monet5//package/sql/src/server/sql_select.mx:398
#4 0x00002aaabc16f3ce in sql_subquery_optname (sql=0xea62e8, scp=0xa71f28,
query=0xea8c28) at /ufs/mk/monet5//package/sql/src/server/sql_select.mx:450
#5 0x00002aaabc16e71a in table_ref (sql=0xea62e8, scp=0xa71f28,
----------------------------------------------------------------------
>Comment By: Niels Nes (nielsnes)
Date: 2007-03-31 08:13
Message:
Logged In: YES
user_id=43556
Originator: NO
properly handle column_name's for subqueries with order by (beware that
order by in subqueries is
a feature which we may drop again in the future)
Added test subquery_orderby.SF-1688915.sql
in src/test/BugTracker
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1688915&group_id=56967
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs