Re: pgsql: Adjust string comparison in jsonpath - Mailing list pgsql-committers

From Thomas Munro
Subject Re: pgsql: Adjust string comparison in jsonpath
Date
Msg-id CA+hUKGJ8N5nK7awwAECgJk84x6c50NHE9nD7v43UgjHTD1hFgQ@mail.gmail.com
Whole thread Raw
In response to Re: pgsql: Adjust string comparison in jsonpath  (Alexander Korotkov <a.korotkov@postgrespro.ru>)
Responses Re: pgsql: Adjust string comparison in jsonpath  (Alexander Korotkov <a.korotkov@postgrespro.ru>)
List pgsql-committers
On Mon, Aug 12, 2019 at 10:30 AM Alexander Korotkov
<a.korotkov@postgrespro.ru> wrote:
> > > This appears to have upset prion when testing on en_US.iso885915.
> >
> > Also lapwing's "InstallCheck-fr_FR" stage crashed on this commit, when
> > running JSON queries, on HEAD and REL_12_STABLE:

> Thank you for pointing!  I hope I can investigate this shortly.

Hi Alexander,

I can reproduce this by running LANG="fr_FR.ISO8859-1" initdb, then
running installcheck (on some other OSes that might be called just
"fr_FR").  See this comment in mbutils.c:

 * The functions return a palloc'd, null-terminated string if conversion
 * is required.  However, if no conversion is performed, the given source
 * string pointer is returned as-is.

You call pfree() on the result of pg_server_to_any() without checking
if it just returned in the input pointer (for example, it does that if
you give it an empty string).  That triggers an assertion failure
somewhere inside pfree().  The following fixes that for me, and is
based on code I found elsewhere in the tree.

--- a/src/backend/utils/adt/jsonpath_exec.c
+++ b/src/backend/utils/adt/jsonpath_exec.c
@@ -2028,8 +2028,10 @@ compareStrings(const char *mbstr1, int mblen1,
                cmp = binaryCompareStrings(utf8str1, strlen(utf8str1),

utf8str2, strlen(utf8str2));

-               pfree(utf8str1);
-               pfree(utf8str2);
+               if (mbstr1 != utf8str1)
+                       pfree(utf8str1);
+               if (mbstr2 != utf8str2)
+                       pfree(utf8str2);

With that fixed it no longer crashes, but then the regression test
fails due to differences in the output, which look like locale
ordering differences.

-- 
Thomas Munro
https://enterprisedb.com



pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: Partially revert "Insert temporary debugging output inregressio
Next
From: Alexander Korotkov
Date:
Subject: pgsql: Fix string comparison in jsonpath