Project

General

Profile

Actions

Bug #93643

open

Database Analyzer Length of Double not synchronized

Added by varioous OG over 3 years ago. Updated over 3 years ago.

Status:
New
Priority:
Should have
Assignee:
-
Category:
Extbase
Target version:
-
Start date:
2021-03-04
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
10
PHP Version:
7.4
Tags:
Complexity:
Is Regression:
Sprint Focus:

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

weight_self_phpmyadmin.jpg (7.19 KB) weight_self_phpmyadmin.jpg varioous OG, 2021-03-04 08:33
Actions #1

Updated by varioous OG over 3 years ago

  • Description updated (diff)
Actions

Also available in: Atom PDF