Wrong documentation of RDB$INDICES.RDB$INDEX_TYPE

Question

Wrong documentation of RDB$INDICES.RDB$INDEX_TYPE

mrotteveel opened this issue 3 years ago · 4 comments

The fblangref25, fblangref30 and fblangref40 say that RDB$INDICES.RDB$INDEX_TYPE "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.

Answer 1 · 2022-07-18T12:16:03.000Z

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

Answer 2 · 2022-07-18T12:45:41.000Z

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).

Answer 3 · 2022-07-18T13:19:24.000Z

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

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

Answer 4 · 2022-07-18T13:24:05.000Z

Published updated docs