SPL caching on secondary - BUG
Hi, everybody,
I've just run into a very unpleasant problem obviously related to
SPL caching on HDR secondary.
Steps to reproduce: (ANSI database, IDS 9.40uc5, also reproduces 9.21):
1. Primary:
create function spl_test() returning INT;return 1;
end function;
commit;
execute function spl_test();commit;
-- returns 1
2. Secondary:
execute function spl_test();commit;
-- returns 1
3. primary:
drop function spl_test;commit;
create function spl_test() returning INT;return 0;
end function;
commit;
execute function spl_test();commit;
-- returns 0
-- CHECKPOINT ON PRIMARY:
onmode -c=20
4. secondary:
execute function spl_test();commit;
-- returns 1
The only way to get expected "0" on Secondary -
restart the Secondary
---------------
I've filed a level-2 bug about it
=A0
---------------------------------------
Alexey