firebird icon indicating copy to clipboard operation
firebird copied to clipboard

"Index XXX cannot be used in the specified plan" error in Firebird 5

Open krzbor opened this issue 1 year ago • 2 comments

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.

krzbor avatar Apr 27 '24 19:04 krzbor

Please provide a reproducible example.

mrotteveel avatar Apr 28 '24 09:04 mrotteveel

Downloadable example: https://geobid.pl/Pliki/pliki/link.php?plik=fb5test_pusta.zip&klucz=7481589c6831bddcf9d60f8785984fcd

krzbor avatar Apr 28 '24 16:04 krzbor