You are viewing a plain text version of this content. The canonical link for it is here.
Posted to github@arrow.apache.org by GitBox <gi...@apache.org> on 2022/09/28 21:53:12 UTC

[GitHub] [arrow-datafusion] andygrove opened a new issue, #3646: Internal error: Failed to coerce types Decimal128(10, 2) and Boolean in BETWEEN expression

andygrove opened a new issue, #3646:
URL: https://github.com/apache/arrow-datafusion/issues/3646

   **Describe the bug**
   
   Postgres:
   
   ```
   select * from test where a between (select distinct a from test) and (select distinct b from test);
     a   |  b   
   ------+------
    1.00 | 2.00
   (1 row)
   ```
   
   DataFusion:
   
   ```
   select * from test where a between (select distinct a from test) and (select distinct b from test);
   
   Internal("Optimizer rule 'type_coercion' failed due to unexpected error: Internal error: Failed to coerce types Decimal128(10, 2) and Boolean in BETWEEN expression. This was likely caused by a bug in DataFusion's code and we would welcome that you file an bug report in our issue tracker")
   ```
   
   **To Reproduce**
   As shown.
   
   **Expected behavior**
   Should work.
   
   **Additional context**
   None
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscribe@arrow.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [arrow-datafusion] andygrove closed issue #3646: Internal error: Failed to coerce types Decimal128(10, 2) and Boolean in BETWEEN expression

Posted by GitBox <gi...@apache.org>.
andygrove closed issue #3646: Internal error: Failed to coerce types Decimal128(10, 2) and Boolean in BETWEEN expression
URL: https://github.com/apache/arrow-datafusion/issues/3646


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscribe@arrow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [arrow-datafusion] andygrove commented on issue #3646: Internal error: Failed to coerce types Decimal128(10, 2) and Boolean in BETWEEN expression

Posted by GitBox <gi...@apache.org>.
andygrove commented on issue #3646:
URL: https://github.com/apache/arrow-datafusion/issues/3646#issuecomment-1263621169

   It looks like the type coercion aspect has already been fixed in a recent commit. It now fails with a different error:
   
   ```
   ❯ create external table test (a decimal(10,2), b decimal(10,2)) stored as csv location 'test.csv';
   0 rows in set. Query took 0.002 seconds.
   ❯ select * from test where a between (select distinct a from test) and (select distinct b from test);
   
   NotImplemented("Physical plan does not support logical expression (<subquery>)")
   ```


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscribe@arrow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [arrow-datafusion] andygrove commented on issue #3646: Internal error: Failed to coerce types Decimal128(10, 2) and Boolean in BETWEEN expression

Posted by GitBox <gi...@apache.org>.
andygrove commented on issue #3646:
URL: https://github.com/apache/arrow-datafusion/issues/3646#issuecomment-1263624040

   I filed a new issue https://github.com/apache/arrow-datafusion/issues/3667 and will close this one


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscribe@arrow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


[GitHub] [arrow-datafusion] andygrove commented on issue #3646: Internal error: Failed to coerce types Decimal128(10, 2) and Boolean in BETWEEN expression

Posted by GitBox <gi...@apache.org>.
andygrove commented on issue #3646:
URL: https://github.com/apache/arrow-datafusion/issues/3646#issuecomment-1263606607

   @liukun4515 You might be interested to see this type coercion issue - I plan on looking at it next week


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscribe@arrow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org