[Libreoffice-bugs] [Bug 124420] FIREBIRD: Query multiplication function returns invalid data when used with fixed point data types (numeric and decimal)
https://bugs.documentfoundation.org/show_bug.cgi?id=124420 --- Comment #11 from Andreas Zieritz --- 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. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 124420] FIREBIRD: Query multiplication function returns invalid data when used with fixed point data types (numeric and decimal)
https://bugs.documentfoundation.org/show_bug.cgi?id=124420 --- Comment #10 from Robert Großkopf --- (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. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 124420] FIREBIRD: Query multiplication function returns invalid data when used with fixed point data types (numeric and decimal)
https://bugs.documentfoundation.org/show_bug.cgi?id=124420 Andreas Zieritz changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=12 ||0149 --- Comment #9 from Andreas Zieritz --- In my opinion related to this bug: https://bugs.documentfoundation.org/show_bug.cgi?id=120149 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 124420] FIREBIRD: Query multiplication function returns invalid data when used with fixed point data types (numeric and decimal)
https://bugs.documentfoundation.org/show_bug.cgi?id=124420 --- Comment #8 from Drew Jensen --- (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. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 124420] FIREBIRD: Query multiplication function returns invalid data when used with fixed point data types (numeric and decimal)
https://bugs.documentfoundation.org/show_bug.cgi?id=124420 --- Comment #7 from Robert Großkopf --- (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. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 124420] FIREBIRD: Query multiplication function returns invalid data when used with fixed point data types (numeric and decimal)
https://bugs.documentfoundation.org/show_bug.cgi?id=124420 Drew Jensen changed: What|Removed |Added Status|NEW |RESOLVED Resolution|--- |DUPLICATE --- Comment #6 from Drew Jensen --- (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 *** -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 124420] FIREBIRD: Query multiplication function returns invalid data when used with fixed point data types (numeric and decimal)
https://bugs.documentfoundation.org/show_bug.cgi?id=124420 --- Comment #5 from Robert Großkopf --- Isn't this a duplicate of bug 121528? -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 124420] FIREBIRD: Query multiplication function returns invalid data when used with fixed point data types (numeric and decimal)
https://bugs.documentfoundation.org/show_bug.cgi?id=124420 Robert Großkopf changed: What|Removed |Added Version|6.2.2.2 release |6.1.0.3 release Keywords||regression --- Comment #4 from Robert Großkopf --- Bug fist appears here with LO 6.1.0.3. Will work well with LO 6.0.5.2 on OpenSUSE 15. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 124420] FIREBIRD: Query multiplication function returns invalid data when used with fixed point data types (numeric and decimal)
https://bugs.documentfoundation.org/show_bug.cgi?id=124420 Robert Großkopf changed: What|Removed |Added CC||rob...@familiegrosskopf.de --- Comment #3 from Robert Großkopf --- 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. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 124420] FIREBIRD: Query multiplication function returns invalid data when used with fixed point data types (numeric and decimal)
https://bugs.documentfoundation.org/show_bug.cgi?id=124420 Drew Jensen changed: What|Removed |Added Status|UNCONFIRMED |NEW Ever confirmed|0 |1 Summary|Possible wrong result in|FIREBIRD: Query |query |multiplication function ||returns invalid data when ||used with fixed point data ||types (numeric and decimal) CC||drewjensen.in...@gmail.com --- Comment #2 from Drew Jensen --- 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. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs