Query By Id Crashes When Longtext Column Exists

[normk]

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