解决 JOIN ON 不支持 @cast，感谢 lindaifeng 的贡献~ Tencent#785

TommyLemon · web-flow · commit 5e2ed07fc332 · 2024-12-22T20:27:31.000+08:00
Tencent#785
diff --git a/APIJSONORM/src/main/java/apijson/orm/AbstractSQLConfig.java b/APIJSONORM/src/main/java/apijson/orm/AbstractSQLConfig.java
@@ -4870,8 +4870,21 @@ protected String concatJoinOn(@NotNull String sql, @NotNull String quote, @NotNu
 
 				String rt = on.getRelateType();
 				if (StringUtil.isEmpty(rt, false)) {
-					sql += (first ? ON : AND) + quote + jt + quote + "." + quote + on.getKey() + quote + (isNot ? " != " : " = ")
-							+ quote + getSQLTableWithAlias(on.getTargetTable(), on.getTargetAlias()) + quote + "." + quote + on.getTargetKey() + quote;
+					// 解决 JOIN ON 不支持 @cast 问题
+					SQLConfig jc = j.getJoinConfig();
+					Map<String, String> castMap = jc == null ? null : jc.getCast();
+					if (castMap == null || castMap.isEmpty()) {
+						sql += (first ? ON : AND) + quote + jt + quote + "." + quote + on.getKey() + quote + (isNot ? " != " : " = ")
+								+ quote + on.getTargetTable() + quote + "." + quote + on.getTargetKey() + quote;
+					} else {
+						String leftTableRelationSql = quote + jt + quote + "." + quote + on.getKey() + quote;
+						Object castValueType = castMap.get(on.getOriginKey());
+						if (castValueType != null) {
+							leftTableRelationSql = "CAST(" + leftTableRelationSql + " AS " + castValueType + ")";
+						}
+						sql += (first ? ON : AND) + leftTableRelationSql + (isNot ? " != " : " = ")
+								+ quote + on.getTargetTable() + quote + "." + quote + on.getTargetKey() + quote;
+					}
 				}
 				else {
 					onJoinComplexRelation(sql, quote, j, jt, onList, on);
