Pivot: sorting by a column triggers a 400 error from the Aggregation API

[ericpgreen2]

I've tried to sort by FuboTV Requests:

Here's the error from the Aggregation API:

{
    "code": 2,
    "message": "Binder Error: Values list \"auction_data_model\" does not have a column named \"__time\"",
    "details": []
}

Link: https://ui.rilldata.com/demo/rill-openrtb-prog-ads/auction?state=CgUKA1AxVxgFKghyZXF1ZXN0czgASAFYAWAEagdFdGMvVVRDeAKAAQGYAf%252F%252F%252F%252F%252F%252F%252F%252F%252F%252F%252FwGiAQQaAggIsAEBugEBBMIBD2FwcF9zaXRlX2RvbWFpbtIBDWFwcF9zaXRlX25hbWXaAQhyZXF1ZXN0c%252BoBCggBEgZjMHYybTDwAQH4AQKAAgQ%253D

[mindspank]

Can't reproduce in the same dash with a fresh state proto.

[ericpgreen2]

I just tried to reproduce and now I'm getting slightly different buggy behavior. Sorting by a column causes the table to disappear entirely. JAM: https://jam.dev/c/52b0109d-9f1e-4608-be4c-fe6fa99e5964

[djbarnwal]

Looks like a bug with the API. @egor-ryashin can you take a look? The request and response is available in the jam link above.

[egor-ryashin]

Thanks https://github.com/rilldata/rill/pull/4667

[begelundmuller]

Closed by https://github.com/rilldata/rill/pull/4667