Re: SQL/JSON path: collation for comparisons, minor typos in docs

2019-08-11 Thread Alexander Korotkov
On Fri, Aug 9, 2019 at 5:27 PM Alexander Korotkov wrote: > On Thu, Aug 8, 2019 at 11:30 PM Alexander Korotkov > wrote: > > On Thu, Aug 8, 2019 at 11:53 AM Markus Winand > > wrote: > > > The patch makes my tests pass. > > > > Cool. > > > > > I wonder about a few things: > > > > > > - Isn’t there

Re: SQL/JSON path: collation for comparisons, minor typos in docs

2019-08-09 Thread Alexander Korotkov
On Thu, Aug 8, 2019 at 11:30 PM Alexander Korotkov wrote: > On Thu, Aug 8, 2019 at 11:53 AM Markus Winand wrote: > > The patch makes my tests pass. > > Cool. > > > I wonder about a few things: > > > > - Isn’t there any code that could be re-used for that (the one triggered by > > ‘a’ < ‘A’ COLLA

Re: SQL/JSON path: collation for comparisons, minor typos in docs

2019-08-08 Thread Alexander Korotkov
Hi, Markus! On Thu, Aug 8, 2019 at 11:53 AM Markus Winand wrote: > The patch makes my tests pass. Cool. > I wonder about a few things: > > - Isn’t there any code that could be re-used for that (the one triggered by > ‘a’ < ‘A’ COLLATE ucs_basic)? PostgreSQL supports ucs_basic, but it's alias

Re: SQL/JSON path: collation for comparisons, minor typos in docs

2019-08-08 Thread Markus Winand
Hi! The patch makes my tests pass. I wonder about a few things: - Isn’t there any code that could be re-used for that (the one triggered by ‘a’ < ‘A’ COLLATE ucs_basic)? - For object key members, the standard also refers to unicode code point collation (SQL-2:2016 4.46.3, last paragraph). - I

Re: SQL/JSON path: collation for comparisons, minor typos in docs

2019-08-07 Thread Alexander Korotkov
On Thu, Aug 8, 2019 at 3:05 AM Alexander Korotkov wrote: > On Thu, Aug 8, 2019 at 12:55 AM Alexander Korotkov > wrote: > > On Wed, Aug 7, 2019 at 4:11 PM Alexander Korotkov > > wrote: > > > On Wed, Aug 7, 2019 at 2:25 PM Markus Winand > > > wrote: > > > > I was playing around with JSON path qu

Re: SQL/JSON path: collation for comparisons, minor typos in docs

2019-08-07 Thread Alexander Korotkov
On Thu, Aug 8, 2019 at 12:55 AM Alexander Korotkov wrote: > On Wed, Aug 7, 2019 at 4:11 PM Alexander Korotkov > wrote: > > On Wed, Aug 7, 2019 at 2:25 PM Markus Winand > > wrote: > > > I was playing around with JSON path quite a bit and might have found one > > > case where the current impleme

Re: SQL/JSON path: collation for comparisons, minor typos in docs

2019-08-07 Thread Alexander Korotkov
On Wed, Aug 7, 2019 at 4:11 PM Alexander Korotkov wrote: > On Wed, Aug 7, 2019 at 2:25 PM Markus Winand wrote: > > I was playing around with JSON path quite a bit and might have found one > > case where the current implementation doesn’t follow the standard. > > > > The functionality in question

Re: SQL/JSON path: collation for comparisons, minor typos in docs

2019-08-07 Thread Alexander Korotkov
Hi! On Wed, Aug 7, 2019 at 2:25 PM Markus Winand wrote: > I was playing around with JSON path quite a bit and might have found one case > where the current implementation doesn’t follow the standard. > > The functionality in question are the comparison operators except ==. They > use the databa

SQL/JSON path: collation for comparisons, minor typos in docs

2019-08-07 Thread Markus Winand
Hi! I was playing around with JSON path quite a bit and might have found one case where the current implementation doesn’t follow the standard. The functionality in question are the comparison operators except ==. They use the database default collation rather then the standard-mandated "Unicod