GlueSQL logic test

You can run test by running commands like following examples:

# Run a single test file
cargo run --bin gluesql-logic-test -- test.slt

# Run all tests in directory
cargo run --bin gluesql-logic-test -- slt/

# Run with verbose output
cargo run --bin gluesql-logic-test -- --verbose test.slt

slt/ directory may be from https://sqlite.org/sqllogictest/tree?name=test&type=tree.

Useful workflow

To collect distinct error types when running sqllogictest, you can run the following commands:

$ cargo run --bin gluesql-logic-test -- slt/ 2>output
$ python3 distinct.py output
evaluate: unreachable empty aggregate value: Avg(UnaryOp { op: Plus, expr: Literal(Number(BigDecimal(sign=Plus, scale=0, digits=[86]))) })
...

---

TODO items

• Implement sqllogictest::AsyncDB trait for GlueSQL in-memory storage backend.
  • Repeat test with other storage backends that supports CRUD.
• Implement sqllogictest-bin ExternalDriver-compatible GlueSQL runner.
• (Not sure) Merge this repository to gluesql/gluesql repository to follow changes of GlueSQL.