mirror of
https://github.com/MariaDB/server.git
synced 2025-10-30 02:16:32 +01:00
24 lines
741 B
Text
24 lines
741 B
Text
CREATE TABLE t (c BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY) ENGINE=MEMORY PARTITION BY KEY();
|
|
INSERT INTO t VALUES (18446744073709551615);
|
|
select * from t;
|
|
c
|
|
18446744073709551615
|
|
drop table t;
|
|
CREATE TABLE t (c BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY) ENGINE=MEMORY;
|
|
INSERT INTO t VALUES (18446744073709551615);
|
|
ALTER TABLE t PARTITION BY KEY();
|
|
INSERT INTO t VALUES (1);
|
|
select * from t;
|
|
c
|
|
18446744073709551615
|
|
1
|
|
drop table t;
|
|
CREATE TABLE t (c BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY) ENGINE=MEMORY;
|
|
INSERT INTO t VALUES (18446744073709551615);
|
|
ALTER TABLE t PARTITION BY KEY();
|
|
INSERT INTO t VALUES (NULL);
|
|
ERROR HY000: Failed to read auto-increment value from storage engine
|
|
select * from t;
|
|
c
|
|
18446744073709551615
|
|
drop table t;
|