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-issue-importer opened this issue Dec 13, 2008 · 7 comments

Comments

@firebird-issue-importer

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

firebird-issue-importer commented Dec 13, 2008

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

firebird-issue-importer commented Oct 24, 2009

Modified by: @dyemanov

Fix Version: 3.0 Alpha 1 [ 10331 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Apr 11, 2013

Modified by: @dyemanov

Component: Engine [ 10000 ]

assignee: Dmitry Yemanov [ dimitr ]

Component: Charsets/Collation [ 10001 ] =>

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Apr 11, 2013

Modified by: @dyemanov

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

resolution: Fixed [ 1 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Mar 29, 2014

Modified by: @pcisar

Link: This issue is related to QA542 [ QA542 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jan 19, 2016

Modified by: @pavel-zotov

QA Status: No test

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Feb 8, 2016

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