Bugzilla – Attachment 130280 Details for
Bug 105101
Firebird: Division of Decimal and Integer gives wrong values
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
script for isql-fb for comparison
Query_Division_Digits.sql (text/plain), 1.13 KB, created by
Terrence Enger
on 2017-01-09 16:53:30 UTC
(
hide
)
Description:
script for isql-fb for comparison
Filename:
MIME Type:
Creator:
Terrence Enger
Created:
2017-01-09 16:53:30 UTC
Size:
1.13 KB
patch
obsolete
>-- tdf#105101: incorrect decimal places from division > >-- For comparison to bug report, use isql-fb to do what attachment >-- Firebird_3_Bug.odb does. > >-- a clean start, please >connect "/tmp/bug_105101.fdb" ; >drop database ; >create database "/tmp/bug_105101.fdb" ; > >-- test data >create table "Table" > ( "ID" integer > , "Integer" integer > , "Decimal_2_Digit" decimal (10,2) > ) ; >insert into "Table" values ( 1, 1, 1.00 ) ; >insert into "Table" values ( 2, 2, 2.00 ) ; >insert into "Table" values ( 3, 3, 3.00 ) ; >insert into "Table" values ( 4, 4, 4.00 ) ; >insert into "Table" values ( 5, 5, 5.00 ) ; > >-- the query in question >-- But abbreviate column headings to facilitate copying the result into >-- a bugzilla. Remove overabundant leading space from each column by ... >-- cut --bytes 11-13,23-26,43-48,63-70,87-92,109-114,129-135 > >SELECT "ID" > , "Integer" "Int", "Integer" / 2 "Int/2" > , "Integer" / 2.0 "Int/2.0" > , "Decimal_2_Digit" "D2D", "Decimal_2_Digit" / 2 "D2D/2" > , "Decimal_2_Digit" / 2.0 "D2D/2.0" > FROM "Table" ;
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Raw
Actions:
View
Attachments on
bug 105101
:
130151
| 130280