BUG #12242: No error - if there is no comma seperator

From: omkar1103(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #12242: No error - if there is no comma seperator
Date: 2014-12-15 16:25:55
Message-ID: 20141215162555.2699.79394@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 12242
Logged by: Onkar Gaonkar
Email address: omkar1103(at)gmail(dot)com
PostgreSQL version: 9.3.3
Operating system: Windows
Description:

Below script does not throw error
=======================================
SELECT
claim_status,
claim_key
FROM tbl_claim
WHERE claim_key IN
(
'1140799265'
'2129945595'
)
=======================================

Throws Error
=======================================
SELECT
claim_status,
claim_key
FROM tbl_claim
WHERE claim_key IN
(
'1140799265' '2129945595'
)

ERROR: syntax error at or near "'2129945595'"
LINE 7: '1140799265' '2129945595'
^
********** Error **********
ERROR: syntax error at or near "'2129945595'"
SQL state: 42601
Character: 113
=======================================

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Andrew Sackville-West 2014-12-15 20:06:40 Re: regression, deadlock in high frequency single-row UPDATE
Previous Message aleks.dark 2014-12-15 15:15:55 BUG #12241: uninitialized value $lib_path