Menu

#4593 (ok 4.3.1) Manual "SELECT" doesn't change active table

4.3.0
fixed
None
5
2014-12-08
2014-07-19
No

Originally brought up in https://stackoverflow.com/questions/24551187/executing-select-query-is-not-switching-environment-to-new-table

When changing tables through manually executed SQL, we don't behave consistently. For instance, in the sakila database, click to browse 'actors'. Then use the Inline edit button to change the SQL to SELECT * FROM category. The expected result would be to have the active table changed to 'category' -- and the navigation pane does change the highlighted table, but the active table for tabs and the breadcrumb list stay with 'actors'.

Additionally, entering a query directly to the SQL tab does not change the navigation pane or breadcrumb list.

However, changing databases this way does work as expected (clicking the SQL tab and typing USE employees; has the desired effect).

Is this possible to improve?

Discussion

  • Marc Delisle

    Marc Delisle - 2014-11-16

    Ticket moved from /p/phpmyadmin/feature-requests/1536/

     
  • Madhura Jayaratne

    This behavior is mostly due to the ajaxification of SQL areas. I'm not sure whether this can be fixed without undoing them.
    May be since we use ajax for page loading itself, removing these custom ajaxifications won't harm much???

     
  • Marc Delisle

    Marc Delisle - 2014-12-06
    • assigned_to: Hugues Peccatte
    • Group: Needs_decision --> 4.3.0
     
  • Marc Delisle

    Marc Delisle - 2014-12-06
    • summary: Manual "SELECT" doesn't change active table --> (ok 4.3.1) Manual "SELECT" doesn't change active table
    • status: open --> resolved
     
  • Marc Delisle

    Marc Delisle - 2014-12-08
    • Status: resolved --> fixed