Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
5.5.24, 5.3.7, 5.2.12, 5.1.62
-
None
-
None
Description
Test case
create table t1 (a bigint unsigned auto_increment primary key); |
insert into t1 values((1<<63)-2); |
insert into t1 values(NULL); select last_insert_id(); |
insert into t1 values(NULL); select last_insert_id(); |
select * from t1; |
Result
MariaDB [test]> insert into t1 values(NULL); select last_insert_id();
|
+---------------------+
|
| last_insert_id() |
|
+---------------------+
|
| 9223372036854775807 |
|
+---------------------+
|
MariaDB [test]> insert into t1 values(NULL); select last_insert_id();
|
+----------------------+
|
| last_insert_id() |
|
+----------------------+
|
| -9223372036854775808 |
|
+----------------------+
|
MariaDB [test]> select * from t1;
|
+---------------------+
|
| a |
|
+---------------------+
|
| 9223372036854775806 |
|
| 9223372036854775807 |
|
| 9223372036854775808 |
|
+---------------------+
|