Bug #93643
Updated by varioous OG over 3 years ago
Hello,
when i have Number definitions in ext_tables.sql like that:
<pre><code class="php">
weight_self double(11,4) NOT NULL DEFAULT '0.0000',
</code></pre>
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
<pre><code class="php">
weight_self double(9,2) NOT NULL DEFAULT '0.00',
</code></pre>
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