Query results are different from go SDK vs Cappela query console

Go SDK
1

Following query is giving different results ig GO SDK and Couchbase Cappela console

We have tried deleting prepared statement query plan also

SELECT ees FROM `vidya`.`event`.`event` e LET ees = ( SELECT dae.contactId, ee.isWildCard, dae.enrolledByUserId enrolledBy FROM `vidya`.`crm`.`dae` dae UNNEST dae.userEnrollments ue UNNEST ue.eventEnrollments ee WHERE ee.eventId = META(e).id AND dae.enrollmentMode NOT IN [2, 4, 5] AND dae.contactId IS NOT MISSING AND dae.donationDate <= "2024-10-19") WHERE e.startDate = "2024-11-01"

This is giving around 15,000 records when we run from console but it gives only 55 records when we run from go code.

Also in go code output, records are repeating.

This issue is happening intermittently. (7 out of 10 times)

This stated happening suddenly in the code which was in prodction for more than a year. May be due to an upgrade in Cappela.

Current capella version: 7.6.3
Go SDK version: 2.9.2

2

Can you open a ticket with customer support for investigation?.Thanks.

3

Please post profile timings output.
Required sample documents (it is execution related) with repro.

Project META(e).id and see which document is missed and use USE KEYS and check what is wrong.

4

2.9.2 was released September 25. So it might be to due to the change from an older version to that one.

5

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.