Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

I can't alter domain type for varchar with length minor to 100 character [CORE4718] #5025

Closed
firebird-automations opened this issue Mar 23, 2015 · 6 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Vicente Tejero Trueba (vicentett)

When I try to alter domain to a new character length of 35 character I receive a exception
Before the domain have a length of 30 characters

alter domain DINUTIL
type varchar(35);

The exception:
New size specified for column DINUTIL must be at least 100 characters.

SQL Code: -607
IB Error Number: 335544351

Is it correct?

@firebird-automations
Copy link
Collaborator Author

Commented by: Sean Leyne (seanleyne)

Please provide full sequence of steps to reproduce and advise of the character set used when defining database.

@firebird-automations
Copy link
Collaborator Author

Commented by: Vicente Tejero Trueba (vicentett)

The database have ISO8859_1 as default character set.

The statements are

create domain DINUTIL
varchar(25)
character set UTF8
default 'INU'
not null
check (value in ('INU', 'INUTIL', 'INUTILES',
'INUTILES SON'))
collate UNICODE;

alter domain DINUTIL
type varchar(35);

When I ommited in the create statement the clausule character set , the problem dissapear.

@firebird-automations
Copy link
Collaborator Author

Commented by: Arioch (arioch)

This regression was introduces with Firebird 1.5 in December 2002.

CORE241

@firebird-automations
Copy link
Collaborator Author

Commented by: @asfernandes

This works in 3.0 and is unlikely to be fixed in 2.5.

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

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

resolution: Won't Fix [ 2 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant