Re: Bug?: Text after right paren in query is ignored - Mailing list pgsql-bugs

From Steve Peterson
Subject Re: Bug?: Text after right paren in query is ignored
Date
Msg-id 6.2.3.4.0.20050930222624.07fed3e0@209.98.88.108
Whole thread Raw
In response to Re: Bug?: Text after right paren in query is ignored  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
List pgsql-bugs
The query is submitted using the JDBC driver, via=20
the SQLExplorer plugin for Eclipse.

Is there a way for me to see the query as it was=20
submitted to the backend?  If so I'll take a look and see what it looks lik=
e.

S

At 09:58 AM 9/30/2005, Alvaro Herrera wrote:
>On Thu, Sep 29, 2005 at 10:04:04PM -0500, Steve Peterson wrote:
> > Is this a bug or some artifact of the SQL language that I've never
> > seen before?
> >
> > SELECT v_id
> > FROM table
> > WHERE col =3D 'V')
> > AND blah
> >
> > executes without errors, ignoring the closing paren and everything
> > thereafter.
>
>Not here.  How are you executing that query, exactly?
>
>--
>Alvaro Herrera       Valdivia, Chile   ICBM: S 39=BA 49' 17.7", W 73=BA 14=
' 26.8"
>"Some men are heterosexual, and some are bisexual, and some
>men don't think about sex at all... they become lawyers" (Woody Allen)

pgsql-bugs by date:

Previous
From: "Jean-Pierre Pelletier"
Date:
Subject: Unreliable pg_stat_activity, Windows 2000, PostgreSQL 8.1 beta2
Next
From: "Tony Marston"
Date:
Subject: BUG #1937: Parts of information_schema only accessible to owner