Select from multiple tables fails when joining another table
------------------------------------------------------------
Key: CORE-5286
URL: http://tracker.firebirdsql.org/browse/CORE-5286
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0.0
Environment: Windows
Reporter: Jonathan Neve
Priority: Minor
Given the following tables:
create table testtable1
(
code integer not null primary key,
name varchar(50)
)
create table testtable2
(
code integer not null primary key,
name varchar(50)
)
create table testtable3
(
code integer not null primary key,
testtable1_ref integer,
name varchar(50)
)
The following SQL fails:
select *
from testtable1 t1, testtable2 t2
join testtable3 t3 on t3.testtable1_ref = t1.code
Error message:
Column does not belong to referenced table.
Dynamic SQL Error.
SQL error code = -206.
Column unknown.
T1.CODE.
At line 3, column 46.
The message doesn't make sense, and the exact same SQL works using FB 2.5.
--
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 NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and protocols are
consuming the most bandwidth. Provides multi-vendor support for NetFlow,
J-Flow, sFlow and other flows. Make informed decisions using capacity planning
reports. http://sdm.link/zohomanageengine
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
