Creation of inactive index

[Dimitry Sibiryakov]

Hello All,

in relation to unanswered
https://github.com/FirebirdSQL/firebird/pull/8076#issuecomment-2064245860
If creation of an inactive index is allowed, what syntax should it have?

'CREATE INACTIVE INDEX <bla-bla>' or 'CREATE INDEX <bla-bla> INACTIVE'?

Former seems to be more natural, latter match 'ALTER INDEX' structure.

--
WBR, SD.

[Mark Rotteveel]

It should follow the pattern already established by alter index, so
after the index name:

CREATE [UNIQUE] [ASC[ENDING] | DESC[ENDING]]
INDEX indexname [{ACTIVE | INACTIVE}]
ON tablename {(col [, col ...]) | COMPUTED BY (<expression>)}
[WHERE <search_condition>]

I'm also including ACTIVE here, though that should be default when it is
not specified explicitly.

Mark
--
Mark Rotteveel