Out of Space issue when selecting data tab of a large table

Hi,
I get the following error when selecting a table name with the data tab active.
SQL Error (3): Error writing file '/tmp/MY9vaRnU' (Errcode: 28 - No space left on device)

SELECT * FROM `dbID`.`session` ORDER BY `status_time` DESC LIMIT 1000;

Is what Heidi is doing, sadly, the column it auto-selected is not one which has a key on it, and is not helped I am sure that this table is rather large ~3GB

Any ideas why Heidi auto selects this column?

8.3.0.4857, also on 47xx too

The error says your harddisk on the server is full.

If that's a query in the data grid, you can deselect some columns on it, using the "Columns" button/dialog on the very top right.

SELECT * FROM `dbID`.`session` ORDER BY `status_time` DESC LIMIT 1000;

If I rerun the query with the following, it works perfectly fine and fast

SELECT * FROM `dbID`.`session'LIMIT 1000;

When i click on the table with the data tab active, why does Heidi make the select with the ORDER BY? Where can I control this order by ?

Right click the table in the database tree, then click "Reset data filter". That removes a *filter*, not the order by clause.

See here for a workaround.

Works perfectly, thank you