select for update skip locked failed with message Can't find column test.T._tidb_rowid in schema Column
- Dominant language
- Go
- Stars
- 40.5k
- Forks
- 6.2k
- PR merge metrics
- PR metrics pending
Description
1. Minimal reproduce step (Required)
CREATE TABLE `T` ( `O_ID` varchar(10) NOT NULL , `UID` varchar(20) DEFAULT NULL , `C_ID` varchar(20) DEFAULT NULL, PRIMARY KEY (`O_ID`) /*T![clustered_index] NONCLUSTERED */, KEY `IDX_N1` (`UID`,`C_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
SELECT O_ID,UID,C_ID FROM T USE INDEX(PRIMARY) where O_ID = 111 for update skip locked;`
2. What did you expect to see? (Required)
Execution successful
3. What did you see instead (Required)
`[conn.go:1149] ["command dispatched failed"] [conn=6134978014850580887] [connInfo="id:6134978014850580887, addr:127.0.0.1:61175 status:10, collation:utf8mb4_0900_ai_ci, user:root"] [command=Query] [status="inTxn:0, autocommit:1"] [sql="SELECT O_ID,UID,C_ID FROM T USE INDEX(PRIMARY) where O_ID = 111 for update skip locked"] [txn_mode=PESSIMISTIC] [timestamp=0] [err="Can't find column test.T._tidb_rowid in schema Column: [test.t.o_id,test.t.uid,test.t.c_id] Unique key: []\ngithub.com/pingcap/tidb/expression.(*Column).resolveIndices\n\t/Users/pingcap/workspace/build-common/go/src/github.com/pingcap/tidb/expression/column.go:508\ngithub.com/pingcap/tidb/expression.(*Column).ResolveIndices\n\t/Users/pingcap/workspace/build-common/go/src/github.com/pingcap/tidb/expression/column.go:501\ngithub.com/pingcap/tidb/planner/core.(*IntHandleCols).ResolveIndices\n\t/Users/pingcap/workspace/build-common/go/src/github.com/pingcap/tidb/planner/core/handle_cols.go:210\ngithub.com/pingcap/tidb/planner/core.(*PhysicalLock).ResolveIndices\n\t/Users/pingcap/workspace/build-common/go/src/github.com/pingcap/tidb/planner/core/resolve_indices.go:602\ngithub.com/pingcap/tidb/planner/core.(*basePhysicalPlan).ResolveIndices\n\t/Users/pingcap/workspace/build-common/go/src/github.com/pingcap/tidb/planner/core/resolve_indices.go:675\ngithub.com/pingcap/tidb/planner/core.(*physicalSchemaProducer).ResolveIndices\n\t/Users/pingcap/workspace/build-common/go/src/github.com/pingcap/tidb/planner/core/resolve_indices.go:664\ngithub.com/pingcap/tidb/planner/core.(*PhysicalProjection).ResolveIndices\n\t/Users/pingcap/workspace/build-common/go/src/github.com/pingcap/tidb/planner/core/resolve_indices.go:26\ngithub.com/pingcap/tidb/planner/core.physicalOptimize\n\t/Users/pingcap/workspace/build-common/go/src/github.com/pingcap/tidb/planner/core/optimizer.go:518\ngithub.com/pingcap/tidb/planner/core.DoOptimize\n\t/Users/pingcap/workspace/build-common/go/src/github.com/pingcap/tidb/planner/core/optimizer.go:291\ngithub.com/pingcap/tidb/planner.optimize\n\t/Users/pingcap/workspace/build-common/go/src/github.com/pingcap/tidb/planner/optimize.go:397\ngithub.com/pingcap/tidb/planner.Optimize\n\t/Users/pingcap/workspace/build-common/go/src/github.com/pingcap/tidb/planner/optimize.go:227\ngithub.com/pingcap/tidb/executor.(*Compiler).Compile\n\t/Users/pingcap/workspace/build-common/go/src/github.com/pingcap/tidb/executor/compiler.go:81\ngithub.com/pingcap/tidb/session.(*session).ExecuteStmt\n\t/Users/pingcap/workspace/build-common/go/src/github.com/pingcap/tidb/session/session.go:1958\ngithub.com/pingcap/tidb/server.(*TiDBContext).ExecuteStmt\n\t/Users/pingcap/workspace/build-common/go/src/github.com/pingcap/tidb/server/driver_tidb.go:225\ngithub.com/pingcap/tidb/server.(*clientConn).handleStmt\n\t/Users/pingcap/workspace/build-common/go/src/github.com/pingcap/tidb/server/conn.go:2022\ngithub.com/pingcap/tidb/server.(*clientConn).handleQuery\n\t/Users/pingcap/workspace/build-common/go/src/github.com/pingcap/tidb/server/conn.go:1876\ngithub.com/pingcap/tidb/server.(*clientConn).dispatch\n\t/Users/pingcap/workspace/build-common/go/src/github.com/pingcap/tidb/server/conn.go:1371\ngithub.com/pingcap/tidb/server.(*clientConn).Run\n\t/Users/pingcap/workspace/build-common/go/src/github.com/pingcap/tidb/server/conn.go:1121\ngithub.com/pingcap/tidb/server.(*Server).onConn\n\t/Users/pingcap/workspace/build-common/go/src/github.com/pingcap/tidb/server/server.go:559\nruntime.goexit\n\t/usr/local/go1.19.10/src/runtime/asm_amd64.s:1594"]`
4. What is your TiDB version? (Required)
Release Version: v6.1.7
Edition: Community
Git Commit Hash: 613ecc5f731b2843e1d53a43915e2cd8da795936
Git Branch: heads/refs/tags/v6.1.7
UTC Build Time: 2023-07-04 11:55:50
GoVersion: go1.19.10
Race Enabled: false
TiKV Min Version: v3.0.0-60965b006877ca7234adaced7890d7b029ed1306
Check Table Before Drop: false
Contributor guide
Assessment
This issue has not been assessed yet.