Description: Multiplication of fields in queries gives wrong results. Steps to Reproduce: 1. Open query "Spørring1" in attached file 2. Multiplication should give 1 for all 3 multiplications 3. Works fine when doing same operation in reports Actual Results: 1 000 000, or 10 000 Expected Results: 1 Reproducible: Always User Profile Reset: No Additional Info:
Created attachment 150388 [details] LibreOffice base file
Verified with Ubuntu 18.04 and LO 6.2.2 Also I duplicated this with decimal data types with the exact same error. Numeric and Decimal being the two fixed point data types in FB and both continue to cause problems. Along with failing in math equations it is still impossible to import a firbird table with either data type from one firebird sdbc base file into another firebird sdbc Base file ( forget about migrating from HSQL ). Exporting into Calc seems to work properly at least. Anyway I digress for this issue. Also there is another issue https://bugs.documentfoundation.org/show_bug.cgi?id=121528 but I think the two are different.
This seems to be a bug of the GUI. I have tested the same query with Tools > SQL and the results were all 1. The decimalseparator will appear at the right position.
Bug fist appears here with LO 6.1.0.3. Will work well with LO 6.0.5.2 on OpenSUSE 15.
Isn't this a duplicate of bug 121528?
(In reply to Robert Großkopf from comment #5) > Isn't this a duplicate of bug 121528? yes, I suppose checking with the SQL window shows that it is. @robert I'm curious when you run the query in the SQL window are the results using number formatting for de or en? *** This bug has been marked as a duplicate of bug 121528 ***
(In reply to Drew Jensen from comment #6)> > @robert I'm curious when you run the query in the SQL window are the results > using number formatting for de or en? In SQL-window the original formatting of the database is used. I see a point as decimal-separator.
(In reply to Robert Großkopf from comment #7) > (In reply to Drew Jensen from comment #6)> > > @robert I'm curious when you run the query in the SQL window are the results > > using number formatting for de or en? > > In SQL-window the original formatting of the database is used. I see a point > as decimal-separator. As far as I can tell the original formatting of the example Base file in question is Norwegian. Though in the query in the example file some of the columns are formatted for Norwegian and some are formatted for English and I can't say how that happens.
In my opinion related to this bug: https://bugs.documentfoundation.org/show_bug.cgi?id=120149
(In reply to Andreas Zieritz from comment #9) > In my opinion related to this bug: > > https://bugs.documentfoundation.org/show_bug.cgi?id=120149 New informations to this bug wouldn't be read, because we decided it is a duplicate of bug 121528. This bug is a special Firebird-bug. If you create an internal HSQLDB the query will work right. No problems with decimal-places there, independent of the language.
I am running norwegian Windows 10, but have changed the decimal delimiter to point ".", due to requirements of other engineering software form the US. This has cause issues in other LibreOffice modules previously (see issue 120149). Libreoffice setting however is decimal delimiter = same as local setting (,). Unchecking this setting does not seem to change anything however (checked in Calc). Did also a test, setting decimal delimiter to default ",", and generate new database. Result however is the same. Doing the same operation in a report however gives the correct results.