Project

General

Profile

Actions

Task #104259

closed

Ensure `BIGINT AUTO_INCREMENT PRIMARY KEY` works

Added by Stefan Bürk 1 day ago. Updated 1 day ago.

Status:
Resolved
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 ?
Actions #1

Updated by Gerrit Code Review 1 day ago

  • Status changed from New to Under Review

Patch set 2 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/85007

Actions #2

Updated by Stefan Bürk 1 day ago

  • Description updated (diff)
Actions #3

Updated by Stefan Bürk 1 day ago

  • Status changed from Under Review to Resolved
  • % Done changed from 0 to 100
Actions

Also available in: Atom PDF