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

Chatee ahora con Soporte

Regresar

Comentarios enviados

¿Este artículo solucionó su problema?

Seleccionar calificación

Título

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

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.
Resolución

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.
ID de defecto

TMB-1520

Comentarios enviados

¿Este artículo solucionó su problema?

Seleccionar calificación

Contenido recomendado

Historial del artículo:: Creado el: 8/21/2019
Última actualización: 5/7/2023

Título