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

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

     [ https://issues.apache.org/jira/browse/IGNITE-11373?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Evgenii Zhuravlev resolved IGNITE-11373.
----------------------------------------
    Resolution: Duplicate

> varchar_ignorecase doesn't work properly
> ----------------------------------------
>
>                 Key: IGNITE-11373
>                 URL: https://issues.apache.org/jira/browse/IGNITE-11373
>             Project: Ignite
>          Issue Type: Bug
>          Components: sql
>            Reporter: Evgenii Zhuravlev
>            Priority: Major
>
> 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.14#76016)