- JDK/基础库: 17
- OS/系统: window11

{
 "@schema": "warehose",
 "[]": {
 "Inventory": {},
 "query": 2,
 "count": 10,
 "page": 0,
 "join": "</Location_info/code@,</Warehose_info/id@",
 "Location_info": {
 "code@": "/Inventory/location_code"
 },
 "Warehose_info": {
 "id@": "/Location_info/warehouse_id"
 }
 },
 "@explain": true
}
如果"query": 0 ,查询没问题,
分页count 生成的,
已生成 1 条 SQL
execute startTime = 1750920200358
database = ; schema = warehose; sql = 
SELECT count(*) AS "count" FROM "warehose"."inventory" AS "Inventory" 
 LEFT JOIN ( SELECT "code" FROM "warehose"."location_info" ) AS "Location_info" ON "Location_info"."code" = "Inventory"."location_code" 
 LEFT JOIN ( SELECT "id" FROM "warehose"."warehose_info" ) AS "Warehose_info" ON "Warehose_info"."id" = "Location_info"."warehouse_id" 
这里限制只能是 SELECT "code" FROM "warehose"."location_info" code了,这个count sql会运行不通过。

有没有另外一种访问可以通过count