Re: [GENERAL] Re: [PHP3] Re: PostgreSQL vs Mysql comparison

> > tested your patch and there was no change in result. I think it
> > wouldn't be nice if this will point out a bug in the perl pg driver
> > because I can't imagine that you would like to do such things in
> > there ...
> >
> > the new crash-me tests results are sent to monty so I think he will
> > put them online tomorrow (today for you I think). I also did a test
> > run on oracle and on a microsoft sql 7 server on windows nt (oracle
> > on linux).
>
> Enclosed is a patch that shows our perl interface can't handle '--'
> comments, even though psql and the backend directly can handle them.
>
> To add complexity to this, the backend -d3 log from the perl test
> session shows the same query that works perfectly in a direct backend
> connection.
>
> Can anyone suggest a cause for this?

OK, fix attached. Seems our "--" comments required a newline on the
end, which was not being done in interfaces like Perl. Added a test in
the perl code for the trailing comments, and patched scan.l.

Seems this should only be applied to 6.6. Applied to 6.6.

--
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