Tests: functional correctness vs SQLite (rusqlite)

[pszymkowiak]

Create tests/correctness.rs that runs identical SQL on trdbte and rusqlite, comparing results:

• CREATE TABLE + INSERT + SELECT * (basic round-trip)
• WHERE with =, <, >, !=, AND, OR
• UPDATE with WHERE
• DELETE with WHERE
• SELECT with ORDER BY ASC/DESC
• SELECT with LIMIT
• DROP TABLE
• Integer, Float, Text, NULL value types
• Multiple tables

Each test: run SQL on both engines, assert same results.

[pszymkowiak]

[w] wshm · Automated triage by AI

🔍 Automated Triage

✨ Category	feature
🟡 Priority	medium
🎯 Confidence	93%

Summary

Request to create a correctness test suite comparing trdbte SQL execution against rusqlite as a reference implementation. Depends on executor (#4) and parser (#3) being completed first.

📁 Relevant files

• tests/correctness.rs

---

Triaged automatically by wshm · This is an automated analysis, not a human review.