I’d like to submit a feature request for a flag to disable hint validation.
Problem
There is always a lag between cloud-spanner-emulator and real Spanner instances in terms of supported query hints, and this can become an obstacle to adopting hints.
The Spanner emulator does not support real Spanner query plans, so the practical benefit of hint validation in the emulator is limited, except for a few hints such as FORCE_INDEX, where it can verify the existence of an index.
Similar to -disable_query_null_filtered_index_check, I would like the emulator to provide a startup flag to disable hint validation. For example, something like -disable_hint_validation or -ignore_unknown_hints.
FYI
I’d like to submit a feature request for a flag to disable hint validation.
Problem
There is always a lag between
cloud-spanner-emulatorand real Spanner instances in terms of supported query hints, and this can become an obstacle to adopting hints.The Spanner emulator does not support real Spanner query plans, so the practical benefit of hint validation in the emulator is limited, except for a few hints such as
FORCE_INDEX, where it can verify the existence of an index.Similar to
-disable_query_null_filtered_index_check, I would like the emulator to provide a startup flag to disable hint validation. For example, something like-disable_hint_validationor-ignore_unknown_hints.FYI