After turning on the trino dialect,filtering during aggregation return wrong data

[LZGH]

Steps to reproduce the behavior (Required)

set sql_dialect = 'trino';
select
    sum(id) filter (
        where
            id <= 1
    ) as aaa
from
    (
        SELECT
            1 AS id,
            'Alice' AS name
        UNION
        ALL
        SELECT
            2 AS id,
            'Bob' AS name
    ) AS simulated_data;

Expected behavior (Required)

1

Real behavior (Required)

3

StarRocks version (Required)

• You can get the StarRocks version by executing SQL select current_version()
  3.3.4

[dirtysalt]

@LZGH which version are you using right now?

I tried to reproduce this case.

set sql_dialect = 'trino';

And got following error

SQL Error [1064] [42000]: Trino parser parse sql error: [io.trino.sql.parser.ParsingException: line 7:8: mismatched input ','. Expecting: ], and StarRocks parser also can not parse: [com.starrocks.sql.parser.ParsingException: Getting syntax error at line 1, column 84. Detail message: Unexpected input '(', the most similar input is {, ';'}.]

Are my reproduce steps correct?

[LZGH]

@LZGH which version are you using right now?

I tried to reproduce this case.

set sql_dialect = 'trino';

And got following error

SQL Error [1064] [42000]: Trino parser parse sql error: [io.trino.sql.parser.ParsingException: line 7:8: mismatched input ','. Expecting: ], and StarRocks parser also can not parse: [com.starrocks.sql.parser.ParsingException: Getting syntax error at line 1, column 84. Detail message: Unexpected input '(', the most similar input is {, ';'}.]

Are my reproduce steps correct?

3.3.4

[LZGH]

@LZGH which version are you using right now?

I tried to reproduce this case.

set sql_dialect = 'trino';

And got following error

SQL Error [1064] [42000]: Trino parser parse sql error: [io.trino.sql.parser.ParsingException: line 7:8: mismatched input ','. Expecting: ], and StarRocks parser also can not parse: [com.starrocks.sql.parser.ParsingException: Getting syntax error at line 1, column 84. Detail message: Unexpected input '(', the most similar input is {, ';'}.]

Are my reproduce steps correct?

I have adjusted the example to make it easier to reproduce the problem.

[dirtysalt]

According to our team members, we don't even have this feature in starrocks correct? @Youngwb

Do you think we should support them in near future?