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 changedWould 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
