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 http://www.innodb.com for the online manual and latest news on InnoDB >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. --------------------------------------------------------------------- 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
