Cannot get Policy with null value in EF core Adapter.

[vansangnguyen1998]

Cannot get Policy with null value in EF core Adapter.

[casbin-bot]

@sagilio @sociometry @AsakusaRinne

[hsluoyz]

@vansangnguyen1998 please:

1. Use pure Casbin API (enforcer, adapter, etc.) in the code (don't add your RESTful)
2. Clarify what you get and what you expect

[vansangnguyen1998]

@hsluoyz
With my models.conf above.
When use e.GetPolicy()
I get response 2 record:

• invoice, app, q, getInvoice, allow, 1
• invoice, app, q, getInvoice, allow, 234

My expect have to exists 3 record
2 record 2 above and 1 record with v5 null same image above ticket.

• invoice, app, q, getInvoice, allow
  

[sagilio]

This should be related to the SQL generated by the policy. I will try to reproduce it later.

[vansangnguyen1998]

@sagilio
I have reproduce with NodeJS with the same case, same data, and same model, Surprisingly, I can get all policy with the same my expectation (3 policy).
Please check again with CasbinNodeJS (Node Cas) and Casbin-Dotnet

please reproduce with dotnet ASAP help me.
Thanks all

[hsluoyz]

@vansangnguyen1998 if your problem is for one adapter, create issue in that adapter's repo, not here

[dacongda]

it seems that adapter is not the problem, the question is cause by function ValuesFrom in model/policy.cs, it use string.IsNullOrWhiteSpace to valid weather the field is exist , so when the field is blank , it will return false when TryAddPolicy call ValidatePolicy, and it will not appears in the result