{"record":{"id":"606346b51211a19b","repo":"mem0ai/mem0","slug":"unsupported-oracle-filter-operator-s-for-field-m","errorCode":null,"errorMessage":"Unsupported Oracle filter operator(s) for field {metadata_key!r}: {', '.join(sorted(map(str, unsupported)))}","messagePattern":"Unsupported Oracle filter operator\\(s\\) for field (.+?): (.+?)","errorType":"validation","errorClass":"ValueError","httpStatus":null,"severity":"error","filePath":"mem0/vector_stores/oracledb.py","lineNumber":129,"sourceCode":"def _build_field_condition(metadata_key: str, value: Any, params: Dict[str, Any]) -> str:\n    json_path = _json_path(metadata_key)\n\n    if value == \"*\":\n        return f\"JSON_EXISTS(payload, '${json_path}')\"\n\n    if not isinstance(value, dict):\n        _validate_scalar_operand(\"eq\", value)\n        if value is None:\n            return _json_exists(json_path, \"@ == null\", [])\n        variable, passing = _bind_filter_value(value, params)\n        return _json_exists(json_path, f\"@ == {variable}\", [passing])\n\n    if not value:\n        raise ValueError(f\"Operator filter for field {metadata_key!r} must not be empty\")\n\n    unsupported = set(value) - _FIELD_OPERATORS\n    if unsupported:\n        raise ValueError(\n            f\"Unsupported Oracle filter operator(s) for field {metadata_key!r}: \"\n            f\"{', '.join(sorted(map(str, unsupported)))}\"\n        )\n\n    predicates: List[str] = []\n    passings: List[str] = []\n    additional_clauses: List[str] = []\n\n    for operator, operand in value.items():\n        if operator in _COMPARISON_OPERATORS:\n            _validate_scalar_operand(operator, operand)\n            if operand is None:\n                if operator not in {\"eq\", \"ne\"}:\n                    raise ValueError(f\"Oracle filter operator {operator!r} does not support null\")\n                predicates.append(f\"@ {_COMPARISON_OPERATORS[operator]} null\")\n                continue\n            variable, passing = _bind_filter_value(operand, params)\n            predicates.append(f\"@ {_COMPARISON_OPERATORS[operator]} {variable}\")","sourceCodeStart":111,"sourceCodeEnd":147,"githubUrl":"https://github.com/mem0ai/mem0/blob/001c235229be8795e3834520467bd0d661ed8f34/mem0/vector_stores/oracledb.py#L111-L147","documentation":"Error \"Unsupported Oracle filter operator(s) for field {metadata_key!r}: {', '.join(sorted(map(str, unsupported)))}\" thrown in mem0ai/mem0.","triggerScenarios":"Thrown at mem0/vector_stores/oracledb.py:129 when the library encounters an invalid state.","commonSituations":"See trigger scenarios.","solutions":["Use only supported Oracle filter operators (eq, ne, gt, gte, lt, lte, in, nin, contains, etc.)."],"exampleFix":null,"handlingStrategy":null,"validationCode":null,"typeGuard":null,"tryCatchPattern":null,"preventionTips":[],"tags":[],"backgroundTag":null,"analyzedSha":"001c235229be8795e3834520467bd0d661ed8f34","analyzedAt":"2026-08-15T01:55:42.685Z","schemaVersion":2},"datasetVersion":"2026-08-15T22:17:37.221Z"}