Strange SQL results, can't explain cause
I am comparing the use of SQL via Analytics between instances used by 2 different customers, both on version 22A.
If I run this SQL on InstanceA:
select count(*) from po_headers_all
I get a result of 133487, regardless of what the "Rows" select menu is set to (e.g. 5, 10, 50, 100 or 200).
For InstanceB, the same SQL returns a value of 5 if Rows is set to 5, 50 if Rows is set to 50 and so on.
Screenshots show what I mean.