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

[Mark Rotteveel]

On 18-07-2022 17:35, Ariel Álvarez wrote:

Great! But I see the table format broken in langref 3.0. Check again.


Aargh, thanks, and fixed :)

Mark
--
Mark Rotteveel


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

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

[Ariel Álvarez]

Great! But I see the table format broken in langref 3.0. Check again.

In 4.0 it's ok

Thank you,

Ariel


El lun., 18 jul. 2022 10:27, Mark Rotteveel  escribió:

> 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
> >> 
> >>
> >> 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
>
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

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

[Mark Rotteveel]

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 



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

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] Wrong doc RDB$INDICES.RDB$INDEX_TYPE ?

[Ariel Álvarez]

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

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