Justin,
- Alkuperäinen viesti -
Lähettäjä: "Justin Swanhart" <[EMAIL PROTECTED]>
Vastaanottaja: "Sasha Pachev" <[EMAIL PROTECTED]>
Kopio: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Lähetetty: Friday, May 14, 2004 9:22 PM
Aihe: Re: unexpecte
--- Sasha Pachev <[EMAIL PROTECTED]> wrote:
> Very possibly a bug. INNODB deadlocks itself during
> the operation, then detects
> the deadlock and aborts the transaction. If this is
> indeed a bug, I am sure
> Heikki would like to fix it ASAP.
There actually was a "create index" that was being
Hi!
- Original Message -
From: "Sasha Pachev" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, May 13, 2004 3:01 AM
Subject: Re: unexpected create table as lock issue
> [EMAIL PROTECTED] wrote:
[EMAIL PROTECTED] wrote:
I have a table called web_master which has as a
primary key column called web_id.
When I try to create another table as a select, I get
the following error message [note, that group_id is
indexed]:
mysql> create table sort_test as select * from
web_master where group_id = 6