Re: Strange error related to temporary tables

Csaba Nagy wrote:
> The code is possible to be executed in parallel by multiple threads, on
> different connections, or in sequence on the same connection. I would
> expect it in both cases to work correctly... in manual tests I was able
> to create in parallel temporary tables named identically in different
> connections, and on the same connection after rolling back the
> transaction which created the first table... so I don't know what to try
> to trigger this.
>
> Any ideas what's the problem ?

Are you sure that you're not re-using an existing connection from a pool?

--
Alban Hertroys
alban@magproductions.nl

magproductions b.v.

T: ++31(0)534346874
F: ++31(0)534346876
M:
I: www.magproductions.nl
A: Postbus 416
    7500 AK Enschede

// Integrate Your World //