search

mridoni / gixsql

GixSQL is an ESQL preprocessor and a series of runtime libraries to enable GnuCOBOL to access PostgreSQL, ODBC, MySQL, Oracle and SQLite databases.
GNU General Public License v3.0
12 stars 5 forks source link

executing NIST testsuite for embedded SQL in COBOL #126

Open GitMensch opened 1 year ago

GitMensch commented 1 year ago

Do you know any "stress test" code that I could use (at least as a base) for testing numeric types? Unfortunately the NIST SQL test suite doesn't seem to be downloadable anymore.

Originally posted by @mridoni in https://github.com/mridoni/gixsql/issues/5#issuecomment-1099959985

It took a while and some back and forth via e-mail with the people from NIST, but they finally found them on a very old backup and made them available again at https://www.itl.nist.gov/div897/ctg/sql_form.htm

It is now also contained in the Internet Archive, so it should stay available, too.

I suggest that "executing" is taken as second step (you need to download and setup the "core" (C) part, then add the COBOL part) and as first step download the v6_pco (embedded in COBOL) one only checking if GixSQL is able to parse all of these and don't error on translation.

GitMensch commented 1 year ago

just a friendly ping, you may want to plan this for an upcoming milestone

mridoni commented 1 year ago

I have an (internal) open branch for it, it might be part of v1.0.21

GitMensch commented 1 year ago

Feel free to also push unfinished branches, especially when something is bigger.