UPSTREAM FIX

magento2-40582: Setup:db:status reporting changes for unsigned doubles without precision

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

Fixes setup:db:status reporting changes for unsigned doubles without precision edited

Pull request title: Fix: Real column type introspection skips unsigned/nullable processors, uses defaults
Pull request: magento/magento2#40582
Issues: #40646 pr-derived
Author: @furan917
Merged: 2026-05-26
Fixed in: no release yet
Reported on: —
Categories: —
Components: magento/framework

Labels

Area: Framework
Component: Framework/DB
Priority: P2
Severity: —
Reported on (labels): 2.4.x

Issue

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

Description

setup:db-schema:upgrade and setup:db:status perpetually report pending modify_column changes for DOUBLE UNSIGNED columns that have no explicit precision/scale even when the database schema is already correct.

Steps to reproduce

1. composer require yotpo/module-yotpo-core or create an XML DB Schema with a double column which needs to be missing precision, or scale definitions.
2. Run setup:db:status
3. Run setup:db-schema:upgrade
4. Run setup:db:status # <- This should be clean, but it isn't due to the doubles in the yotpo module

Taken from the upstream pull request.

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.

Line	Code match per tag	Tests
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: test could not run before the patch, passes after (test header adapted)unit: could not run before, passes after
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: test could not run before the patch, passes after (test header adapted)unit: could not run before, passes after
2.4.9	2.4.9 clean	2.4.9: test could not run before the patch, passes afterunit: could not run before, passes after

Triage

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

Show the model's answers and probabilities

Question	Answer	Probabilities	Confidence
Change kind	bugfix	bugfix 96.0%, refactor 1.8%, tests_only 0.8%, feature 0.6%, dependency 0.4%, docs_only 0.4%	90.6%
Area	framework	framework 93.8%, admin 1.9%, other 1.2%	86.4%
Reported version	unspecified	unspecified 24.9%, 2.4.6 2.9%, 2.4.8 2.6%	6.0%
Scope	0.52 of 2	0 57.3%, 1 33.4%, 2 9.2%	17.3%
Risk	0.35 of 2	0 74.7%, 1 15.4%, 2 9.8%	38.8%
Worth backporting	1.62 of 2	2 69.5%, 1 23.2%, 0 7.2%	31.4%

Download

For cweagans/composer-patches, choose a version below and download the bundle. Copy its magento2-40582/ 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.

Bundle README (what the ZIP ships)

# magento2-40582

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/40582
Issue: https://github.com/magento/magento2/issues/40646
Author: @furan917
Source commit: 3fb8bdfc26e251b507cccdfb816f8a69ce2f8987
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.