Bug #93643
openDatabase Analyzer Length of Double not synchronized
0%
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
Files