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? Sean ------------------------------------------------------------------------------ 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
