Querying a SELECT statement in an EDB database causes Toad to hang, as the 'Number of fetch rows' option is being ignored (4239066)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Querying a SELECT statement in an EDB database causes Toad to hang, as the 'Number of fetch rows' option is being ignored
Description

When using an EDB 11.3 database, and running a select statement when there are many rows in a table, the 'Number of fetch rows' option is being ignored and Toad Edge hangs whilst trying to return all rows.
Resolution

WORKAROUND:
At present, the limit has to be set manually in the query.
You can set the limit on returned rows from the query using the following statement:

First 100 rows:
SELECT * FROM test_table LIMIT 100 ;

next 100 rows:
SELECT * FROM test_table LIMIT 100 OFFSET 100;

STATUS:
The issue has been fixed in Toad Edge version 2.1.2. It can be downloaded here.
Defect ID

TMB-1520

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title