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.
---------------------------------------------- 国内收费邮箱谁最强，首次权威评测见分晓 http://news.21cn.com/domestic/21CN/2001-11-19/550568.html 买企业邮箱，获赠域名 http://mail.21cn.com/corporation/010.html 21cn带您走进目标之旅，享受商旅乐趣 http://travel.21cn.com/agency/aimtrip/aimtrip.html 收费邮箱真能大行其道，给我一个理由 http://mail.21cn.com/bijiao/index2-7.html --------------------------------------------------------------------- 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
