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

Reply via email to