Historical misconfiguration ?

Open Nolwennig-Jeulin opened this issue 2 months ago • 0 comments

Hi,

I wonder why in magento/module-catalog/etc/db_schema.xml the type for column value_id primary key is :

INT(11)

instead of INT(11) UNSIGNED ?

I found that because we occur SQLSTATE[22003]: Numeric value out of range: 167 Out of range value for column 'value_id' at row 1 at catalog product mass importation.

https://github.com/magento/magento2/blob/08f6eee62b475d44663e20c1de6419702e41eb98/app/code/Magento/Catalog/etc/db_schema.xml#L37

 <table name="catalog_product_entity_datetime" resource="default">
        <column xsi:type="int" name="value_id" padding="11" unsigned="false" nullable="false" identity="true"/>

Nov 04 '25 11:11 Nolwennig-Jeulin