Yes, you are right!
在 2021/4/22 上午12:49, Igor Belyakov 写道:
Seems like it could be related with the next issue:
https://issues.apache.org/jira/browse/IGNITE-14451
<https://issues.apache.org/jira/browse/IGNITE-14451>
Which should be fixed in the 2.11 release.
As workaround you can try to change fields order in the PK to the same
which is used in the cache fields list:
CREATE TABLE IF NOT EXISTS VIEWSORTCONTROL (
TABLEID VARCHAR NOT NULL,
ID VARCHAR,
...
PRIMARY KEY (TABLEID, ID)
)
Igor
On Mon, Apr 12, 2021 at 1:03 PM 38797715 <38797...@qq.com
<mailto:38797...@qq.com>> wrote:
Hi team,
test.zip Is a single node snapshot compressed file.
Unzip the file to the work directory of ignite, and then use the
example.xml start a node and activate the cluster.
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?