[
https://issues.jboss.org/browse/TEIID-3770?page=com.atlassian.jira.plugin...
]
Van Halbert commented on TEIID-3770:
------------------------------------
Now, Teiid throws different exception:
12:37:27,261 WARN [org.teiid.PROCESSOR] (Worker3_QueryProcessorQueue181) TEIID30020
Processing exception for request r7NYsl824ly1.8 'TEIID30504 Source: 602
TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT
g_0.intkey AS c_0, g_0.bigdecimalvalue AS c_1 FROM smalla AS g_0 WHERE g_0.bigdecimalvalue
= SOME (SELECT MAX(g_1.bigdecimalvalue) FROM smalla AS g_1 WHERE g_1.intkey = g_0.intkey)
ORDER BY c_0]'. Originally TeiidProcessingException PhoenixSQLParser.java:345.:
org.teiid.core.TeiidProcessingException: TEIID30504 Source: 602 TEIID11008:TEIID11004
Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0.intkey AS c_0,
g_0.bigdecimalvalue AS c_1 FROM smalla AS g_0 WHERE g_0.bigdecimalvalue = SOME (SELECT
MAX(g_1.bigdecimalvalue) FROM smalla AS g_1 WHERE g_1.intkey = g_0.intkey) ORDER BY c_0]
at
org.teiid.dqp.internal.process.DataTierTupleSource.exceptionOccurred(DataTierTupleSource.java:401)
[teiid-engine-8.12.5.redhat-6.jar:8.12.5.redhat-6]
at
HBase - table's alias (... AS ...) is not "visible" in
SELECT caluse in IN predicate
------------------------------------------------------------------------------------
Key: TEIID-3770
URL:
https://issues.jboss.org/browse/TEIID-3770
Project: Teiid
Issue Type: Bug
Components: Misc. Connectors
Affects Versions: 8.7.1.6_2
Reporter: Juraj DurĂ¡ni
Assignee: Steven Hawkins
Fix For: 8.12.1, 8.13
Query:
SELECT INTKEY, BIGDECIMALVALUE FROM BQT1.SMALLA AS A WHERE BIGDECIMALVALUE *IN (SELECT
MAX(BIGDECIMALVALUE) FROM BQT1.SMALLA AS B WHERE _A_.INTKEY = B.INTKEY)* ORDER BY INTKEY
It seems like bug in Phoenix driver.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)