Details
-
Bug
-
Resolution: Won't Fix
-
Major
-
None
-
*Location*: https://developer.couchbase.com/documentation/server/current/n1ql/n1ql-language-reference/reservedwords.html
*User-Agent*: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/68.0.3440.106 Safari/537.36
*Screen Resolution*: 1680 x 1050
Description
If the alias or identifier or filename has especial character or reserved words you need to use backticks.
With in the whole back-tic is considered as identifier.
Case 1:
{ "contact": { "work": "Programing"}}
can be referenced as
contact.`work` OR
`contact`.`work`
If referenced as `contact.work` There is no such field and returns MISSING
Case 2:
{ "contact.work": "Programing"}can be referenced as due to special character in filed name dot.
`contact.work`
If referenced as contact.`work` OR `contact`.`work` returns as MISSING because there is contact field is MISSING in object.