Mongo发版不支持嵌套字典语句

[liujiashun0520]

重现步骤

1 选择SQL上线，选择上线实例 2 贴入Mongo脚本： db.test.insertMany( [ { "_id":ObjectId("649cf51186b24852c55f7ee8"), "gmtCreateDate": ISODate("2023-06-29T03:05:53.158Z"), "gmtCreateUser": "admin", "gmtModifiedDate": ISODate("2023-07-20T10:50:06.061Z"), "gmtModifiedUser": "admin", "paramSchema": "[{"code":"startTime","name":"开始时间","type":"String","defaultValue":"1687017600000"},{"code":"endTime","name":"结束时间","type":"String","defaultValue":"1689695999999"},{"code":"division","name":"division","type":"String","defaultValue":"itemType"},{"code":"sceneId","name":"sceneId","type":"String","defaultValue":"10000283"},{"code":"taskType","name":"taskType","type":"List","defaultValue":["M0001","M0002"]}]", "returnSchema": "{"type":"Map","defaultValue":{}}", "scriptId": "649cf51186b24852c55f7ee7", "status": 1, "timeout": 1000 } ]); 3 点击sql检测 提示Invalid symbol "code" 错误

预期外的结果

点击sql检测 提示Invalid symbol "code" 错误

日志文本

No response

版本

1.9.1

部署方式

手工部署

是否还有其他可以辅助定位问题的信息？比如数据库版本等

No response

[fancy-lee]

直接用mongoshell执行也不可以，所以应该是你语句的问题

db.test.insertMany( [{ "returnSchema": "{"type":"Map","defaultValue":{}}" }] ); 这一段到底是字符串还是字典？按你的标题理解如果是字典的话就把两边的""去掉，如果是字符串就按这下面这么写就可以 db.test.insertMany( [{ "returnSchema": '{"type":"Map","defaultValue":{}}' }] );