Skip site navigation (1) Skip section navigation (2)

Bug?: Text after right paren in query is ignored

From: Steve Peterson <steve(at)zpfe(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug?: Text after right paren in query is ignored
Date: 2005-09-30 03:04:04
Message-ID: 6.2.3.4.0.20050929220117.01ed5ed8@209.98.88.108 (view raw or flat)
Thread:
Lists: pgsql-bugs
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.

Platform:  PostgreSQL 8.0.3 on Intel / Windows XP


Responses

pgsql-bugs by date

Next:From: Kevin WaldronDate: 2005-09-30 04:44:11
Subject: BUG #1926: /etc/init.d/postgresql - script version 7.4.5 fails on startup
Previous:From: Bruce MomjianDate: 2005-09-30 01:14:22
Subject: Re: [patch] krb5 authentication on multihomed server hosts

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group