| Subject | Re: [firebird-support] Re: 2.5.1 upgrade dilemma |
|---|---|
| Author | |
| Post date | 2015-08-22T23:34Z |
Alright, so the remaining questions to someone with that knowledge are:
- Does the problem going from 2.5.1 to 2.5.4 still only concern compound indices containing at least one NULLable (VAR)CHAR and no other indices than that?
If not, what else?
- Is the following code enough to rebuild a superset of those, i.e. at least all indices that would give trouble?
If not, then what should it be?
Thanks a lot.
- Does the problem going from 2.5.1 to 2.5.4 still only concern compound indices containing at least one NULLable (VAR)CHAR and no other indices than that?
If not, what else?
- Is the following code enough to rebuild a superset of those, i.e. at least all indices that would give trouble?
SET TERM !! ;
EXECUTE BLOCK AS
DECLARE VARIABLE stmt VARCHAR(1000);
BEGIN
for select 'ALTER INDEX '||rdb$index_name ||' ACTIVE;'
from rdb$indices
where (rdb$system_flag is null or rdb$system_flag = 0)
order by rdb$foreign_key nulls first
into :stmt
do EXECUTE STATEMENT :stmt;
END!!
SET TERM ; !!
EXECUTE BLOCK AS
DECLARE VARIABLE stmt VARCHAR(1000);
BEGIN
for select 'ALTER INDEX '||rdb$index_name ||' ACTIVE;'
from rdb$indices
where (rdb$system_flag is null or rdb$system_flag = 0)
order by rdb$foreign_key nulls first
into :stmt
do EXECUTE STATEMENT :stmt;
END!!
SET TERM ; !!
If not, then what should it be?
Thanks a lot.