Equals match not working for subdocument in an array

[maheshrajamani]

If we have a data as below filter condition on entiry.identities.iAttributes works with $all but $eq not returning

{
                "entity": {
                    "entityType": "customer",
                    "status": "active",
                    "identities": 
                        {
                            "iRole": "individual",
                            "iAppCode": "CIS",
                            "iAttributes": [
                                {
                                    "aKey": "companyId",
                                    "aValue": "96"
                                },
                                {
                                    "aKey": "customerId",
                                    "aValue": "CHAMIL"
                                },
                                {
                                    "aKey": "customerTie",
                                    "aValue": "1"
                                },
                                {
                                    "aKey": "customerNumber",
                                    "aValue": "16562798"
                                }
                            ],
                            "identityKey": "customer-001",
                            "iStatus": "active",
                            "metadata": {
                                "createdDate": "2024-08-27T19:16:59Z",
                                "lastModifiedDate": "2024-08-27T19:16:59Z",
                                "createdBy": "CISBatchApp",
                                "lastModifiedBy": "CISBatchApp"
                            }
                        }
                    ,
                    "entityRelationshipLinks": [],
                    "identityRelationshipLinks": [],
                    "metadata": {
                        "createdDate": "2024-08-27T19:16:59Z",
                        "lastModifiedDate": "2024-08-27T19:16:59Z",
                        "createdBy": "CISBatchApp",
                        "lastModifiedBy": "CISBatchApp"
                    }
                }
            }

Working $all condition

{
    "find": {
        "filter": {
            "entity.identities.iAppCode": "CIS",
            "entity.identities.iAttributes": {
                "$all": [
                    {
                        "aKey": "companyId",
                        "aValue": "96"
                    }
                ]
            }
        }
    }
}

Not working equals:

{
    "find": {
        "filter": {
            "entity.identities.iAppCode": "CIS",
            "entity.identities.iAttributes": {
                "aKey": "companyId",
                "aValue": "96"
            }
        }
    }
}

[maheshrajamani]

The issue here is data-api uses query_text_values column for sub-document equals condition. If the data is array of subdocuments, the code considers the query as a sub document match and not an array element match.