Bug #5593 SELECT AS not working as expected

• Submitted: 15 Sep 2004 12:45
• Modified: 3 Feb 2006 13:45
• Reporter: Andreas Götz
• Status: Won't fix
• Category: MySQL Server
• Severity: S4 (Feature request)
• Version: 4.1.4
• OS: Windows (WinXP SP1)
• CPU Architecture: Any

[15 Sep 2004 12:45] Andreas Götz

Description:
I've read A.5.4 Problems with alias and would like to request aliases to work in WHERE clauses- in the cases where it's possible. Simple statement as

select sr as request from service_requests where request = 'abc'

should work- and would greatly simlify porting oracle applications.

How to repeat:
.

Suggested fix:
.

[3 Feb 2006 13:45] Valeriy Kravchuk

Thank you for a feature request. Sorry, but I do not think that we'll ever implement this feature. Not sure that it works in Oracle, and that it is covered by SQL 2003 Standard.