Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
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.
