Re: Bug: Different data for different connections

[Yves Goergen]

On 20.12.2007 20:34 CE(S)T, Martijn Tonies wrote:
> Are your tables InnoDB? If so, the snapshot transaction is giving you
> a static view on the data and your own changes, while your PHPMyAdmin
> commits the NULL write. Your application keeps on seeing your own
> changes, cause it did not end the snapshot transaction.

Yes, all tables are InnoDB.

So MySQL does support nested transaction and both "SET AUTOCOMMIT = 0"
and "START TRANSACTION" start a new transaction level, is that true?

-- 
Yves Goergen "LonelyPixel" <nospam.list@stripped>
Visit my web laboratory at http://beta.unclassified.de