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

 
 

bug #31232: Inconsistency in display query time

Submitter:  Ben Spencer <dangerousben>
Submitted:  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
* Mandatory Fields

Add a New Comment Rich Markup
   

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>
Group administrator

 

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

Attach Files:
   
   
Comment:
   

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)
  •  

    There are 0 votes so far. Votes easily highlight which items people would like to see resolved in priority, independently of the priority of the item set by tracker managers.

    Only logged-in users can vote.

     

    No changes have been made to this item

    Back to the top

    Powered by Savane 3.13-3230.
    Corresponding source code