{"data":{"id":"magento2-28796","source":"github-pr","sourceRef":"magento/magento2#28796","title":"Missing unique key on eav_attribute_option_value table","pr":{"number":28796,"url":"https://github.com/magento/magento2/pull/28796","author":"ihor-sviziev","mergedAt":"2024-07-04T16:37:36Z","mergeCommit":"db49817132754cb61d597afed341ec44521d51d4","headCommit":"14ee777aed23b5b3305a2dd82b337a396cf05fc6","baseRef":"2.4-develop","diffSha256":"3e5832f58084e1076f6cc7fc42b1668ce4962848172b78299251eddaf308bf6f"},"issues":[{"number":24718,"url":"https://github.com/magento/magento2/issues/24718","title":"Missing unique key on eav_attribute_option_value table","labels":["Area: Catalog","Component: DB","Issue: Clear Description","Issue: Confirmed","Issue: Format is valid","Priority: P2","Progress: done","Reported on 2.3.x","Reproduced on 2.4.x","Severity: S3"],"kind":"human"}],"fixedIn":"2.4.8","containingTags":["2.4.8","2.4.8-p1","2.4.8-p2","2.4.8-p3","2.4.8-p4","2.4.8-p5","2.4.9"],"reportedOn":null,"codeMatch":{"2.4.6":"clean","2.4.6-p1":"clean","2.4.6-p2":"clean","2.4.6-p3":"clean","2.4.6-p4":"clean","2.4.6-p5":"clean","2.4.6-p6":"clean","2.4.6-p7":"clean","2.4.6-p8":"clean","2.4.6-p9":"clean","2.4.6-p10":"clean","2.4.6-p11":"clean","2.4.6-p12":"clean","2.4.6-p13":"clean","2.4.6-p14":"clean","2.4.6-p15":"clean","2.4.7":"clean","2.4.7-p1":"clean","2.4.7-p2":"clean","2.4.7-p3":"clean","2.4.7-p4":"clean","2.4.7-p5":"clean","2.4.7-p6":"clean","2.4.7-p7":"clean","2.4.7-p8":"clean","2.4.7-p9":"clean","2.4.7-p10":"clean","2.4.8":"conflict","2.4.8-p1":"conflict","2.4.8-p2":"conflict","2.4.8-p3":"conflict","2.4.8-p4":"conflict","2.4.8-p5":"conflict","2.4.9":"conflict"},"affectedVersions":["2.4.6","2.4.6-p1","2.4.6-p2","2.4.6-p3","2.4.6-p4","2.4.6-p5","2.4.6-p6","2.4.6-p7","2.4.6-p8","2.4.6-p9","2.4.6-p10","2.4.6-p11","2.4.6-p12","2.4.6-p13","2.4.6-p14","2.4.6-p15","2.4.7","2.4.7-p1","2.4.7-p2","2.4.7-p3","2.4.7-p4","2.4.7-p5","2.4.7-p6","2.4.7-p7","2.4.7-p8","2.4.7-p9","2.4.7-p10"],"components":["magento/module-eav"],"files":[{"path":"app/code/Magento/Eav/etc/db_schema.xml","change":"modified","package":"magento/module-eav"},{"path":"app/code/Magento/Eav/etc/db_schema_whitelist.json","change":"modified","package":"magento/module-eav"}],"stripped":{"tests":[],"docs":[],"outsideCode":[]},"linesChanged":7,"mergeBatched":false,"excluded":null,"sections":{"description":null,"stepsToReproduce":null,"expectedResult":null,"actualResult":null,"source":null},"signatures":[],"labels":{"area":["Catalog"],"component":["DB"],"priority":"P2","severity":"S3","reportedOn":["2.3.x"]},"categories":["Catalog/Product"],"triage":{"model":"@cf/cloudflare/clef","requestHash":"4910c2f2bfaa65e06cc4450d539383542b29465c6835413a4a65d68dd95f9404","isBugfix":0.8945,"changeKind":{"choice":"bugfix","probabilities":{"bugfix":0.8995,"feature":0.0465,"refactor":0.0346,"tests_only":0.0073,"docs_only":0.005,"dependency":0.0071},"confidence":0.7751},"scope":{"score":0.2376,"probabilities":{"0":0.8056,"1":0.1513,"2":0.0431},"confidence":0.5106},"risk":{"score":1.7878,"probabilities":{"0":0.0776,"1":0.0569,"2":0.8655},"confidence":0.6374},"area":{"choice":"catalog","probabilities":{"catalog":0.8779,"checkout":0.0044,"customer":0.0041,"admin":0.0367,"graphql_api":0.0042,"framework":0.0438,"frontend":0.0097,"other":0.0192},"confidence":0.7422},"securityRelevant":0.0056,"reportedVersion":{"choice":"unspecified","probabilities":{"2.4.0":0.0073,"2.4.0-p1":0.0088,"2.4.1":0.016,"2.4.1-p1":0.0123,"2.4.2":0.0159,"2.4.2-p1":0.0139,"2.4.2-p2":0.015,"2.4.3":0.0158,"2.4.3-p1":0.016,"2.4.3-p2":0.0145,"2.4.3-p3":0.009,"2.4.4":0.0109,"2.4.4-p1":0.0125,"2.4.4-p10":0.0066,"2.4.4-p11":0.0094,"2.4.4-p12":0.007,"2.4.4-p13":0.0079,"2.4.4-p14":0.0095,"2.4.4-p15":0.0074,"2.4.4-p16":0.0071,"2.4.4-p17":0.0066,"2.4.4-p18":0.0051,"2.4.4-p2":0.0036,"2.4.4-p3":0.0041,"2.4.4-p4":0.0044,"2.4.4-p5":0.0053,"2.4.4-p6":0.0049,"2.4.4-p7":0.0055,"2.4.4-p8":0.0049,"2.4.4-p9":0.0042,"2.4.5":0.0071,"2.4.5-p1":0.0079,"2.4.5-p10":0.0048,"2.4.5-p11":0.0057,"2.4.5-p12":0.0069,"2.4.5-p13":0.0067,"2.4.5-p14":0.0052,"2.4.5-p15":0.0059,"2.4.5-p16":0.004,"2.4.5-p17":0.0049,"2.4.5-p2":0.0033,"2.4.5-p3":0.0042,"2.4.5-p4":0.0049,"2.4.5-p5":0.0046,"2.4.5-p6":0.0044,"2.4.5-p7":0.0046,"2.4.5-p8":0.0042,"2.4.5-p9":0.0032,"2.4.6":0.0082,"2.4.6-p1":0.0087,"2.4.6-p10":0.0059,"2.4.6-p11":0.0065,"2.4.6-p12":0.0052,"2.4.6-p13":0.0065,"2.4.6-p14":0.0061,"2.4.6-p15":0.0049,"2.4.6-p2":0.0037,"2.4.6-p3":0.0052,"2.4.6-p4":0.0061,"2.4.6-p5":0.0048,"2.4.6-p6":0.0052,"2.4.6-p7":0.0067,"2.4.6-p8":0.0046,"2.4.6-p9":0.0034,"2.4.7":0.0056,"2.4.7-p1":0.0066,"2.4.7-p10":0.0057,"2.4.7-p2":0.0047,"2.4.7-p3":0.0074,"2.4.7-p4":0.0101,"2.4.7-p5":0.0076,"2.4.7-p6":0.0076,"2.4.7-p7":0.0072,"2.4.7-p8":0.0052,"2.4.7-p9":0.0039,"2.4.8":0.007,"2.4.8-p1":0.0086,"2.4.8-p2":0.009,"2.4.8-p3":0.0101,"2.4.8-p4":0.0116,"2.4.8-p5":0.0091,"2.4.9":0.0103,"unspecified":0.4071},"confidence":0.1608},"backportWorthy":{"score":1.0868,"probabilities":{"0":0.222,"1":0.4691,"2":0.3089},"confidence":0.0471}},"curated":{"title":"Fixes duplicated data in eav_attribute_option_value with a unique key","description":"The eav_attribute_option_value table has a missing unique key, and duplicated data in this table is causing issues when trying to load attribute option values. The change adds a unique key on store_id and option_id in db_schema.xml.","categories":["Catalog/Product"],"author":"claude-code/opus-5.5","date":"2026-10-06","reviewedBy":null},"tests":null},"_documentation":"https://magento.watch/api","_description":"Upstream fix magento2-28796 details"}