Re: [Firebird-devel] Natural plan with rdb$procedures and 3.0, 4.0

2021-05-11 Thread Adriano dos Santos Fernandes
On 11/05/2021 10:25, Gabor Boros wrote: > 2021.05.11. 15:09 keltezéssel, Adriano dos Santos Fernandes írta: >> >> Because the index segment is now prefixed with RDB$PACKAGE_NAME. >> >> >> Adriano > Nice. And where is the backward compatibility? :-) > Why modified the old and not a new index for pac

Re: [Firebird-devel] Natural plan with rdb$procedures and 3.0, 4.0

2021-05-11 Thread Gabor Boros
2021.05.11. 15:09 keltezéssel, Adriano dos Santos Fernandes írta: Because the index segment is now prefixed with RDB$PACKAGE_NAME. Adriano Nice. And where is the backward compatibility? :-) Why modified the old and not a new index for package+proc names? Gabor Firebird-Devel mailing list,

Re: [Firebird-devel] Natural plan with rdb$procedures and 3.0, 4.0

2021-05-11 Thread Adriano dos Santos Fernandes
On 11/05/2021 10:05, Gabor Boros wrote: > Hi All, > > I tried with employee... > > SQL> select 1 from rdb$procedures where rdb$procedure_name='x'; > > 2.5.9.27139 > PLAN (RDB$PROCEDURES INDEX (RDB$INDEX_21)) > > 3.0.8.33468 > PLAN (RDB$PROCEDURES NATURAL) > > 4.0.0.2478 > PLAN (RDB$PROCEDURES

[Firebird-devel] Natural plan with rdb$procedures and 3.0, 4.0

2021-05-11 Thread Gabor Boros
Hi All, I tried with employee... SQL> select 1 from rdb$procedures where rdb$procedure_name='x'; 2.5.9.27139 PLAN (RDB$PROCEDURES INDEX (RDB$INDEX_21)) 3.0.8.33468 PLAN (RDB$PROCEDURES NATURAL) 4.0.0.2478 PLAN (RDB$PROCEDURES NATURAL) Why? :-) Gabor Firebird-Devel mailing list, web interf