SELECT * FROM bucket parent LEFT JOIN bucket reply ON parent.quoted_id == reply.id WHERE parent.obj_type == 0 AND parent.sender_jid == 'noobmaster69' AND (parent.quoted_id == reply.id OR parent.quoted_id == '') AND parent.timestamp > 1571180243 AND parent.timestamp < 1572148029; i create index for…

create index ix1 on bucket(id); Following predicate will not make it left outer join AND (parent.quoted_id == reply.id OR parent.quoted_id == ‘’) [image] ANSI JOIN Support in N1QL | The Couchbase Blog Visit the blog to learn how to transform your existing join queries in N1QL from look…

No index available for ANSI join term

SQL++

jihantoro November 4, 2019, 4:28am 4

so i need to create index for id from reply.id without any WHERE, thankyou <3

Topic		Replies	Views
No index available for ANSI join term error SQL++	2	1386	January 20, 2020
No index available for ANSI join SQL++ query , n1ql	1	1435	December 2, 2019
[INNER JOIN] use OR with ON SQL++ query	3	1362	July 27, 2019
Issue in Joining 2 documents .NET SDK n1ql , index , dot-net	2	668	December 8, 2022
Index on joined field SQL++ query , n1ql	8	1074	May 8, 2018

No index available for ANSI join term

Related topics