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

contributor search returns no results when name contains "-"

    XMLWordPrintable

    Details

    • Template:
    • Sprint:
      CP: sprint 69
    • Story Points:
      3
    • Development Team:
      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

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

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    TestRail: Runs

                      TestRail: Cases