You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Pavel Pereslegin (Jira)" <ji...@apache.org> on 2023/03/10 12:19:00 UTC
[jira] [Created] (IGNITE-19001) Sql. Query with distinct aggregate fails (H2 engine).
Pavel Pereslegin created IGNITE-19001:
-----------------------------------------
Summary: Sql. Query with distinct aggregate fails (H2 engine).
Key: IGNITE-19001
URL: https://issues.apache.org/jira/browse/IGNITE-19001
Project: Ignite
Issue Type: Bug
Reporter: Pavel Pereslegin
Sql fields query fails with assertion error for the query "SELECT COUNT(*), COUNT(DISTINCT(v)) FROM test".
Reproducer:
{code:java}
IgniteCache<?, ?> cache = startGrid().getOrCreateCache(DEFAULT_CACHE_NAME);
cache.query(new SqlFieldsQuery("CREATE TABLE test(id int primary key, v int)"));
cache.query(new SqlFieldsQuery("SELECT COUNT(*), COUNT(DISTINCT(v)) FROM test"));
{code}
Error:
{noformat}
java.lang.AssertionError
at org.apache.ignite.internal.processors.query.h2.sql.GridSqlQuerySplitter.splitAggregate(GridSqlQuerySplitter.java:1732)
at org.apache.ignite.internal.processors.query.h2.sql.GridSqlQuerySplitter.splitAggregates(GridSqlQuerySplitter.java:1611)
at org.apache.ignite.internal.processors.query.h2.sql.GridSqlQuerySplitter.splitSelectExpression(GridSqlQuerySplitter.java:1563)
at org.apache.ignite.internal.processors.query.h2.sql.GridSqlQuerySplitter.splitSelect(GridSqlQuerySplitter.java:1181)
at org.apache.ignite.internal.processors.query.h2.sql.GridSqlQuerySplitter.splitQueryModel(GridSqlQuerySplitter.java:1131)
at org.apache.ignite.internal.processors.query.h2.sql.GridSqlQuerySplitter.splitQuery(GridSqlQuerySplitter.java:378)
at org.apache.ignite.internal.processors.query.h2.sql.GridSqlQuerySplitter.split0(GridSqlQuerySplitter.java:290)
at org.apache.ignite.internal.processors.query.h2.sql.GridSqlQuerySplitter.split(GridSqlQuerySplitter.java:221)
at org.apache.ignite.internal.processors.query.h2.QueryParser.parseH2(QueryParser.java:552)
at org.apache.ignite.internal.processors.query.h2.QueryParser.parse0(QueryParser.java:229)
at org.apache.ignite.internal.processors.query.h2.QueryParser.parse(QueryParser.java:142)
at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.querySqlFields(IgniteH2Indexing.java:1006)
at org.apache.ignite.internal.processors.query.GridQueryProcessor$2.applyx(GridQueryProcessor.java:3111)
at org.apache.ignite.internal.processors.query.GridQueryProcessor$2.applyx(GridQueryProcessor.java:3082)
at org.apache.ignite.internal.util.lang.IgniteOutClosureX.apply(IgniteOutClosureX.java:36)
at org.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuery(GridQueryProcessor.java:3817)
at org.apache.ignite.internal.processors.query.GridQueryProcessor.lambda$querySqlFields$3(GridQueryProcessor.java:3128)
at org.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuerySafe(GridQueryProcessor.java:3256)
at org.apache.ignite.internal.processors.query.GridQueryProcessor.querySqlFields(GridQueryProcessor.java:3078)
at org.apache.ignite.internal.processors.query.GridQueryProcessor.querySqlFields(GridQueryProcessor.java:3006)
at org.apache.ignite.internal.processors.cache.IgniteCacheProxyImpl.query(IgniteCacheProxyImpl.java:819)
at org.apache.ignite.internal.processors.cache.IgniteCacheProxyImpl.query(IgniteCacheProxyImpl.java:767)
at org.apache.ignite.internal.processors.cache.GatewayProtectedCacheProxy.query(GatewayProtectedCacheProxy.java:428)
{noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)