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

RAW data fails to get imported in some cases #584

Closed
shubham-yb opened this issue Nov 11, 2022 · 0 comments
Closed

RAW data fails to get imported in some cases #584

shubham-yb opened this issue Nov 11, 2022 · 0 comments

Comments

@shubham-yb
Copy link
Contributor

There are some cases where the user may face invalid hexadecimal error upon attempting to migrate a (LONG) RAW attribute.

Example Schema for Oracle:

DROP TABLE RAW_TYPE;
CREATE TABLE RAW_TYPE(raw_value RAW(2000), long_raw_value LONG RAW);
INSERT INTO RAW_TYPE VALUES('FFFFFFFF','FFFFFFFF');
INSERT INTO RAW_TYPE VALUES(HEXTORAW('7FFFFFFF16'),HEXTORAW('7FFFFFFF16'));
INSERT INTO RAW_TYPE VALUES(NULL,HEXTORAW('7FFFFFFF16'));
INSERT INTO RAW_TYPE VALUES(HEXTORAW('7FFFFFFF16'),NULL);
INSERT INTO RAW_TYPE VALUES(NULL,NULL);
INSERT INTO RAW_TYPE VALUES('','');

This might be related to the collation of the user's machine as the issue was reproducing on a Ubuntu VM, which has C-based locale , whereas the same issue couldn't be replicated on a CentOS 7 VM uses en_US-based locale.

Visit this link for more collation related details:

#243

@github-actions github-actions bot added the triage Needs to be triaged label Nov 11, 2022
@shubham-yb shubham-yb removed the triage Needs to be triaged label Nov 17, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant