phpmyadmin / phpmyadmin/phpmyadmin

"WITH ROLLUP" Shows "Expects delimiter" Syntax Error in PhpMyAdmin, SQL Executes OK - v10.5.25-MariaDB-cll-lve

Open
#19,787 1 comment 0 reactions 0 assignees View on GitHub

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)

Image

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

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.