When I scan the QR code for the payment of an invoice on the website, like on Log on, the payment is incorrect.
For an invoice of EUR 71.39, only EUR 71.00 is transferred.
When I scan the QR code for the payment of an invoice on the website, like on Log on, the payment is incorrect.
For an invoice of EUR 71.39, only EUR 71.00 is transferred.
The cause is a bug in the case statement of Invantive UniversalSQL. This statement is used in the internal processing of invoices and payments.
The following statement results in c having the value 123 instead of 123.45:
select case
when false
then 456
else 123.45
end
c
The data type determination is based solely on the first then, but in this case it should have been broader.
A bug has been registered for this, and a solution will be put into production soon.
This question was automatically closed after 1 week of inactivity. The last provided answer is marked as the solution.
Please create a new question in a separate topic if the issue occurs again. Please include a link to this topic in the new question by pasting its URL into the text.