Toad World® Forums

Bug: Count Dataset Rows


#1

The number returned by clicking ‘Count dataset rows’ in the results pane does not match the number of records when you fetch all rows is performed.

I’m using version 6.1.0.1094.


#2

Hi Matthew,

Would you mind providing us with a screenshot of the issue? I could not reproduce this.

Gwen


#3

I have PM’d you the SQL used for these screenshots:
row_count-869.jpeg


#4

I have PM’d you the SQL used for these screenshots:
fetch_all-843.jpeg


#5

Hi Matthew,

Thanks for the screenshots and queries. I can now reproduce the issue. The bug was caused by the GROUP BY clause and it has been logged in our system.

Cheers,
Gwen