Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Table Filters Returning No Results #26

Closed
bacon1986 opened this issue May 26, 2018 · 3 comments
Closed

Table Filters Returning No Results #26

bacon1986 opened this issue May 26, 2018 · 3 comments
Assignees
Labels
bug Something isn't working legacy Legacy Azurite V2 and previous versions table-storage Relating to Azurite table storage implementation

Comments

@bacon1986
Copy link

I'm using Azurite, Version 2.6.5 on Mac OSX

I perform the following request and I receive all results from the database:

GET /devstoreaccount1/Signposts HTTP/1.1
Host: 127.0.0.1:10002
Authorization: SharedKey devstoreaccount1:Eby8vdM02xNOcqFlqUwJPLlmEtlCDXJ1OUzFT50uSRZ6IFsuFq2UVErCz4I6tq/K1SZFPTOtr/KBHBeksoGMGw==
x-ms-date: 1527335502
Content-Type: application/json
x-ms-version: 2017-07-29
Cache-Control: no-cache
Postman-Token: 463d93a9-df19-49d1-8e59-eaf509432d41
{
    "value": [
        {
            "Timestamp": "2018-04-19T12:20:36.776Z",
            "title": "Benefits - GOV.UK",
            "description": "The best place to find government services and information. Simpler, clearer, faster",
            "url": "https://www.gov.uk/browse/benefits",
            "image": "/static/images/govuk.png",
            "categories": "Benefits",
            "PartitionKey": "Signposts",
            "RowKey": "574d5f400d3e106660158ac3"
        },
        {
            "Timestamp": "2018-04-19T12:20:36.791Z",
            "title": "Business & Self-Employment - GOV.UK",
            "description": "The best place to find government services and information. Simpler, clearer, faster",
            "url": "https://www.gov.uk/browse/business",
            "image": "/static/images/govuk.png",
            "categories": "Business",
            "PartitionKey": "Signposts",
            "RowKey": "574d5f400d3e106660158ac4"
        }
    ]
}

If I submit a request with a query (in this case on the PartitionKey) I get no results:

GET /devstoreaccount1/Signposts?$filter=PartitionKey%20eq%20%27Signposts%27 HTTP/1.1
Host: 127.0.0.1:10002
Authorization: SharedKey devstoreaccount1:Eby8vdM02xNOcqFlqUwJPLlmEtlCDXJ1OUzFT50uSRZ6IFsuFq2UVErCz4I6tq/K1SZFPTOtr/KBHBeksoGMGw==
x-ms-date: 1527335659
Content-Type: application/json
x-ms-version: 2017-07-29
Cache-Control: no-cache
Postman-Token: ae88e955-2304-409d-820f-60e5b0a7c6d3
{
    "value": []
}

This query was replayed via postman but I first tried the query via the Micosoft.WindowsAzure.Storage library which gave the same results.

Is the query wrong or is this a bug in Azurite?

Thanks

Simon

@bacon1986 bacon1986 changed the title Table Queries Returning No Results Table Filters Returning No Results May 26, 2018
@bacon1986
Copy link
Author

bacon1986 commented Jun 6, 2018

From some further testing it does seem that this only happens when filtering on RowKey and PartitionKey.
I can successfully filter on other fields so it seems that @kalleep has the right idea.

@nevercast
Copy link

@bacon1986 Care to retest this now that #28 has merged?

@XiaoningLiu XiaoningLiu added table-storage Relating to Azurite table storage implementation enhancement New feature or request bug Something isn't working and removed enhancement New feature or request labels Jul 18, 2018
@XiaoningLiu XiaoningLiu self-assigned this Jul 24, 2018
@edwin-huber edwin-huber added the legacy Legacy Azurite V2 and previous versions label Aug 13, 2019
@edwin-huber
Copy link
Collaborator

closing feature issues for legacy api, new table query api has been implemented for v3

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working legacy Legacy Azurite V2 and previous versions table-storage Relating to Azurite table storage implementation
Projects
None yet
Development

No branches or pull requests

4 participants