On 14-07-2022 18:23, Ariel Álvarez wrote:
In language reference it is documented:
Table RDB$INDICES
Column RDB$INDEX_TYPE:
Distinguishes between an expression index (1) and a regular index (0 or
null). Not used in databases created before Firebird 2.0; hence, regular
indexes in upgraded databases are more more likely to store null in this
column
But, according to this discussion:
https://github.com/FirebirdSQL/firebird/issues/4085
<https://github.com/FirebirdSQL/firebird/issues/4085>
RDB$INDEX_TYPE identifies a descending or ascending index.
It appears the doc is wrong
It looks like it. The error also occurs in The Firebird Book, Second
Edition. I guess the error derives from there. The first edition of The
Firebird Book says "Not currently used; likely to distinguish regular
indexes from expression indexes when the feature is implemented", so I
guess when expression indexes were added in Firebird 2, the assumption
was codified in the book, and then copied when the Language Reference
was written.
I'll double check this and fix the documentation.
Mark
--
Mark Rotteveel
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel