While having trouble extending the CREATE VIEW grammar i discovered this:

bommel@[local]:yomama #= CREATE VIEW vtest as SELECT * from abteilung WITH;
CREATE VIEW

I can reproduce this on 8.0.0beta1 && beta3 and in a 7.4.2 production 
database.

  Bernd

Fri, 01 Oct 2004 01:21:00 +0200
Bernd Helmle <mailings@oopsware.de>
Bug in CREATE VIEW grammar
On Fri, 1 Oct 2004, Bernd Helmle wrote:

> While having trouble extending the CREATE VIEW grammar i discovered this:
>
> bommel@[local]:yomama #= CREATE VIEW vtest as SELECT * from abteilung WITH;
> CREATE VIEW

I'm not sure what in particular you're getting at. Although technically
WITH is a reserved word and as such shouldn't be usable as a correlation
name for abteilung, we generally try to limit those restrictions whenever
possible.

Thu, 30 Sep 2004 16:32:48 -0700 (PDT)
Stephan Szabo <sszabo@megazone.bigpanda.com>
Re: Bug in CREATE VIEW grammar
--On Donnerstag, September 30, 2004 16:32:48 -0700 Stephan Szabo 
<sszabo@megazone.bigpanda.com> wrote:

> On Fri, 1 Oct 2004, Bernd Helmle wrote:
>
>> While having trouble extending the CREATE VIEW grammar i discovered this:
>>
>> bommel@[local]:yomama #= CREATE VIEW vtest as SELECT * from abteilung
>> WITH; CREATE VIEW
>
> I'm not sure what in particular you're getting at. Although technically
> WITH is a reserved word and as such shouldn't be usable as a correlation
> name for abteilung, we generally try to limit those restrictions whenever
> possible.
>
>

Hmm, okay, it wasn't clear to me that WITH is an allowed table alias name. 
Looking in the unreserved keyword map in gram.y i see WITH there.
My current work is to extend the CREATE VIEW statement with the WITH [ 
CASCADE | LOCAL ] CHECK OPTION, so i wondered first, why WITH is not a 
reserved word.


  Thanks for your reply.

-- 

  Bernd

Fri, 01 Oct 2004 01:58:38 +0200
Bernd Helmle <mailings@oopsware.de>
Re: Bug in CREATE VIEW grammar