Tool to Test RDBMS SQL Dialect for ANSI SQL Standard Compliance

developmentsql-standardtesting

We are developing an interface to our internal data storage and manipulation tool that would allow people to use SQL dialect.

We decided that it would be perfect to make our SQL dialect as close to the standard as possible.

Currently I'm trying to find a tool that would test our implementation of query language and make a verdict about its compliance and list missing details.

Have anyone ever encountered anything like this?

Best Answer

Finally after looking at SQLite unit tests and postgreSQL unit tests we decided to use these tools

Related Solutions

SQL ISO Standard for group concatenation

The wiscorp.com page SQL Standards has several older revisions and drafts of SQL:20nn (zip):

The 7IWD2-02-Foundation-2011-12.pdf, with a date of 2011-12-21 has at page 289:

If at least one of S1 and S2 is the null value, then the result of the <concatenation> is the null value.

ANSI/ISO plans for LIMIT standardization

The latest draft SQL standard that I could find on the internet (dated 21/12/2011) has the following available for use in a query expression:

<result offset clause> ::=
    OFFSET <offset row count> { ROW | ROWS }

<fetch first clause> ::=
    FETCH { FIRST | NEXT } [ <fetch first quantity> ] { ROW | ROWS } { ONLY | WITH TIES }

Best Answer

Related Solutions

SQL ISO Standard for group concatenation

ANSI/ISO plans for LIMIT standardization

Related Question