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

Поиск
Список
Период
Сортировка
От Steve Peterson
Тема Re: Bug?: Text after right paren in query is ignored
Дата
Msg-id 6.2.3.4.0.20050930222624.07fed3e0@209.98.88.108
обсуждение исходный текст
Ответ на Re: Bug?: Text after right paren in query is ignored  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Список 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 по дате отправления:

Предыдущее
От: "Jean-Pierre Pelletier"
Дата:
Сообщение: Unreliable pg_stat_activity, Windows 2000, PostgreSQL 8.1 beta2
Следующее
От: "Tony Marston"
Дата:
Сообщение: BUG #1937: Parts of information_schema only accessible to owner