Skip to content

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

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;

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

Projects

No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions