To reproduce, create a sample table using JDBC endpoint:
CREATE TABLE person(Id VARCHAR, birthTime TIMESTAMP, name VARCHAR, PRIMARY
KEY(Id)) WITH "TEMPLATE=templateEternal,CACHE_NAME=person,
KEY_TYPE=personKey,VALUE_TYPE=person";
and configure cache expiry policy as below
with above cache configuration records will start expiring at the end of 10
minute, batch insert around 1 records to the table and after 10 minute
records will start expiring but after some time check the records count
[select count(*) from person] most of the time it will show some non zero
number but if rows are selected instead of count to see the actual data with
[select * from person] there will be zero rows.
why count is not becoming zero even though there are now data (rows) in the
table ?
0: jdbc:ignite:thin://10...*:10800> select count from person;
COUNT
70
1 row selected (0.004 seconds)
0: jdbc:ignite:thin://10...*:10800> select * from person;
-+--+
ID BIRTHTIME NAME
-+--+
-+--+
No rows selected (0.015 seconds)
0: jdbc:ignite:thin://10...*:10800>
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/