You might have passed as string instead of Object.
INSERT INTO default VALUES ("k01", { "Comment": "asdfsdaf", "resultsobject": null, "tcid": "asdf", "type": "dsaf" });
SELECT * FROM default USE KEYS "k01";
UPDATE default AS d USE KEYS "k01" SET d.resultsobject = { "result": {"code" : "sdafsda","descripton" : "sucess"}};
SELECT * FROM default USE KEYS "k01";
cbq> INSERT INTO default VALUES ("k01", { "Comment": "asdfsdaf", "resultsobject": null, "tcid": "asdf", "type": "dsaf" });
{
"requestID": "652525e1-4363-4f79-9e3e-078d3823c6fe",
"signature": null,
"results": [
],
"status": "success",
"metrics": {
"elapsedTime": "1.797609ms",
"executionTime": "1.680491ms",
"resultCount": 0,
"resultSize": 0,
"mutationCount": 1
}
}
cbq> SELECT * FROM default USE KEYS "k01";
{
"requestID": "0f6cc7d3-c893-47fa-8de7-b87fb4467149",
"signature": {
"*": "*"
},
"results": [
{
"default": {
"Comment": "asdfsdaf",
"resultsobject": null,
"tcid": "asdf",
"type": "dsaf"
}
}
],
"status": "success",
"metrics": {
"elapsedTime": "663.404µs",
"executionTime": "600.877µs",
"resultCount": 1,
"resultSize": 163
}
}
cbq> UPDATE default AS d USE KEYS "k01" SET d.resultsobject = { "result": {"code" : "sdafsda","descripton" : "sucess"}};
{
"requestID": "9a4dc4dd-846e-4fec-8592-8b32cb98dca6",
"signature": null,
"results": [
],
"status": "success",
"metrics": {
"elapsedTime": "1.112692ms",
"executionTime": "1.060617ms",
"resultCount": 0,
"resultSize": 0,
"mutationCount": 1
}
}
cbq> SELECT * FROM default USE KEYS "k01";
{
"requestID": "3f5b0331-d3b0-4bb5-b294-a6ca7fa0b6de",
"signature": {
"*": "*"
},
"results": [
{
"default": {
"Comment": "asdfsdaf",
"resultsobject": {
"result": {
"code": "sdafsda",
"descripton": "sucess"
}
},
"tcid": "asdf",
"type": "dsaf"
}
}
],
"status": "success",
"metrics": {
"elapsedTime": "1.067177ms",
"executionTime": "973.349µs",
"resultCount": 1,
"resultSize": 302
}
}