On Thu, Mar 29, 2001 at 07:57:41PM +0300, Michael Widenius wrote:
>
> mysql> rename tables test1 to test3, test2 to test1, test3 to test2;
> Peter> ERROR 1192: Can't execute the given command because you have active locked
> Peter> tables or an active transaction
>
> I bet this happens when you have a server that is compiled w
> transaction support but you are using --skip-bdb and --skip-innobase ?
>
> Here is a fix for this:
What's the scope of this bug? Does it only affect the use of 'circular'
rename, or all renames, or table locking in general, or tables in general?
Tim.
---------------------------------------------------------------------
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