Skip to content

Historical misconfiguration ? #516

@Nolwennig-Jeulin

Description

@Nolwennig-Jeulin

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"/>

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions