meta data for this page
  •  

Indexing and optimization

Firebird 2.0: Indexing and optimization

SF #459059D Index breaks = ANY result. MORE INFO REQUIRED.

fixed by N. Samofatov

~ ~ ~

Not registered Ambiguous queries were still possible under some conditions.

fixed by A. Brinkman

~ ~ ~

SF #735720 SELECT … STARTING WITH :v was wrong when :v = ''.

fixed by A. Brinkman

~ ~ ~

Not registered There were issues with negative dates, i.e. those below Julian date [zero], when stored in indices.

fixed by A. Brinkman

~ ~ ~

SF #1211354 Redundant evaluations were occurring in COALESCE.

fixed by A. Brinkman

~ ~ ~

Not registered Error index key too big would occur when creating a descending index.

fixed by V. Horsun

~ ~ ~

SF #1242982 Bug in compound index key mangling.

fixed by A. Brinkman

~ ~ ~