yiteng.liu created IGNITE-12777:
-----------------------------------
Summary: 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.7.6, 2.7.5, 2.8
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
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)
