[jira] (IGNITE-1338) SQL engine doesn't convert query fields name in upper case before using

[Sergey Kalashnikov (JIRA)]

Title: Message Title

Sergey Kalashnikov commented on IGNITE-1338   Re: SQL engine doesn't convert query fields name in upper case before using I have transformed this configuration to simpler and newer QueryEntity-based variant. The new configuration starts up without errors. <bean class="org.apache.ignite.configuration.CacheConfiguration"> <property name="name" value="cache1338"/> <property name="cacheMode" value="PARTITIONED"/> <property name="atomicityMode" value="ATOMIC"/> <property name="readFromBackup" value="true"/> <property name="copyOnRead" value="true"/> <property name="queryEntities"> <list> <bean class="org.apache.ignite.cache.QueryEntity"> <property name="keyType" value="org.apache.ignite.ComalgorithmKey"/> <property name="valueType" value="org.apache.ignite.Comalgorithm"/> <property name="fields"> <map> <entry key="apcsbjcode" value="java.lang.String"/> <entry key="apcid" value="java.lang.String"/> <entry key="agrsbjcode" value="java.lang.String"/> <entry key="agrid" value="java.lang.String"/> </map> </property> <property name="keyFields"> <set> <value>APCSBJCODE</value> <value>APCID</value> </set> </property> <property name="indexes"> <list> <bean class="org.apache.ignite.cache.QueryIndex"> <property name="name" value="FK1COMALGORITHM"/> <property name="indexType"> <util:constant static-field="org.apache.ignite.cache.QueryIndexType.SORTED"/> </property> <property name="fields"> <map> <entry key="agrsbjcode" value="true"/> <entry key="AGRID" value="true"/> </map> </property> </bean> </list> </property> </bean> </list> </property> </bean> However, the following must be noted: When using binary marshaller and QueryEntity.keyFields are specified in wrong register, the SQL query requesting compound key fields return nulls in corresponding columns. I have created ticket <https://issues.apache.org/jira/browse/IGNITE-4631> for tracking that issue. Add Comment   This message was sent by Atlassian JIRA (v6.3.15#6346-sha1:dbc023d)