Den 2011-05-18 16:28 skrev Kjell Rilbe (JIRA) såhär: > Ref to undefined TABLE ALIAS gives error message about unknown COLUMN > --------------------------------------------------------------------- > > Key: CORE-3483 > URL: http://tracker.firebirdsql.org/browse/CORE-3483 > Project: Firebird Core > Issue Type: Bug > Components: Engine > Affects Versions: 2.1.3 > Environment: Windows 2008 server 64 bit. Classic. > Reporter: Kjell Rilbe > Priority: Minor > > > select * > from "Investeringskategori" X > inner join "Värdeförrådsvärde" Y on Z."ECO_ID" = X."ECO_ID" > > Please note that in the join condition I accidentally wrote Z instead of Y. > Alias Z isn't defined ANYWHERE. But I still get this error: > > Engine Code : 335544569 > Engine Message : > Dynamic SQL Error > SQL error code = -206 > Column unknown > Z.ECO_ID > At line 14, column 41 > > This may be related to CORE-2959.
Now that I've noticed this bug, I see that it seems to happen each and every time you happen to reference anything using an undefined table alias in a select. Always. So, a pretty consistent bug! :-) Kjell -- -------------------------------------- Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 ------------------------------------------------------------------------------ Simplify data backup and recovery for your virtual environment with vRanger. Installation's a snap, and flexible recovery options mean your data is safe, secure and there when you need it. Discover what all the cheering's about. Get your free trial download today. http://p.sf.net/sfu/quest-dev2dev2 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel