Re: stupid bug in HDR

rkusenet said: > IDS921UC4 > > this statement fails on secondary server > > create temp table t > ( fld1 char(10) not null unique > ) with no log ;> > 626: Cannot obtain or set serial value.> > 140: ISAM error: operation illegal on a DR Secondary> > > however this statement succeeds on secondary server} > > create temp table t > ( fld1 char(10) not null > ) with no log ; > create unique index t_u on t(fld1);> > Isn't it a bug. Both statements are effectively the same:- one maintains > uniqueness thru constraint > and the other thru unique index. > > Is this bug reproducible in later version(s). I *think* the issue is setting the unique constraint number/name. However, I'm personally hugely reluctant to do any kind of diddling with tables (temporary or not) on a secondary. I've run into "interesting and challenging" situations as to what is allowed and yet should not be done on a secondary. -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" - Coluche "I'm trying to see things your way, but I can't get my head up my ass" - JCH "Ogni uomo mi guarda come se fossi una testa di cazzo" - Marco I went to the airport to check in and they asked what I did because I looked like a terrorist. I said I was a comedian. They said, "Say something funny then." I told them I had just graduated from flying school. -- Ahmed Ahmed sending to informix-list