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.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
What Every C/C++ and Fortran developer Should Know!
Read this article and learn how Intel has extended the reach of its
next-generation tools to help Windows* and Linux* C/C++ and Fortran
developers boost performance applications - including clusters.
http://p.sf.net/sfu/intel-dev2devmay
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
