Doctrine randomly subtracting 1 from what seems to be random integers #7238

Closed
opened 2026-01-22 15:47:43 +01:00 by admin · 0 comments
Owner

Originally created by @suavid on GitHub (Oct 31, 2023).

Bug Report

"doctrine/cache": "^1.12.1 || ^2.1.1",
"doctrine/collections": "^1.5 || ^2.1",
"doctrine/common": "^3.0.3",
"doctrine/dbal": "^2.13.1 || ^3.2",
"doctrine/deprecations": "^0.5.3 || ^1",
"doctrine/event-manager": "^1.2 || ^2",
"doctrine/inflector": "^1.4 || ^2.0",
"doctrine/instantiator": "^1.3 || ^2",
"doctrine/lexer": "^2",
"doctrine/persistence": "^2.4 || ^3",

Summary

I am trying to insert transaction information into a transaction table, the column is INT in the database and also in the mapping class.

Current behavior

When I try to import a list of X transaction for N number of them it is dropping a cent, amount is represented in cents so it is an integer, when I debug I can see the correct value up to the point when it creates the prepared statement, as far as I can debug the value looks correct but when I see the database logs it has one cent less for some transactions.

How to reproduce

It is hard to tell how to reproduce, I don't know what causes the issue, I also can't code due to privacy reasons, I know it isn't much help and I understand if nothing can be done with the little information I am providing but it is worth a shot, maybe it rings a bell.
Thanks

Expected behavior

Integers is stored without changes.

Originally created by @suavid on GitHub (Oct 31, 2023). ### Bug Report <!-- Fill in the relevant information below to help triage your issue. --> "doctrine/cache": "^1.12.1 || ^2.1.1", "doctrine/collections": "^1.5 || ^2.1", "doctrine/common": "^3.0.3", "doctrine/dbal": "^2.13.1 || ^3.2", "doctrine/deprecations": "^0.5.3 || ^1", "doctrine/event-manager": "^1.2 || ^2", "doctrine/inflector": "^1.4 || ^2.0", "doctrine/instantiator": "^1.3 || ^2", "doctrine/lexer": "^2", "doctrine/persistence": "^2.4 || ^3", #### Summary I am trying to insert transaction information into a transaction table, the column is INT in the database and also in the mapping class. #### Current behavior <!-- What is the current (buggy) behavior? --> When I try to import a list of X transaction for N number of them it is dropping a cent, amount is represented in cents so it is an integer, when I debug I can see the correct value up to the point when it creates the prepared statement, as far as I can debug the value looks correct but when I see the database logs it has one cent less for some transactions. #### How to reproduce It is hard to tell how to reproduce, I don't know what causes the issue, I also can't code due to privacy reasons, I know it isn't much help and I understand if nothing can be done with the little information I am providing but it is worth a shot, maybe it rings a bell. Thanks #### Expected behavior <!-- What was the expected (correct) behavior? --> Integers is stored without changes.
admin closed this issue 2026-01-22 15:47:43 +01:00
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: doctrine/archived-orm#7238