Skip to content

AggregateError (no explanation?) #1535

@emrecio

Description

@emrecio

Describe the bug
I have a query that runs just fine in psql(v13) to a postgresql server (v8). I receive a cryptic error "AggregateError"

To Reproduce
Steps to reproduce the behavior:

  1. Highlight SQL query selection
  2. Click on 'Run Selected Query '
  3. See error

Expected behavior
A table of the union of this selected query

-- who are the SAPs?
SELECT distinct sap, sap_desc, 'N' as blessed from wps2 where sap in ('221','224','225','226','227','228','260','261','263','264','268') and sap not in (select sap from wps2_blessed)
union
SELECT distinct sap, sap_desc, 'Y' as blessed from wps2 where sap in (select sap from wps2_blessed)
;

Screenshots
N/A

Desktop (please complete the following information):

  • SQLTools Version: 0.28.5
  • VS Code Version: 1.105.1 Universal
  • OS: Mac
  • Driver:
    • PostgreSQL/Redshift (0.5.7)
  • Database version: PostgreSQL v8.2.4

Additional context
Query works fine in psql, but not in vscode

Metadata

Metadata

Assignees

No one assigned

    Labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions