#4495 (ok 4.3) Comment lines in multiquery

[Sten Öhman]

My version number is 4.2.3. Inserting multiquery commands with comment lines fails. This multiquerycommand works:

SET @d = 32267;

SELECT @d;

but not this:

SET @d = 32267;
-- ##
SELECT @d;

[Angelito M. Goulart]

I solved this issue adding preg_replace before mysqli_query. Can i proceed with pull request?

[Marc Delisle]

Sure. For your pull request, see
https://github.com/phpmyadmin/phpmyadmin/blob/master/CONTRIBUTING.md
and
https://github.com/phpmyadmin/phpmyadmin/blob/master/DCO

[Madhura Jayaratne]

Can you elaborate on what you meant by 'works' and 'does not work'. What are the outputs you get for each of the queries? Do you get a MySQL error?

[Sten Öhman]

Literally what I wrote:

phpMyAdmin executes all lines until a comment line and then it does
nothing at all. No error message, or other indication of what is wrong.
It simply ignores all lines following a comment line.

Best wishes
/Sten

Madhura Jayaratne skrev 2014-10-03 09:27:

Can you elaborate on what you meant by 'works' and 'does not work'. What
are the outputs you get for each of the queries? Do you get a MySQL error?

---

[bugs:#4495] http://sourceforge.net/p/phpmyadmin/bugs/4495 Comment
lines in multiquery

Status: open
Group: 4.2.3
Created: Thu Jul 24, 2014 07:48 AM UTC by Sten Öhman
Last Updated: Thu Aug 14, 2014 03:34 PM UTC
Owner: nobody

My version number is 4.2.3. Inserting multiquery commands with comment
lines fails. This multiquerycommand works:

SET @d = 32267;

SELECT @d;

but not this:

SET @d = 32267;
-- ##
SELECT @d;

---

Sent from sourceforge.net because you indicated interest in
https://sourceforge.net/p/phpmyadmin/bugs/4495/
https://sourceforge.net/p/phpmyadmin/bugs/4495

To unsubscribe from further messages, please visit
https://sourceforge.net/auth/subscriptions/
https://sourceforge.net/auth/subscriptions

--

Sten Öhman
Elfins Development AB, Centralplan 1, SE-590 71 Ljungsbro
Tel: (46) 709 526415
sten@elfins.eu

[Hugues Peccatte]

A PR has been sent for 4.3: https://github.com/phpmyadmin/phpmyadmin/pull/1388
As the SQL import had been rewritten, it can't be applied to 4.2.