#93643Database Analyzer Length of Double not synchronized
Description
Hello,
when i have Number definitions in ext_tables.sql like that:
weight_self double(11,4) NOT NULL DEFAULT '0.0000',
After synchronizing with the “Analyze Database Structure” the field is created, but without the correct length is ignored (see attached screenshot). When changing the field to
weight_self double(9,2) NOT NULL DEFAULT '0.00',
the Analyse Database Structure tools does not detect any changes.
Problem is, if we set the weight of the object to 4.246 and trying to save ($repository->update()) a error message is thrown:
{exception“Doctrine\\DBAL\\Driver\\Mysqli\\Exception\\StatementError: Data truncated for column ‘weight’ at row 1 in
……..
{closure}()\n#23 {main}\n\nNext Doctrine\\DBAL\\Exception\\DriverException: An exception occurred while executing ‘UPDATE `tx_xxxxxxx` SET `weight` = ? WHERE `uid` = ?’ with params [\“0,878\”, 1629]:\n\nData truncated for column ‘weight’ at row 1 in
Reviews 1
Fix this issue
Start the commit message of your patch with this. Add what the patch does, and the versions it goes to in "Releases:". The changes above were merged or abandoned: read them before you start. How to create a patch
- Commit message
-
[BUGFIX] Database Analyzer Length of Double not synchronized Resolves: #93643 Releases: main
Related issues 1
Files 1
History 46
-
varioous OG changed description <span data-processor="relativetime" data-value="2021-03-04T08:41:10+00:00" > 03/04/21, 08:41 </span>
-
Gerrit Code Review pushed patch set 1 for main to change 92540 status
NewUnder Review <span data-processor="relativetime" data-value="2026-01-27T20:11:18+00:00" > 01/27/26, 20:11 </span> -
Gerrit Code Review pushed patch set 2 for main to change 92540 <span data-processor="relativetime" data-value="2026-04-21T08:03:18+00:00" > 04/21/26, 08:03 </span>
-
Stefan Bürk changed Related to #110420 <span data-processor="relativetime" data-value="2026-08-11T01:25:45+00:00" > 08/11/26, 01:25 </span>
-
Benni Mack changed status
Under ReviewNew <span data-processor="relativetime" data-value="2026-10-02T15:40:56+00:00" > 10/02/26, 15:40 </span> -
Alexander Schnitzler changed category <span data-processor="relativetime" data-value="2026-10-17T09:40:06+00:00" > 10/17/26, 09:40 </span>