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
