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 UNICODE_CI collate can not be used in compound index [CORE3239] #3610

Closed
firebird-automations opened this issue Nov 16, 2010 · 7 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: 1g0r (1g0r)

Is related to QA557

CREATE TABLE TEST_CI (
RULE_ID INTEGER NOT NULL,
CI VARCHAR(10) CHARACTER SET UTF8 NOT NULL COLLATE UNICODE_CI,
ASCII VARCHAR(10) CHARACTER SET ASCII
);

INSERT INTO TEST_CI (RULE_ID, CI, ASCII) VALUES (1, 'А', 'A');
INSERT INTO TEST_CI (RULE_ID, CI, ASCII) VALUES (1, 'Б', 'B');
INSERT INTO TEST_CI (RULE_ID, CI, ASCII) VALUES (1, 'В', 'V');

COMMIT;

check query:

SQL> SELECT * FROM TEST_CI WHERE RULE_ID = 1 AND CI STARTING WITH 'А'

result: one record - is correct

Add the key (index)

SQL> ALTER TABLE TEST_CI ADD CONSTRAINT PK_TEST_CI PRIMARY KEY (RULE_ID, CI);

result: empty - bug

Commits: c1c5d2b 57ddc9e FirebirdSQL/fbt-repository@a290acc

@firebird-automations
Copy link
Collaborator Author

Modified by: 1g0r (1g0r)

Component: Charsets/Collation [ 10001 ]

Component: Engine [ 10000 ] =>

@firebird-automations
Copy link
Collaborator Author

Commented by: Attila Molnár (e_pluribus_unum)

Looks the same as CORE3052

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

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

resolution: Fixed [ 1 ]

Fix Version: 3.0 Alpha 1 [ 10331 ]

assignee: Adriano dos Santos Fernandes [ asfernandes ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Link: This issue is related to QA557 [ QA557 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

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

QA Status: Done successfully

@firebird-automations
Copy link
Collaborator Author

Commented by: @pcisar

Test created.

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

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