[jira] [Commented] (IGNITE-8552) Unable to use date as primary key

["Sergey Kozlov (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/IGNITE-8552?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16550495#comment-16550495 ] 

Sergey Kozlov commented on IGNITE-8552:
---------------------------------------

There's the another effect after issued {{CREATE TABLE t1 (id DATE NOT NULL ..., PRIMARY KEY (id))}}
Try to create new table ({{CREATE TABLE t1 (id INT NOT NULL, name VARCHAR, PRIMARY KEY (id))}}) causes in sqlline hung and the node prints out exception:
{format}
java.lang.IndexOutOfBoundsException: Index: 0, Size: 0
        at java.util.ArrayList.rangeCheck(ArrayList.java:653)
        at java.util.ArrayList.get(ArrayList.java:429)
        at org.apache.ignite.internal.processors.cache.CacheGroupContext.singleCacheContext(CacheGroupContext.java:385)
        at org.apache.ignite.internal.processors.cache.distributed.dht.GridDhtLocalPartition.<init>(GridDhtLocalPartitio
n.java:198)
        at org.apache.ignite.internal.processors.cache.distributed.dht.GridDhtPartitionTopologyImpl.getOrCreatePartition
(GridDhtPartitionTopologyImpl.java:812)
        at org.apache.ignite.internal.processors.cache.distributed.dht.GridDhtPartitionTopologyImpl.initPartitions(GridD
htPartitionTopologyImpl.java:368)
        at org.apache.ignite.internal.processors.cache.distributed.dht.GridDhtPartitionTopologyImpl.beforeExchange(GridD
htPartitionTopologyImpl.java:543)
        at org.apache.ignite.internal.processors.cache.distributed.dht.preloader.GridDhtPartitionsExchangeFuture.distrib
utedExchange(GridDhtPartitionsExchangeFuture.java:1141)
        at org.apache.ignite.internal.processors.cache.distributed.dht.preloader.GridDhtPartitionsExchangeFuture.init(Gr
idDhtPartitionsExchangeFuture.java:712)
        at org.apache.ignite.internal.processors.cache.GridCachePartitionExchangeManager$ExchangeWorker.body0(GridCacheP
artitionExchangeManager.java:2419)
        at org.apache.ignite.internal.processors.cache.GridCachePartitionExchangeManager$ExchangeWorker.body(GridCachePa
rtitionExchangeManager.java:2299)
        at org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110)
        at java.lang.Thread.run(Thread.java:745)
{format}

> Unable to use date as primary key
> ---------------------------------
>
>                 Key: IGNITE-8552
>                 URL: https://issues.apache.org/jira/browse/IGNITE-8552
>             Project: Ignite
>          Issue Type: Bug
>          Components: sql
>    Affects Versions: 2.4
>            Reporter: Pavel Vinokurov
>            Assignee: Vladimir Ozerov
>            Priority: Blocker
>             Fix For: 2.7
>
>
> It' is unable to create cache via ddl:
> create table tab(id date primary key, date_field date);
> Result:
> ERROR CacheAffinitySharedManager - Failed to initialize cache. Will try to rollback cache start routine. [cacheName=SQL_PUBLIC_T3]
> class org.apache.ignite.IgniteCheckedException: Failed to find value class in the node classpath (use default marshaller to enable binary objects) : SQL_PUBLIC_T3_e90848b2_fe30_4adb_a934_6e13ca0eb409
> 	at org.apache.ignite.internal.processors.query.QueryUtils.typeForQueryEntity(QueryUtils.java:426)



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)