Re: benchmarking Flex practices

On Thu, Aug 1, 2019 at 8:51 PM John Naylor <john.naylor@2ndquadrant.com> wrote:
>  select U&'\de04\d83d'; -- surrogates in wrong order
> -psql:test_unicode.sql:10: ERROR:  invalid Unicode surrogate pair at
> or near "U&'\de04\d83d'"
> +psql:test_unicode.sql:10: ERROR:  invalid Unicode surrogate pair
>  LINE 1: select U&'\de04\d83d';
> -               ^
> +                  ^
>  select U&'\de04X'; -- orphan low surrogate
> -psql:test_unicode.sql:12: ERROR:  invalid Unicode surrogate pair at
> or near "U&'\de04X'"
> +psql:test_unicode.sql:12: ERROR:  invalid Unicode surrogate pair
>  LINE 1: select U&'\de04X';
> -               ^
> +                  ^

While moving this to the September CF, I noticed this failure on Windows:

+ERROR: Unicode escape values cannot be used for code point values
above 007F when the server encoding is not UTF8
LINE 1: SELECT U&'\d83d\d83d';
^

https://ci.appveyor.com/project/postgresql-cfbot/postgresql/build/1.0.50382

-- 
Thomas Munro
https://enterprisedb.com