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

UTF8 and large varchar fields, is disinct from > Implementation limit exceeded. [CORE2238] #2665

Closed
firebird-automations opened this issue Dec 13, 2008 · 7 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Alexander (sms-timing)

Is related to QA542

The update statement fails since I switched to UTF8.

update NEW_TABLE set big = :new where big is distinct from :new

Undefined name.
Dynamic SQL Error.
SQL error code = -204.
Implementation limit exceeded.
block size exceeds implementation restriction.

Included the db (ibexpert)script

SET SQL DIALECT 3;
SET NAMES UTF8;
SET CLIENTLIB 'fbclient';

CREATE DATABASE 'LOCALHOST:c:\test.fdb'
USER 'SYSDBA' PASSWORD 'masterkey'
PAGE_SIZE 8192
DEFAULT CHARACTER SET UTF8;

CREATE DOMAIN NEW_DOMAIN AS
VARCHAR(8191);

CREATE TABLE NEW_TABLE (
NEW_FIELD INTEGER,
BIG NEW_DOMAIN
);

@firebird-automations
Copy link
Collaborator Author

Commented by: @asfernandes

This is well know problem. I'm not sure if it's already registered.

VARCHAR(8191) in UTF8 uses 32764 bytes.

You're using two parameters, hence 65528 bytes, and that is greater than the implementation limit.

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Fix Version: 3.0 Alpha 1 [ 10331 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Component: Engine [ 10000 ]

assignee: Dmitry Yemanov [ dimitr ]

Component: Charsets/Collation [ 10001 ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

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

resolution: Fixed [ 1 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Link: This issue is related to QA542 [ QA542 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

QA Status: No test

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

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

QA Status: No test => Done successfully

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