Details
Description
select e.first_name from emp e, addr a where e.first_name in (a.first_name)
8org.apache.calcite.avatica.proto.Responses$ErrorResponseÆ ëjava.lang.RuntimeException: java.sql.SQLException: ERROR 214 (22008): Values in IN must evaluate to a constant. at org.apache.calcite.avatica.jdbc.JdbcMeta.propagate(JdbcMeta.java:645) at org.apache.calcite.avatica.jdbc.JdbcMeta.prepare(JdbcMeta.java:671) at org.apache.calcite.avatica.remote.LocalService.apply(LocalService.java:177) at org.apache.calcite.avatica.remote.Service$PrepareRequest.accept(Service.java:1401) at org.apache.calcite.avatica.remote.Service$PrepareRequest.accept(Service.java:1379) at org.apache.calcite.avatica.remote.AbstractHandler.apply(AbstractHandler.java:102) at org.apache.calcite.avatica.remote.ProtobufHandler.apply(ProtobufHandler.java:38) at org.apache.calcite.avatica.server.AvaticaProtobufHandler.handle(AvaticaProtobufHandler.java:68) at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:52)
Attachments
Issue Links
- is required by
-
PHOENIX-3051 IN predicate cannot compare CHAR columns of differing length
- Reopened
- relates to
-
PHOENIX-1386 ANY function only works with absolute value and doesn't work with other parameters
- Open