[
https://issues.apache.org/jira/browse/IGNITE-12777?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
yiteng.liu updated IGNITE-12777:
--------------------------------
Priority: Blocker (was: Critical)
> Incorrect query result with count(*) should return 0
> ----------------------------------------------------
>
> Key: IGNITE-12777
> URL: https://issues.apache.org/jira/browse/IGNITE-12777
> Project: Ignite
> Issue Type: Bug
> Components: compute
> Affects Versions: 2.8, 2.7.5, 2.7.6
> Environment: apache ignite 2.8.0 / 2.9.0 SNAPSHOT
> uname -a:
> Linux (hostname) 3.10.0-862.14.4.el7.x86_64 #1 SMP Wed Sep 26 15:12:11 UTC
> 2018 x86_64 x86_64 x86_64 GNU/Linux
> java:
> java version "1.8.0_60"
> Java(TM) SE Runtime Environment (build 1.8.0_60-b27)
> Java HotSpot(TM) 64-Bit Server VM (build 25.60-b23, mixed mode)
> Reporter: yiteng.liu
> Priority: Blocker
>
> Query on cache with parallelism > 1 will result in incorrect result;
> add
>
> ||xml||
> |<property name="cacheConfiguration">
> <list>
> <bean
> class="org.apache.ignite.configuration.CacheConfiguration"
> name="parallelTemplate">
> <property name="name" value="parallelTemplate*"/>
> <property name="queryParallelism" value="9"/>
> <property name="backups" value="1"/>
> <property name="cacheMode">
> <value
> type="org.apache.ignite.cache.CacheMode">PARTITIONED</value>
> </property>
> <property name="atomicityMode"
> value="TRANSACTIONAL_SNAPSHOT"/>
> <property name="queryDetailMetricsSize" value="1024"/>
> </bean>
> </list>
> </property>|
> to default-config.xml
> and create a table in sqlline
> ||sql||
> |create table test3
> (
> ID BIGINT default 0 not null,
> C1 VARCHAR(100) default '' not null,
> C2 VARCHAR(32) default '' not null,
> C3 DECIMAL(10,2) default 0.00 not null,
> C4 TIMESTAMP,
> C5 TIMESTAMP,
> C6 VARCHAR(10) default '' not null,
> primary key (C1, C2)
> ) with "template=parallelTemplate,affinity_key=c1" ;|
>
> execute query:
>
> ||sql||
> |select count(*) from test3
> where C1 = 'CESHIZJBX_7789'
> and C2 = '12345'
> and C3 = 12.5;|
> Results in incorrent result:
>
> sqlline version 1.3.0
> 0: jdbc:ignite:thin://127.0.0.1> create table test3
> . . . . . . . . . . . . . . . .> (
> . . . . . . . . . . . . . . . .> ID BIGINT default 0 not null,
> . . . . . . . . . . . . . . . .> C1 VARCHAR(100) default '' not null,
> . . . . . . . . . . . . . . . .> C2 VARCHAR(32) default '' not null,
> . . . . . . . . . . . . . . . .> C3 DECIMAL(10,2) default 0.00 not null,
> . . . . . . . . . . . . . . . .> C4 TIMESTAMP,
> . . . . . . . . . . . . . . . .> C5 TIMESTAMP,
> . . . . . . . . . . . . . . . .> C6 VARCHAR(10) default '' not null,
> . . . . . . . . . . . . . . . .> primary key (C1, C2)
> . . . . . . . . . . . . . . . .> ) with
> "template=parallelTemplate,affinity_key=c1" ;
> No rows affected (0.239 seconds)
> 0: jdbc:ignite:thin://127.0.0.1> select count(*) from test3
> . . . . . . . . . . . . . . . .> where C1 = 'CESHIZJBX_7789'
> . . . . . . . . . . . . . . . .> and C2 = '12345'
> . . . . . . . . . . . . . . . .> and C3 = 12.5;
> +--------------------------------+
> | COUNT(*) |
> +--------------------------------+
> | 0 |
> | 0 |
> | 0 |
> | 0 |
> | 0 |
> | 0 |
> | 0 |
> | 0 |
> | 0 |
> +--------------------------------+
> 9 rows selected (0.052 seconds)
>
>
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
