Re: pgsql: Add json(b)_to_tsvector function

On 2018-04-07 21:53:01 +0300, Teodor Sigaev wrote:
> https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=desmoxytes&dt=2018-04-07
> 18%3A32%3A02
>
> test select_parallel ... FAILED
>
> I don't understand how it's connected to json_to_tsquery. Can somebody point
> me what I'm missing?

Yea, I was confused as well.

Given that it "only" failed during upgrade check, not the earlier
parallel check, it is possible that it's entirely unrelated and just a
low likelihood event?

This however does clearly seem related:
https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=fulmar&dt=2018-04-07%2018%3A15%3A15

Probably caused by that animal using a non-standard collation?

*** /var/buildfarm/fulmar/build/HEAD/pgsql.build/src/test/regress/expected/json.out Sat Apr 7 20:15:40 2018
--- /var/buildfarm/fulmar/build/HEAD/pgsql.build/src/test/regress/results/json.out Sat Apr 7 20:29:30 2018
***************
*** 2333,2353 ****

-- json_to_tsvector
select json_to_tsvector('{"a": "aaa in bbb", "b": 123, "c": 456, "d": true, "f": false, "g": null}'::json, '"all"');
! json_to_tsvector
! ----------------------------------------------------------------------------------------
! '123':8 '456':12 'aaa':2 'b':6 'bbb':4 'c':10 'd':14 'f':18 'fals':20 'g':22 'true':16
(1 row)

select json_to_tsvector('{"a": "aaa in bbb", "b": 123, "c": 456, "d": true, "f": false, "g": null}'::json, '"key"');
! json_to_tsvector
! --------------------------------
! 'b':2 'c':4 'd':6 'f':8 'g':10
(1 row)

select json_to_tsvector('{"a": "aaa in bbb", "b": 123, "c": 456, "d": true, "f": false, "g": null}'::json, '"string"');
! json_to_tsvector
! ------------------
! 'aaa':1 'bbb':3
(1 row)

select json_to_tsvector('{"a": "aaa in bbb", "b": 123, "c": 456, "d": true, "f": false, "g": null}'::json, '"numeric"');
--- 2333,2353 ----

-- json_to_tsvector
select json_to_tsvector('{"a": "aaa in bbb", "b": 123, "c": 456, "d": true, "f": false, "g": null}'::json, '"all"');
! json_to_tsvector
! ------------------------------------------------------------------------------------------------------
! '123':9 '456':13 'a':1 'aaa':3 'b':7 'bbb':5 'c':11 'd':15 'f':19 'false':21 'g':23 'in':4 'true':17
(1 row)

select json_to_tsvector('{"a": "aaa in bbb", "b": 123, "c": 456, "d": true, "f": false, "g": null}'::json, '"key"');
! json_to_tsvector
! --------------------------------------
! 'a':1 'b':3 'c':5 'd':7 'f':9 'g':11
(1 row)

select json_to_tsvector('{"a": "aaa in bbb", "b": 123, "c": 456, "d": true, "f": false, "g": null}'::json, '"string"');
! json_to_tsvector
! ------------------------
! 'aaa':1 'bbb':3 'in':2
(1 row)

select json_to_tsvector('{"a": "aaa in bbb", "b": 123, "c": 456, "d": true, "f": false, "g": null}'::json, '"numeric"');

- Andres