parser
parser copied to clipboard
Window Function syntax error
Bug Report
Please answer these questions before submitting your issue. Thanks!
- What did you do?
// use d1; // CREATE TABLE t1 (qty INT, price INT);
ddl = "CREATE VIEW t8 AS SELECT qty, price, ROW_NUMBER() OVER(PARTITION BY qty ORDER BY price) AS row_num FROM t1;" nodes, _, err := parser.New().Parse(ddl, "", "")
- What did you expect to see?
parser.New().Parse(ddl, "", "") return success
-
What did you see instead? parser.New().Parse(ddl, "", "") return error error msg: line 1 column 150 near "(PARTITION BY
t1.qtyORDER BYt1.price) ASrow_numfromt1" -
What version of TiDB SQL Parser are you using? github.com/pingcap/parser v0.0.0-20200623164729-3a18f1e5dceb