search

FirebirdSQL / firebird

Firebird server, client and tools
https://www.firebirdsql.org/
1.19k stars 204 forks source link

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

Open krzbor opened 3 weeks ago

krzbor commented 3 weeks ago

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 2 weeks ago

Please provide a reproducible example.

krzbor commented 2 weeks ago

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