Skip to content

README.md

Latest commit

 

History

History
31 lines (24 loc) · 1.39 KB

README.md

File metadata and controls

31 lines (24 loc) · 1.39 KB

SQLite

The ztest YAML definitions found below this directory are derived from the corresponding sqllogictest scripts from SQLite found here. They are intended to test for SuperDB's backward compatibility with PostgreSQL.

Trimmed Query Set

The queries included in these ztests are trimmed down from the full set provided with SQLite. The trimming process is as follows:

  1. Only the select[1-5] and random sets are targeted, since SuperDB does not currently support SQL features exercised by the other test sets (e.g., indexing, views, etc.)

  2. DDL/DML statements at the top of the sqllogictest scripts (e.g., CREATE TABLE and INSERT INTO) have been previously executed in PostgreSQL and the resulting tables dumped to Parquet files (as described in the top-level README) to be used as query inputs.

  3. Any queries hinted with skipif postgresql, hinted with onlyif for a non-PostgreSQL system, or otherwise confirmed to be rejected by PostgreSQL are not included.

This remaining 3,619,718 total queries are captured in .yaml or .fail ztest files below this directory.