Re: BUG #15022: Multiple + operators when parsing SQL query

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: victoria(dot)nope(at)mail(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #15022: Multiple + operators when parsing SQL query
Date: 2018-01-19 22:32:18
Message-ID: CAKFQuwY2xtWghTPm2kZGBHtv9c44uK1zfff9nzxk1SnnWbb5AQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Fri, Jan 19, 2018 at 3:17 PM, PG Bug reporting form <
noreply(at)postgresql(dot)org> wrote:

> The following bug has been logged on the website:
>
> Bug reference: 15022
> Logged by: Victoria Nope
> Email address: victoria(dot)nope(at)mail(dot)com
> PostgreSQL version: 10.1
> Operating system: Windows 7
> Description:
>
> When executing query like this:
>
> SELECT 1 +++++++ 1;
>
> parser doesn't complain. Shall we consider this as an issue?
>
>
​No.

What that really says is (using just 3 + signs)

1 + (+(+1))

Not much different that writing:

1 + (-(-1))

Which is the same as:

1 + - - 1

(you cannot write 1 + --1 since -- is the comment indicator)

David J.


In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Wallace Baggaley 2018-01-20 00:32:06 Re: BUG #15021: Postgres crashes unexpectedly
Previous Message PG Bug reporting form 2018-01-19 22:17:41 BUG #15022: Multiple + operators when parsing SQL query