Formatting of blob sub_type 6 (rdb$formats.rdb$descriptor)
----------------------------------------------------------
Key: CORE-4287
URL: http://tracker.firebirdsql.org/browse/CORE-4287
Project: Firebird Core
Issue Type: Improvement
Components: Engine
Affects Versions: 2.5.2 Update 1
Reporter: prenosil
At first sight it looks like engine creates unnecessaty format versions when
altering scale of field,
see script below ... all descriptors look same.
However, when you dump the blobs into files, you will see they are actually
different.
So the problems is just formating of format descriptors,
i.e. filter which converts blob sub_type 6 into text should show also scale
value.
SET BLOB ALL;
CREATE TABLE T(A NUMERIC(12, 4));
ALTER TABLE T ALTER A TYPE NUMERIC(12, 2);
ALTER TABLE T ALTER A TYPE NUMERIC(12, 1);
SELECT * FROM RDB$FORMATS;
RDB$RELATION_ID RDB$FORMAT RDB$DESCRIPTOR
=============== ========== =================
128 1 8:0
==============================================================================
RDB$DESCRIPTOR:
8: type=19 (BIGINT) length=8 sub_type=1 flags=0x0
==============================================================================
128 2 8:2
==============================================================================
RDB$DESCRIPTOR:
8: type=19 (BIGINT) length=8 sub_type=1 flags=0x0
==============================================================================
128 3 8:4
==============================================================================
RDB$DESCRIPTOR:
8: type=19 (BIGINT) length=8 sub_type=1 flags=0x0
==============================================================================
--
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
------------------------------------------------------------------------------
Sponsored by Intel(R) XDK
Develop, test and display web and hybrid apps with a single code base.
Download it for free now!
http://pubads.g.doubleclick.net/gampad/clk?id=111408631&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
