[
https://issues.apache.org/jira/browse/IGNITE-19001?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Pavel Pereslegin updated IGNITE-19001:
--------------------------------------
Component/s: sql
> 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
> Components: sql
> Reporter: Pavel Pereslegin
> Priority: Major
>
> Sql fields query fails with assertion error for the query
> {code:sql}
> SELECT COUNT(*), COUNT(DISTINCT(v)) FROM test
> {code}
> (if we replace {{count( *)}} with {{count(v)}}, everything will work)
> 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)
