In the SQLite CVS repository, look at the test subdirectory.  There are a
set of TCL based files and scripts which are fed to the SQLite test harness
to implement much of the regression tests for SQLite.

You can probably grep through the *.test files to get examples of many, many
SQL statements handled by SQLite.

You can also take a look at fuzz.test which attempts to throw semi-random
(but mostly valid) SQL statements at the parser in an attempt to find
errors.

HTH.
-Shane

On Sun, Oct 12, 2008 at 4:32 PM, Kristoffer Danielsson <
[EMAIL PROTECTED]> wrote:

> I have made a topdown parser of a subset of the SQLite syntax. Now I need
> to verify its correctness.
>
> Does the SQLite developer team make use of some kind of regression tests
> where complex statements are being tested?
> It would really be great if I could find some 100 SELECT-statements for
> testing!
>
> Thanks.
> _________________________________________________________________
>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to