SQL92 Test Suite

Hi I wrote a parser for SQL92 and I want to test if it parses correctly and is implemented properly. Its sort of complicated but what I bascially need is DB schema and a set of SQL queries such as "select * from TABLENAME" .  What I am going to do is take the SQL queries, run them on a mySQL datase, and save those results in a test file. Then I am going to see if my implemenation produces the same result. I've googled it but can't seem to find any information. Thanks!
eecosmo01Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
petoskey-001Connect With a Mentor Commented:
I don't really see a way without compiling them.  If you compiled the test programs, you could look at your log file and have every SQL query ran.  In the mean time, it's not exactly SQL92, but here is a link to all the SQL files that PostgreSQL uses to do testing before each release.  It has SQL92 syntax, as well as some extra PGSQL stuff.
http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/test/regress/sql/#dirlist
0
 
petoskey-001Commented:
MySql isn't 100% sql-92 compliant by default, and even in Ansi mode, I think there are some very minor differences.

Here is the MySql manual on compatibility...
http://dev.mysql.com/doc/mysql/en/Compatibility.html

The differences from ANSI
http://dev.mysql.com/doc/mysql/en/Differences_from_ANSI.html

And a better review of MySql compliance, as well as a few other databases
http://det-dbalice.if.pw.edu.pl/det-dbalice/documents/all/html/db_compare/db_compar_chp01.html

And finally while I couldn't find a simple test suite like you requested, here is the full SQL92 Spec...
http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt

NIST.GOV should carry the test suite, I think you have to pay for it.  
0
 
eecosmo01Author Commented:
Thanks, I have most of those links already. I really looking for just a list of queries and a DB schema but I guess if that does not exist then I'll write my own =( Thanks again for the help.
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
petoskey-001Commented:
Here is a link to the source code at least so you can download the test suites...
http://www.itl.nist.gov/div897/ctg/sql_form.htm
0
 
eecosmo01Author Commented:
Yah I came across that too. Is there a way to extract the queries? It seems to be spread out between all those different files and it seems like I need some app to run it. I really just want to test the parser. Thanks
0
 
eecosmo01Author Commented:
0
 
eecosmo01Author Commented:
petoskey-001,
   Oh thanks for that last link... that helps pretty well too! I appreciate your help =)
0
 
petoskey-001Commented:
Well I guess for just testing a parser those would be OK, but they don't have any create scheme commands so they would all fail on a real database.  Unlesss I'm missing something.  
0
 
eecosmo01Author Commented:
petoskey,
   Yup you are correct. I did not realize there was no schema to be located anywhere =(
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.