
IN List Handling Improvements in Couchbase Server 6.5
Introduction IN list is commonly used in N1QL queries. Couchbase Server 6.5 introduces a couple of enhancements in handling of IN list in N1QL queries. Handling of Large IN List Before Couchbase Server 6.5 N1QL handles IN list evaluation at...
Bingjie Miao, Senior Software Engineer, Couchbase February 17, 2020

ANSI JOIN Enhancements and ANSI MERGE
Introduction N1QL support for ANSI JOIN was first introduced in version 5.5. Currently there is a restriction in ANSI JOIN (version 5.5 and 6.0) in that the right-hand side of an ANSI JOIN must be a keyspace. This restriction will...
Bingjie Miao, Senior Software Engineer, Couchbase January 21, 2020

ANSI JOIN Support in N1QL
Overview ANSI JOIN support is added in N1QL to Couchbase version 5.5. In previous versions of Couchbase, join support was limited to lookup join and index join, which works great when the document key from one side of the join...
Bingjie Miao, Senior Software Engineer, Couchbase March 5, 2018