#4206 Formatting of SQL statements is no longer working

4.1.2
wont-fix
nobody
5
2014-01-09
2013-12-29
No

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.

Discussion

  • Marc Delisle

    Marc Delisle - 2013-12-29

    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

    Jørgen Thomsen - 2013-12-29

    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

    Marc Delisle - 2014-01-09

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

     
  • Marc Delisle

    Marc Delisle - 2014-01-09
    • status: open --> wont-fix