Bugs item #2333119, was opened at 2008-11-23 15:26 Message generated for change (Comment added) made by romulog You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2333119&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: Invalid Priority: 5 Private: No Submitted By: Stefan de Konink (skinkie) Assigned to: Niels Nes (nielsnes) Summary: SQL92? 'AS' Initial Comment: I don't know if I understand the specs; select bla as y from (select 'hello' as bla) as q where y = 'hello'; !SELECT: identifier 'y' unknown Shouldn't that work the same as: select bla as y from (select 'hello' as bla) as q where bla = 'hello'; ---------------------------------------------------------------------- >Comment By: Romulo Goncalves (romulog) Date: 2008-12-16 10:59 Message: This is not considered a bug. The right way to write your query is like the second the query. bla as y It is used when you return the result to rename the column name. You can't use this alias in the where clause ;) I will close this bug and set it as invalid... ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2333119&group_id=56967 ------------------------------------------------------------------------------ SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada. The future of the web can't happen without you. Join us at MIX09 to help pave the way to the Next Web now. Learn more and register at http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/ _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
