Details
-
Bug
-
Resolution: Duplicate
-
Major
-
7.1.0
-
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
- duplicates
-
MB-46428 Deprecate SEARCH_QUERY()
- Closed