microsoft
An error info prompts when executing query in one emulator table if there is no queried clause
Storage Explorer Version: 1.25.0-dev Build Number: 20220519.1 Branch: main Platform/OS: Windows 10 Architecture: ia32 Azurite Version: 3.17.1 How Found: Ad-hoc testing Regression From: Previous release (1.21.3)
Steps to Reproduce
- Install and run Azurite 3.17.1 -> Launch Storage Explorer.
- Expand 'Local & Attached -> Storage Accounts -> (Emulator - Default Ports) (Key)' -> Tables.
- Create a table -> Click 'Query' -> Don't add any clause.
- Execute query -> Check whether no error info prompts.
Expected Experience
No error info prompts.
Actual Experience
An error info prompts.
Additional Context
Error details:
{"odata.error":{"code":"InvalidInput","message":{"lang":"en-US","value":"The query condition specified in the request is invalid.\nRequestId:cdc2ba30-2551-4b29-879c-0cef7593b668\nTime:2022-05-19T09:48:51.915Z"}}}
@v-kellyluo There's some conflicting information between the bug title and the repro steps. Are you executing the default query that is created, or are you removing all clauses before executing the query?
@craxal ,
In a new created table, there is no default clause after clicking Query if no entity is added,
This issue also reproduces when executing query if removing all clauses.
Here is the record:
This appears to be a problem with the emulator and not Storage Explorer. I believe trying to run a query with no clauses is an edge case that not many users will run into. I will file a bug (https://github.com/Azure/Azurite/issues/1573), but I consider this a lower priority to get fixed.
Verified this issue on the build main/20221226.3, there is always at least one clause, so close this bug.
