bugdbsh - Bugs: bug #31232, Inconsistency in display query time


bug #31232: Inconsistency in display query time

Submitted by:  Ben Spencer <dangerousben>
Submitted on:  Sat 02 Oct 2010 08:14:55 PM UTC  
Category:  None Severity:  3 - Normal
Item Group:  None Status:  None
Privacy:  Public Assigned to:  None
Open/Closed:  Open

Add a New Comment(Rich Markup)

You are not logged in

Please log in, so followups can be emailed to you.


Sat 02 Oct 2010 08:14:55 PM UTC, original submission:

If you type something like 'SELECT * FROM foo; ' the query time will not be displayed. This is because the action is actually ' ', which gets caught by the default case in output.c, but the query time is only displayed if the action is 'g' or 'G'.

There are two considerations here:

It is unintuitive that the above string should use ' ' as an action. A space should be interpreted as the default action, but it would be nice to generalise this (maybe any unrecognised action should be interpreted as the default action, so we don't need the default case in output.c - implementing #31198 would make this easy).

It seems a little weird to only display query time for 'g' and 'G'. If the query wasn't a select we don't care what the action was. Perhaps the query time should always be displayed, but it should always go to the screen, bypassing any redirects (but what about pagers? worth noting that mysql sends neither the row count nor the query time to the pager).

Ben Spencer <dangerousben>
Project Administrator


(Note: upload size limit is set to 16384 kB, after insertion of the required escape characters.)

Attach Files:

No files currently attached


Depends on the following items: None found

Items that depend on this one: None found


Carbon-Copy List
  • -email is unavailable- added by dangerousben (Submitted the item)

    Do you think this task is very important?
    If so, you can add your encouragement to it.
    This task has 0 encouragements so far.

    Only logged-in users can vote.


    Please enter the title of George Orwell's famous dystopian book (it's a date):



    No changes have been made to this item

    Back to the top

    Powered by Savane 3.3