{"record":{"id":"b6e9d82911095dca","repo":"mem0ai/mem0","slug":"oracle-filter-operator-operator-r-requires-a-non","errorCode":null,"errorMessage":"Oracle filter operator {operator!r} requires a non-empty list","messagePattern":"Oracle filter operator (.+?) requires a non-empty list","errorType":"validation","errorClass":"ValueError","httpStatus":null,"severity":"error","filePath":"mem0/vector_stores/oracledb.py","lineNumber":153,"sourceCode":"    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\n                variable, passing = _bind_filter_value(item, params)\n                variables.append(variable)\n                list_passings.append(passing)\n\n            membership = _json_exists(json_path, f\"@ in ({', '.join(variables)})\", list_passings)\n            if operator == \"in\":\n                additional_clauses.append(membership)\n            else:\n                additional_clauses.append(f\"NOT ({membership})\")\n            continue","sourceCodeStart":135,"sourceCodeEnd":171,"githubUrl":"https://github.com/mem0ai/mem0/blob/001c235229be8795e3834520467bd0d661ed8f34/mem0/vector_stores/oracledb.py#L135-L171","documentation":"Error \"Oracle filter operator {operator!r} requires a non-empty list\" thrown in mem0ai/mem0.","triggerScenarios":"Thrown at mem0/vector_stores/oracledb.py:153 when the library encounters an invalid state.","commonSituations":"See trigger scenarios.","solutions":["Pass a non-empty list of values for this Oracle filter 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"}