Stanislav Lukyanov created IGNITE-7687:
------------------------------------------
Summary: SQL SELECT doesn't update TTL for
Touched/AccessedExpiryPolicy
Key: IGNITE-7687
URL: https://issues.apache.org/jira/browse/IGNITE-7687
Project: Ignite
Issue Type: Bug
Components: sql
Affects Versions: 2.5
Reporter: Stanislav Lukyanov
SQL SELECT queries don't update TTLs when TouchedExpiryPolicy or
AccessedExpiryPolicy is used (unlike IgniteCache::get which does update the
TTLs).
Example (modified SqlDmlExample):
========================
CacheConfiguration<Long, Organization> orgCacheCfg = new
CacheConfiguration<Long, Organization>(ORG_CACHE)
.setIndexedTypes(Long.class, Organization.class)
.setExpiryPolicyFactory(TouchedExpiryPolicy.factoryOf(new
Duration(TimeUnit.SECONDS, 10)));
IgniteCache<Long, Organization> orgCache =
ignite.getOrCreateCache(orgCacheCfg);
SqlFieldsQuery qry = new SqlFieldsQuery("insert into Organization (_key,
id, name) values (?, ?, ?)");
orgCache.query(qry.setArgs(1L, 1L, "ASF"));
orgCache.query(qry.setArgs(2L, 2L, "Eclipse"));
SqlFieldsQuery qry1 = new SqlFieldsQuery("select id, name from Organization
as o");
for (int i = 0; ;i++) {
List<List<?>> res = orgCache.query(qry1).getAll();
print("i = " + i);
for (Object next : res)
System.out.println(">>> " + next);
U.sleep(5000);
}
========================
Output:
>>> i = 0
>>> [1, ASF]
>>> [2, Eclipse]
>>> i = 1
>>> [1, ASF]
>>> [2, Eclipse]
>>> i = 2
>>> i = 3
...
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
