phpmyadmin / phpmyadmin/phpmyadmin
"WITH ROLLUP" Shows "Expects delimiter" Syntax Error in PhpMyAdmin, SQL Executes OK - v10.5.25-MariaDB-cll-lve
Nobody has claimed this yet.
- Dominant language
- PHP
- Stars
- 7.9k
- Forks
- 3.6k
- Avg merge
- 4d 18h
- Merged PRs (30d)
- 36
Description
A syntax error is displayed for the MariaDB example at "https://mariadb.com/docs/server/reference/sql-statements/data-manipulation/selecting-data/select-with-rollup".
A new statement was found, but no delimiter between it and the previous one. (near WIDTH)
As you can see from the SQL output, the query actually works. If there is an option I need to set then I haven't managed to find it.
From the homepage:
Database server
Server: Localhost via UNIX socket
Server type: MariaDB
Server connection: SSL is not being used Documentation
Server version: 10.5.25-MariaDB-cll-lve - MariaDB Server
Protocol version: 10
User: wcipporg@localhost
Server charset: cp1252 West European (latin1)
Web server
cpsrvd 11.110.0.50
Database client version: libmysql - mysqlnd 8.1.31
PHP extension: mysqli Documentation curl Documentation mbstring Documentation
PHP version: 8.1.31
phpMyAdmin
Version information: 5.2.1
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by reproducing the MariaDB WITH ROLLUP example from the linked documentation page in phpMyAdmin 5.2.1 against MariaDB 10.5.25, comparing the displayed delimiter error with successful execution. Trace the SQL validation path responsible for the false syntax report; done means the valid example no longer shows that error, or the incompatibility is clearly documented.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- mariadb, php
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100