TiFlash Explicit Transaction Error: Internal: Can’t find a proper physical plan for this query

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: TiFlash显式事务报错,Internal : Can’t find a proper physical plan for this query

| username: Kongdom

【TiDB Version】5.7.25-TiDB-v6.5.0
【Impact of the Bug】Affects normal business operations
【Possible Steps to Reproduce the Issue】

CREATE TABLE test_202304141 (id INT NOT NULL PRIMARY KEY);
CREATE TABLE test_202304142 (id INT NOT NULL PRIMARY KEY);

ALTER TABLE test_202304141 SET TIFLASH REPLICA 1;

SELECT * FROM INFORMATION_SCHEMA.tiflash_replica 
WHERE TABLE_NAME = 'test_202304141';

INSERT INTO test_202304141 VALUES (1);

BEGIN; 
INSERT INTO test_202304142 
SELECT /*+ read_from_storage(tiflash[t]) */ * FROM test_202304141 t;      
COMMIT;

【Observed Unexpected Behavior】Internal: Can’t find a proper physical plan for this query
【Expected Behavior】Execute normally
【Related Components and Specific Versions】

Release Version: v6.5.0
Edition: Community
Git Commit Hash: 706c3fa3c526cdba5b3e9f066b1a568fb96c56e3
Git Branch: heads/refs/tags/v6.5.0
UTC Build Time: 2022-12-27 03:50:44
GoVersion: go1.19.3
Race Enabled: false
TiKV Min Version: 6.2.0-alpha
Check Table Before Drop: false
Store: tikv
| username: Kongdom | Original post link

Issues have been submitted: Can’t find a proper physical plan for this query when using TiFlash with explicit transaction · Issue #43050 · pingcap/tidb · GitHub

| username: Kongdom | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.