Path: utzoo!utgpu!water!watmath!clyde!att!osu-cis!killer!netsys!cucstud!lcain
From: lcain@cucstud.UUCP (Leroy Cain)
Newsgroups: comp.databases
Subject: Re: SQL in YACC format needed
Summary: A SQL
Message-ID: <249@cucstud.UUCP>
Date: 31 May 88 03:47:41 GMT
References: <11633@mimsy.UUCP> <2782@geac.UUCP>
Organization: Columbia Union College; Takoma Park, MD 20912
Lines: 36

In article <2782@geac.UUCP>, ivor@geac.UUCP (Ivor Williams) writes:
> In article <11633@mimsy.UUCP> timos@mykines.UUCP (Timos Sellis) writes:
> >
> >Anybody has a parser for SQL written in YACC? If so, can you please
> >mail me a copy? 
> >
> >Thanks, Timos Sellis
> 
> Me too, please.
> 
> -- 
> Ivor Williams, Geac Computers International Inc. 
> UUCP:	{mnetor|yunexus|utgpu}!geac!ivor

YASQLR (Yet Another SQL Request)

OK For all you out there that want YACC for SQL I have one.  Infact I will
have two very soon.  The one I mailed to Timos is a old junk one I did
almost two years ago.  I was doing an advanced project and dreamed up this
fully relational SQL with about everything you could think of putting in
SQL and some things you would never want in SQL.  I got rid of some of the
less useful stuff and only got a B out of the class (the teacher thought
it was creative but I was supposed to have finished generating parse trees).
The only problem with it is that it has some many tokens that I had to
hack YACC to YACC it.  For those with source just increase the number of
terminals.

The one I am about to write is part of an experimental system we call
a Customizable Relation Data Base Managment System.  Since this is only
a feasibility study (at this time) the SQL will be a subset of ANSI,
however it does have domains, primary keys, and sematic override.  
The first is available now the second will be couple of weeks (the BNF is
done but is not signoff on yet).

If there is enough interest I could wipe up an ANSI SQL.  Email me which
you would like and I will take appropiate action.