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)