Toad World® Forums

Bug with Cancelling Long Running SQL Queries


#1

In the most recent build if I write a SQL query that takes a while to run (at
least 10 seconds) and I cancel the query before it finished running, then go to
the object explorer and change the type of object I am viewing (so for example I
was viewing tables, then I go to look at views) it will show no objects in the
database. If I try to look at any type of object (view, stored procs,
functions, etc) it will show nothing until I disconnect from the database and
then reconnect. I have reproduce this multiple times so I believe it has to do
with cancelling the SQL query in the editor and then trying to use the object
explorer.


Charles Haines
Senior Software Developer
P: (410) 535-5590 x1196

Recorded Books, LLC
http://www.recorded books.com


#2

Hello Charles,

We can’t reproduce this issue on 362 development build. Could you please try it on next available beta?

thanks in advance,
Alexander


#3

Hello Charles,

We can’t reproduce this issue on 362 development build. Could you please try it on next available beta?

thanks in advance,
Alexander


#4

Sure can. When should we expect the next beta build?

Thanks,


Charles Haines
Senior Software Developer
P: (410) 535-5590 x1196

Recorded Books, LLC
http://www.recorded books.com

On Wed, May 26, 2010 at 1:53 AM, Alexander Maximov
quest.com > wrote:

Message from: Alexander Maximov

Hello Charles,

We can't reproduce this issue on 362 development build. Could you please
try it on next available beta?

thanks in advance,
Alexander

Historical Messages

Author: Alexander Maximov
Date: Tue May 25 22:53:41 PDT 2010
Hello Charles,

We can't reproduce this issue on 362 development build. Could you please
try it on next available beta?

thanks in advance,
Alexander

__

Author: Chuck HAines
Date: Tue May 18 06:01:01 PDT 2010

In the most recent build if I write a SQL query that takes a while to run
(at least 10 seconds) and I cancel the query before it finished running,
then go to the object explorer and change the type of object I am viewing
(so for example I was viewing tables, then I go to look at views) it will
show no objects in the database. If I try to look at any type of object
(view, stored procs, functions, etc) it will show nothing until I disconnect
from the database and then reconnect. I have reproduce this multiple times
so I believe it has to do with cancelling the SQL query in the editor and
then trying to use the object explorer. – Charles Haines Senior Software
Developer P: (410) 535-5590 x1196 Recorded Books, LLC http://www.recorded
books.com

__
____________ _________ _________ _________

#5

We’re trying to post it before coming long weekend.

Igor.