Informix - Problem description
Problem IT40280 | Status: Closed |
SQL ERROR (-19819): AN ON CLAUSE HAS AN INVALID TABLE REFERENCE | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
Getting error when executing the below query. The same query is working for other databases (like SQL, Oracle...etc) select automaton2_.id as id1_0_, automaton2_.code as code2_0_ from operationtype operationt0_ cross join operation operation1_ inner join automaton automaton2_ on operationt0_.automaton_id=automaton2_.id where operation1_.operationtype_id=operationt0_.id and operation1_.id=1 SQL Error (-19819): An ON clause has an invalid table reference | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC16 and 14.10.xC9. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 12.10.xC16 or 14.10.xC9. * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC16 and 14.10.xC9. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 12.10.xC16 or 14.10.xC9. * **************************************************************** | |
Comment | |
Fixed in Informix Server 12.10.xC16 and 14.10.xC9. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 15.03.2022 15.05.2023 15.05.2023 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |