[POLL] Centralize existing syntax or create new syntax? > > 1.) CREATE INDEX ... USING .... WITH OPTIONS... > 2.) CREATE LOCAL INDEX ... USING ... WITH OPTIONS... (same as 1, but > adds LOCAL keyword for clarity and separation from future GLOBAL indexes) >
(1) CREATE INDEX … > [POLL] Should there be a default? (YES/NO) > Yes (but see below). > [POLL] What do do with the default? > > 1.) Allow a default, and switch it to SAI (no configurables) > 2.) Allow a default, and stay w/ the legacy 2i (no configurables) > 3.) YAML config to override default index (legacy 2i remains the default) > 4.) YAML config/guardrail to require index type selection (not required by > default) > (4) YAML config. Commented out default of 2i. I agree that the default cannot change in 5.0, but our existing default of 2i can be commented out. For the user this gives them the same feedback, and puts the same requirement to edit one line of yaml, as when we disabled MVs and SASI in 4.0 No one has complained about either of these, which is a clear signal folk understood how to get their existing DDLs to work from 3.x to 4.x
