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

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

 
------------------------------------------
Alexey Sonkin