alamb opened a new issue, #26672: URL: https://github.com/apache/datafusion/issues/26672
This ticket lists all the open wrong results results bugs; Please add any new issues you find in comments. Specifically where DataFusion produces a result but that result is incorrect. # Rationale / Call To Action As a foundational piece of technology, it is important that users can count on DataFusion's results to be correct. For the most part I think we do a very good job and we have many [tests](https://datafusion.apache.org/contributor-guide/testing.html) As part of my ongoing quest to figure out how to prioritize all the proposals / PRs to DataFusion, I think correctness bugs are quite high on the list so I wish to track them here. I have also been needled several times in discussions with various professors from TUM (who shall remain nameless) that they don't think DataFusion takes correctness seriously. While I disagree with this sentiment, I do think it is worth time focusing on correctness. # The List ™️ Correlated subqueries and decorrelation - [ ] https://github.com/apache/datafusion/issues/8241 - [ ] https://github.com/apache/datafusion/issues/23534 - [ ] https://github.com/apache/datafusion/issues/24960 - [ ] https://github.com/apache/datafusion/issues/25347 - [ ] https://github.com/apache/datafusion/issues/25480 - [ ] https://github.com/apache/datafusion/issues/25808 - [ ] https://github.com/apache/datafusion/issues/26014 - [ ] https://github.com/apache/datafusion/issues/26032 - [ ] https://github.com/apache/datafusion/issues/26234 - [ ] https://github.com/apache/datafusion/issues/26508 - [ ] https://github.com/apache/datafusion/issues/26569 - [x] https://github.com/apache/datafusion/issues/24513 - [x] https://github.com/apache/datafusion/issues/25258 - [x] https://github.com/apache/datafusion/issues/25283 - [x] https://github.com/apache/datafusion/issues/25336 - [x] https://github.com/apache/datafusion/issues/25340 - [x] https://github.com/apache/datafusion/issues/25473 - [x] https://github.com/apache/datafusion/issues/25474 - [x] https://github.com/apache/datafusion/issues/25507 - [x] https://github.com/apache/datafusion/issues/25519 - [x] https://github.com/apache/datafusion/issues/25792 - [x] https://github.com/apache/datafusion/issues/25834 Sort order and equivalence / ordering properties - [ ] https://github.com/apache/datafusion/issues/4649 - [ ] https://github.com/apache/datafusion/issues/25052 - [ ] https://github.com/apache/datafusion/issues/25817 - [ ] https://github.com/apache/datafusion/issues/26036 - [ ] https://github.com/apache/datafusion/issues/26162 - [ ] https://github.com/apache/datafusion/issues/26656 - [x] https://github.com/apache/datafusion/issues/25232 - [x] https://github.com/apache/datafusion/issues/25353 - [x] https://github.com/apache/datafusion/issues/25506 - [x] https://github.com/apache/datafusion/issues/25779 - [x] https://github.com/apache/datafusion/issues/26646 TopK, LIMIT and dynamic filters - [ ] https://github.com/apache/datafusion/issues/26029 - [ ] https://github.com/apache/datafusion/issues/26054 - [ ] https://github.com/apache/datafusion/issues/26416 - [ ] https://github.com/apache/datafusion/issues/26454 - [ ] https://github.com/apache/datafusion/issues/26617 - [ ] https://github.com/apache/datafusion/issues/26618 - [x] https://github.com/apache/datafusion/issues/24272 - [x] https://github.com/apache/datafusion/issues/24352 - [x] https://github.com/apache/datafusion/issues/24807 - [x] https://github.com/apache/datafusion/issues/25244 - [x] https://github.com/apache/datafusion/issues/25263 - [x] https://github.com/apache/datafusion/issues/25296 - [x] https://github.com/apache/datafusion/issues/25998 - [x] https://github.com/apache/datafusion/issues/26050 Window functions - [x] https://github.com/apache/datafusion/issues/25471 - [x] https://github.com/apache/datafusion/issues/25859 - [x] https://github.com/apache/datafusion/issues/26364 Logical optimizer rewrites (filter pushdown, unwrap cast, volatile expressions) - [ ] https://github.com/apache/datafusion/issues/7976 - [ ] https://github.com/apache/datafusion/issues/14303 - [ ] https://github.com/apache/datafusion/issues/23095 - [ ] https://github.com/apache/datafusion/issues/24284 - [ ] https://github.com/apache/datafusion/issues/24702 - [ ] https://github.com/apache/datafusion/issues/25457 - [ ] https://github.com/apache/datafusion/issues/25477 - [ ] https://github.com/apache/datafusion/issues/26058 - [ ] https://github.com/apache/datafusion/issues/26267 - [ ] https://github.com/apache/datafusion/issues/26545 - [ ] https://github.com/apache/datafusion/issues/26619 - [x] https://github.com/apache/datafusion/issues/21246 - [x] https://github.com/apache/datafusion/issues/24246 - [x] https://github.com/apache/datafusion/issues/24678 - [x] https://github.com/apache/datafusion/issues/25071 - [x] https://github.com/apache/datafusion/issues/25137 - [x] https://github.com/apache/datafusion/issues/25414 - [x] https://github.com/apache/datafusion/issues/26082 Aggregation, GROUP BY, constraints and set operations - [ ] https://github.com/apache/datafusion/issues/5672 - [ ] https://github.com/apache/datafusion/issues/9924 - [ ] https://github.com/apache/datafusion/issues/12955 - [ ] https://github.com/apache/datafusion/issues/12956 - [ ] https://github.com/apache/datafusion/issues/16965 - [ ] https://github.com/apache/datafusion/issues/21507 - [ ] https://github.com/apache/datafusion/issues/23634 - [ ] https://github.com/apache/datafusion/issues/23819 - [ ] https://github.com/apache/datafusion/issues/23820 - [ ] https://github.com/apache/datafusion/issues/25233 - [ ] https://github.com/apache/datafusion/issues/26497 - [ ] https://github.com/apache/datafusion/issues/26648 - [x] https://github.com/apache/datafusion/issues/17910 - [x] https://github.com/apache/datafusion/issues/23818 - [x] https://github.com/apache/datafusion/issues/24421 - [x] https://github.com/apache/datafusion/issues/24576 - [x] https://github.com/apache/datafusion/issues/25018 - [x] https://github.com/apache/datafusion/issues/25055 - [x] https://github.com/apache/datafusion/issues/25844 - [x] https://github.com/apache/datafusion/issues/26471 Joins - [ ] https://github.com/apache/datafusion/issues/25701 - [ ] https://github.com/apache/datafusion/issues/26002 - [x] https://github.com/apache/datafusion/issues/21309 - [x] https://github.com/apache/datafusion/issues/24297 - [x] https://github.com/apache/datafusion/issues/24348 - [x] https://github.com/apache/datafusion/issues/24745 - [x] https://github.com/apache/datafusion/issues/25957 Parquet pruning, statistics and file reading - [ ] https://github.com/apache/datafusion/issues/4918 - [ ] https://github.com/apache/datafusion/issues/8342 - [ ] https://github.com/apache/datafusion/issues/9779 - [ ] https://github.com/apache/datafusion/issues/10609 - [ ] https://github.com/apache/datafusion/issues/15812 - [ ] https://github.com/apache/datafusion/issues/25268 - [ ] https://github.com/apache/datafusion/issues/26451 - [ ] https://github.com/apache/datafusion/issues/26490 - [ ] https://github.com/apache/datafusion/issues/26491 - [x] https://github.com/apache/datafusion/issues/18241 - [x] https://github.com/apache/datafusion/issues/19264 - [x] https://github.com/apache/datafusion/issues/24109 - [x] https://github.com/apache/datafusion/issues/24355 - [x] https://github.com/apache/datafusion/issues/24381 - [x] https://github.com/apache/datafusion/issues/25221 - [x] https://github.com/apache/datafusion/issues/25226 - [x] https://github.com/apache/datafusion/issues/25239 - [x] https://github.com/apache/datafusion/issues/25794 Type coercion, casts and scalar function semantics - [ ] https://github.com/apache/datafusion/issues/14396 - [ ] https://github.com/apache/datafusion/issues/14738 - [ ] https://github.com/apache/datafusion/issues/20342 - [ ] https://github.com/apache/datafusion/issues/21703 - [ ] https://github.com/apache/datafusion/issues/24860 - [ ] https://github.com/apache/datafusion/issues/25893 - [ ] https://github.com/apache/datafusion/issues/25941 - [ ] https://github.com/apache/datafusion/issues/25942 - [ ] https://github.com/apache/datafusion/issues/26296 - [x] https://github.com/apache/datafusion/issues/21841 - [x] https://github.com/apache/datafusion/issues/24721 - [x] https://github.com/apache/datafusion/issues/25419 - [x] https://github.com/apache/datafusion/issues/25690 Writing files (round trip) - [ ] https://github.com/apache/datafusion/issues/26492 - [ ] https://github.com/apache/datafusion/issues/26514 SQL planning - [ ] https://github.com/apache/datafusion/issues/24754 - [x] https://github.com/apache/datafusion/issues/24388 -- 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]
