[
https://issues.apache.org/jira/browse/IGNITE-11917?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Evgeniy Rudenko reassigned IGNITE-11917:
----------------------------------------
Assignee: Evgeniy Rudenko
> Row count [select count(*) from table] not matching with the actual row count
> present in the table
> ---------------------------------------------------------------------------------------------------
>
> Key: IGNITE-11917
> URL: https://issues.apache.org/jira/browse/IGNITE-11917
> Project: Ignite
> Issue Type: Bug
> Components: sql
> Affects Versions: 2.7
> Reporter: shivakumar
> Assignee: Evgeniy Rudenko
> Priority: Major
>
> 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
> <property name="cacheConfiguration">
> <list>
> <bean id="cache-template-bean" abstract="true"
> class="org.apache.ignite.configuration.CacheConfiguration">
> <property name="name" value="templateEternal*"/>
> <property name="cacheMode" value="PARTITIONED"/>
> <property name="backups" value="1"/>
> <property name="groupName" value="groupEternal"/>
> <property name="expiryPolicyFactory">
> <bean class="javax.cache.expiry.CreatedExpiryPolicy"
> factory-method="factoryOf">
> <constructor-arg>
> <bean class="javax.cache.expiry.Duration">
> <constructor-arg value="SECONDS"/>
> <constructor-arg value="600"/>
> </bean>
> </constructor-arg>
> </bean>
> </property>
> </bean>
> </list>
> </property>
> with above cache configuration records will start expiring at the end of 10
> minute, batch insert around 10000 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>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
