19.03.2018 11:55, Leyne, Sean wrote:
Vlad,
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:
(1) - field data type is changed *and* its "index" type changed too
(2) - default value is set at nullable field *and* there was no default value
before
- "computed by" expression is changed
Would criteria (1) and (2) not also need apply to any field which is referenced by a
"computed by" index, and cause that index to need to be rebuilt?
Seems, yes. Also, i was a bit wrong at (2) - it should be read as
(2) - default value is set at *non-nullable* field *and* there was no default
value
And, probably, we should add:
(3) - NOT NULL is set and default value was set before
Regards,
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