Attachment 130280 Details for Bug 105101 – script for isql-fb for comparison

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:

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" ;

Actions: View

Attachments on bug 105101: 130151 | 130280