LO/Firebird - subtraction issue and other operations

[pinco pallo]

Hi, I have an issue with an embedded Firebird database with LO 6.2.
In my table one is decimal =12,0 and two is decimal=10,0.
Why the subtraction one-two = 20?
Why the additions one+two = 220?
Why the division one/two = 120?
Why the product one*two = 12000?
Thanks so much.

[RoryOF]

Your comma is not being treated as a decimal point.

[pinco pallo]

Thanks for your quick reply.
But even changing the decimal separator from comma to point (choosing English in the Format dialog box) things don't change.

[Villeroy]

Test_Firebird.odb

(3.73 KiB) Downloaded 307 times

[pinco pallo]

Thank you. But not in MyTest:

Where am I wrong?

[Villeroy]

Because your query is not the same as mine.

[chrisb]

i have not downloaded any of the attachments related to this topic but suspect that the answer lies here>> https://ask.libreoffice.org/en/question ... breoffice/
the use of CAST is required:-

Code: Select all

cast("Column1" - "Column2" as decimal(8,2)) "Column1-Column2"

in my humble opinion there are currently so many bugs in libreoffice base & embedded firebird in particular that it can not be trusted.

[Villeroy]

+1

Use LibreOffice instead of OpenOffice but not the new Firebird engine that integrates so poorly. I do not blame anybody. It could be Firebird not obeying certain standards, it could be the Base developers of old OpenOffice.org, it could be the LibreOffice crew. There is nothing wrong with HSQL. Even the old embedded version works better than Firebird, and if you switch from embedded HSQL to external HSQL2 you get a really nice backend playing almost perfectly together with Base.

[pinco pallo]

but not the new Firebird engine that integrates so poorly

I thought I was doing something right with Firebird. If I select HSQL LO it says:

the use of CAST is required

Better to give up immediately if I need to reformat the fields in all the queries.

[pinco pallo]

The problem also exists with a new database connected.
Is it possible that the developers have done this stupid thing?

[Villeroy]

Yes, they did this stupid thing.
menu:Tools>Options>Advanced turn off experimental features and you won't be prompted for conversion anymore.