Link: This issue is related to JDBC94 [ JDBC94 ]

assignee: Adriano dos Santos Fernandes [ asfernandes ]

Fix Version: 3.0 Alpha 1 [ 10331 ]

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Link: This issue is duplicated by CORE3842 [ CORE3842 ]

description: The query that does not work is of the following kind:

SELECT <columns> FROM table_1 t1
WHERE <conditions on table_1>
AND (? IN SELECT some_col FROM table_2 t2 WHERE http://t1.id = t2.ref_id)

Firebird complains that the data type of the parameter is unknown, however it could be derived from the some_col data type.

I understand that this query can be rewritten using EXISTS clause, but according to the bug description it was generated by Hibernate, so the Java developers hardly have any possibility to fix it themselves.

=>

The query that does not work is of the following kind:

SELECT <columns> FROM table_1 t1
WHERE <conditions on table_1>
AND (? IN (SELECT some_col FROM table_2 t2 WHERE http://t1.id = t2.ref_id))

Firebird complains that the data type of the parameter is unknown, however it could be derived from the some_col data type.

I understand that this query can be rewritten using EXISTS clause, but according to the bug description it was generated by Hibernate, so the Java developers hardly have any possibility to fix it themselves.

summary: Support the "? in SELECT some_col FROM some_table" subqueries => Support the "? in (SELECT some_col FROM some_table)" subqueries

status: Resolved [ 5 ] => Resolved [ 5 ]

QA Status: Done successfully

Link: This issue is related to QA647 [ QA647 ]