Is there a param to tell N1QL to create a Parent if it does not exist. I use the below query to create a phone doc under my phones array, all works as expected if the doc has an phones array. if it does not have the phones array it fails to create the doc under pones
UPDATE mls SET phones = ARRAY_APPEND (phones, { "type":"home" , "number":"2135551212", "dflt":true }) where _type= "demo" and id= 123
I know in the subdoc operation there is a flag to create any missing parents hope that exists for N1QL as well