On 16-07-2022 11:15, Mark Rotteveel wrote:
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.
I published a new version of the docs with this fixed.
Mark
--
Mark Rotteveel
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
