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