Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Sort problem with numeric columns

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Sort problem with numeric columns

  • This topic is empty.
Viewing 3 reply threads
  • Author
    Posts
    • May 28, 2003 at 8:23 am #7976
      AdminIT
      Member

      Hi,

      First of all this is my first message on this board, I just installed SQLyog and it seems very cool, good work.

      I noticed a little bug/problem, when I click on a column header that hold numeric value the sort is done alphabetically so i have:

      1

      10

      11

      12

      2

      Hope you can solve this.

      Byez.

    • May 28, 2003 at 8:42 am #14386
      Shadow
      Member

      It works perfectly for me (v3.11). What is the exact column type?

    • May 28, 2003 at 4:08 pm #14387
      AdminIT
      Member

      Ops, you are right, it happens only with query like this:

      SHOW PROCESSLIST

      Perhaps for table-based queries SQLyog remember the column type…

      Byez.

    • May 28, 2003 at 8:38 pm #14388
      CalEvans
      Member

      This is a mysql bug or issue. (I'm not sure it's a bug. It may be designed that way)

      Show process list gives back a table of all chars (or varchars) SQLyo is actually handeling them correctly.

      =C=

  • Author
    Posts
Viewing 3 reply threads
  • You must be logged in to reply to this topic.