Is there ever a case where `SELECT COUNT(*)` would return a different result in `SELECT COUNT(something)` assuming no group by clause? I'm curious why they generate different query plans on virtually every backend.
-
Best guess though is ID gets it
-
-
users.* might include the id column which may not be NULL which may cause it to count anyways.
-
but again, guessing at this point. I'd be curious to know as well.
End of conversation
New conversation -
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.