Hi, I guess since it is documented, it is a new feature - I agree with the principal of not backporting it.
Many thanks for the reply - can't wait for 4.1 to mature :-) Thanks, Mike > -----Original Message----- > From: Heikki Tuuri [mailto:[EMAIL PROTECTED] > Sent: 15 June 2004 13:00 > To: Mysql > Subject: Re: DROP TEMPORARY TABLE and implicit commits > > > 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] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
