Skip to content
This repository was archived by the owner on Aug 29, 2025. It is now read-only.
This repository was archived by the owner on Aug 29, 2025. It is now read-only.

Updating queries with different numbers and names of columns  #507

Closed

Description

@nicolaskruchten

Try the following scenario from Falcon with an SQL connector like Postgres:

  1. Create a query select 1 as a and save it. The result is as expected.
  2. Update it to select 2 as a and save it. The result is as expected.
  3. Update it to select 3 as b and save it. Note that the grid on the Plotly side still has the column named a and not b although the cell value in the row is indeed 3 and the metadata did get updated.
  4. Update it to select 3 as a, 4 as c and note the pattern: still 1 column only.
  5. Update it to select 3 and note the JSON error without indication of which processing-stage it came from.

A different set of examples is possible when the original dataset has more than 1 column and we try to update it with a dataset with fewer columns: more errors.

These errors don't appear in the webapp-based UI, presumably because it has a different set of API calls when registering a query change, which re-registers the columns?

Heads-up @scjody, this is likely a new blocker for 2.5.0.

Activity

  1. scjody commented on Aug 4, 2018

    @scjody

    @nicolaskruchten Is this a regression from 2.4.0? If so can you log an issue in streambed so we can add it to the project?

  2. nicolaskruchten commented on Aug 6, 2018

    @nicolaskruchten
    ContributorAuthor
  3. nicolaskruchten commented on Aug 6, 2018

    @nicolaskruchten
    ContributorAuthor

    FWIW I would consider just raising a user-visible error in cases like this, so that we can move forward with the release, if it's not feasible to actually resolve this fully/properly within the next few days.

  4. nicolaskruchten commented on Aug 10, 2018

    @nicolaskruchten
    ContributorAuthor

    Closed by #511

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Labels

No labels
No labels

Type

No type

Projects

No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions