alter character set fail
-------------------------
Key: CORE-5825
URL: http://tracker.firebirdsql.org/browse/CORE-5825
Project: Firebird Core
Issue Type: Bug
Components: Charsets/Collation, Engine
Affects Versions: 3.0.3
Environment: WINDOWS.. FB 3.0.3 AND 3.0.4.32972
Reporter: wesley blanco
script to reproduce:
CREATE TABLE TEST(
ID INTEGER,
UUID CHAR(16)
);
COMMIT;
/********* I want change only character set. *****************/
ALTER TABLE TEST ALTER UUID TYPE CHAR(16) CHARACTER SET OCTETS;
COMMIT;
/********** No erros, no update charset... **********/
SELECT A.RDB$FIELD_NAME,
A.RDB$RELATION_NAME,
B.RDB$CHARACTER_SET_ID,
C.RDB$CHARACTER_SET_NAME
FROM RDB$RELATION_FIELDS A
INNER JOIN RDB$FIELDS B ON B.RDB$FIELD_NAME = A.RDB$FIELD_SOURCE
INNER JOIN RDB$CHARACTER_SETS C ON C.RDB$CHARACTER_SET_ID =
B.RDB$CHARACTER_SET_ID
WHERE RDB$RELATION_NAME = 'TEST';
RESULT:
RDB$FIELD_NAME RDB$RELATION_NAME
RDB$CHARACTER_SET_ID RDB$CHARACTER_SET_NAME
=============================== ===============================
==================== ===============================
UUID TEST
0 NONE
--
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
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
