ALTER DOMAIN and ALTER TABLE don't allow to change character set and/or collation [CORE1058] #1479
Comments
|
Commented by: @pcisar Fix verified for 2.1 Alpha 1. Test added. |
Modified by: @pcisarstatus: Resolved [ 5 ] => Closed [ 6 ] |
|
Commented by: @pcisar Reopened to update ticket information. |
Modified by: @pcisarWorkflow: jira [ 11403 ] => Firebird [ 15194 ] |
Modified by: @pavel-zotovQA Status: No test |
Modified by: @pavel-zotovstatus: Closed [ 6 ] => Closed [ 6 ] QA Status: No test => Done successfully |
Modified by: @pavel-zotovstatus: Closed [ 6 ] => Closed [ 6 ] QA Status: Done successfully => Done with caveats Test Details: Currently test changes only CHARACTER SET; changing of field collation is missed. |
|
Commented by: @livius2 as title say "and/or collation" CREATE DOMAIN TEST VARCHAR(50) CHARACTER SET WIN1250 COLLATE PXW_PLK; ALTER DOMAIN TEST TYPE VARCHAR(100) CHARACTER SET WIN1250 COLLATE PXW_PLK; Engine Code : 335544569 withoult collate it is altered but colltions is changed to WIN1250.. Issue is related to CORE1202 |
|
@@@ QA issue @@@ Found case when ALTER TABLE ALTER COLUMN <NEW_TYPE> <NEW_CHAR_SET> does not change character set. |
Submitted by: @dyemanov
Is related to QA45
CREATE DOMAIN D_TEST AS VARCHAR(100) CHARACTER SET WIN1251;
-- domain created successfully
ALTER DOMAIN D_TEST TYPE VARCHAR(100) CHARACTER SET UTF8;
-- no error but charset is not changed either
Commits: 21397ed
====== Test Details ======
Currently test changes only CHARACTER SET; changing of field collation is missed.
The text was updated successfully, but these errors were encountered: