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

[markus-ksg]

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:

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'.

[san-ki]

this has not yet resolved i guess. i am getting same error

[williamdes]

this has not yet resolved i guess. i am getting same error

most probably since it's still open
Maybe it's a challenge @niconoe- would like to solve?

[niconoe-]

I'll take a deeper look as I'm a little bit free today, but at the first sight, it's not really an easy fix… I can't promise anything