parser
parser copied to clipboard
Incompatible for skip locked statements.
Bug Report
- What did you do?
mysql> CREATE TABLE t (i INT, PRIMARY KEY (i)) ENGINE = InnoDB;
mysql> INSERT INTO t (i) VALUES(1),(2),(3);
mysql> SELECT * FROM t FOR UPDATE SKIP LOCKED;
- What did you expect to see?
+---+
| i |
+---+
| 1 |
+---+
| 2 |
+---+
| 3 |
+---+
- What did you see instead?
Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your TiDB version for the right syntax to use line 1 column 31 near "SKIP LOCKED"
-
What version of TiDB SQL Parser are you using?
v0.0.0-20200623082809-b74301ac298b
The TiDB issue for this is https://github.com/pingcap/tidb/issues/18207