[BUG] Func delegate Filter in Tableclient.QueryAsync does not support Equals(x, StringComparison) method

[arsamigullin]

Library name and version

Azure.Data.Tables 12.10.0

Describe the bug

Before upgrading Azure.Data.Tables to 12.10.0 we used 12.8.3 version where this code worked without errors

Tableclient.QueryAsync(x=>x.Equals("test", StringComparison.OrdinalIgnoreCase), null, columns, cancellationToken)

After upgrading to 12.10.0 we started seeing this error

"message": "Equals method with more than two arguments is not supported.",
"type": "System.NotSupportedException",

Expected behavior

This code works without error when using Azure.Data.Tables, Version=12.10.0

Tableclient.QueryAsync<T>(x=>x.Equals("test", StringComparison.OrdinalIgnoreCase), null, columns, cancellationToken)

Actual behavior

After upgrading to Azure.Data.Tables to 12.10.0 we started seeing this error

"message": "Equals method with more than two arguments is not supported.",
"type": "System.NotSupportedException",

StackTrace:

{
"assembly": "Azure.Data.Tables, Version=12.10.0.0, Culture=neutral, PublicKeyToken=92742159e12e44c8",
"method": "Azure.Data.Tables.Queryable.ExpressionNormalizer.VisitMethodCallNoRewrite",
"level": 0,
"line": 0
},
{
"assembly": "Azure.Data.Tables, Version=12.10.0.0, Culture=neutral, PublicKeyToken=92742159e12e44c8",
"method": "Azure.Data.Tables.Queryable.ExpressionNormalizer.VisitMethodCall",
"level": 1,
"line": 0
},
{
"assembly": "System.Linq.Expressions, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a",
"method": "System.Linq.Expressions.ExpressionVisitor.VisitBinary",
"level": 2,
"line": 0
},
{
"assembly": "Azure.Data.Tables, Version=12.10.0.0, Culture=neutral, PublicKeyToken=92742159e12e44c8",
"method": "Azure.Data.Tables.Queryable.ExpressionNormalizer.VisitBinary",
"level": 3,
"line": 0
},
{
"assembly": "System.Linq.Expressions, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a",
"method": "System.Linq.Expressions.ExpressionVisitor.VisitLambda",
"level": 4,
"line": 0
},
{
"assembly": "Azure.Data.Tables, Version=12.10.0.0, Culture=neutral, PublicKeyToken=92742159e12e44c8",
"method": "Azure.Data.Tables.TableClient.Bind",
"level": 5,
"line": 0
},
{
"assembly": "Azure.Data.Tables, Version=12.10.0.0, Culture=neutral, PublicKeyToken=92742159e12e44c8",
"method": "Azure.Data.Tables.TableClient.QueryAsync",
"level": 6,
"line": 0
}

Reproduction Steps

Pass filter Func delegate

x=>x.Equals("test", StringComparison.OrdinalIgnoreCase)

to the Tableclient.QueryAsync, i.e.

Tableclient.QueryAsync<T>(x=>x.Equals("test", StringComparison.OrdinalIgnoreCase), null, columns, cancellationToken)

Environment

No response

[jsquire]

Hi @arsamigullin. Thanks for reaching out and we regret that you're experiencing difficulties. This is by design. As discussed in #49675, the previous version accepted the comparison argument and then ignored it:

The error you are seeing is by design and is a breaking change in the 12.10.0 version of the SDK as noted in the CHANGELOG. Previously, the StringComparison argument was silently ignored as the Azure Table service does not support these methods in a query filter. The linked CHANGELOG has instructions to configure the SDK to not throw to match the behavior prior to version 12.10.0, if you wish to do so.

Otherwise, you will need to perform a case sensitive search and filter the items locally.

Please see #49675 for additional context and discussion.

[github-actions]

Hi @arsamigullin. Thank you for opening this issue and giving us the opportunity to assist. We believe that this has been addressed. If you feel that further discussion is needed, please add a comment with the text "/unresolve" to remove the "issue-addressed" label and continue the conversation.

[github-actions]

Hi @arsamigullin, since you haven’t asked that we /unresolve the issue, we’ll close this out. If you believe further discussion is needed, please add a comment /unresolve to reopen the issue.