| Bug #90620 | MySQL Workbench SQL Editor displays error on SELECT query with window functions | ||
|---|---|---|---|
| Submitted: | 25 Apr 2018 7:45 | Modified: | 18 May 2019 10:32 |
| Reporter: | Georgi Sotirov | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Workbench: SQL Editor | Severity: | S3 (Non-critical) |
| Version: | 8.0.11 RC | OS: | Windows (Microsoft Windows (Windows 7 Professional SP1 (6.1.7601)) |
| Assigned to: | CPU Architecture: | x86 | |
[25 Apr 2018 7:46]
Georgi Sotirov
Screen shot with the error as it appears in Workbench 8.0.11
Attachment: wb_sqled_select_window_error.png (image/png, text), 18.38 KiB.
[25 Apr 2018 8:01]
MySQL Verification Team
Hello Georgi, Thank you for the report and feedback. Thanks, Umesh
[26 Apr 2018 8:08]
Mike Lischke
Against which server version did you guys try? This is a query with windows and hence supported only for servers 8+. Workbench will show errors for anything below that.
[26 Apr 2018 9:09]
MySQL Verification Team
I had connected to MySQL Server 8.0.11 instance using WB 8.0.11 build and the query was taken from our docs and never really tried to run but to just observe the reported issue. Regards, Umesh
[26 Apr 2018 9:35]
Mike Lischke
OK, thanks, I see now.
[26 Apr 2018 18:27]
Georgi Sotirov
Just to note that, I have indicated Workbench version in field 'Version' of the bug and to confirm that I'm trying it over a connection to MySQL 8+ server.
[28 Nov 2018 10:01]
Jay Bloggs
I am using MySQL 8, workbench 8, Python 2.7. I was experiencing the same issue for an INSERT INTO statement. After reviewing the documentation I coudln't see anything wrong with my syntax. However I noticed that some of my columns were highlighted, as reserved words would be. I renamed all the affected columns and now it works as expected.
[7 Mar 2019 22:28]
Christine Cole
Posted by developer: Fixed as of the upcoming MySQL Workbench 8.0.16 release, and here's the changelog entry: A valid query using an appropriate server version for window functions displayed a syntax error at the opening parenthesis of the first OVER clause in the query editor. Thank you for the bug report.
[18 May 2019 10:32]
Georgi Sotirov
Verified fixed. Thanks.
[26 Apr 2020 18:38]
Edward Tilley
Workbench .16 doesn't run on 8.1 Windows - some bug in the release.
[7 May 2020 9:55]
Jayasree L
"SELECT" is no valid input at this position for this server version, expecting: '(', WITH
on the following query:
select name,age from database123.employeeinfo;
Description: I get the following strange error: "SELECT" is no valid input at this position for this server version, expecting: '(', WITH on the following query: SELECT E.ename, E.job, D.dname, E.sal, SUM(E.sal) OVER (PARTITION BY E.deptno) AS dept_sal, E.comm, SUM(IFNULL(E.comm, 0)) OVER (PARTITION BY E.deptno) AS dept_com FROM emp E, dept D WHERE E.deptno = D.deptno; Which I believe it's perfectly OK and it only uses the new in 8.0 window functions. How to repeat: Copy and paste the query from bug's description into a SQL Editor in MySQL Workbench 8.0.11 Suggested fix: No such error should be displayed.