.. interesting...
I'd be willing to bet a donut that Oracle isn't using copy semnatics
when passing the transition variable.
so :new.id is pointing straight to the buffer holding the nextval.
The dummy variable assignment forces the copy.
Fix will likely be to force copies when cosuming any of those special
guys since detecting the conflict is hard.
Just my 2 (reverse engineered) cents
Cheers
Serge
--
Serge Rielau
DB2 UDB SQL Compiler Development
IBM Software Lab, Canada
Received on Tue May 28 2002 - 22:24:41 CDT
