search

FirebirdSQL / firebird-documentation

Firebird documentation
https://www.firebirdsql.org/en/firebird-rdbms/
34 stars 14 forks source link

Wrong documentation of RDB$INDICES.RDB$INDEX_TYPE #174

Closed mrotteveel closed 2 years ago

mrotteveel commented 2 years ago

The fblangref25, fblangref30 and fblangref40 say that RDB$INDICES.RDB$INDEXTYPE "Distinguishes between an expression index (1) and a regular index (0 or null)."_, this seems to be not correct. Instead, the value is (0 or null): Ascending, 1: Descending.

Verify to see if maybe expression indexes toggle another bit, and fix this.

mrotteveel commented 2 years ago

There are no additional bits or different values for expression indexes. So, it's 0 (or sometimes NULL) for ascending, and 1 for descending.

mrotteveel commented 2 years ago

Updated fblangref25, fblangref30 and fblangref40. Keeping ticket open to update German version as well (but needs a little more work to catch up with changes of fblangref25).

mrotteveel commented 2 years ago

Also updated German version (with help from Google Translate).

@MartinKoeditz Could you review my recent changes to fblangref25-de, fblangref30-de and fblangref40-de?

mrotteveel commented 2 years ago

Published updated docs