[jira] [Created] (IGNITE-11373) varchar_ignorecase doesn't work properly

["Evgenii Zhuravlev (JIRA)" <ji...@apache.org>]

Evgenii Zhuravlev created IGNITE-11373:
------------------------------------------

             Summary: varchar_ignorecase doesn't work properly
                 Key: IGNITE-11373
                 URL: https://issues.apache.org/jira/browse/IGNITE-11373
             Project: Ignite
          Issue Type: Bug
            Reporter: Evgenii Zhuravlev


Looks like a field with type varchar_ignorecase can't be used for filtering the values for different cases.


{code:java}
Ignite ignite = Ignition.start("examples/config/example-ignite.xml");
        
        IgniteCache cache = ignite.getOrCreateCache("TEST");

        cache.query(new SqlFieldsQuery("CREATE TABLE IF NOT EXISTS TEST\n" +
            "(\n" +
            "  TEST_ID                NUMBER(15)        NOT NULL,\n" +
            "  TEST_VALUE             VARCHAR_IGNORECASE(100),\n" +
            "  PRIMARY KEY (TEST_ID)\n" +
            ") "));

        System.out.println("INSERTED:" + ignite.cache("TEST").query(new SqlFieldsQuery("INSERT INTO TEST values (1,'aAa')")).getAll().size());

        System.out.println("FOUND:" + ignite.cache("TEST").query(new SqlFieldsQuery("Select * from TEST where TEST_VALUE like '%aaa%'")).getAll().size());
{code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)