microsoft / microsoft/AzureStorageExplorer

Added new property to existing table does not sort

Open
#3,307 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

:gear: tables
Dominant language
No language data
Stars
452
Forks
92
Avg merge
15h 20m
Merged PRs (30d)
3

Description

Storage Explorer Version:
Version: 1.13.1 and updated to Version: 1.14.2

Build Number:
Build Number: 20200715.2

Platform/OS:
macOS Catalina

Architecture:
x64

Regression From:
Did not work in previous version

Bug Description

When we try to sort the table by with a newly added property, it times out.

Steps to Reproduce

After creating an Azure Storage Table and populating it with data with properties: PartitionKey, RowKey, a, b, c, d
We later decided to add 3 more properties with all 3 in double type, lets name is: x, y, z
Then we continue to add more entities.
When we try to sort by property x, y, or z. All three sort options would time out. My guess is, it might be an indexing issue. Only the initially created properties are indexed.

Expected Experience

The recent added properties (post initial creation) to be sortable, like the initial added properties.

Actual Experience

Sort times out

Additional Context

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Reproduce the issue in Azure Storage Explorer using a table with properties added after the initial entities, then sort by the newly added double-valued properties. Compare sorting those properties with the initially created ones and investigate why the newer-property queries time out. Done means all listed properties sort successfully without timing out.

Written by the indexing model from the issue text.

Assessment

Tech stack
azure
Domain
cloud, databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
30/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.