Skip to content

SQL: aggregate functions with single argument not processing modifiers #1037

@gramian

Description

@gramian

ArcadeDB Server v23.3.1 (build da609e4/1680693032550/main)

Running on Mac OS X 12.6.4 - OpenJDK 64-Bit Server VM Homebrew

The results of aggregate functions with a single argument (either literal or type) do not handle modifiers. It works as expected when using two arguments.

Expected behavior

LIST
1
INTEGER
INTEGER

Actual behavior

[1,2,3,4]
[1,2,3,4]
10
4

Steps to reproduce

CREATE DOCUMENT TYPE doc;
INSERT INTO doc (num) VALUES (1), (2), (3), (4);
SELECT unionall(num).type() FROM doc;
SELECT unionall(num)[0] FROM doc;
SELECT sum(num).type() FROM doc;
SELECT max(num).type() FROM doc;

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions