Bug: Count Dataset Rows

SQL Navigator
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
row_count-869.jpeg739×514 43.8 KB

4

I have PM'd you the SQL used for these screenshots:

fetch_all-843.jpeg
fetch_all-843.jpeg725×513 45.6 KB

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