| Summary: | Firebird: Division of Decimal and Integer gives wrong values | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Robert Großkopf <robert> |
| Component: | Base | Assignee: | Tamas Bunth <btomi96> |
| Status: | CLOSED FIXED | ||
| Severity: | normal | CC: | btomi96, himajin100000, ilmari.lauhakangas, lionel, lo_bugs |
| Priority: | medium | ||
| Version: | 5.3.0.0.alpha0+ | ||
| Hardware: | x86-64 (AMD64) | ||
| OS: | All | ||
| See Also: |
https://bugs.documentfoundation.org/show_bug.cgi?id=104903 https://bugs.documentfoundation.org/show_bug.cgi?id=104890 |
||
| Whiteboard: | target:5.4.0 | ||
| Crash report or crash signature: | Regression By: | ||
| Bug Depends on: | |||
| Bug Blocks: | 51780 | ||
| Attachments: |
Open the query and have a look. Says all.
script for isql-fb for comparison |
||
|
Description
Robert Großkopf
2017-01-04 15:37:46 UTC
Confirmed. Arch Linux 64-bit, KDE Plasma 5 Version: 5.4.0.0.alpha0+ Build ID: 1a58cdf8af1aba52ce0a376666dd7d742234d7cf CPU Threads: 8; OS Version: Linux 4.8; UI Render: default; VCL: kde4; Locale: fi-FI (fi_FI.UTF-8); Calc: group Built on January 4th 2016 Created attachment 130280 [details]
script for isql-fb for comparison
Just in case there was any doubt, the problem is LibreOffice. isql-fb
returns the expected results (abbreviating long column names in the
obvious way) ...
ID Int Int/2 Int/2.0 D2D D2D/2 D2D/2.0
== === ===== ======= ==== ===== =======
1 1 0 0.5 1.00 0.50 0.500
2 2 1 1.0 2.00 1.00 1.000
3 3 1 1.5 3.00 1.50 1.500
4 4 2 2.0 4.00 2.00 2.000
5 5 2 2.5 5.00 2.50 2.500
It feels like a confusion between "." as thousand separator and decimal point. It also happens in Tools/SQL. Have tested this a little bit more:
SELECT CAST("Integer" AS FLOAT)/ 2.0 "Integer/2.0_Float", CAST ("Decimal_2_Digit" AS FLOAT)/2.0 "Decimal_2_Digit/2.0_Float" FROM "Table"
gives the right value for both. The decimal point works right with Float (or Double Precision), but doesn't work with Decimal (or Numeric). If I set
CAST("Integer" AS NUMERIC)/ 2.0
the result is as wrong as described in bug-report.
I will set this bug to version 5.3.0.0alpha0+, because the buggy behavior is introduced with Firebird 3.0.
It turns out that for computed numeric/decimal values firebird does not set subtype to either numeric or decimal.[1] In isql and jaybird (jdbc driver for firebird) the problem is solved by checking not only for subtype but scale of the column too. So I decided to do the same in this patch: https://gerrit.libreoffice.org/33660 [1] http://firebird.1100200.n4.nabble.com/Wrong-rdb-field-sub-type-for-numeric-computed-column-td4305957.html Tamás Bunth committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=4a193d39fb785c75668c977cf6b40d11b0ef4afe tdf#105101 check scale to determine subtype It will be available in 5.4.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. Works now, also for other numeric functions. Thanks Tamas. Could this be backported to LO 5.3.1? Eminently composed article, if just all bloggers offered the same substance as you, the web would be a far superior spot. https://enjoy-the-life-baby.com I love the blog. Great post. It is very true, people must learn how to learn before they can learn. lol i know it sounds funny but its very true. https://www.singinglikepro.com On the off chance that you set out to make me think today; mission achieved! I truly like you"re composing style and how you express your thoughts. Much thanks to you. https://paydayloanslowdown.com A great blog that I recommend to all my friends! I do not even know what I did without your advice, great work! https://small-home-ideas.com Superbly written article, if only all bloggers offered the same content as you, the internet would be a far better place. https://www.debt-to-income.com The primary thing you'll have to do is begin composing as quickly as time permits. Numerous understudies don't do this, as they feel it's an exercise in futility. All things considered, on the off chance that you begin composing before you've gone out and done the exploration, at that point, it might all not be right and you'll need to discard it. By: https://articleoftheweek.com/2020/02/18/coolest-place-in-karnataka/ Contents for TV or theater are never going to mirror the manner in which individuals really talk: common discourse is excessively loaded with falterings, errors, and arbitrary deviations to be fascinating in an emotional setting. Nonetheless, it's additionally conceivable to go excessively far the other way. At the point when your characters need to pass on significant snippets of data to one another, it's anything but difficult to fall into the snare of having them pose each other inquiries and offer the responses straight away. By: https://www.writemyessays.org.uk/ Works now, additionally for other numeric capacities. Regards, https://4bautomotive.co.uk/ Looks like you mistakenly reopened the bug. Closing again. Write in a Specific Voice. The information you print is the voice of your organization and it ought to be particular to your institution's personality. It is very important to align with the tone of your own writing to your intended audience, company objectives, and a new personality. By: https://www.contentmajestic.com/services/product-description-writing |