Azure Cosmos DB $regexMatch issue

[StarkLiew]

I ran into issue with Azure Cosmos DB with latest ver 8 during deployment.

My solution a quick fix via monkey patch of query_utils.py

def regex_match(field, regex_vals, insensitive=False):
    """
    Safe override for MongoDB $regexMatch to ensure input is a string.
    """
    regex = {"$concat": regex_vals} if isinstance(regex_vals, tuple) else regex_vals
    options = "i" if insensitive else ""

    return {
        "$regexMatch": {
            "input": {
                "$cond": [
                    {"$eq": [{"$type": field}, "string"]},
                    field,
                    {"$toString": field}
                ]
            },
            "regex": regex,
            "options": options
        }
    }

[timgraham]

Please provide steps (model and queryset) to reproduce the issue. It could be a valid issue if the steps don't work on MongoDB, otherwise the report should be directed to Cosmos DB (if they claim interoperability with MongoDB).

[timgraham]

Closing as "needs info".