Paul DuBois wrote:
manner. AUTO_INCREMENT columns are for use only with *positive*
integers,
and any attempt to use them otherwise will eventually cause you grief.
Just to point out, a lot of people get confused about the definition of
positive integers, especially in how it relates to
On Sun, 15 Dec 2002 17:38:49 -0600, Paul DuBois wrote:
INSERT INTO gebaeude_daten VALUES (0, 'Bank Stufe 1', 1000, 30, 900, 1);
What happens if you use a value of NULL instead of 0?
Inserting a field with 0 tells the table to generate a value on its
own, like it's supposed to.
I think you did not properly process this request.
Dennis Schwerdel
Date: Sun, 15 Dec 2002 20:51:14 +0100
From: [EMAIL PROTECTED]
To: Dennis Schwerdel [EMAIL PROTECTED]
Subject: Re: Bug in auto_increment
X-WEBDE-TAG: S
Sender: [EMAIL PROTECTED]
Your message cannot be posted to [EMAIL
[EMAIL PROTECTED]
Subject: Re: Bug in auto_increment
X-WEBDE-TAG: S
Sender: [EMAIL PROTECTED]
Your message cannot be posted to [EMAIL PROTECTED] because it did not
follow the format expected by our spam/off-topic filter. To this list we
accept only repeatable bugs reports, meaning that you can
Steve,
Wednesday, July 10, 2002, 11:12:48 AM, you wrote:
SH Continuing my troubles with AUTO_INCREMENT (which nobody has yet
SH responded to), I've now ruled the Perl DBI out of the equation and
SH reproduced the same problem using the mysql.exe command-line tool.
SH Hopefully somebody will
Victoria Reznichenko wrote:
Steve,
Wednesday, July 10, 2002, 11:12:48 AM, you wrote:
SH The bug can be reproduced as follows:
SH Create the following simple database containing just one BDB table:
SH CREATE DATABASE test;
SH CREATE TABLE foo (
SHid INT NOT NULL
Mark Matthews wrote:
Steve Hay wrote:
| I've tried the same myself on MyISAM tables as well now, and I also
| found that there is no problem - it only seems to happen using BDB
tables.
|
| However, I need to use BDB tables rather than MyISAM to get transaction
| support, which is
Hi,
Continuing my troubles with AUTO_INCREMENT (which nobody has yet
responded to), I've now ruled the Perl DBI out of the equation and
reproduced the same problem using the mysql.exe command-line tool.
Hopefully somebody will be tempted to help this time now that there is
no Perl involved
Can your INT id be overflowing, i.e. reaches the max value for int and
starting at 1 again?
Rich
- Original Message -
From: Steve Hay [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, July 10, 2002 4:12 AM
Subject: Bug with AUTO_INCREMENT
Hi,
Continuing my troubles
over after some particular number of
iterations - it falls over at different, apparently random, times each
time I try the test.
- Steve
- Original Message -
From: Steve Hay [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, July 10, 2002 4:12 AM
Subject: Bug with AUTO_INCREMENT
Hi
Thomas Spahni wrote:
Steve,
I tried your example on MyIsam tables; no problems with auto_increment at
all, except for a few
ERROR 1040: Too many connections
when 100 scripts are inserting concurrently at full speed.
Thomas
I've tried the same myself on MyISAM tables as well now, and I also
1040: Too many connections
when 100 scripts are inserting concurrently at full speed.
Thomas
- Original Message -
From: Steve Hay [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, July 10, 2002 4:12 AM
Subject: Bug with AUTO_INCREMENT
Hi,
Continuing my troubles
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Steve Hay wrote:
| Thomas Spahni wrote:
|
| Steve,
|
| I tried your example on MyIsam tables; no problems with auto_increment at
| all, except for a few
|
| ERROR 1040: Too many connections
|
| when 100 scripts are inserting concurrently at full
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Caching Bug with AUTO_INCREMENT columns
Description:
When i use a table with an AUTO_INCREMENT column and
insert Data in the Table with a NULL Value for the
AUTO_INCREMENT column, AUTO_INCREMENT sets an new value
parameter ?
*slightly blank look*
P
On Tue, 13 Feb 2001
[EMAIL PROTECTED] wrote:
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Caching Bug with AUTO_INCREMENT columns
Description:
When i use a table with an AUTO_INCREMENT column and
insert Data in the Table
15 matches
Mail list logo