[BUGFIX] Fix sqlite bigint from ext_tables.sql issue

Table sys_messenger_messages introduced with #97700
declares a bigint(20) as primary key in ext_tables.sql.

ext_tables.sql is essentially mysql syntax, the core
SchemaMigrator creates a doctrine object structure
from it, and struggles with bigint on sqlite, found
by a nightly test.

A simple fix is to declare a "casual" int(11), which
should be more than big enough for this table and
is in line with our other "uid" column primary keys
of other tables.

Resolves: #99689
Related: #97700
Releases: main
Change-Id: I5322aefe0f8e9b93015eaf2fb7af1ae8536b94ae
Reviewed-on: https://review.typo3.org/c/Packages/TYPO3.CMS/+/77555
Reviewed-by: Anja Leichsenring <aleichsenring@ab-softlab.de>
Tested-by: core-ci <typo3@b13.com>
Reviewed-by: Susanne Moog <look@susi.dev>
Tested-by: Christian Kuhn <lolli@schwarzbu.ch>
Tested-by: Anja Leichsenring <aleichsenring@ab-softlab.de>
Reviewed-by: Christian Kuhn <lolli@schwarzbu.ch>
Tested-by: Stefan Bürk <stefan@buerk.tech>
Reviewed-by: Stefan Bürk <stefan@buerk.tech>
Reviewed-by: Georg Ringer <georg.ringer@gmail.com>

[BUGFIX] Fix sqlite bigint from ext_tables.sql issue · TYPO3/typo3@10a4e28

Table sys_messenger_messages introduced with #97700 declares a bigint(20) as primary key in ext_tables.sql. ext_tables.sql is essentially mysql syntax, the core SchemaMigrator creates a doctrine o...

^GitHub

[FEATURE] Adopt symfony messenger as message bus and queue

See the Feature.rst file for details.

The changes in workspaces are meant as a usage example.

The goal is to provide a basic implementation as a first step.
Further features (for example extending the capabilities of the
consume command or providing additional transportFactories or
multi-bus support) can be done in additional patches
(or even – in case of transports – in additional packages).

The default transport is synchronous to avoid forcing users to
configure the long running message consumer worker.

Command executed:
composer req symfony/doctrine-messenger:^6.2 symfony/messenger:^6.2
composer req symfony/doctrine-messenger:^6.2 symfony/messenger:^6.2 \
-d typo3/sysext/core --no-update

Releases: main
Resolves: #97700
Change-Id: Ib034f70b8d6c0be974f807341df257c17dff42a1
Reviewed-on: https://review.typo3.org/c/Packages/TYPO3.CMS/+/77232
Tested-by: Benni Mack <benni@typo3.org>
Tested-by: Benjamin Franzke <bfr@qbus.de>
Reviewed-by: Benni Mack <benni@typo3.org>
Reviewed-by: Benjamin Franzke <bfr@qbus.de>
Reviewed-by: Frank Nägler <frank.naegler@typo3.com>
Reviewed-by: Susanne Moog <look@susi.dev>
Tested-by: core-ci <typo3@b13.com>
Reviewed-by: Daniel Goerz <daniel.goerz@b13.com>

[FEATURE] Adopt symfony messenger as message bus and queue · TYPO3/typo3@c17e30a

See the Feature.rst file for details. The changes in workspaces are meant as a usage example. The goal is to provide a basic implementation as a first step. Further features (for example extendin...

^GitHub