[jira] [Created] (IGNITE-7687) SQL SELECT doesn't update TTL for Touched/AccessedExpiryPolicy

[Anton Vinogradov (Jira)]

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)