Fully use precision for NUMERIC
-------------------------------
Key: CORE-4638
URL: http://tracker.firebirdsql.org/browse/CORE-4638
Project: Firebird Core
Issue Type: Improvement
Reporter: Maxim Kuzmin
Priority: Minor
Query:
SELECT
CAST(0 AS NUMERIC(1,0)),
CAST(0 AS NUMERIC(2,0)),
CAST(0 AS NUMERIC(3,0)),
CAST(0 AS NUMERIC(4,0)),
CAST(0 AS NUMERIC(5,0)),
CAST(0 AS NUMERIC(6,0)),
CAST(0 AS NUMERIC(7,0)),
CAST(0 AS NUMERIC(8,0)),
CAST(0 AS NUMERIC(9,0)),
CAST(0 AS DOM$NUMERIC_1_0),
CAST(0 AS DOM$NUMERIC_2_0)
FROM
RDB$DATABASE
Returning result:
CAST NUMERIC(4,0),
CAST1 NUMERIC(4,0),
CAST2 NUMERIC(4,0),
CAST3 NUMERIC(4,0),
CAST4 NUMERIC(9,0),
CAST5 NUMERIC(9,0),
CAST6 NUMERIC(9,0),
CAST7 NUMERIC(9,0),
CAST8 NUMERIC(9,0),
CAST9 NUMERIC(4,0),
CAST10 NUMERIC(4,0)
This select should return:
CAST NUMERIC(1,0),
CAST1 NUMERIC(2,0),
CAST2 NUMERIC(3,0),
CAST3 NUMERIC(4,0),
CAST4 NUMERIC(5,0),
CAST5 NUMERIC(6,0),
CAST6 NUMERIC(7,0),
CAST7 NUMERIC(8,0),
CAST8 NUMERIC(9,0),
CAST9 NUMERIC(1,0),
CAST10 NUMERIC(2,0)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
