<F5> current statement count off by 1

Toad for Oracle - Beta
1

Good Morning TOAD Team,

    I'm running the latest beta, 12.11.0.67.  On script execution, <F5>, the reported statement being executed is off by one.

I’m running a three statement script; the first and last are selecting a timestamp and execute very quickly; the middle statement is simply being timed.

select to_char(SYSTIMESTAMP,‘HH24:MI:SSxFF’) as “Start” from dual;

/* some statement another team ask to be tuned */

Select …

select to_char(SYSTIMESTAMP,‘HH24:MI:SSxFF’) as “End” from dual;

    When running I should only see  Processing script Task 2 of 3, but what I see is Task 3 of 3 (see attached) and a record count at some point.  The first and last SQL return one record.

    Please correct the Task counter.

Execution count off by one.docx (22 KB)

2

Good Morning TOAD Team,

It has been a month and nobody replied to this issue; it still exists, today with 12.11.0.82: One bunus suggestion in yellow below to make the Output tabe more usable when you select many long rows of data, too.

Reported to TOAD World on April 10th the current statement being executed when a script is executed is off by one until done (it is a higher count than actual, unless an error occurred, then it is lower by one than actual). I’m still doing my time check script, select timestamp; run query to be timed and finally select timestamp again. I’ve added to environment setting lines up front, too (so the output tab is usable): set linesize 4096; SET PAGESIZE 50000; (4) hey, these should be TOAD defaults so the output tab does not crash TOAD when running scripts that return lots of data – only 30K records and Output becomes unresponsive without these settings)

In this morning’s retest I see the navigator is off by one, too. The statement failed on the one under test but the navigator is showing the first timestamp being executed: (The navigator should be on the second select, not the first select as is shown below.

The select timastamp did not fail)

A new screen shot of originally reported issue; should say Task 2 of 3 in the pop-up box; but it says Task 3 of 3:

3

Sorry the images were scrubbed, a Word file with the images is attached.
Reported to TOAD World on April 10th the current statement being executed when a script is executed is off by one until done.docx (109 KB)

4

Sorry, the images were scrubbed; please see the attached.
Current statement being executed when a script is executed is off by one.docx (109 KB)

5

Hey Larry,

Your images got cut off in the Word document, so they don’t seem to show the issue you’re experiencing. However, I was able to reproduce your issue in-house based on your followup post. I wasn’t able to reproduce this issue when I looked at it last week because I had only included the three select statements you specified in your original posting. Under that circumstance, Toad seemed to number the statements correctly. It seems when you add the “set” commands, that throws off the numbering in the script execution.

We’re nearing the end of a release cycle, but let me see what we can do. The fortunate thing is that this only seems to affect the display in the progress dialog.

Thanks for letting us know about this!

-John

6

Thank you John!

            These are nits.

Larry Wickliffe

Monitoring,
Performance and Tuning Services Lead, Data and Business Intelligence Services (DABIS)

Office of Information Systems and Technology (OIST)

Employment and Training Administration (ETA). US Department of Labor

Wickliffe.Larry@dol.gov: 202-693-3485 FPB

l.wickliffe@computer.org
703-508-4945 Cell

From: John Bowman [mailto:bounce-jbowman@toadworld.com]

Sent: Friday, May 12, 2017 12:53 PM

To: toadoraclebeta@toadworld.com

Subject: RE: [Toad for Oracle - Beta Discussion Forum] current statement count off by 1

RE: current statement count off by 1

Reply by John Bowman

Hey Larry,

Your images got cut off in the Word document, so they don’t seem to show the issue you’re experiencing. However, I was able to reproduce your issue in-house based on your followup post. I wasn’t able to reproduce this issue when I looked at it last week because I had only included the three select statements you specified in your original posting. Under that circumstance, Toad seemed to number the statements correctly. It seems when you add the “set” commands, that throws off the numbering in the script execution.

We’re nearing the end of a release cycle, but let me see what we can do. The fortunate thing is that this only seems to affect the display in the progress dialog.

Thanks for letting us know about this!

-John

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta Forum notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.

7

Good Morning John,

 Just noticed that off by 1 is still there, but now the total number of statements is off by 2;  Says executing 1 of 1  when actually executing 2 of 3.  (Beta 12.12.0.27)

Larry

703-508-4945

8

Hey Larry,

My apologies: unfortunately, I wasn’t able to get to this issue for this release. We’re currently at the end of the current release, and we had a lot to try to accomplish for this release. With it being such a short release cycle, and this only affecting the display in the progress dialog, I didn’t get much time to tackle this issue. There is a work item created for this issue, though. I’ll do my best to address it for the start of the next beta cycle.

-John