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 browser doesn't always correctly apply updates #635

Closed
ryzhyk opened this issue Sep 4, 2023 · 0 comments · Fixed by #990
Closed

Table browser doesn't always correctly apply updates #635

ryzhyk opened this issue Sep 4, 2023 · 0 comments · Fixed by #990
Assignees
Labels
bug Something isn't working Web Console Related to the browser based UI

Comments

@ryzhyk
Copy link
Contributor

ryzhyk commented Sep 4, 2023

  • Create a program consisting of a single CREATE TABLE declaration:
create table json_test (
    b BOOLEAN,
    i INTEGER,
    d DOUBLE,
    v VARCHAR(32),
    cc CHAR(16),
    t TIME,
    ts TIMESTAMP,
    dt DATE,
    geo GEOMETRY,
    ar BIGINT ARRAY
);
  • Create and run a pipeline without connectors.
  • Open the "browse table" view in the browser.
  • Feed one record to the table:
curl -s -X 'POST' http://localhost:8080/v0/pipelines/018a6216-1598-7234-8876-3899017aced0/ingress/JSON_TEST?format=json -d '{"insert":{"B":true,"I":12345,"D":0.12345,"V":"foo","CC":"bar","T":"05:05:24","TS":"2023-11-21 23:19:09","DT":"1995-03-07","GEO":[2.3, 45.2],"AR": [1,2,3,4,5]}}'

The browser will correctly show the update:
image

  • Feed a different record:
curl -s -X 'POST' http://localhost:8080/v0/pipelines/018a6216-1598-7234-8876-3899017aced0/ingress/JSON_TEST?format=json -d '{"insert":{"B":false,"I":0,"D":0,"V":"foo","CC":"bar","T":"05:05:24","TS":"2023-11-21 23:19:09","DT":"1995-03-07","GEO":[2.3, 45.2],"AR": [1,2,3,4,5]}}'

The browser now shows two identical copies of the first records:

image.

  • Navigate to a different view in the browser and then come back to the BROWSE JSON_TEST view. The table will look correct now.

PS. The problem is not related to the use of "fancy" types like GEOMETRY and ARRAY and happens even without them.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working Web Console Related to the browser based UI
Projects
None yet
Development

Successfully merging a pull request may close this issue.

3 participants