"Index XXX cannot be used in the specified plan" error in Firebird 5
krzbor opened this issue · 2 comments
krzbor commented
In Firebird 5, the error "index XXX cannot be used in the specified plan" occurred. The problem does not occur in earlier versions of FB (2.5, 3, 4).
What is characteristic is that the error appears only in a newly created database. After adding a few records, the problem disappears - the question is executed correctly without errors. Even after deleting all records, the problem does not return - it only affects the new, empty database. I also checked the situation when an empty database was created in FB4 and opened in FB5. Unfortunately the error still persists.
mrotteveel commented
Please provide a reproducible example.
krzbor commented