Query reader hangs on queries returning zero rows (5.8.2)

Hi all

We’re about to migrate to a new DB, so I started testing KNIME (5.8.2) on it and at some point I realised query reader nodes hang indefinitely (well, they timeout after 10 minutes, but that’s probably just our configs) on SQL queries that should return no rows. This happens even when I run something as simple as:

select * from random_table where 1=0

A few things I’ve tested:

*

The same queries run fine on 4.7.4 and 4.4.2

*

No issues at all running the same queries on workbench.

*

Using DB connector instead of MySQL connector makes no difference

*

The DB is MariaDB 6.8.3, I tried on a different DB, same MariaDB version, and no issue at all

*

Also tried all 3 different drivers available on the connector (8.0.29, 8.0.11, 5.1.49), same issue

*

Looked around and tried different jdbc connector parameters like

defaultFetchSize=1

and

useInformationSchema=false

, but no change

Any ideas on what could be happening or possible workarounds?

Thanks