UPSTREAM FIX

magento2-40540: Truncated applied_rule_ids in the quote table when many sales rules apply

Community fix magento2-40540 merged into magento/magento2 on 2026-06-08, not in a release yet; applies cleanly to 34 releases from 2.4.6 to 2.4.9.

Fixes truncated applied_rule_ids in the quote table when many sales rules apply edited

Pull request title
Data Type of applied_rule_ids in Quote and Quote Item is different
Pull request
magento/magento2#40540
Issues
#39838 human
Author
@lbajsarowicz
Merged
2026-06-08
Fixed in
no release yet
Reported on
2.4.8
Categories
Shopping Cart
Components
magento/module-quote

Labels

Area
Catalog
Component
Quote
Priority
P3
Severity
—
Reported on (labels)
2.4.8

Issue

Title and steps come from the upstream issue and pull request.

Description

- Data type of Quote Item applied_rule_ids column is inconsistent compare to applied_rule_ids in quote table

Steps to reproduce

- Just check the db_schema.xml in Quote module

Expected result

- Data type should be consistent across parent and child tables

Actual result

- Data type of Quote Item applied_rule_ids column is inconsistent compare to applied_rule_ids in quote table

Taken from the upstream issue.

Code match per tag

Each tag was checked with git apply --check against that tag's files. A clean match means the change applies; it is not a test result. Tags that already contain the fix are marked.

LineCode match per tagTests
2.4.6
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.6: no test data 2.4.6-p1: no test data 2.4.6-p2: no test data 2.4.6-p3: no test data 2.4.6-p4: no test data 2.4.6-p5: no test data 2.4.6-p6: no test data 2.4.6-p7: no test data 2.4.6-p8: no test data 2.4.6-p9: no test data 2.4.6-p10: no test data 2.4.6-p11: no test data 2.4.6-p12: no test data 2.4.6-p13: no test data 2.4.6-p14: no test data 2.4.6-p15: no test data
2.4.7
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.7: no test data 2.4.7-p1: no test data 2.4.7-p2: no test data 2.4.7-p3: no test data 2.4.7-p4: no test data 2.4.7-p5: no test data 2.4.7-p6: no test data 2.4.7-p7: no test data 2.4.7-p8: no test data 2.4.7-p9: no test data 2.4.7-p10: no test data
2.4.8
2.4.8 clean 2.4.8-p1 clean 2.4.8-p2 clean 2.4.8-p3 clean 2.4.8-p4 clean 2.4.8-p5 clean
2.4.8: no test data 2.4.8-p1: no test data 2.4.8-p2: no test data 2.4.8-p3: no test data 2.4.8-p4: no test data 2.4.8-p5: no test data
2.4.9
2.4.9 clean
2.4.9: no test data

Triage

Model @cf/cloudflare/clef. Probability this is a bug fix: 96.1%. Probability it is security relevant: 0.7%.

Show the model's answers and probabilities
QuestionAnswerProbabilitiesConfidence
Change kindbugfixbugfix 92.3%, refactor 4.6%, tests_only 0.9%, feature 0.8%, dependency 0.7%, docs_only 0.7%82.6%
Areacheckoutcheckout 86.5%, other 3.6%, catalog 2.9%71.6%
Reported version2.4.82.4.8 35.8%, 2.4.7 6.1%, unspecified 5.0%13.1%
Scope0.17 of 20 86.5%, 1 10.1%, 2 3.4%63.8%
Risk1.67 of 22 80.2%, 0 12.9%, 1 6.9%49.8%
Worth backporting1.25 of 22 43.1%, 1 39.0%, 0 17.9%5.5%

Download

For cweagans/composer-patches, choose a version below and download the bundle. Copy its magento2-40540/ folder into patches/composer/, merge composer.patches.json into composer.json, then run composer install. Test files are always removed; paths are relative to each package root, using the default -p1 level.

Packages (1): magento/module-quote
Bundle README (what the ZIP ships)
# magento2-40540

Community fix merged upstream into magento/magento2, adapted by magento.watch.
This is not a patch published by Adobe.

Pull request: https://github.com/magento/magento2/pull/40540
Issue: https://github.com/magento/magento2/issues/39838
Author: @lbajsarowicz
Source commit: f578c1b7b9ea965cd014fd399aca5e4b3cce5819
Modifications: test files and documentation removed, paths rewritten relative to each Composer package.
Licence: OSL-3.0 / AFL-3.0, as the original Magento Open Source code.
Maintainer: Łukasz Bajsarowicz (@lbajsarowicz)

Licence: Magento Open Source code under OSL-3.0 and AFL-3.0. The bundle carries the original author, source commit and the list of modifications.

Sources

Łukasz Bajsarowicz
Built by

Łukasz Bajsarowicz, e-commerce architect

Magento and Adobe Commerce architecture, upgrades, performance and audits for merchants and agencies since 2015; magento.watch is the tooling I use on those projects.

Open source, maintained on weekends.