magento / magento/architecture
Historical misconfiguration ?
Nobody has claimed this yet.
- Dominant language
- No language data
- Stars
- 278
- Forks
- 146
- PR merge metrics
- No merged PRs in 30d
Description
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.
<table name="catalog_product_entity_datetime" resource="default">
<column xsi:type="int" name="value_id" padding="11" unsigned="false" nullable="false" identity="true"/>
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start with app/code/Magento/Catalog/etc/db_schema.xml, especially the catalog_product_entity_datetime value_id definition and its signedness. Trace the catalog product mass importation path that produces the reported SQLSTATE[22003] error, then determine the intended schema behavior and verify it with a focused reproduction or relevant database tests.
Written by the indexing model from the issue text.
Assessment
- Domain
- database
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100