Description of problem: Unexpected exception. Returned exception indicates that query failed but there is no reason in message. How reproducible: Source databse - Ingres VDB view model - BQT2 tables: smallb - `INTKEY` integer primary key, `STRINGKEY` varchar(10), `INTNUM` integer, `STRINGNUM` varchar(10), `FLOATNUM` real, `LONGNUM` bigint, `DOUBLENUM` double, `BYTENUM` tinyint, `DATEVALUE` date, `TIMEVALUE` time, `TIMESTAMPVALUE` timestamp, `BOOLEANVALUE` boolean, `CHARVALUE` character(1), `SHORTVALUE` smallint, `BIGINTEGERVALUE` bigint, `BIGDECIMALVALUE` decimal(10,0), `OBJECTVALUE` byte SQL query - SELECT intkey FROM BQT1.SmallA AS A WHERE stringkey = (SELECT stringkey FROM BQT1.SmallA AS B WHERE b.intnum = a.intnum ) ORDER BY intkey Actual results: TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 Source: 4502 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0.intkey AS c_0 FROM smalla AS g_0 WHERE g_0.stringkey = (SELECT g_1.stringkey FROM smalla AS g_1 WHERE g_1.intnum = g_0.intnum) ORDER BY c_0] Expected results: Additional info: server log and exception stack trace in attachment
Created attachment 927826 [details] java application exception stack trace
Created attachment 927827 [details] server log
Created attachment 927828 [details] Server log after query
*** Bug 1131012 has been marked as a duplicate of this bug. ***
*** Bug 1131007 has been marked as a duplicate of this bug. ***
*** Bug 1130985 has been marked as a duplicate of this bug. ***
Steven Hawkins <shawkins> updated the status of jira TEIID-3088 to Resolved
Steven Hawkins <shawkins> updated the status of jira TEIID-3088 to Closed