Re: Engine assertion failure for create Index
what where clause?? As Art says do a dummy update of a column to get
rid of the in place alter table.
you could do this in spl:
WARNING UNTESTED CODE ahead....
ex:
create procedure dodummy()
define commit_cnt int;
set isolation to dirty read;
set lock mode to wait 10;let commit_cnt = 0;
-- no exception handling yet, simply wait for a lock if fails
-- rerun the spl.
begin work;
foreach mycur with hold
for
select somecol from sometable
let commit_cnt = commit_cnt + 1;
update yourtable set somecol = somecol where current of mycur;
if mod(commit_cnt,1000) = 999 then
commit work;
begin work;
end if;
end foreach;
commit work;
end procedure;
which i guess is as fast as it is going to get/be in a logged db.
or make the table raw??? so stuff does not get logged.....
Superboer.