NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

use Perl

All the Perl that's Practical to Extract and Report

rblackwe
(email not shown publicly)
http://robertblackwell.com/
AOL IM: robertdblackwell (Add Buddy, Send Message)
Yahoo! ID: robertblackwell (Add User, Send Message)

Monday November 10, 2008

06:06 PM

[ #37850 ]

At PPW a hallway track discussion came up about having a test on CPAN that could test database conformance with the various SQL standards.

I am attempting to do some resarch on this and am not finding a good free reference for the SQL standards.

This is what I have found so far but it is not free.

You can kind of think of this as Acid2 for databases.

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.

Without JavaScript enabled, you might want to use the classic discussion system instead. If you login, you can remember this preference.

NIST, perhaps ? (Score:1)

by renodino (6856)

NIST SQL Test Suite [nist.gov] used to be the conformance std; alas, its a bit dated (I think it still only supported SQL 92). However, its likely a decent starting point.
It ain't much, but it's something... (Score:1)

by Ron Savage (5224)

http://savage.net.au/SQL.html [savage.net.au]
Drafts (Score:2)

by bart (450)

You can't get the final version for free, but usually you can find drafts for the standard. The final draft usually is quite close to the actual standard.
Google search [google.com]