Menu

#11 GUI locks up when using aggregate funcs

Bug
open-accepted
GUI (5)
4
2002-04-05
2002-01-07
Sam Tilders
No

Executing a query like:

SELECT count(*) FROM sometable

locks up the GUI and when it returns the Query stop
button is still enabled and no results appear.

However if one does:

SELECT count(*) AS somealias FROM sometable

the results appear with a column headed 'somealias'

So it seems like the results formatting might be
having trouble with aggregate functions not having
column names?

Discussion

  • Michael J. Cannon

    Logged In: YES
    user_id=32217

    Checking source...do you have a workaround yet?

    dedmike

     
  • Michael J. Cannon

    • priority: 5 --> 4
    • assigned_to: nobody --> dedmike
    • status: open --> open-accepted
     
  • Nobody/Anonymous

    Logged In: NO

    I did a count(*) using oracle as back end it worked for me

     
  • Nobody/Anonymous

    Logged In: NO

    Works fine with MySQL too...probably need more detail on
    what the database is, driver, etc, where it fails.

     

Log in to post a comment.

MongoDB Logo MongoDB