phpmyadmin/sql-parser

erroneously reports syntax error when calling stored procedure with schema

mousumis opened this issue · 2 comments

mousumis commented

Describe the bug

The phpMyAdmin editor shows errors about tokens when running a call statement for stored procedure with the schema included. Example screenshot is included below

To Reproduce

Steps to reproduce the behavior:

  1. Go to phpMyAdmin
  2. Click on the SQL tab
  3. Run a stored procedure call script which includes a schema
  4. Observe parsing errors though the command is correct and can execute correctly

Expected behavior

No errors should be seen in the editor

Screenshots

image

Server configuration

  • Operating system: CentOS-7
  • Web server:
  • Database version: 10.5.10-MariaDB
  • PHP version: 7.4.24
  • phpMyAdmin version: 4.9.7

Client configuration

  • Browser: Chrome
  • Operating system: MacOS

Additional context

ibennetch commented

I confirm this issue (which actually exists in our sql-parser library):

./bin/lint-query --query 'call foo.bar'
phpmyadmin/phpmyadmin#1: Unexpected token. (near "bar" at position 9)
  • 👍1
williamdes commented

Thank you for the report, I moved it in the right place