Hello everyone,
Hibernate often generates this kind of nested from queries, if you have a
complex hierarchy of entities:
SELECT
mtoplevelt0_.definition_id AS definiti1_5_0_,
mtoplevelt0_.entity_id AS entity_i2_5_0_,
mtoplevelt0_.m_owner_id AS m_owner_3_5_0_,
mtoplevelt0_.entity_version AS entity_v4_5_0_,
mtoplevelt0_.execution_type AS executio1_9_0_,
mtoplevelt0_.m_parent_definition_id AS m_parent2_9_0_,
mtoplevelt0_.m_parent_id AS m_parent3_9_0_,
mtoplevelt0_.m_parent_owner_id AS m_parent4_9_0_,
mtoplevelt0_.clazz_ AS clazz_0_
FROM (SELECT
definition_id,
entity_id,
m_owner_id,
entity_version,
m_parent_definition_id,
m_parent_id,
m_parent_owner_id,
execution_type,
3 AS clazz_
FROM m_task_group) mtoplevelt0_
WHERE mtoplevelt0_.definition_id = ? AND mtoplevelt0_.entity_id = ? AND
mtoplevelt0_.m_owner_id = ?
It seems that this kind of query syntax doesn’t work in Ignite SQL, it throws a
org.apache.ignite.internal.processors.query.IgniteSQLException: Failed to parse
query exception in Ignite 2.3.0.
Are there any plans to support this kind of nested queries? Should an
enhancement request be made for this in JIRA?
Regards,
M.
