Skip to content

error on create table with "CHARACTER SET DOS775" field [CORE4276] #4600

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.

Sign up for GitHub

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

Jump to bottom
Closed
firebird-automations opened this issue Nov 23, 2013 · 7 comments
Closed

error on create table with "CHARACTER SET DOS775" field [CORE4276] #4600

firebird-automations opened this issue Nov 23, 2013 · 7 comments
Assignees
@asfernandes
Labels
affect-version: 3.0 Alpha 1 affect-version: 3.0 Alpha 2 component: charsets/collation fix-version: 2.5.5 fix-version: 3.0 RC1 priority: major qa: done successfully type: bug

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Nick (nick)

CREATE TABLE CHARSETS_TEST(
"DOS775" VARCHAR(10) CHARACTER SET DOS775)
Commit transaction
--------------------Error:
unsuccessful metadata update
CHARSETS_TEST
COLLATION DOS775 for CHARACTER SET DOS775 is not installed

Commits: 4bf40ab cf5c5b7 FirebirdSQL/fbt-repository@b9a1f32 FirebirdSQL/fbt-repository@ea4a781
@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Fix Version: 3.0 RC 1 [ 10584 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

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

resolution: Fixed [ 1 ]

Fix Version: 2.5.5 [ 10670 ]

assignee: Adriano dos Santos Fernandes [ asfernandes ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @pavel-zotov

> Fix Version/s: 3.0 RC 1, 2.5.5

On 2.5:

echo show version; recreate table test(s varchar(10) character set dos775); show table test; | bin\isql -q /3255:e25

Output:

Database: /3255:e25
SQL> ISQL Version: WI-V2.5.5.26909 Firebird 2.5
Server version:
Firebird/x86/Windows NT (access method), version "WI-V2.5.5.26909 Firebird 2.5"
Firebird/x86/Windows NT (remote server), version "WI-V2.5.5.26909 Firebird 2.5/tcp (balaha)/P12"
Firebird/x86/Windows NT (remote interface), version "WI-V2.5.5.26909 Firebird 2.5/tcp (balaha)/P12"
on disk structure version 11.2
S VARCHAR(10) CHARACTER SET DOS775 Nullable

// i.e. OK, it works fine.

On 3.0:

echo show version; recreate table test(s varchar(10) character set dos775); show table test; | isql -q /3333:e30

Output:

ISQL Version: WI-V3.0.0.31925 Firebird 3.0 Release Candidate 1
Server version:
Firebird/Windows/Intel/i386 (access method), version "WI-V3.0.0.31925 Firebird 3.0 Release Candidate 1"
Firebird/Windows/Intel/i386 (remote server), version "WI-V3.0.0.31925 Firebird 3.0 Release Candidate 1/tcp (balaha)/P13"
Firebird/Windows/Intel/i386 (remote interface), version "WI-V3.0.0.31925 Firebird 3.0 Release Candidate 1/tcp (balaha)/P13"
on disk structure version 12.0
Statement failed, SQLSTATE = 22021
unsuccessful metadata update
-TEST
-COLLATION DOS775 for CHARACTER SET DOS775 is not installed
There is no table TEST in this database

@firebird-automations
Copy link
Collaborator Author

Commented by: @asfernandes

You should better test in 3.0.0.31928, as I don't know when the snapshots are checked-out and built.

@firebird-automations
Copy link
Collaborator Author

Commented by: @pavel-zotov

Checked on: WI-V2.5.5.26909, WI-V3.0.0.31928

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

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

QA Status: Done successfully

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@asfernandes asfernandes

Labels
affect-version: 3.0 Alpha 1 affect-version: 3.0 Alpha 2 component: charsets/collation fix-version: 2.5.5 fix-version: 3.0 RC1 priority: major qa: done successfully type: bug
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@asfernandes @firebird-automations