[
https://issues.apache.org/jira/browse/IGNITE-13230?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17280994#comment-17280994
]
Andrey Mashenkov commented on IGNITE-13230:
-------------------------------------------
CREATE INDEX command in H2 dialect (as other vendors Mysql, MS, Postgres)
expects mandatory index name.
The example above looks like misusage.
> Ignite duplicate key and NullPointerException
> ---------------------------------------------
>
> Key: IGNITE-13230
> URL: https://issues.apache.org/jira/browse/IGNITE-13230
> Project: Ignite
> Issue Type: Bug
> Components: clients
> Affects Versions: 2.9.1
> Reporter: Abhay
> Priority: Critical
> Attachments: logFile.txt, patch3.txt
>
>
> [^logFile.txt]
> Following steps lead to crash
> # Start ignite node with persistence enabled , and use ODBC client like isql
> or pyignite
> # Fire create table command e.g
> ## CREATE TABLE ct_countries(id bigint PRIMARY KEY NOT NULL,code VARCHAR(50)
> DEFAULT '',name VARCHAR(100) DEFAULT '',timezonecheck VARCHAR DEFAULT
> 'N',dstcheck VARCHAR DEFAULT 'N',phonecodelength VARCHAR(20) DEFAULT
> '',status varchar(10) DEFAULT 'INACTIVE')WITH
> "template=partitioned,backups=0,affinity_key=id";
> # Create index without giving index name and create two such index
> ## CREATE INDEX ON ct_countries(code);
> ## CREATE INDEX ON ct_countries(name);
> Restart ignite and it will crash with the follolwing logs
> java.lang.IllegalStateException: Duplicate key
> at org.apache.ignite.cache.QueryEntity.checkIndexes(QueryEntity.java:233)
> at org.apache.ignite.cache.QueryEntity.makePatch(QueryEntity.java:184)
> at
> org.apache.ignite.internal.processors.query.QuerySchema.makePatch(QuerySchema.java:114)
>
> java.lang.IllegalStateException: Duplicate key
> at org.apache.ignite.cache.QueryEntity.checkIndexes(QueryEntity.java:233)
> at org.apache.ignite.cache.QueryEntity.makePatch(QueryEntity.java:184)
> at
> org.apache.ignite.internal.processors.query.QuerySchema.makePatch(QuerySchema.java:114)
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
