{"record":{"id":"ff73e09f213ebe67","repo":"mem0ai/mem0","slug":"oracle-filter-operator-operator-r-does-not-suppo","errorCode":null,"errorMessage":"Oracle filter operator {operator!r} does not support null","messagePattern":"Oracle filter operator (.+?) does not support null","errorType":"validation","errorClass":"ValueError","httpStatus":null,"severity":"error","filePath":"mem0/vector_stores/oracledb.py","lineNumber":143,"sourceCode":"        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}\")\n            passings.append(passing)\n            continue\n\n        if operator in {\"in\", \"nin\"}:\n            if not isinstance(operand, (list, tuple)) or not operand:\n                raise ValueError(f\"Oracle filter operator {operator!r} requires a non-empty list\")\n\n            variables: List[str] = []\n            list_passings: List[str] = []\n            for item in operand:\n                _validate_scalar_operand(operator, item)\n                if item is None:\n                    variables.append(\"null\")\n                    continue","sourceCodeStart":125,"sourceCodeEnd":161,"githubUrl":"https://github.com/mem0ai/mem0/blob/001c235229be8795e3834520467bd0d661ed8f34/mem0/vector_stores/oracledb.py#L125-L161","documentation":"Error \"Oracle filter operator {operator!r} does not support null\" thrown in mem0ai/mem0.","triggerScenarios":"Thrown at mem0/vector_stores/oracledb.py:143 when the library encounters an invalid state.","commonSituations":"See trigger scenarios.","solutions":["This operator does not accept null; provide a concrete value or use a null-capable operator."],"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"}