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