Server：新增撤回 ^ SIDE JOIN 修改的说明

TommyLemon · TommyLemon · commit 1eebd7b01ab4 · 2020-05-02T03:02:41.000+08:00
diff --git a/APIJSON-Java-Server/APIJSONORM/src/main/java/apijson/orm/AbstractSQLConfig.java b/APIJSON-Java-Server/APIJSONORM/src/main/java/apijson/orm/AbstractSQLConfig.java
@@ -1387,6 +1387,7 @@ else if ("!".equals(ce.getKey())) {
 						newWs += AND;
 					}
 
+					//MySQL 因为 NULL 值处理问题，(A & ! B) | (B & ! A) 与 ! (A & B) 返回结果不一样，后者往往更多
 					if ("^".equals(j.getJoinType())) { // (A & ! B) | (B & ! A)
 						newWs += " (   ( " + ws + ( StringUtil.isEmpty(ws, true) ? "" : AND + NOT ) + " ( " + js + " ) ) "
 								+ OR

Original file line number	Diff line number	Diff line change
`@@ -1387,6 +1387,7 @@ else if ("!".equals(ce.getKey())) {`
`1387`	`1387`	`newWs += AND;`
`1388`	`1388`	`}`
`1389`	`1389`
	`1390`	`+ //MySQL 因为 NULL 值处理问题，(A & ! B) \| (B & ! A) 与 ! (A & B) 返回结果不一样，后者往往更多`
`1390`	`1391`	`if ("^".equals(j.getJoinType())) { // (A & ! B) \| (B & ! A)`
`1391`	`1392`	`newWs += " ( ( " + ws + ( StringUtil.isEmpty(ws, true) ? "" : AND + NOT ) + " ( " + js + " ) ) "`
`1392`	`1393`	`+ OR`