select lock in share mode Unexpected behavior

[haiying-gao]

Description

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

<!-- a step by step guide for reproducing the bug. -->
(root@192.168.3.11:4000)[test]
(root@192.168.3.11:4000)[test]show create table t;
+-------+------------------------------------------------------------------------------------------------------------+
| Table | Create Table                                                                                               |
+-------+------------------------------------------------------------------------------------------------------------+
| t     | CREATE TABLE `t` (
  `id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin |
+-------+------------------------------------------------------------------------------------------------------------+
1 row in set (0.05 sec)

(root@192.168.3.11:4000)[test]select * from t lock in share mode;
ERROR 1105 (HY000): Can't find column test.t._tidb_rowid in schema Column: [test.t.id] Unique key: []
(root@192.168.3.11:4000)[test]

2. What did you expect to see? (Required)

select * from t lock in share mode;
Empty set (0.00 sec)

3. What did you see instead (Required)

ERROR 1105 (HY000): Can't find column test.t._tidb_rowid in schema Column: [test.t.id] Unique key: []

4. What is your TiDB version? (Required)

v4.0.3 and v4.0.4

SIG slack channel

#sig-exec

Score

• 300

Mentor

• @SunRunAway

[ekexium]

/label sig/execution

[lzmhhh123]

Can't reproduce on master branch.

tidb(localhost:4000) > create table t (a int);
Query OK, 0 rows affected (0.14 sec)

tidb(localhost:4000) > select * from t lock in share mode;
ERROR 1235 (42000): function LOCK IN SHARE MODE has only noop implementation in tidb now, use tidb_enable_noop_functions to enable these functions
tidb(localhost:4000) > set @@tidb_enable_noop_functions = 1;
Query OK, 0 rows affected (0.00 sec)

tidb(localhost:4000) > select * from t lock in share mode;
Empty set (0.01 sec)

But it can be reproduced on release-4.0 branch.

tidb(localhost:4000) > select * from t lock in share mode;
ERROR 1105 (HY000): Can't find column test.t._tidb_rowid in schema Column: [test.t.a] Unique key: []