[Table Storage] Azurite filters not matching production filters for null values
- Dominant language
- TypeScript
- Stars
- 2.3k
- Forks
- 393
- Avg merge
- 1d 20h
- Merged PRs (30d)
- 36
Description
### Which service(blob, file, queue, table) does this issue concern?
Table
### Where do you get Azurite? (npm, DockerHub, NuGet, Visual Studio Code Extension)
Visual Studio Professional 2022 (v 17.8.4)
### What problem was encountered?
When trying to query for properties with null values or without them the query is different when using azurite and when using the real azure storage.
The following will filter out null values in azure storage but not in azurite
`[PROPERTY_NAME] lt ''`
While the following will filter out null values in azurite but not in azure storage
`[PROPERTY_NAME] gt ''`
### Steps to reproduce the issue?
Create a table, add two entities with a few properties, leave one property as NULL in one of the entities and execute a query using that property with the filters described above.
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.