summary: RDB$TYPES contain duplicated character sets => RDB$TYPES contain duplicate character sets

description: table RDB$TYPES have duplicate records for some rdb$character_set_name. Duplicates can be found by query

select rdb$field_name, rdb$type_name, count(rdb$type_name)
from rdb$types
group by rdb$field_name, rdb$type_name
having count(rdb$type_name) > 1

=>

table RDB$TYPES have duplicate records for some rdb$character_set_name. Duplicates can be found by query

select rdb$field_name, rdb$type_name, count(rdb$type_name)
from rdb$types
group by rdb$field_name, rdb$type_name
having count(rdb$type_name) > 1

Result of the query:
RDB$FIELD_NAME RDB$TYPE_NAME COUNT
RDB$CHARACTER_SET_NAME ISO8859_1 2
RDB$CHARACTER_SET_NAME ISO8859_13 2
RDB$CHARACTER_SET_NAME ISO8859_2 2
RDB$CHARACTER_SET_NAME ISO8859_3 2
RDB$CHARACTER_SET_NAME ISO8859_4 2
RDB$CHARACTER_SET_NAME ISO8859_5 2
RDB$CHARACTER_SET_NAME ISO8859_6 2
RDB$CHARACTER_SET_NAME ISO8859_7 2
RDB$CHARACTER_SET_NAME ISO8859_8 2
RDB$CHARACTER_SET_NAME ISO8859_9 2

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 3.0 Alpha 1 [ 10331 ]

assignee: Adriano dos Santos Fernandes [ asfernandes ]

Link: This issue is related to QA574 [ QA574 ]

status: Resolved [ 5 ] => Resolved [ 5 ]

QA Status: Done successfully

status: Resolved [ 5 ] => Closed [ 6 ]