mit-pdos/noria

Add better SQL-compatibility tests

Open

#98 opened on Sep 19, 2018

View on GitHub
 (0 comments) (0 reactions) (0 assignees)Rust (4,576 stars) (229 forks)batch import
enhancementhelp wantedm-sql

Description

While we have a test module that checks for MySQL compatibility, it is still relatively limited. It'd be amazing to have a more extensive test suite that we could run to see that our operators indeed match SQL semantics. Something standard like the SQL Logic Test might be a good candidate.

Contributor guide

Tech stack
rust
Domain
databasetesting
Issue type
test
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
3
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
1-3 hours
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
stale
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
clear
Prerequisites
Rustbasic SQL knowledgefamiliarity with test frameworks
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
80
Research direction
The issue requests expanding the SQL compatibility test suite by integrating a standard test suite like SQL Logic Test. The existing MySQL comparison tests are in `tests/mysql comparison.rs`; similar logic should be applied to test against SQLite's test harness. Investigate the SQL Logic Test format and adapt it to the project's test infrastructure. No linked PRs or comments exist, so the approach is open ended.