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?
to your account
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');
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
The text was updated successfully, but these errors were encountered:
Component: Charsets/Collation [ 10001 ]
Component: Engine [ 10000 ] =>
Sorry, something went wrong.
Commented by: Attila Molnár (e_pluribus_unum)
Looks the same as CORE3052
status: Open [ 1 ] => Resolved [ 5 ]
resolution: Fixed [ 1 ]
Fix Version: 3.0 Alpha 1 [ 10331 ]
assignee: Adriano dos Santos Fernandes [ asfernandes ]
Link: This issue is related to QA557 [ QA557 ]
status: Resolved [ 5 ] => Resolved [ 5 ]
QA Status: Done successfully
Commented by: @pcisar
status: Resolved [ 5 ] => Closed [ 6 ]
No branches or pull requests