★ wanayoo — archive 1999 https://github.com/phpmyadmin/sql-parser/issues/283Nouvelle recherche | Portail wanayoo
Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SQL query editor: MariaDB window function with alias gives bad linting errors #283

Open
markus-ksg opened this issue Jan 17, 2020 · 0 comments
Open
Labels
bug

Comments

@markus-ksg
Copy link

@markus-ksg markus-ksg commented Jan 17, 2020

Describe the bug

A MariaDB window function used together with an alias results in bad linting errors in the SQL query editor.

To Reproduce

  1. Go to https://demo.phpmyadmin.net/master-config/index.php?route=/table/sql&db=opengis&table=world_borders&server=1
  2. Enter query:
SELECT *, COUNT(*) OVER(PARTITION BY `REGION`) AS 'count(REGION)' FROM `world_borders`

=> Linting errors:

phpmyadmin-linting-error

Expected behavior

No error. Query is correct and executes fine.

Server configuration

  • phpMyAdmin version: latest (5.1.0)

Client configuration

  • Browser: Firefox
  • Operating system: Windows 10

Additional context

The error only shows up if there is an AS 'label'.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
2 participants
You can’t perform that action at this time.