Actions
Task #104259
closed
Ensure `BIGINT AUTO_INCREMENT PRIMARY KEY` works
Status:
Closed
Priority:
Should have
Assignee:
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2024-06-29
Due date:
% Done:
100%
Estimated time:
TYPO3 Version:
13
PHP Version:
Tags:
Complexity:
Sprint Focus:
Description
SQLITE INTEGER SIGNED -9223372036854775808 <=> +9223372036854775807 (INTEGER SCALES SINCE v3, AUTOINCREMENT PK ONLY WIHT INTEGER TYPE) PK/AUTOINCREMENT POSSIBLE SQLITE INTEGER SIGNED 0 <=> 18446744073709551615 (INTEGER SCALES SINCE v3, AUTOINCREMENT PK ONLY WIHT INTEGER TYPE) PK/AUTOINCREMENT POSSIBLE SQLITE BIGINT UNSIGNED -9223372036854775808 <=> +9223372036854775807 (INTEGER SCALES SINCE v3, AUTOINCREMENT PK ONLY WIHT INTEGER TYPE) PK/AUTOINCREMENT POSSIBLE SQLITE BIGINT UNSIGNED 0 <=> 18446744073709551615 (INTEGER SCALES SINCE v3, AUTOINCREMENT PK ONLY WIHT INTEGER TYPE) PK/AUTOINCREMENT POSSIBLE POSTGRESQL INTEGER -2147483648 <=> +2147483647 (no unsigned integer, only signed) PK/AUTOINCREMENT POSSIBLE POSTGRESQL BIGINT -9223372036854775808 <=> +9223372036854775807 (no unsigned integer, only signed) PK/AUTOINCREMENT POSSIBLE MARIADB INTEGER SIGNED -2147483648 <=> 2147483647 MARIADB INTEGER UNSIGNED 0 <=> 4294967295 MARIADB BIGINT SIGNED -9223372036854775808 <=> 9223372036854775807 PK/AUTOINCREMENT POSSIBLE ? MARIADB BIGINT UNSIGNED 0 <=> 18446744073709551615 PK/AUTOINCREMENT POSSIBLE ? MYSQL INTEGER SIGNED -2147483648 <=> 2147483647 MYSQL INTEGER UNSIGNED 0 <=> 4294967295 MYSQL BIGINT SIGNED -2^63 <=> 2^63 - 1 PK/AUTOINCREMENT POSSIBLE ? MYSQL BIGINT UNSIGNED 0 <=> 2^64 - 1 PK/AUTOINCREMENT POSSIBLE ?
Updated by 
Updated by 
Updated by
Actions