I have a query that I’m expecting to display 50903 records. But when I display all the records I only get 50902 records. When I wrap the query in a SELECT COUNT(*) I get the count I expect (50903).
I was told by a co-worker that there is a ‘bug’ with toad for db2 where this could happen.
Any one ever heard of this? if so, anyone have a fix?
I’m running TOAD for DB2 18.104.22.1688