Skip to content

[BUG] Redshift: Query completes but result does not populate #1271

Open
@victorvpham

Description

@victorvpham
  • Database type and version: Redshift | PostgreSQL 8.0.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.4.2 20041017 (Red Hat 3.4.2-6.fc3), Redshift 1.0.74097

Running queries from Terminal works (Full data and output of rows).
Running system queries like (SELECT version(); SELECT getdate();) work and output in Results tab is correct.
However the Results tab seems to hang and never outputs the data (Spinning blue dots continuously and cost counter keeps running up), when running query on a table with data (eg. SELECT count(1) FROM public.user; SELECT * FROM public.user LIMIT 10;). Note, the output message seems to indicate the query was successful (eg. Result: 10 rows retrieved in 179ms).

Attached screenshot for more details:
Screenshot 2024-09-12 at 11 35 04 AM

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't workingpriority-lowDifficult to reproduce or needs additional information

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions