Following #25543 and, more specifically, #25552 which only contained a couple of tests, this issue is for testing out a few more scenarios with pushing, querying, and pruning the metadata cache.

• A test case for catching the case where multiple predicates are specified on a single column in the cache feat: metadata cache provider and datafusion trait impls #25566
• Rows that do not contain all columns in the cache are ignored test: distinct cache ignores rows with nulls #26306