[
https://issues.apache.org/jira/browse/IGNITE-11373?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ivan Pavlukhin updated IGNITE-11373:
------------------------------------
Component/s: sql
> 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.3#76005)
