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
1g0r made changes - 14/Dec/10 03:33 PM
Field Original Value New Value
Component/s Charsets/Collation [ 10001 ]
Component/s Engine [ 10000 ]
Adriano dos Santos Fernandes made changes - 28/Aug/12 03:40 PM
Status Open [ 1 ] Resolved [ 5 ]
Assignee Adriano dos Santos Fernandes [ asfernandes ]
Fix Version/s 3.0 Alpha 1 [ 10331 ]
Resolution Fixed [ 1 ]
Pavel Cisar made changes - 29/Mar/14 05:03 PM
Link This issue is related to QA-557 [ QA-557 ]
Pavel Zotov made changes - 28/May/15 05:13 PM
Status Resolved [ 5 ] Resolved [ 5 ]
QA Status Done successfully
Pavel Cisar made changes - 23/Sep/15 12:56 PM
Status Resolved [ 5 ] Closed [ 6 ]