Re: BUG #14394: No error raised in IN-clause when commas are missing

On 2016-10-24 16:28, andreas(dot)imboden(at)bl(dot)ch wrote:
> The following bug has been logged on the website:
>
> Bug reference: 14394

> -- not correct, result = 3
> -- no comma after 'two', no error message, incorrect result
> select sum(cvalue) from abug
> where cname in (
> 'one',
> 'two'
> 'three',
> 'four',
> 'five');
>

This is actually the correct result because

'two'
'three'

will be concatenated to 'twothree', which is isn't present
(leaving 'one', 'four', and 'five' as the 3 that SUM counted).

See also:

select
'two'
'three' ;

?column?
----------
twothree
(1 row)

which is, I believe, as described in the SQL standard.

Erik Rijkers