[OSM-dev] Slow Osmosis

Joachim Zobel jz-2008 at heute-morgen.de
Mon Dec 1 22:29:22 GMT 2008


Am Montag, den 01.12.2008, 19:15 +0100 schrieb Joachim Zobel:
> Is there any chance there is a 0 PK? This may trigger an auto
> increment.

To bee more specific:

mysql> CREATE TABLE test (t INTEGER PRIMARY KEY AUTO_INCREMENT);
Query OK, 0 rows affected (0.11 sec)

mysql> INSERT INTO test(t) VALUES(0);
Query OK, 1 row affected (0.06 sec)

mysql> INSERT INTO test(t) VALUES(1);
ERROR 1062 (23000): Duplicate entry '1' for key 1

See
http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html#sqlmode_no_auto_value_on_zero
for an explanation.

Sincerely,
Joachim






More information about the dev mailing list