OasisLMF / OasisDataManager

BSD 3-Clause "New" or "Revised" License
0 stars 0 forks source link

SQL tests fail in CI #5

Open sambles opened 4 months ago

sambles commented 4 months ago

Issue Description

Marked the following 4 checks as skipped, needs fixing https://github.com/OasisLMF/OasisDataManager/pull/2/commits/f628100f85b4ca76b9122aa8fef8a5b61bafbc6f

FAILED tests/df_reader/test_sql.py::test_sql__validity[SELECT CONCAT(A, B) as "count_A" FROM table] - ValueError: Metadata inference failed in `add`.
FAILED tests/df_reader/test_sql.py::test_sql__result__joined - ValueError: You are trying to merge on object and datetime64[ns] columns for key 'common_0'. If you wish to proceed you should use pd.concat
FAILED tests/df_reader/test_sql.py::test_sql__result__joined__where - ValueError: You are trying to merge on object and datetime64[ns] columns for key 'common_0'. If you wish to proceed you should use pd.concat
FAILED tests/df_reader/test_sql.py::test_sql__result__joined__multi - ValueError: You are trying to merge on object and datetime64[ns] columns for key 'common_0'. If you wish to proceed you should use pd.concat

test-errors.txt