We have a third-partylibrary that’s using a nested paths query, which is not working due to a"syntax-error". So I tried to create a document and execute the query myself, but still get the same error.
I’m running CouchBase 4.5.1 and I’m trying to execute the following nested paths query:
SELECT * FROM default.primary_contact
But the response I get is a syntax error:
[{
“code”: 3000,
“msg”: “syntax error - at .”,
“query_from_user”: “SELECT * FROM default.primary_contact”
}]
If I instead execute this query, I get the excpected response:
SELECT primary_contact FROM default
{
“primary_contact”: [
{
“name”: “John Smith”,
“phone”: “+1-650-555-1234”
},
{
“name”: “Jane Brown”,
“phone”: “+1-650-555-5678”
}
]
}