Re: [Firebird-devel] Wrong doc RDB$INDICES.RDB$INDEX_TYPE ?

[Mark Rotteveel]

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 



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

[Firebird-devel] Is batch release necessary in the wire protocol?

[Mark Rotteveel]

Is sending op_batch_rls necessary in the wire protocol, or is closing 
the statement itself sufficient?


Mark
--
Mark Rotteveel


Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel