row_number() over sql parse error

[attson]

eg:

        $sql = <<<EOF
select id,
       pid,
       appid,
       appname,
       row_number() over (partition by pid, appid) as `group_row_number`
from game group by appname
EOF;

        $parser = new \PhpMyAdmin\SqlParser\Parser($sql);

        dump($parser->statements[0]->build());
        dump($parser->statements[0]->expr);

output:

SELECT id, pid, appid, appname, row_number()  (partition by pid, appid) AS `over` FROM game GROUP BY appname

...

  4 => PhpMyAdmin\SqlParser\Components\Expression
    +database: null
    +table: null
    +column: "row_number"
    +expr: "row_number()  (partition by pid, appid)"
    +alias: "over"
    +function: "row_number"
    +subquery: null
  }

...

expected

return an incorrect alias, expected to be group_row_number.

env

PHP 8.1.30 (cli) (built: Sep 27 2024 04:07:29) (NTS)
Copyright (c) The PHP Group
Zend Engine v4.1.30, Copyright (c) Zend Technologies
    with Zend OPcache v8.1.30, Copyright (c), by Zend Technologies
    with Xdebug v3.3.2, Copyright (c) 2002-2024, by Derick Rethans

phpmyadmin/sql-parser 5.10.1

phpmyadmin/sql-parser 5.10.3 same error

[williamdes]

I think this may be a duplicate of #188 or be related to it