Re: pgsql: Add json(b)_to_tsvector function - Mailing list pgsql-committers

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