Heidi seizes up when running queries that include JSON/LONGTEXT fields.

Hi,

I've recently noticed when running simple queries (e.g. just returning one row) where the query includes JSON/LONGTEXT fields that the query starts and the result is shown and the status console shows found rows and query duration time etc, but a little box appears (see blue arrow in image heidi-1.png) over the query and the JSON field is not populated/selectable (red arrow).

I then can't do anything further. If I try to close the application I get the status message "Cannot close tab with running query". I have to then force the application down using Task Manager. See image heidi-2.png

The JSON data is long but not THAT long (e.g. 50-100KB).

The problem is intermittent but happens more often than not.

Many thanks.

Steve

Yes, I can confirm this behavior too.

It is annoying as it garbles the queries after some time and you can't read the whole query. Copy-pasting everything still works so I copy it to a new tab, but that only resolves it for a short period.

That is a known issue with larger text values in grids. Try setting Tools > Preferences > Grid formatting > Lines of text in grid rows to "2" or more - that issue will get even worse then. I was debugging already and saw there were tons of Windows paint messages flying through the air, the longer the text the more messages. I was not yet able to fix that.

It looks like the query section tries to fall-back to a initial dimension and then this dimension is overwritten by the required dimension but on some "Z" level this initial dimension is still active?

I didn't notice any differences in behavior when I changed the grid rows quantity.