Обсуждение: FIPS 127-2
I searched the email archives and didn't find any reference to this, though I thought for sure that I'd seen something come across the list sometime in the past. Has there been any thought about making use of the NIST SQL Test Suite (http://www.itl.nist.gov/div897/ctg/sql_form.htm) inspired by the FIPS Pub 127-2? And what about a FIPS flag? Joe Celko had an interesting post about this a little while back: http://groups.google.com/groups?selm=c0d87ec0.0301101643.6fcbec82%40posting.google.com&output=gplain I would guess that, if nothing else, the test suite would be useful. mrc -- Mike Castle dalgoda@ix.netcom.com www.netcom.com/~dalgoda/ We are all of us living in the shadow of Manhattan. -- Watchmen fatal ("You are in a maze of twisty compiler features, all different"); -- gcc
dalgoda@ix.netcom.com (Mike Castle) writes: > Has there been any thought about making use of the NIST SQL Test Suite Great Bridge tried to run it a couple years ago, and got stymied by the fact that the test suite is utterly dependent on schema support; and also it assumes autocommit-off behavior IIRC. It would be interesting to try again now that 7.3 has cleared those first hurdles. Are you volunteering? regards, tom lane
In article <20647.1048137165@sss.pgh.pa.us>, Tom Lane <tgl@sss.pgh.pa.us> wrote: >dalgoda@ix.netcom.com (Mike Castle) writes: >> Has there been any thought about making use of the NIST SQL Test Suite > >Great Bridge tried to run it a couple years ago, and got stymied by the >fact that the test suite is utterly dependent on schema support; and >also it assumes autocommit-off behavior IIRC. That is probably what I was remembering. Could you give me any pointers on how to find possible emails discussing this attempt in the archives? I was able to find a single reference via groups.google.com, but couldn't find anything using the postgresql.org search engine. Who knows, maybe it wasn't on a postgresql list after all. >It would be interesting to try again now that 7.3 has cleared those >first hurdles. Are you volunteering? I agree it would be interesting. Right now I have too many other things on my plate, but if I get it cleared off and get a chance to come back to this, and no one else has beaten me to it, I just might give it a shot. That's at least 6 months down the line for me though. Right now my employer is integrating the tests into our suite for our own product, which is what made me think of it. mrc -- Mike Castle dalgoda@ix.netcom.com www.netcom.com/~dalgoda/ We are all of us living in the shadow of Manhattan. -- Watchmen fatal ("You are in a maze of twisty compiler features, all different"); -- gcc
> -----Original Message----- > From: Mike Castle [mailto:dalgoda@ix.netcom.com] > Sent: Friday, March 21, 2003 8:58 AM > To: pgsql-general@postgresql.org > Subject: Re: [GENERAL] FIPS 127-2 > > > In article <20647.1048137165@sss.pgh.pa.us>, > Tom Lane <tgl@sss.pgh.pa.us> wrote: > >dalgoda@ix.netcom.com (Mike Castle) writes: > >> Has there been any thought about making use of the NIST SQL Test > >> Suite > > > >Great Bridge tried to run it a couple years ago, and got > stymied by the > >fact that the test suite is utterly dependent on schema support; and > >also it assumes autocommit-off behavior IIRC. > > That is probably what I was remembering. Could you give me > any pointers on how to find possible emails discussing this > attempt in the archives? I was able to find a single > reference via groups.google.com, but couldn't find anything > using the postgresql.org search engine. Who knows, maybe it > wasn't on a postgresql list after all. > > >It would be interesting to try again now that 7.3 has cleared those > >first hurdles. Are you volunteering? > > I agree it would be interesting. > > Right now I have too many other things on my plate, but if I > get it cleared off and get a chance to come back to this, and > no one else has beaten me to it, I just might give it a shot. > That's at least 6 months down the line for me though. > > Right now my employer is integrating the tests into our suite > for our own product, which is what made me think of it. Here is all the NIST stuff in an archive: ftp://cap.connx.com/chess-engines/new-approach/nist.ZIP I once suggested using the NIST tests for ecpg testing.
dalgoda@ix.netcom.com (Mike Castle) writes: > Tom Lane <tgl@sss.pgh.pa.us> wrote: >>> Has there been any thought about making use of the NIST SQL Test Suite >> >> Great Bridge tried to run it a couple years ago, and got stymied by the >> fact that the test suite is utterly dependent on schema support; and >> also it assumes autocommit-off behavior IIRC. > That is probably what I was remembering. Could you give me any pointers > on how to find possible emails discussing this attempt in the archives? There probably isn't much; I recall internal Great Bridge discussions but not anything on the community lists. Fernando Nasser of Red Hat has also looked at this, but I dunno if he's tried it since 7.3 became available. regards, tom lane