SOLR-8845 found that Spark runs queries with "where 1 = 0" This should be reduced and removed from the plan by the Calcite planner and not have to be pushed down to Solr.
Integrate Apache Calcite into the SQLHandler
SolrJ JDBC - Ensure that Spark works with SolrJ JDBC
This patch adds the Constant Reduction rules and tests that 1 = 0 works correctly with the new rules in place.
Once SOLR-8593 is committed to branch_6x this should be pulled back too.
Joel Bernstein - Any thoughts on this?
Commit 686fbd3ba294e7a71f08b2821b5c3ce50235c78b in lucene-solr's branch refs/heads/master from Kevin Risden
[ https://git-wip-us.apache.org/repos/asf?p=lucene-solr.git;h=686fbd3 ]
SOLR-10171: Add Constant Reduction Rules to Calcite Planner
Commit 08ad0e3316bfa0ff1dbf79f54a6fbbc814943bcf in lucene-solr's branch refs/heads/branch_6x from Kevin Risden
[ https://git-wip-us.apache.org/repos/asf?p=lucene-solr.git;h=08ad0e3 ]