mysql8 .0 OVER() function not support

[night2049]

SELECT row_number() OVER ( ORDER BY id ), id FROM xxx;

Compatibility and Syntax tips: "Syntax error"

[tianzhou]

Looks like we are using an old pingcap/parser version. github.com/pingcap/parser v0.0.0-20200623164729-3a18f1e5dceb

Upgrading to a new version including pingcap/parser#959 should fix this.

Will try to upgrade.

[tianzhou]

The only newer release is https://github.com/pingcap/parser/releases/tag/v5.2.0-alpha. Though it's alpha, we just use it for syntax check and can take a try.

Hopefully we just need to update the github.com/pingcap/parser dependency in our go.mod file

[night2049]

看起来我们正在使用旧的pingcap/解析器版本。github.com/pingcap/parser v0.0.0-20200623164729-3a18f1e5dceb

升级到包含pingcap/parser#959的新版本应该可以解决这个问题。

将尝试升级。

hello，i think need add feature for enforce run Issues,or check for example mysql to EXPLAIN ${sql} to backup