Do not attempt to merge an empty DataFrame with the time data
Do not use the intersection of the set of columns in fresh & cache data when one of them has no columns because the intersection would always be an empty set
Verification
Run
poetry run python tests/test_against_cache.py --shot 177985
And the test will say the comparison failed because Have fresh data and Missing cache data.
Problem
The test against cache threw an error when using a shot without cached sql data.
Proposed solution
A few small logic changes including
Verification
Run
And the test will say the comparison failed because
Have fresh data and Missing cache data
.All other tests pass/xfail appropriately.