microsoft / AzureStorageExplorer

Easily manage the contents of your storage account with Azure Storage Explorer. Upload, download, and manage blobs, files, queues, tables, and Cosmos DB entities. Gain easy access to manage your virtual machine disks. Work with either Azure Resource Manager or classic storage accounts, plus manage and configure cross-origin resource sharing (CORS) rules.
Creative Commons Attribution 4.0 International
377 stars 87 forks source link

All entities are calculated when executing 'Table Statistics' for the queried entities #8285

Closed v-kellyluo closed 1 week ago

v-kellyluo commented 2 weeks ago

Storage Explorer Version: 1.37.0-dev (102) Build Number: 20241107.5 Branch: main Platform/OS: Windows 11/Windows 11/Linux Ubuntu 22.04/MacOS Sequoia 15.1(Apple M1 Pro) Architecture: arm64/x64/x64/arm64 How Found: From running test cases Regression From: Previous release (1.36.2)

Steps to Reproduce

  1. Expand one storage account -> Tables.
  2. Create a table -> Add several entities.
  3. Click 'Query' -> Add one clause -> Execute query.
  4. Click 'Table Statistics' -> Observe the activity log.
  5. Check whether only the queried entities are calculated.

Expected Experience

Only the queried entities are calculated. Image

Actual Experience

All entities are calculated. Image

craxal commented 1 week ago

Probably an oversight when refactoring tables to use the common components. Will look into it.

craxal commented 1 week ago

@v-kellyluo Can you please include the query you used?

v-kellyluo commented 1 week ago

@craxal , The query is PartitionKey eq '1'. Image

craxal commented 1 week ago

I found the problem. We weren't actually applying the working query when running the query. Should be fixed soon.

v-kellyluo commented 1 week ago

Verified this issue on the build 20241115.2. Fixed. So we're going to close it. Image