[EMAIL PROTECTED] wrote:
>Your message cannot be posted because it appears to be either spam or
>simply off topic to our filter. To bypass the filter you must include
>one of the following words in your message:
>
>sql,query
>
>If you just reply to this message, and include the entire text of it in the
>reply, your reply will go through. However, you should
>first review the text of the message to make sure it has something to do
>with MySQL. Just typing the word MySQL once will be sufficient, for example.
>
>You have written the following:
>
>Mike Hall wrote:
>
>>Well if you try and INSERT '1' into a unique field several times, of course
>>it is going to fail. That is expected behaviour, not a bug.
>>
>Yes, I realise that, but I'm not INSERTing '1' into a UNIQUE field.
>
>The '1' in the code below is INSERTed into the 'num' column, which, if
>you look at the database definition, is not specified as UNIQUE.
>
>The error that I'm getting refers to "key 1", which is the 'id' column.
> You'll note that I'm not specifying a value for the 'id' column - I
>leave it up to the database to choose a value itself (it is an
>AUTO_INCREMENT column) and it keeps wrongly choosing a value that is
>already used.
>
>I'd say that IS a bug.
>
>- Steve
>
>>>for (my $deadlocks = 0, my $total = 0, my $i = 1; $i <= 50000; $i++) {
>>> $total++;
>>>
>>> eval {
>>> $dbh->do("INSERT INTO foo (num, str) VALUES (1, 'a')");
>>> $dbh->commit();
>>> };
>>>
>
>
>
>
>
--
Klein bottle for rent - enquire within.
---------------------------------------------------------------------
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
