Re: Unexpected temporary table behavior

[Thomas CORBIERE]

Hello,

I think you have misinterpreted the documentation.
You test case is showing exactly what the doc says.
Since the CREATE TABLE doesn't automaticaly commit the transaction,
when you are doing your insertion you are still in your explicit transaction.
That's why you are allowed to rollback your INSERT.

The documentation doesn't imply however that the table will be removed for you.
At least, this is how I understand it.

Regards,

Thomas CORBIERE