parser: compatibility enhancement for SELECT ... INTO
syntax
#40201
Labels
component/parser
help wanted
Denotes an issue that needs help from a contributor. Must meet "help wanted" guidelines.
sig/sql-infra
SIG: SQL Infra
type/enhancement
The issue or PR belongs to an enhancement.
Enhancement
Now TiDB does not support the following
SELECT ... INTO
syntax:In which
INTO
clause appears beforeFROM
clause, as described in MySQL manual:To improve the compatibility, we need to update
parser.y
file and try to update the declaration ofSelectStmt
:tidb/parser/parser.y
Line 8646 in fdf335e
Some tips:
INTO
clause is allowed to appear afterFOR UPDATE
clause, we could also consider supporting it as well(nice to have).The text was updated successfully, but these errors were encountered: