Re: [HACKERS] parser enhancement request for 6.5

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: Michael Davis <michael(dot)davis(at)prevuenet(dot)com>
Cc: hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] parser enhancement request for 6.5
Date: 1999-05-10 00:54:27
Message-ID: 199905100054.UAA04457@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


Added to 6.5 beta.

> I would like for you to also consider adding the following to gram.y for
> version 6.5:
>
> | NULL_P '=' a_expr
> { $$ = makeA_Expr(ISNULL, NULL, $3,
> NULL); }
>
> I know there was some discussion about this earlier including comments
> against this. Access 97 is now generating the following statement and
> error:
>
> SQLDriverConnect(out)='DSN=PostgreSQL;DATABASE=mp;SERVER=192.168.97.2;PORT=5
> 432;UID=kari;PWD=;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROW
> VERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS='
> conn=154616224,
> query='SELECT "RentalOrders"."rentalorderlinesid" FROM "rentalorderlines"
> "RentalOrders" WHERE ( NULL = "rentalorderid" ) '
> ERROR from backend during send_query: 'ERROR: parser: parse error at or
> near "="'
>
>
> The above code changed allows Access 97 to work correctly. I would be happy
> to consider any other possible alternatives.
>
> Thanks, Michael
>
>
> -----Original Message-----
> From: Bruce Momjian [SMTP:maillist(at)candle(dot)pha(dot)pa(dot)us]
> Sent: Saturday, March 13, 1999 10:14 PM
> To: Michael Davis
> Cc: hackers(at)postgreSQL(dot)org
> Subject: Re: [HACKERS] parser enhancement request for 6.5
>
> Applied.
>
>
> [Charset iso-8859-1 unsupported, filtering to ASCII...]
> > I have a problem with Access97 not working properly when entering
> new
> > records using a sub form, i.e. entering a new order/orderlines or
> master and
> > detail tables. The problem is caused by a SQL statement that
> Access97 makes
> > involving NULL. The syntax that fails is "column_name" = NULL.
> The
> > following attachment was provided by -Jose'-. It contains a very
> small
> > enhancement to gram.y that will allow Access97 to work properly
> with sub
> > forms. Can this enhancement be added to release 6.5?
> >
> > <<gram.patch>>
> > Thanks, Michael
> >
>
> [Attachment, skipping...]
>
>
> --
> Bruce Momjian | http://www.op.net/~candle
> maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
> + If your life is a hard drive, | 830 Blythe Avenue
> + Christ can be your backup. | Drexel Hill, Pennsylvania
> 19026
>

--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tatsuo Ishii 1999-05-10 00:58:06 Re: [HACKERS] Re: SIGBUS in AllocSetAlloc & jdbc
Previous Message Bruce Momjian 1999-05-10 00:51:25 Re: [HACKERS] Associative Operators? (Was: Re: [NOVICE] Out of frying pan, into fire)