Querying a SELECT statement in an EDB database causes Toad to hang, as the 'Number of fetch rows' option is being ignored
说明
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.
解决办法
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.
