Comments (10)
Another thing that'll break those tests is lack of support for valuesort
.
from sqllogictest-rs.
from sqllogictest-rs.
🤣🤣
from sqllogictest-rs.
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.
from sqllogictest-rs.
And #122 (trailing comments)
from sqllogictest-rs.
SQLite & Postgres allow duplicate column names in results: apache/datafusion#8379 (comment)
from sqllogictest-rs.
SQLite & Postgres allow AVG(DISTINCT)
, and this is seen a lot in the tests: apache/datafusion#2408
from sqllogictest-rs.
from sqllogictest-rs.
Sorry, I just realized I wrote datafusion comments here. Nevermind that, those problems are downstream from this project.
from sqllogictest-rs.
And value-wise query results #108 (column-per-line instead of line-per-row).
from sqllogictest-rs.
Related Issues (20)
- Don't log all records (or at-least provide option to control logging) HOT 8
- runner: support matching column type in postgres engine HOT 1
- Proposal: Fail a statement test when an actual output is a query result HOT 3
- ci: add semver check in CI HOT 3
- Proposal: Add support for checking for stream errors HOT 2
- enhancement: better diff for result mismatch HOT 5
- bin: enhance `skipif` HOT 3
- `statement error` test should fail when expected error did not occur HOT 2
- Bug: sqllogictest pass unexpectedly HOT 2
- ci: enhance release workflow to include more targets
- tests: add a test suite and test agains supported engines
- remove condition/connection from `Record`
- runner: allow omit column type in query HOT 2
- Should we run `semver` test on release instead of each PR? HOT 4
- feat: add a "multi-line mode" for results spanning multiple lines
- support parameterized query in Postgres extended query protocol
- feat: support printing the test file after variable substitution
- `system ok` with `-o pipefail`
- print `stderr` for `system ok`
- `system`: for background command, stdout will be printed in output
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from sqllogictest-rs.