If the following query is executed and the subquery returns a single value, an exception is thrown.
SELECT * FROM table t1 WHERE t1."foo" IN (SELECT t2."bar" FROM table t2)
[Error Code: 393216, SQL State: 60000] java.lang.ClassCastException: [Ljava.lang.Object; cannot be cast to [[B
at com.hxtt.sql.dbf.i.if(Unknown Source)
at com.hxtt.sql.a1.a(Unknown Source)
at com.hxtt.sql.cl.a(Unknown Source)
at com.hxtt.sql.ay.a(Unknown Source)
at com.hxtt.sql.dj.a(Unknown Source)
at com.hxtt.sql.dj.a(Unknown Source)
at com.hxtt.sql.c1.e(Unknown Source)
at com.hxtt.sql.dj.a(Unknown Source)
at com.hxtt.sql.br.a(Unknown Source)
at com.hxtt.sql.ai.a(Unknown Source)
at com.hxtt.sql.dl.execute(Unknown Source)
not sure if this helps, but I also noticed that the query did work when rewriting it to:
SELECT * FROM table t1 WHERE NVL(t1."foo", '') IN (SELECT t2."bar" FROM table t2)
|
|
Supported now. That's an issue about index quicken for IN clause. The latest package will be available after about 1 hour.
|
Main
webmaster@hxtt.com