From: Tom Lane <tgl@sss.pgh.pa.us>
To: Heikki Linnakangas <hlinnaka@iki.fi>
Cc: James Cloos <cloos@jhcloos.com>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: pg should ignore u+200b zero width space
Date: Tue, 03 Nov 2020 09:52:47 -0500
Message-ID: <919181.1604415167@sss.pgh.pa.us> (raw)
In-Reply-To: <e1c98248-ac7b-5fd2-0b74-86669054d58a@iki.fi>
References: <m3k0v21rss.fsf@carbon.jhcloos.org>
<e1c98248-ac7b-5fd2-0b74-86669054d58a@iki.fi>
Heikki Linnakangas <hlinnaka@iki.fi> writes:
> On 03/11/2020 15:41, James Cloos wrote:
>> pg should treat a no break space after whitespace as just more
>> whitespace.
> Hmm. I'm not sure if change the behavior is a good idea, but a hint in
> the error message would be nice. Something like:
The difficulty with doing anything in this space --- whether it be
ignoring, throwing an error, or whatever --- is that it makes the
lexer's behavior encoding-sensitive and potentially locale-sensitive.
That's problematic for all sorts of reasons. One of the worst is
that frontend programs such as psql and ecpg also have SQL lexers,
and there'd be no way to keep their behavior in precise sync with
the backend's. (They might not even be running in the same encoding,
never mind locale.) It might even be possible to build security
holes around that; recall the fun we've had with trying to lock
down quoting rules in encodings where backslash can be part of a
multibyte character :-(.
Perhaps it'd be all right to confine the change in behavior to
just modifying the error text in cases where we were going to
throw an error anyway. But I think this is much harder than
it sounds to do in a valid, safe way.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: tgl@sss.pgh.pa.us, hlinnaka@iki.fi, cloos@jhcloos.com, pgsql-bugs@lists.postgresql.org
Subject: Re: pg should ignore u+200b zero width space
In-Reply-To: <919181.1604415167@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox