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

Query By Id Crashes When Longtext Column Exists

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Query By Id Crashes When Longtext Column Exists

  • This topic is empty.
Viewing 0 reply threads
  • Author
    Posts
    • November 4, 2009 at 8:13 pm #11739
      normk
      Member

      I have a table in mysql that has a longtext column and an id integer primary key. I can view the table in sqlyog table view tab and sort it on the id column. When I try to query it for a specific record where id = some known value, SqlYog shows the hourglass cursor and never returns. I cannot terminate the query and I must kill the process. This used to work fine but is no longer working. The size of the data in the longtext field is not very big (a few hundred bytes).

      When I run the query from mysql command line on the server, it returns fine, consistently.

      My environment:

      Client:

      sqlyog enterprise 8.17

      windows xp pro sp3

      Server:

      mysql 5.0.68

      centos 2.6.9-67

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