[
https://issues.apache.org/jira/browse/IGNITE-16494?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17489706#comment-17489706
]
Ignite TC Bot commented on IGNITE-16494:
----------------------------------------
{panel:title=Branch: [pull/9808/head] Base: [master] : No blockers
found!|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}{panel}
{panel:title=Branch: [pull/9808/head] Base: [master] : New Tests
(6)|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}
{color:#00008b}Continuous Query 4{color} [[tests
6|https://ci.ignite.apache.org/viewLog.html?buildId=6411036]]
* {color:#013220}IgniteCacheQuerySelfTestSuite6:
IgniteInsertNullableDuplicatesSqlTest.testInsertKeyWithNullKeyPartsDefaultCacheApi
- PASSED{color}
* {color:#013220}IgniteCacheQuerySelfTestSuite6:
IgniteInsertNullableDuplicatesSqlTest.testInsertKeyWithNullKeyParts -
PASSED{color}
* {color:#013220}IgniteCacheQuerySelfTestSuite6:
IgniteInsertNullableDuplicatesSqlTest.testInsertKeyWithNullKeys - PASSED{color}
* {color:#013220}IgniteCacheQuerySelfTestSuite6:
IgniteInsertNullableDuplicatesSqlTest.testInsertKeyWithNullKeyPartsDefault -
PASSED{color}
* {color:#013220}IgniteCacheQuerySelfTestSuite6:
IgniteInsertNullableDuplicatesSqlTest.testInsertKeyWithNullKeyParts2 -
PASSED{color}
* {color:#013220}IgniteCacheQuerySelfTestSuite6:
IgniteInsertNullableDuplicatesSqlTest.testInsertKeyWhenKeyIsNotSet -
PASSED{color}
{panel}
[TeamCity *--> Run :: All*
Results|https://ci.ignite.apache.org/viewLog.html?buildId=6410302&buildTypeId=IgniteTests24Java8_RunAll]
> Query engine allows to insert rows with logically equal compound PK
> -------------------------------------------------------------------
>
> Key: IGNITE-16494
> URL: https://issues.apache.org/jira/browse/IGNITE-16494
> Project: Ignite
> Issue Type: Bug
> Components: sql
> Affects Versions: 2.11.1
> Reporter: Taras Ledkov
> Assignee: Taras Ledkov
> Priority: Major
> Time Spent: 10m
> Remaining Estimate: 0h
>
> It's possible now to insert two logically equal yet physically different keys
> with SQL API into a table, that will bring indexes into inconsistent state.
> For example follow snippet will pass, although it should have fallen on the
> third statement:
> {code}
> create table test (id1 int, id2 int, val int, constraint primary key(id1,
> id2));
> insert into test (id1, id2, val) values (1, null, 1);
> insert into test (id1, val) values (1, 1); <-- should fail here because there
> is already exists such key, but it's
> {code}
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
