[postgis-tickets] [SCM] PostGIS branch master updated. 3.4.0rc1-12-gad03e3599

git at osgeo.org git at osgeo.org
Fri Aug 11 13:43:29 PDT 2023


This is an automated email from the git hooks/post-receive script. It was
generated because a ref change was pushed to the repository containing
the project "PostGIS".

The branch, master has been updated
       via  ad03e35996b3b9c82a1a933fd2a6ef08f30ad578 (commit)
      from  9376923fdd6b5c62f25e5a1bb4a05064699670b6 (commit)

Those revisions listed above that are new to this repository have
not appeared on any other notification email; so we list those
revisions in full, below.

- Log -----------------------------------------------------------------
commit ad03e35996b3b9c82a1a933fd2a6ef08f30ad578
Author: Regina Obe <lr at pcorp.us>
Date:   Fri Aug 11 16:42:10 2023 -0400

    Regress output fix from Tobias Bussmann
    Closes #5470 for PostGIS 3.4.0

diff --git a/extensions/address_standardizer/expected/test-debug_standardize_address.out b/extensions/address_standardizer/expected/test-debug_standardize_address.out
index c4d62e004..70b2dfb40 100644
--- a/extensions/address_standardizer/expected/test-debug_standardize_address.out
+++ b/extensions/address_standardizer/expected/test-debug_standardize_address.out
@@ -1,5 +1,5 @@
 SELECT je->>'pos' AS pos, je->>'input-word' AS input_word, je->>'input-token' AS input_token, je->>'mapped-word' AS ouput_word, je->>'output-token' AS output_token FROM jsonb(debug_standardize_address('us_lex'::text, 'us_gaz'::text, 'us_rules'::text, '123 Main Street'::text, 'Kansas City, MO 45678'::text)) AS d, jsonb_array_elements(d->'rules'->0->'rule_tokens' ) AS je;
- pos | input_word | input_token | ouput_word | output_token
+ pos | input_word | input_token | ouput_word | output_token 
 -----+------------+-------------+------------+--------------
  0   | 123        | NUMBER      | 123        | HOUSE
  1   | MAIN       | WORD        | MAIN       | STREET
@@ -7,32 +7,32 @@ SELECT je->>'pos' AS pos, je->>'input-word' AS input_word, je->>'input-token' AS
 (3 rows)
 
 SELECT jsonb_array_length(jsonb(d)->'rules') FROM debug_standardize_address('us_lex','us_gaz','us_rules', '10-20 DORRANCE ST PROVIDENCE RI') AS d;
- jsonb_array_length
+ jsonb_array_length 
 --------------------
                   6
 (1 row)
 
 SELECT '#5299a' AS ticket, jsonb_array_length(d->'rules') AS num_rules, jsonb_array_length(d->'input_tokens') AS num_input_tokens,  d->'rules'->0->'raw_score' AS best_score FROM jsonb(debug_standardize_address('us_lex',  'us_gaz', 'us_rules','1 Timepiece Point','Boston, MA, 02220')) As d;
- ticket | num_rules | num_input_tokens | best_score
+ ticket | num_rules | num_input_tokens | best_score 
 --------+-----------+------------------+------------
  #5299a |         5 |                4 | 0.902500
 (1 row)
 
 SELECT '#2978c' As ticket, jsonb_array_length(d->'rules') AS num_rules, jsonb_array_length(d->'input_tokens') AS num_input_tokens,  d->'rules'->0->'raw_score' AS best_score FROM jsonb(debug_standardize_address('us_lex','us_gaz','us_rules', '10-20 DORRANCE ST, PROVIDENCE, RI')) AS d;
- ticket | num_rules | num_input_tokens | best_score
+ ticket | num_rules | num_input_tokens | best_score 
 --------+-----------+------------------+------------
  #2978c |         6 |                5 | 0.751875
 (1 row)
 
 SELECT '#5299b' AS ticket, jsonb_array_length(d->'rules') AS num_rules, jsonb_array_length(d->'input_tokens') AS num_input_tokens, d->'rules'->0->'score' AS best_score FROM jsonb(debug_standardize_address('us_lex',  'us_gaz', 'us_rules','50 Gold Piece Drive, Boston, MA, 02020')) AS d;
- ticket | num_rules | num_input_tokens | best_score
+ ticket | num_rules | num_input_tokens | best_score 
 --------+-----------+------------------+------------
  #5299b |         3 |                6 | 0.902500
 (1 row)
 
 SELECT '#5299bt' AS ticket, it->>'pos' AS pos, it->>'word' AS word,  it->>'token' AS token, it->>'stdword' AS stdword FROM jsonb(debug_standardize_address('us_lex',  'us_gaz', 'us_rules','50 Gold Piece Drive, Boston, MA, 02020')) AS d, jsonb_array_elements(d->'input_tokens') AS it
 WHERE it @> '{"pos": 2}'::jsonb;
- ticket  | pos | word  | token | stdword
+ ticket  | pos | word  | token | stdword 
 ---------+-----+-------+-------+---------
  #5299bt | 2   | PIECE | UNITH | PIECE
  #5299bt | 2   | PIECE | UNITT | PIECE
@@ -40,7 +40,7 @@ WHERE it @> '{"pos": 2}'::jsonb;
 (3 rows)
 
 SELECT r->>'score' AS score,r->>'rule_string' AS rule, r->>'rule_stub_string' AS rule_stub  FROM jsonb(debug_standardize_address('us_lex','us_gaz','us_rules', '25 Prince Street, NC 09985')) AS d, jsonb_array_elements(d->'rules') AS r;
-  score   |          rule          |      rule_stub
+  score   |          rule          |      rule_stub      
 ----------+------------------------+---------------------
  0.902500 | 0 1 2 -1 1 5 6 -1 1 16 | 0 1 2 -1 1 5 6 -1 %
  0.791875 | 0 1 2 -1 1 5 6 -1 1 16 | 0 1 2 -1 1 5 6 -1 %

-----------------------------------------------------------------------

Summary of changes:
 .../expected/test-debug_standardize_address.out            | 14 +++++++-------
 1 file changed, 7 insertions(+), 7 deletions(-)


hooks/post-receive
-- 
PostGIS


More information about the postgis-tickets mailing list