Re: Bug?: Text after right paren in query is ignored

From: Steve Peterson <steve(at)zpfe(dot)com>
To: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug?: Text after right paren in query is ignored
Date: 2005-10-01 03:37:05
Message-ID: 6.2.3.4.0.20050930222624.07fed3e0@209.98.88.108
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The query is submitted using the JDBC driver, via
the SQLExplorer plugin for Eclipse.

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

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 = '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 49' 17.7", W 73 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)

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Balaji NV 2005-10-01 06:12:09 Error While Connectint to Database
Previous Message Michael Rau 2005-09-30 18:06:11 BUG #1929: Successful COPY fails with less records in CSV file