altering column of type CHAR to new length changes column sub_type to 2093
--------------------------------------------------------------------------
Key: CORE-4272
URL: http://tracker.firebirdsql.org/browse/CORE-4272
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 2.1.5 Update 1
Environment: Firebird server 2.1.5.18496, Windows 8 Pro
Reporter: Daniel Vidic
Priority: Minor
altering column of type CHAR with any CHARACTER SET except NONE with to new
length changes column sub_type from 0 to 2093.
Example:
CREATE TABLE GRUPAKOR (
GRUPAKOR CHAR(10) CHARACTER SET DOS852 default '' NOT NULL COLLATE PDOX_SLO,
KORISNIK CHAR(11) CHARACTER SET DOS852 default '' COLLATE PDOX_SLO,
PRIMARY KEY (GRUPAKOR)
);
after
ALTER TABLE GRUPAKOR ALTER COLUMN KORISNIK TYPE CHAR(11)
select
SELECT F.RDB$FIELD_SUB_TYPE FROM RDB$FIELDS F LEFT JOIN RDB$RELATION_FIELDS RF
ON F.RDB$FIELD_NAME = RF.RDB$FIELD_SOURCE WHERE RF.RDB$RELATION_NAME =
'GRUPAKOR' AND RF.RDB$FIELD_NAME = 'KORISNIK'
returns 2093
Backing up and restoring database still leaves sub_type 2093.
Is this behavior error or irrelevant?
--
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
------------------------------------------------------------------------------
Shape the Mobile Experience: Free Subscription
Software experts and developers: Be at the forefront of tech innovation.
Intel(R) Software Adrenaline delivers strategic insight and game-changing
conversations that shape the rapidly evolving mobile landscape. Sign up now.
http://pubads.g.doubleclick.net/gampad/clk?id=63431311&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
