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

Regression: Can not restore database with table contains field CHAR(n) and UTF8 character set [CORE5304] #5581

Closed
firebird-automations opened this issue Jul 11, 2016 · 7 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @sim1984

Is duplicated by CORE5309
Is related to CORE5277

databases.conf contains

test = d:\fb\fb30\data\test.fdb
{
DefaultDbCachePages = 8K
}

In isql execute

set names utf8;

set sql dialect 3;

create database '127.0.0.1/3051:test'
user 'SYSDBA' password 'masterkey'
page_size 8192
default character set utf8;

create table t(
name char(10)
);

insert into t(name) values(null);

commit;

-----------------------

gbak -b -g -V -user SYSDBA -pas masterkey -se 127.0.0.1/3051:service_mgr test d:\fb\fb30\data\test.dmp

work wothout error

rename test.fdb

----------------------
gbak -c -V -user SYSDBA -pas masterkey -st TD -se 127.0.0.1/3
051:service_mgr d:\fb\fb30\data\test.dmp test
gbak: time delta
gbak: 0.000 0.000 opened file d:\fb\fb30\data\test.dmp
gbak: 0.001 0.001 transportable backup -- data in XDR format
gbak: 0.001 0.000 backup file is compressed
gbak: 0.001 0.000 backup version is 10
gbak: 0.232 0.231 created database test, page_size 8192 bytes
gbak: 0.237 0.004 started transaction
gbak: ERROR:arithmetic exception, numeric overflow, or string truncation
gbak: ERROR: string right truncation
gbak: ERROR: expected length 10, actual 40
gbak: ERROR: gds_$send failed
gbak: ERROR: Exiting before completion due to errors
gbak:Exiting before completion due to errors

If field name has type varchar(10) error not reproduced.

Commits: 600b408 0e90030 891c172 36e4fa9 0d46c91 8f02eb0

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

assignee: Adriano dos Santos Fernandes [ asfernandes ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

Link: This issue is duplicated by CORE5309 [ CORE5309 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

Link: This issue is related to CORE5277 [ CORE5277 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

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

resolution: Fixed [ 1 ]

Fix Version: 4.0 Alpha 1 [ 10731 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

Version: 3.0.1 [ 10730 ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

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

QA Status: No test => 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
Projects
None yet
Development

No branches or pull requests

2 participants