[
https://issues.apache.org/jira/browse/IGNITE-14024?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17273460#comment-17273460
]
Lukas Eder commented on IGNITE-14024:
-------------------------------------
{quote}It's news for me that there is such syntaxis at all.
{quote}
That's interesting to hear 😀 You mean, this is just an artifact from the fact
that you're using (parts of) the H2 parser behind the scenes, and thus inherit
all its syntax, without necessarily inheriting its execution capabilities? That
would explain a few other issues I've encountered, recently, including:
https://issues.apache.org/jira/browse/IGNITE-14041
If that's the case, it's quite hard to assess what is really supported by
Ignite, and what isn't. Have you considered running H2's test suite? It has a
very convenient text file format that might be easily adapted to run on Ignite.
That way, you could perhaps quickly assess what other syntax you're parsing but
not really supporting, possibly adapting your error messages.
> Aggregate FILTER clause is implemented incorrectly
> --------------------------------------------------
>
> Key: IGNITE-14024
> URL: https://issues.apache.org/jira/browse/IGNITE-14024
> Project: Ignite
> Issue Type: Bug
> Components: sql
> Affects Versions: 2.9.1
> Reporter: Lukas Eder
> Priority: Major
>
> Try this query:
> {code:java}
> CREATE TABLE t (i int PRIMARY KEY, j int);
> INSERT INTO t VALUES (1, 1), (2, 2), (3, 3), (4, 4);
> SELECT count(j) FILTER (WHERE i > 2) FROM t;{code}
> The result is 4, when it should be 2
> This works:
> {code:java}
> SELECT count(j) FILTER (WHERE i > 2)
> FROM (VALUES (1, 1), (2, 2), (3, 3), (4, 4)) t(i, j);{code}
> Â
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
