If I run an update query, similar to the following:
update fsm USE KEYS "unique-key-of-the-single-document" set `hvacr_equipment`.`fs_geo_pt_location`.`testing`="testing123" for `hvacr_equipment` in `hvacr_equipment` when `hvacr_equipment`.`_id`="some-unique-id-value" end where doc_type = "hvacr_system"
fs_geo_pt_location is not in the document OR has a value set to null, the query does not update it.
fs_geo_pt_location is set, it is updated properly.
How do I get this query to create
fs_geo_pt_location if it doesn’t exist and then set the
testing value in it?
Same question if it does exist and it’s set to null?