Return
-
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