|
If you were logged in you would be able to see more operations.
|
|
|
|
Environment:
|
Windows XP SP3, Firebird SuperServer
|
|
Issue Links:
|
Relate
|
|
|
|
This issue is related to:
|
|
|
|
|
|
|
|
| Planning Status: |
Unspecified
|
|
Table already exists with FIELD_A VARCHAR(14) CHARSET WIN1252 COLLATE WIN1252;
Create a domain A_DOMAIN VARCHAR(14) CHARSET WIN1252 COLLATE WINPT_BR;
Use "alter table" to change FIELD_A to type A_DOMAIN
Try to create a FK in some other table, referencing FIELD_A and you will get:
This operation is not defined for system tables.
unsuccessful metadata update.
partner index segment no 1 has incompatible data type.
Looks like FIELD_A still has old collation. If I change system tables to force the new collation, I can create the FK.
|
|
Description
|
Table already exists with FIELD_A VARCHAR(14) CHARSET WIN1252 COLLATE WIN1252;
Create a domain A_DOMAIN VARCHAR(14) CHARSET WIN1252 COLLATE WINPT_BR;
Use "alter table" to change FIELD_A to type A_DOMAIN
Try to create a FK in some other table, referencing FIELD_A and you will get:
This operation is not defined for system tables.
unsuccessful metadata update.
partner index segment no 1 has incompatible data type.
Looks like FIELD_A still has old collation. If I change system tables to force the new collation, I can create the FK. |
Show » |
|
Bug
Alter table not respecting collation
create domain A_DOMAIN VARCHAR(14) CHARacter SET WIN1252 COLLATE WINPT_BR;
create domain B_DOMAIN VARCHAR(14) CHARacter SET ISO8859_1 COLLATE PT_BR;
create table t (FIELD_A VARCHAR(14) CHARacter SET WIN1252 COLLATE WIN1252);
alter table t alter field_a type b_domain;
show table t; -- colattion changes to de_de