Looking at bug CORE-5774 i found very odd behavior of engine: it seems it 
rebuilds
indices in many unneeded cases, when almost any property of the indexed field 
is changed.

  I understand that index should be rebuild in this cases only:
- field data type is changed *and* its "index" type changed too
- default value is set at nullable field *and* there was no default value before
- "computed by" expression is changed

and indices should not be rebuild when:
- field data type is changed but its "index" type is still the same
- default value is changed (not added)
- default value is added or changed at non-nullable field
- default value is dropped
- field's identity value is restarted
- field name is changed
- field position is changed

Am i missing something ? Am i wrong ?

Thanks,
Vlad

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to