Skip to content

SQL: aggregating projection returns nothing #3585

@gramian

Description

@gramian

ArcadeDB Server v26.4.1-SNAPSHOT (build 0db79073e18e153b71847e824493dc833a5698be/1772787794018/main)

Running on Mac OS X 15.7.3 - OpenJDK 64-Bit Server VM 25.0.2 (Homebrew)

Adding to a projection which aggregates but the type has no records results in an empty result.

Setup:

CREATE DOCUMENT TYPE doc;

This works as expected, returning 1 record with the count 0:

SELECT count(*) FROM doc

These return no records:

SELECT count(*), 2 FROM doc
SELECT count(*), $x FROM doc
LET $x = 2;

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions