fix: PG count join 报错找不到 column，感谢 wz11wz 的贡献 Tencent#825

TommyLemon · web-flow · commit a05e2e2b6e46 · 2025-07-02T23:52:39.000+08:00
Tencent#825
diff --git a/APIJSONORM/src/main/java/apijson/orm/AbstractSQLConfig.java b/APIJSONORM/src/main/java/apijson/orm/AbstractSQLConfig.java
@@ -6324,7 +6324,10 @@ LEFT JOIN ( SELECT count(*)  AS count FROM sys.Comment ) AS Comment ON Comment.m
 				List<String> column = onList == null ? null : new ArrayList<>(onList.size());
 				if (column != null) {
 					for (On on : onList) {
-						column.add(on.getKey());
+						//解决 pg  如果只查询关联键，会报找不到column的错误
+						///* SELECT  count(*)  AS count  FROM sys.Moment AS Moment
+						//			   LEFT JOIN ( SELECT *  FROM sys.Comment ) AS Comment ON Comment.momentId = Moment.id LIMIT 1 OFFSET 0 */
+						//column.add(on.getKey());
 					}
 				}
 

Original file line number	Diff line number	Diff line change
`@@ -6324,7 +6324,10 @@ LEFT JOIN ( SELECT count(*) AS count FROM sys.Comment ) AS Comment ON Comment.m`
`6324`	`6324`	`List<String> column = onList == null ? null : new ArrayList<>(onList.size());`
`6325`	`6325`	`if (column != null) {`
`6326`	`6326`	`for (On on : onList) {`
`6327`		`- column.add(on.getKey());`
	`6327`	`+ //解决 pg 如果只查询关联键，会报找不到column的错误`
	`6328`	`+ ///* SELECT count(*) AS count FROM sys.Moment AS Moment`
	`6329`	`+ // LEFT JOIN ( SELECT * FROM sys.Comment ) AS Comment ON Comment.momentId = Moment.id LIMIT 1 OFFSET 0 */`
	`6330`	`+ //column.add(on.getKey());`
`6328`	`6331`	`}`
`6329`	`6332`	`}`
`6330`	`6333`