APIJSON
diff --git a/‎APIJSONORM/src/main/java/apijson/orm/AbstractSQLConfig.java‎
Lines changed: 4 additions & 1 deletion b/‎APIJSONORM/src/main/java/apijson/orm/AbstractSQLConfig.java‎
Lines changed: 4 additions & 1 deletion
@@ -4651,7 +4651,10 @@ public String gainContainString(String key, String column, Object[] childs, int
 					condition += (gainKey(column) + " @> " + gainValue(key, column, newJSONArray(c)));
 					// operator does not exist: jsonb @> character varying  "[" + c + "]");
 				}
-				else if (isOracle() || isDameng() || isKingBaseOracle() || isKingBaseSQLServer()) {
+				else if (isKingBaseSQLServer()) {
+					condition += (gainKey(column) + "::jsonb @> " + gainValue(key, column, newJSONArray(c)) + "::jsonb");
+				}
+				else if (isOracle() || isDameng() || isKingBaseOracle()) {
 					condition += ("json_textcontains(" + gainKey(column) + ", " + (StringUtil.isEmpty(path, true)
 							? "'$'" : gainValue(key, column, path)) + ", " + gainValue(key, column, c == null ? null : c.toString()) + ")");
 				}
Original file line number	Diff line number	Diff line change
`@@ -4651,7 +4651,10 @@ public String gainContainString(String key, String column, Object[] childs, int`
`4651`	`4651`	`condition += (gainKey(column) + " @> " + gainValue(key, column, newJSONArray(c)));`
`4652`	`4652`	`// operator does not exist: jsonb @> character varying "[" + c + "]");`
`4653`	`4653`	`}`
`4654`		`- else if (isOracle() \|\| isDameng() \|\| isKingBaseOracle() \|\| isKingBaseSQLServer()) {`
	`4654`	`+ else if (isKingBaseSQLServer()) {`
	`4655`	`+ condition += (gainKey(column) + "::jsonb @> " + gainValue(key, column, newJSONArray(c)) + "::jsonb");`
	`4656`	`+ }`
	`4657`	`+ else if (isOracle() \|\| isDameng() \|\| isKingBaseOracle()) {`
`4655`	`4658`	`condition += ("json_textcontains(" + gainKey(column) + ", " + (StringUtil.isEmpty(path, true)`
`4656`	`4659`	`? "'$'" : gainValue(key, column, path)) + ", " + gainValue(key, column, c == null ? null : c.toString()) + ")");`
`4657`	`4660`	`}`