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