Details
Description
Create two buckets b0 and b1 with primary indexes defined using gsi.
In each bucket ass 3 documents with (key, value) pairs defined as follows
"1":
{ "id": "1", "int_field1": 1 }"2":
{ "id": "2", "int_field1": 2 }"3":
{ "id": "3", "int_field1": 3 }The following sub-query based N1QL Stmt returns incorrect results
select * from b0 where TO_ARRAY(int_field) != (array c.int_field for c in (select int_field from b1 US}
{
"requestID": "c55d9a23-9b77-401d-8d5a-c2c86ba15f7c",
"signature":
,
"results": [
{
"b0":
}
],
"status": "success",
"metrics":
Missing json document
{ "id": "1", "int_field": 1 }