Uploaded image for project: 'RAML Module Builder'
  1. RAML Module Builder
  2. RMB-438

contributor search returns no results when name contains "-"

    XMLWordPrintable

Details

    • CP: sprint 69
    • 3
    • Core: Platform

    Description

      Following should return result but it does not.

      /inventory/instances?limit=30&query=(contributors =/@name "Vigneras, Louis-André,") sortby title
      

      Reason:

      folio=# select to_tsvector('simple', f_unaccent('Vigneras, Louis-André')) @@ to_tsquery('simple', f_unaccent('Vigneras,<->Louis-André'));
       ?column? 
      ----------
       f
      (1 row)
      folio=# select to_tsvector('simple', f_unaccent('Vigneras, Louis-André'));
                         to_tsvector                    
      --------------------------------------------------
       'andre':4 'louis':3 'louis-andre':2 'vigneras':1
      (1 row)
      
      folio=# select to_tsquery('simple', f_unaccent('Vigneras,<->Louis-André'));
                            to_tsquery                      
      ------------------------------------------------------
       'vigneras' <-> ( 'louis-andre' & 'louis' & 'andre' )
      (1 row)
      

      TestRail: Results

        Attachments

          Issue Links

            Activity

              People

                julianladisch Julian Ladisch
                hji Hongwei Ji
                Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases