N1QL count query is not working with Count(1) with client 3.1.5

SQL++
1

Hi,

I was doing upgrade of the Couchbase client to 3.1.5
and
below query stopped working from java client call-
SELECT COUNT(1) AS itemsNumber FROM f AS f_S WHERE LOWER(f_S.S.cSId) LIKE “%92638%” AND LOWER(f_S.S.cID) = “10000000046”

but the same query is working from couchbase UI query (version 6.6.1)-

And after making changes in Count(1) to Count(f_S.S.bId) -
SELECT Count(f_S.S.bId) AS itemsNumber FROM f AS f_S WHERE LOWER(f_S.S.cSId) LIKE “%92638%” AND LOWER(f_S.S.cID) = “10000000046”

it is working but explain plan changed and as I understood in past Count(1) gives better performance.

Please suggest.

2

One more point noticed, It is happening in case of ‘like’ in where clause

3

May be related to MB-44354 Try 6.6.2