Michael, ----- Alkuperäinen viesti ----- Lähettäjä: "Michael McTernan" <[EMAIL PROTECTED]> Vastaanottaja: "Mysql" <[EMAIL PROTECTED]> Kopio: <[EMAIL PROTECTED]> Lähetetty: Monday, June 14, 2004 9:40 PM Aihe: DROP TEMPORARY TABLE and implicit commits
> Hi there, > > I'm using MySQL 4.0.18 and finding that DROP TEMPORARY TABLE is performing > an implicit commit, as is documented. > > The problem is that I have a complex query in a Java function, and I need to > call it a number of times to get the overall, which I also want to do as a > single transaction so as not to leave data inconsistent at any point. > > The implicit commit is causing me a problem here, the only solution to which > I can think is to use 4.1.0 (which is alpha) or to do some horrible table > name mangling for the temp table and just accumulate a lot of data for the > duration of the transaction. > > Does anyone know if it is planned to back port the fix in 4.1.0 onto 4.0.21 > or later? I am sorry, 4.0 is frozen from new features. The backport will probably not happen. > From 4.1.0 changelog: > > - DROP TEMPORARY TABLE now drops only temporary tables and doesn't end > transactions. > > Thanks, > > Mike Best regards, Heikki Innobase Oy InnoDB - transactions, row level locking, and foreign keys for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables http://www.innodb.com/order.php Order MySQL support from http://www.mysql.com/support/index.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
