search

Tokutek / mysql-5.5

TokuDB for MySQL 5.5
http://www.tokutek.com/products/tokudb-for-mysql/
GNU General Public License v2.0
110 stars 38 forks source link

investigate temporary table transactions #30

Closed prohaska closed 10 years ago

prohaska commented 10 years ago

create table t1; begin; select * from t1; create temporary table t2; select * from t2 FAILS with table definition has changed.

prohaska commented 10 years ago

mysql 5.5 creates the temporary table with a new transaction rather than the enclosing transaction. since this transaction is newer than the enclosing transaction, we dont make t2 visible to the enclosing transaction.

mysql 5.5 terminates the enclosing transaction for 'create table t2' instead.

tmcallaghan commented 10 years ago

Moved to Jira as https://tokutek.atlassian.net/browse/DB-624