I have a couple of views that didn't work with standard core node.module (Drupal v. 7.32).
The first view is a query that has a node table appearing twice with a left join. Patch #174 fixed the issue.
Then I built another view (a completely different one) with an Entity Reference in the Relationship area. The view has an exposed filter based on a field belonging to the referenced Entity.
Patch #174 caused a problem since the pager of the view disappeared each time I filled in the filter field even though there were more rows matching the specified criteria than those displayed in the first page.
After applying patch #195 the issue is fixed. The SQL code generated by the view is the same both under patch #174 and #195. But now the pager works correctly. I noticed that under patch #195 the internal "count_query" (see code in function execute() in module views_plugin_query_default.inc) now returns the correct number of total rows and thus the pager is properly displayed.
#195 did a great job for me for both views. Thanks a lot.