Somewhere between 5.4.3.2 and 5.4.3.15, our Postgr...
# luceed
Dean
07/11/2024, 7:14 AMSomewhere between 5.4.3.2 and 5.4.3.15, our Postgres queries stopped returning proper decimals.
The query result below is from the same query run on the above version, +2 returning the decimals and +15 not.
I couldnt find anything relevant to Postgres in the change log, only the HSQL change. This query is joining tables, but not using hsql, its direct sql.
I tested using a docker container with exactly the same config, just switching the Lucee versions.
Is there some way we can get the decimals back?
b
brettpr
07/11/2024, 7:31 AM@Dean - we had a similar problem but with mySQL related to this ticket: https://luceeserver.atlassian.net/browse/LDEV-4827
Which has been resolved in Lucee version 5.4.6.9.
brettpr
07/11/2024, 7:33 AMOr am I reading that back to front?
d
Dean
07/11/2024, 7:33 AMI originally had 5.4.6.9 on the containers, and found this problem, so I started testing version to figure out where the issue started.
Dean
07/11/2024, 7:35 AMIf I go back to 5.4.3.2 I get decimals, anything above that, no decimals. To be clear, if I put a decimal value in the column like 29.65, it returns ok, its only when its being saved as 30.00. The columns in the db are correct and return the correct format
b
brettpr
07/11/2024, 7:39 AMahh... gotcha... Perhaps it is something similar that was 'fixed' around the same time as LDEV-4827 because we were stuck on 5.4.3.16 until it was fixed which is eerily close to 5.4.3.15 😉
🙏 1
d
Dean
07/22/2024, 2:56 AMDean
07/22/2024, 2:56 AM@zackster FYI
2 Views