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

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

Closed
firebird-issue-importer opened this issue Nov 23, 2013 · 7 comments
Closed

Comments

@firebird-issue-importer

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jul 5, 2015

Modified by: @dyemanov

Fix Version: 3.0 RC 1 [ 10584 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jul 7, 2015

Modified by: @asfernandes

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

resolution: Fixed [ 1 ]

Fix Version: 2.5.5 [ 10670 ]

assignee: Adriano dos Santos Fernandes [ asfernandes ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jul 8, 2015

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jul 8, 2015

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jul 8, 2015

Commented by: @pavel-zotov

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

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jul 8, 2015

Modified by: @pavel-zotov

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

QA Status: Done successfully

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jul 8, 2015

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
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
2 participants