Parser error shown with multiple statements in query box

[M393]

Describe the bug

An error is shown when multiple SQL statements are entered in the query box.

To Reproduce

Steps to reproduce the behavior:

1. Go to the query box
2. Input

SELECT 1; SELECT 1; 

3. See error

Expected behavior

No error shown.

Screenshots

Server configuration

• phpMyAdmin version: 5.2 and 6.0

[williamdes]

Thanks, I can confirm this on the current 5.2-dev version

[Ekott2006]

Can I work on this issue?

[williamdes]

Can I work on this issue?

For sure, please use QA_5_2 as a base branch for yours. And feel free to ask stupid questions, this can be a complicated subject involving changes on the sql-parser repository

[MoonE]

The problem is here in line 59:

phpmyadmin/libraries/classes/Controllers/LintController.php

Lines 47 to 59 in 99881de

	if (! empty($params['options'])) {
	$options = $params['options'];
	if (! empty($options['routineEditor'])) {
	$sqlQuery = 'CREATE PROCEDURE `a`() ' . $sqlQuery;
	} elseif (! empty($options['triggerEditor'])) {
	$sqlQuery = 'CREATE TRIGGER `a` AFTER INSERT ON `b` FOR EACH ROW ' . $sqlQuery;
	} elseif (! empty($options['eventEditor'])) {
	$sqlQuery = 'CREATE EVENT `a` ON SCHEDULE EVERY MINUTE DO ' . $sqlQuery;
	}
	}
	echo json_encode(Linter::lint("DELIMITER $$\n" . $sqlQuery . "$$\nDELIMITER ;\n"));

Always setting the delimiter here doesn't seem right. I guess this should only be done if editing routines/triggers/events.

[williamdes]

Again that delimiter 🙄
This last line seems like my fix..
Could you try to fix it?