Hi *!
This query fails with
"The cursor identified in the UPDATE or DELETE statement is not positioned on a row.
no current record for fetch operation."
Works as expected with SubQueryConversion = false.
Tested with with 5.0.4 latest snapshot (1770).
SELECT FIRST 1
a.rdb$index_name
FROM rdb$relation_constraints a
WHERE a.rdb$relation_name = 'RDB$FUNCTIONS' AND
a.rdb$constraint_type IN ('UNIQUE', 'PRIMARY KEY') AND
EXISTS(SELECT
1
FROM rdb$index_segments b1
WHERE b1.rdb$index_name = a.rdb$index_name AND
b1.rdb$field_name = 'RDB$PACKAGE_NAME') AND
EXISTS(SELECT
1
FROM rdb$index_segments b2
WHERE b2.rdb$index_name = a.rdb$index_name AND
b2.rdb$field_name = 'RDB$FUNCTION_NAME')
Hi *!
This query fails with
"The cursor identified in the UPDATE or DELETE statement is not positioned on a row.
no current record for fetch operation."
Works as expected with SubQueryConversion = false.
Tested with with 5.0.4 latest snapshot (1770).