Server:解决 MySQL 避免隐式转换后 json_contains 不兼容传数值

TommyLemon · TommyLemon · commit e9e0f6d89e2a · 2019-05-03T03:01:48.000+08:00
diff --git a/APIJSON-Java-Server/APIJSONORM/src/main/java/zuo/biao/apijson/server/AbstractSQLConfig.java b/APIJSON-Java-Server/APIJSONORM/src/main/java/zuo/biao/apijson/server/AbstractSQLConfig.java
@@ -1724,7 +1724,7 @@ public String getContainString(String key, Object[] childs, int type) throws Ill
 								+ getKey(key) + " @> " + getValue(newJSONArray(childs[i])); //operator does not exist: jsonb @> character varying  "[" + childs[i] + "]"); 
 					} else {
 						condition += (i <= 0 ? "" : (Logic.isAnd(type) ? AND : OR))
-								+ "json_contains(" + getKey(key) + ", " + getValue(childs[i]) + ")";
+								+ "json_contains(" + getKey(key) + ", " + getValue(childs[i].toString()) + ")";
 					}
 				}
 			}

Original file line number	Diff line number	Diff line change
`@@ -1724,7 +1724,7 @@ public String getContainString(String key, Object[] childs, int type) throws Ill`
`1724`	`1724`	`+ getKey(key) + " @> " + getValue(newJSONArray(childs[i])); //operator does not exist: jsonb @> character varying "[" + childs[i] + "]");`
`1725`	`1725`	`} else {`
`1726`	`1726`	`condition += (i <= 0 ? "" : (Logic.isAnd(type) ? AND : OR))`
`1727`		`- + "json_contains(" + getKey(key) + ", " + getValue(childs[i]) + ")";`
	`1727`	`+ + "json_contains(" + getKey(key) + ", " + getValue(childs[i].toString()) + ")";`
`1728`	`1728`	`}`
`1729`	`1729`	`}`
`1730`	`1730`	`}`