Tencent/APIJSON · error · IllegalArgumentException

子查询 {}/{}:{ range:value } 中 value 只能为 [ALL, ANY] 中的一个！

Error message

子查询 {}/{}:{ range:value } 中 value 只能为 [ALL, ANY] 中的一个！

What it means

When parsing a 'key{}@' subquery object, AbstractObjectParser reads its 'range' field and only allows the constants SUBQUERY_RANGE_ALL ('ALL') or SUBQUERY_RANGE_ANY ('ANY') — these map to SQL ALL/ANY quantifiers. If range is present and is neither of those exact strings (case-sensitive), an IllegalArgumentException is thrown naming the path and key.

Source

Thrown at APIJSONORM/src/main/java/apijson/orm/AbstractObjectParser.java:424

    //private boolean hasOtherKeyNotFun = false;

    /**解析普通成员
	 * @param key
	 * @param value
	 * @return whether parse succeed
	 */
	@Override
	public boolean onParse(@NotNull String key, @NotNull Object value) throws Exception {
		if (key.endsWith("@")) {  // StringUtil.isPath((String) value)) {
			// [] 内主表 position > 0 时，用来生成 SQLConfig<T, M, L> 的键值对全都忽略，不解析
			if (value instanceof Map<?, ?>) {  // key{}@ getRealKey, SQL 子查询对象，JSONRequest -> SQLConfig.getSQL
				String replaceKey = key.substring(0, key.length() - 1);

				M subquery = (M) value;
				String range = getString(subquery, KEY_SUBQUERY_RANGE);
				if (range != null && SUBQUERY_RANGE_ALL.equals(range) == false && SUBQUERY_RANGE_ANY.equals(range) == false) {
					throw new IllegalArgumentException("子查询 " + path + "/" + key + ":{ range:value } 中 value 只能为 ["
                            + SUBQUERY_RANGE_ALL + ", " + SUBQUERY_RANGE_ANY + "] 中的一个！");
				}

				L arr = parser.onArrayParse(subquery, path, key, true, null);

				M obj = arr == null || arr.isEmpty() ? null : JSON.get(arr, 0);
				if (obj == null) {
					throw new Exception("服务器内部错误，解析子查询 " + path + "/" + key + ":{ } 为 Subquery 对象失败！");
				}

				String from = getString(subquery, apijson.JSONRequest.KEY_SUBQUERY_FROM);
				boolean isEmpty = StringUtil.isEmpty(from);
				M arrObj = isEmpty ? null : JSON.get(obj, from);
				if (isEmpty) {
					Set<Entry<String, Object>> set = obj.entrySet();
					for (Entry<String, Object> e : set) {
						String k = e == null ? null : e.getKey();
						Object v = k == null ? null : e.getValue();

View on GitHub (pinned to 5284052872)

Solutions

1. Use exactly "ALL" or "ANY" (uppercase) for the range value.
2. Omit the range key entirely when you don't need the ALL/ANY quantifier.
3. For 'IN'-style membership, drop range and rely on the default subquery behavior instead of trying range values.

Example fix

// before
"id{}@": { "from": "Comment", "range": "all", "Comment": { "@column": "userId" } }
// after
"id{}@": { "from": "Comment", "range": "ALL", "Comment": { "@column": "userId" } }

Object range = subquery.get("range");
if (range != null && !"ALL".equals(range) && !"ANY".equals(range)) {
  throw new IllegalArgumentException("range must be ALL or ANY (uppercase)");
}

function isValidRange(r: unknown): boolean {
  return r == null || r === 'ALL' || r === 'ANY';
}

When it happens

Trigger: A request like "id{}@": { "from": "Comment", "Comment": { "@column": "userId" }, "range": "all" } — lowercase 'all', 'SOME', 'IN', or any other string. Omitting range entirely is fine (null passes).

Common situations: Writing 'all'/'any' in lowercase; assuming SQL 'SOME' or 'IN' semantics are supported; copy-pasting from docs that capitalize differently.

Related errors

• 子查询 {}/{}:{ from:value } 中 value 对应的主表对象 {}:{} 不存在！
• 字符 {} 不合法！远程函数不允许指定类名！且必须为 function(key0,key1,...) 这种单函数格式！\
• {}/{}:value 中 value 必须为 依赖路径String 或 SQL子查询JSONObject ！
• {}/{}:value 中 value 必须为函数String！
• {}/{}:{} 不合法！数组 []:{} 中每个 key:{} 都必须是表 TableKey:{} 或 数组 arra

AI-assisted analysis of Tencent/APIJSON@5284052872 (2026-08-14). Data as JSON: /api/errors/bb0ecac83ace078d. Report an issue: GitHub.