#4206 Formatting of SQL statements is no longer working

[Jørgen Thomsen]

Formatting of SQL statements is no longer working. The syntax highlighting has been fixed (ticket 4200), but not the prettyprinting of SQL, which is important during development when importing a SQL statement from a program trace into phpMyAdmin to work on it.

[Marc Delisle]

Jørgen,
please describe a scenario to reproduce the problem.

Note that in 4.0.x we were doing some prettyprinting at the PHP level and some with CodeMirror at the JavaScript level, but in 4.1 we switched to CodeMirror only.

[Jørgen Thomsen]

Simply click the SQL tab to enter a SQL statement and execute it. Ticket 4200 fixed the syntax highlighting, but not the formatting of the result.

Input:

SELECT * FROM ordrer WHERE nr = 315 LIMIT 10

Just above the result table the SQL statement is listed

4.1.2:

SELECT * FROM ordrer WHERE nr = 315 LIMIT 10

4.0.7:

SELECT *
FROM ordrer
WHERE nr =315
LIMIT 10

[Marc Delisle]

We now rely on CodeMirror for this and I could not find a way to support this, so this won't be fixed.