Bug #28135 error while inserting to auto_increment
Submitted: 27 Apr 2007 12:40 Modified: 27 Apr 2007 13:35
Reporter: sandie bug Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version: 5.2.3-falcon-alpha OS:Windows (2000 server)
Assigned to: CPU Architecture:Any
Tags: 5.2.3, auto_increment, error 1366, insert

[27 Apr 2007 12:40] sandie bug
Description:
error while inserting values into auto_increment field in innodb table.
mysql version is  5.2.3-falcon-alpha
image attached with this bug.

How to repeat:
see image

Suggested fix:
nothing...
[27 Apr 2007 12:41] sandie bug
see this file

Attachment: mysql_error.doc (application/msword, text), 76.00 KiB.

[27 Apr 2007 13:35] MySQL Verification Team
Thank you for the bug report. Please read the Manual regarding sql_mode:

c:\Arquivos de programas\mysql\MySQL Server 5.2>bin\mysql -uroot -P3308 test
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.2.3-falcon-alpha-community-nt MySQL Community Server (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create table tb1 (id serial, col1 char(1));
Query OK, 0 rows affected (0.30 sec)

mysql> insert into tb1 values ('','a');
ERROR 1366 (HY000): Incorrect integer value: '' for column 'id' at row 1

mysql> select @@sql_mode;
+----------------------------------------------------------------+
| @@sql_mode                                                     |
+----------------------------------------------------------------+
| STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
+----------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> set @@sql_mode='';
Query OK, 0 rows affected (0.00 sec)

mysql> insert into tb1 values ('','a');
Query OK, 1 row affected, 1 warning (0.07 sec)

mysql> select * from tb1;
+----+------+
| id | col1 |
+----+------+
|  1 | a    |
+----+------+
1 row in set (0.03 sec)

mysql>