Bug #545: Keyword USER not detected in CREATE VIEW

Avi Kivity (avi@argo.co.il) reports a bug with a severity of 3
The lower the number the more severe it is.

Short Description
Keyword USER not detected in CREATE VIEW

Long Description
The reserved keyword USER is rejected in CREATE TABLE, as expected:

  avi=> create table x (user varchar);
  ERROR:  parser: parse error at or near "user"

In my ignorance, however, I tried to create a view with a field named user:

  avi=> create table y (x varchar);
  CREATE
  avi=> create view z as select x as user from y;
  CREATE

Note no error.

  avi=> \d z
                   View "z"
   Attribute |       Type        | Modifier
  -----------+-------------------+----------
   user      | character varying |
  View definition: SELECT y.x AS "user" FROM y;

  avi=> insert into y values ('zz');
  INSERT 43771 1
  avi=> select user from z;
   current_user
  --------------
   avi
  (1 row)

Wrong value returned.

  avi=> select "user" from z;
   user
  ------
   zz
  (1 row)

Correct value returned.

My expected result: an error message in CREATE VIEW


Sample Code


No file was uploaded with this report