Omega359 commented on PR #15413:
URL: https://github.com/apache/datafusion/pull/15413#issuecomment-2752424919
the sqlite tests need updating prior to this issue being pushed to main.
Confirmed test failures, here are a few examples:
```
External error: query is expected to fail with error:
(regex) DataFusion error: Execution error: avg\(DISTINCT\)
aggregations are not available
but got error:
DataFusion error: Arrow error: Invalid argument error: number of
columns(2) must match number of fields(3) in schema
[SQL] SELECT - COUNT ( * ) * AVG ( DISTINCT + col3 ) AS col3 FROM tab0 WHERE
NOT NULL <= + + col3
at ../../datafusion-testing/data/sqlite/index/random/100/slt_good_1.slt:11104
External error: query is expected to fail, but actually succeed:
[SQL] SELECT DISTINCT - COUNT ( * ) * AVG ( DISTINCT + 89 ) col4 FROM tab0
AS cor0 WHERE NULL NOT IN ( CAST ( NULL AS INTEGER ) + - 15 )
at
../../datafusion-testing/data/sqlite/index/random/1000/slt_good_8.slt:17760
External error: query is expected to fail, but actually succeed:
[SQL] SELECT - AVG ( DISTINCT 27 ) + - MAX ( DISTINCT col1 ) AS col4 FROM
tab0 WHERE NOT NULL <> - + 90
at ../../datafusion-testing/data/sqlite/index/random/1000/slt_good_0.slt:6040
External error: query is expected to fail with error:
(regex) DataFusion error: Execution error: avg\(DISTINCT\)
aggregations are not available
but got error:
DataFusion error: Arrow error: Invalid argument error: number of
columns(1) must match number of fields(2) in schema
[SQL] SELECT ALL - AVG ( DISTINCT 48 ) AS col4 FROM tab0 WHERE NOT - col4
BETWEEN ( NULL ) AND CAST ( 2 AS INTEGER )
at
../../datafusion-testing/data/sqlite/index/random/1000/slt_good_7.slt:38250
```
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
