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. <cut> >> 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 the given command because you have active >> locked >> tables or a active transaction" >> note that I have already send a command "set autocommit=1" to mysql server, > I don't >> know whether I am wrong, but it seems an Innodb bug. Just a quick update: This is now fixed in the 4.0.2 tree. Regards, Monty --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
