Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-47038

Invalid function SEARCH_QUERY (near line 1, column 117) (resolving to default:SEARCH_QUERY)

    XMLWordPrintable

Details

    • Untriaged
    • 1
    • Unknown

    Description

      Build: 7.1.0-1027

      Job : centos-query_n1ql_fts_integration_phase1_6.5_P1

      Jenkins URL: http://qa.sc.couchbase.com/job/test_suite_executor/357328/consoleFull

      All Tests in centos-query_n1ql_fts_integration_phase1_6.5_P1 are failing while run query with SEARCH_QUERY function.

      select primary_key from `test_bucket` where meta().id in (select raw ht.id from (SELECT result.hits FROM SEARCH_QUERY('idx_test_bucket_fts', { 'explain' : FALSE, 'fields' : [ 'string_field' ], 'highlight' : {}, 'query' : { 'query' : 'string_field:test_string' }, 'size':100}) AS result) aa unnest aa.hits as ht) order by primary_key
       
      [
        {
          "code": 3000,
          "msg": "Invalid function SEARCH_QUERY (near line 1, column 117) (resolving to default:SEARCH_QUERY)",
          "query": "select primary_key from `test_bucket` where meta().id in (select raw ht.id from (SELECT result.hits FROM SEARCH_QUERY('idx_test_bucket_fts', { 'explain' : FALSE, 'fields' : [ 'string_field' ], 'highlight' : {}, 'query' : { 'query' : 'string_field:test_string' }, 'size':100}) AS result) aa unnest aa.hits as ht) order by primary_key"
        }
      ]
      

      Same tests used to pass with 7.0.0-5295

      Attachments

        Issue Links

          For Gerrit Dashboard: MB-47038
          # Subject Branch Project Status CR V

          Activity

            Sitaram Vemulapalli, would you let me know if the syntax is ok here? Not sure if this is pointing to an issue within couchbase/n1fty.

            abhinav Abhinav Dangeti added a comment - Sitaram Vemulapalli , would you let me know if the syntax is ok here? Not sure if this is pointing to an issue within couchbase/n1fty.

            This is expected. In Neo SEARCH_QUERY() is removedĀ MB-46428

            Sitaram.Vemulapalli Sitaram Vemulapalli added a comment - This is expected. In Neo SEARCH_QUERY() is removedĀ  MB-46428

            People

              isha Isha Kandaswamy (Inactive)
              girish.benakappa Girish Benakappa
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty