Share via

我已经禁用了enable cross-partition query,为什么还是跨区查询

谭振华 1 Reputation point
2021-09-29T09:36:55.573+00:00

container1,item有
[
{
"id": "1",
"day": "Mon",
"ivalue": "10",
"_rid": "-DM6AMVda94BAAAAAAAAAA==",
"_self": "dbs/-DM6AA==/colls/-DM6AMVda94=/docs/-DM6AMVda94BAAAAAAAAAA==/",
"_etag": "\"2000df70-0000-0700-0000-615430b80000\"",
"_attachments": "attachments/",
"_ts": 1632907448
},
{
"id": "2",
"day": "Mon",
"ivalue": "101",
"_rid": "-DM6AMVda94CAAAAAAAAAA==",
"_self": "dbs/-DM6AA==/colls/-DM6AMVda94=/docs/-DM6AMVda94CAAAAAAAAAA==/",
"_etag": "\"2000f470-0000-0700-0000-615430d90000\"",
"_attachments": "attachments/",
"_ts": 1632907481
},
{
"id": "3",
"day": "Tue",
"ivalue": "10",
"_rid": "-DM6AMVda94DAAAAAAAAAA==",
"_self": "dbs/-DM6AA==/colls/-DM6AMVda94=/docs/-DM6AMVda94DAAAAAAAAAA==/",
"_etag": "\"2000e970-0000-0700-0000-615430c70000\"",
"_attachments": "attachments/",
"_ts": 1632907463
},
{
"id": "4",
"day": "Wed",
"ivalue": "10",
"_rid": "-DM6AMVda94EAAAAAAAAAA==",
"_self": "dbs/-DM6AA==/colls/-DM6AMVda94=/docs/-DM6AMVda94EAAAAAAAAAA==/",
"_etag": "\"2000e870-0000-0700-0000-615430c40000\"",
"_attachments": "attachments/",
"_ts": 1632907460
}
]

我取消勾选了 enable cross-partition query,为什么执行

select * from c where c.ivalue = "10",还是返回了三条数据。

Azure Cosmos DB
Azure Cosmos DB

An Azure NoSQL database service for app development.


Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.