The latter ignores NULLs
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.
-
-
-
That explains some of it. But how about the difference between `SELECT COUNT(*) FROM users` vs `SELECT COUNT(users.*) FROM users`, which still produces a different query plan, and returns the same value even if all columns are null
- 11 more replies
New conversation -
-
- 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.