Tracking: run SQLite sqllogictest suite
skyzh opened this issue · 10 comments
We can add a SQLite backend to sqllogictest-bin and see how compatible it is with the original SQLite's sqllogictest. Though we didn't consider compatibility when we started this project, it's never too late to see how compatible we are for now. 🤣
🤣🤣
Another thing that'll break those tests is lack of support for valuesort.
Another is that sqlite tests think CAST ( - 55 AS REAL ) should have query I and output -55, not R and -55.000. That is, sqlite doesn't really keep track of floats vs integers, if a float has no decimals it's stored as an integer (https://www.sqlite.org/sqllogictest/doc/trunk/about.wiki).
This one is more for the runner, not the harness. Or for anyone trying to repurpose SQLite tests for other backends.
SQLite & Postgres allow duplicate column names in results: apache/datafusion#8379 (comment)
SQLite & Postgres allow AVG(DISTINCT), and this is seen a lot in the tests: apache/datafusion#2408
Sorry, I just realized I wrote datafusion comments here. Nevermind that, those problems are downstream from this project.