Issue Details (XML | Word | Printable)

Key: CORE-3239
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Adriano dos Santos Fernandes
Reporter: 1g0r
Votes: 0
Watchers: 1
Operations

If you were logged in you would be able to see more operations.
Firebird Core

UTF8 UNICODE_CI collate can not be used in compound index

Created: 16/Nov/10 03:44 PM   Updated: 23/Sep/15 12:56 PM
Component/s: Charsets/Collation
Affects Version/s: 2.5.0
Fix Version/s: 3.0 Alpha 1

Environment: Windows XP SP3
Issue Links:
Relate
 

QA Status: Done successfully


 Description  « Hide
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

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Attila Molnár added a comment - 20/Jan/11 12:49 PM
Looks the same as CORE-3052

Pavel Cisar added a comment - 23/Sep/15 12:56 PM
Test created.