[2.10]If affinityKey is used as a where condition, cannot retrieve the result set

[38797715]

Hi team,

test.zip Is a single node snapshot compressed file.



You will see a table called viewsortcontrol.

Execute the following SQL, the result is normal:

SELECT * FROM viewsortcontrol

However, if you execute the following SQL, there is no query result:

SELECT * FROM viewsortcontrol WHERE tableid= '0x8d20e'

The tableid field is the affinitykey of the table.

What are the possible reasons?


<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans";
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; xsi:schemaLocation="http://www.springframework.org/schema/beans
        http://www.springframework.org/schema/beans/spring-beans.xsd";>
    <bean id="ignite.cfg" class="org.apache.ignite.configuration.IgniteConfiguration">
        <property name="peerClassLoadingEnabled" value="true"/>
        <property name="consistentId" value="jx_ignite_seed_0"/>
        <property name="snapshotPath" value="snapshots"/>
        <property name="metricsLogFrequency" value="0"/>
        <!-- <property name="workDirectory" value="/home/liyujue/ignite"/> -->
        <property name="cacheConfiguration">
            <list>
                <bean id="partitioned-cache-template" abstract="true" class="org.apache.ignite.configuration.CacheConfiguration">
                    <property name="name" value="cache-partitioned*"/>
                    <property name="cacheMode" value="PARTITIONED" />
                    <property name="readFromBackup" value="false" />
                    <property name="statisticsEnabled" value="true" />
                    <property name="queryParallelism" value="4"/>
                    <property name="sqlIndexMaxInlineSize" value="64"/>
                    <property name="backups" value="1" />
                    <property name="partitionLossPolicy" value="READ_WRITE_SAFE" />
                    <property name="atomicityMode" value="TRANSACTIONAL" />
                </bean>
                <bean id="replicated-cache-template" abstract="true" class="org.apache.ignite.configuration.CacheConfiguration">
                    <property name="name" value="cache-replicated*"/>
                    <property name="statisticsEnabled" value="true" />
                    <property name="cacheMode" value="REPLICATED" />
                    <property name="sqlIndexMaxInlineSize" value="64"/>
                    <property name="atomicityMode" value="TRANSACTIONAL" />
                </bean>
            </list>
        </property>
        <property name="dataStorageConfiguration">
            <bean class="org.apache.ignite.configuration.DataStorageConfiguration">
                <property name="walSegmentSize" value="#{128L * 1024 * 1024}" />
                <property name="walCompactionEnabled" value="true" />
                <property name="walCompactionLevel" value="4" />
                <property name="metricsEnabled" value="true" />
                <property name="defaultDataRegionConfiguration">
                    <bean class="org.apache.ignite.configuration.DataRegionConfiguration">
                        <property name="maxSize" value="#{2L * 1024 * 1024 * 1024}"/>
                        <property name="persistenceEnabled" value="true"/>
                    </bean>
                </property>
            </bean>
        </property>
        <property name="gridLogger">
            <bean class="org.apache.ignite.logger.log4j2.Log4J2Logger">
                <constructor-arg type="java.lang.String" value="config/ignite-log4j2.xml"/>
            </bean>
        </property>
        <property name="transactionConfiguration">
            <bean class="org.apache.ignite.configuration.TransactionConfiguration">
                <property name="defaultTxTimeout" value="20000" />
                <property name="txTimeoutOnPartitionMapExchange" value="20000" />
            </bean>
        </property>
    </bean>
</beans>

Unzip the file to the work directory of ignite, and then use the example.xml start a node and activate the cluster.

<<attachment: test.zip>>

VIEWSORTCONTROL.sql
Description: application/sql