Skip to content
This repository has been archived by the owner on Jun 24, 2021. It is now read-only.

unable to use the window functions after rolling update from 2.1.5 to 3.0.3 #924

Open
heguangzhu opened this issue Sep 1, 2019 · 0 comments

Comments

@heguangzhu
Copy link

mysql> SELECT end_pos, ROW_NUMBER() OVER (ORDER BY end_pos) from checkpoint;
ERROR 1064 (42000): 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 35 near "(ORDER BY end_pos) from checkpoint"
mysql> status

mysql Ver 8.0.17 for Linux on x86_64 (MySQL Community Server - GPL)

Connection id: 13
Current database: tidb_loader
Current user: [email protected]
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.7.25-TiDB-v3.0.3 MySQL Community Server (Apache License 2.0)
Protocol version: 10
Connection: 10.138.0.19 via TCP/IP
Server characterset: utf8mb4
Db characterset: utf8mb4
Client characterset: utf8mb4
Conn. characterset: utf8mb4
TCP port: 4000

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant