Re: Mysql 4.0.1 autocommit bug with Innodb table

Hi! > "Heikki" == Heikki Tuuri <[EMAIL PROTECTED]> writes: Heikki> Hi! Heikki> This is a bug in the MySQL layer of code. I am sending a carbon copy of this Heikki> email to Monty. >> I am using Mysql 4.0.1 alpha for Windows, my table are all on InnoDB, when >> I connect >> to >> mysql se

Re: Mysql 4.0.1 autocommit bug with Innodb table

Hi! > "Heikki" == Heikki Tuuri <[EMAIL PROTECTED]> writes: Heikki> Hi! Heikki> This is a bug in the MySQL layer of code. I am sending a carbon copy of this Heikki> email to Monty. Heikki> I assume calling COMMIT explicitly after the SELECT allows you to do the Heikki> TRUNCATE? If you are

Re: Mysql 4.0.1 autocommit bug with Innodb table

Hi! This is a bug in the MySQL layer of code. I am sending a carbon copy of this email to Monty. I assume calling COMMIT explicitly after the SELECT allows you to do the TRUNCATE? Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See ht

Mysql 4.0.1 autocommit bug with Innodb table

I am using Mysql 4.0.1 alpha for Windows, my table are all on InnoDB, when I connect to mysql server using C API mysql_real_connect() and execute a sql command "select * from sampletable" and fetched the result set, then execute a "truncate table anothertable", it reports "1192 Can't execute th