Menu

#4714 (ok 4.3.8) Forced ORDER BY for own sql statements

4.3.7
fixed
None
1
2015-01-24
2015-01-19
Michael
No
  • browse a database table "example_table"
  • click on a column of this table to order by that "data_field"
  • phpmyadmin will execute "SELECT * FROM example_table ORDER BY data_field DESC"
  • now click on "SQL" to execute an own statement:
    "SELECT * FROM example_table"
  • even though I do not want a specific order by, the old order by is forced by phpmyadmin:
    "SELECT * FROM example_table ORDER BY data_field DESC"
  • phpmyadmin should not force such saved settings on own statements in the console

Discussion

  • Rakesh Kumar

    Rakesh Kumar - 2015-01-19

    Hi,
    I also think that PMA should not include previous statements when executing the next query in SQL console.

    Should I try to fix it?

     
    • Marc Delisle

      Marc Delisle - 2015-01-20

      Rakesh,
      please do.

       
  • Rakesh Kumar

    Rakesh Kumar - 2015-01-20

    Here is my Pull request : https://github.com/phpmyadmin/phpmyadmin/pull/1463

    Please review.

     
  • Marc Delisle

    Marc Delisle - 2015-01-20
    • assigned_to: Marc Delisle
     
  • Marc Delisle

    Marc Delisle - 2015-01-20
    • summary: Forced order by for own sql statements --> (ok 4.3.8) Forced ORDER BY for own sql statements
    • status: open --> resolved
    • Priority: 5 --> 1
     
  • Marc Delisle

    Marc Delisle - 2015-01-24
    • Status: resolved --> fixed