Can we really OPTIMIZE FOR LAST ROWS in SELECT statements?

[mrotteveel]

Discussed in FirebirdSQL/firebird#8419

^{Originally posted by Wolf-SO January 31, 2025}
I'm quite familiar with FB 1.0.3 but somehow wish to get up-to-date with the current developments, so I'm currently reading docs.

In the 5.0 documentation, I read about the setting OptimizeForFirstRows that we can opt for optimizing for first rows instead of all rows (which is the default). We also find the documentation of SET OPTIMIZE and OPTIMIZE FOR Clause linked here. Both contain the option FIRST but then diverge on the option ALL and LAST while they link to each other if they would be alternative ways to reach the same goals (on different levels). Could it be that LAST is just a typo in the OPTIMIZE FOR clause?

[mrotteveel]

Fixed in 04c3628