Andy Grove

[EPIC] Type-coercion improvements

1

**Is your feature request related to a problem or challenge? Please describe what you are trying to do.** I am running into type-coercion errors and am probably going to be...

Fix inconsistencies in type coercion logic

3

**Describe the bug** The TypeCoercion rule incorrectly uses `coerce_types` (which should probably be renamed to `get_binary_op_type` because it determines the output type of a binary expression) to determine the types...

filter_push_down internal error

1

**Describe the bug** I have queries failing with: ``` Error: Internal("Optimizer rule 'filter_push_down' failed due to unexpected error: Internal error: on_lr_is_preserved cannot be appplied to SEMI/ANTI-JOIN nodes. This was likely...

common_sub_expression_eliminate internal error

1

**Describe the bug** ``` Error: Internal("Optimizer rule 'common_sub_expression_eliminate' failed due to unexpected error: Error during planning: 'Date64

**Describe the bug** ``` Error: Internal("Optimizer rule 'scalar_subquery_to_join' failed due to unexpected error: Error during planning: Optimizing disjunctions not supported! at /home/andy/git/apache/arrow-datafusion/datafusion/optimizer/src/utils.rs:91") ``` **To Reproduce** tbd **Expected behavior** **Additional context**

**Describe the bug** Apologies for the vague bug report but I wanted to add this to a list tracking work I need to do. Now that CAST no longer changes...

**Describe the bug** `d3.d_date > d1.d_date + INTERVAL '5 days'` fails with `Int64 AND Boolean' can't be evaluated because there isn't a common type to coerce the types to` `d3.d_date...

**Is your feature request related to a problem or challenge? Please describe what you are trying to do.** I can't see anything in the user guide or examples showing how...

Make type coercion rule more robust

1

**Is your feature request related to a problem or challenge? Please describe what you are trying to do.** Dask SQL project is seeing this: ``` Skipping optimizer rule TypeCoercion due...

# Which issue does this PR close? Closes https://github.com/apache/arrow-ballista/issues/272 # Rationale for this change Trying to improve the user guide # What changes are included in this PR? - Spit...