-
-
Notifications
You must be signed in to change notification settings - Fork 218
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Firebird 5.0 - GBAK: Wrong warning "index X cannot be used in the specified plan" #8301
Comments
Is the PLAN in SP equal to the PLAN generated by the optimizer ? |
Seems like a duplicate for #7841 |
@hvlad The test was prepared to demonstrate behavior instead a more complex DDL.
|
Firebird: 5.0.1.
The stored procedure has the optimiser hint to use one of two indices for the table
During restoring the database from the backup, the backup log contains a warning message:
...
gbak: restoring index IND_TBL_TEST_NAME_ID
...
gbak: WARNING: index IND_TBL_TEST_NAME_ID cannot be used in the specified plan
...
gbak: activating and creating deferred index IND_TBL_TEST_NAME_ID
...
As a result:
However, the warning message wrongly attracts the attention of the support team and automatization routines.
The gbak must suppress a warning when the deferred index is planned to be activated and created later.
See the attached archive with the test artefacts:
TEST__GBAK_WARN_INDEX_OPTIMISER_HINT.zip
The text was updated successfully, but these errors were encountered: