See 
<https://ci-builds.apache.org/job/Calcite/job/Calcite-snapshots/513/display/redirect?page=changes>

Changes:

[nobigogle] [CALCITE-5711] Implement the SINGLE_VALUE aggregation in PostgreSQL 
Dialect


------------------------------------------
[...truncated 459.49 KB...]
          2.9sec, 
org.apache.calcite.adapter.innodb.InnodbAdapterTest > 
testSelectBySkTimeRangeQueryNothing()
          3.4sec, 
org.apache.calcite.adapter.innodb.InnodbAdapterTest > 
testSelectBySkTimestampRangeQueryGteProjectSomeFields()
          2.0sec, 
org.apache.calcite.adapter.innodb.InnodbAdapterTest > 
testSelectByMultipleSkTinyIntDecimalDecimalPointQueryProjectSomeFields()
          2.1sec, 
org.apache.calcite.adapter.innodb.InnodbAdapterTest > 
testSelectByMultipleSkForceIndexOrderByDesc()
          3.9sec, 
org.apache.calcite.adapter.innodb.InnodbAdapterTest > 
testSelectByMultipleSkWithSameLeftPrefixChooseOneIndex()
          2.6sec, 
org.apache.calcite.adapter.innodb.InnodbAdapterTest > 
testSelectByMultipleSkRangeQueryPushDownPartialCondition2()
          2.4sec, 
org.apache.calcite.adapter.innodb.InnodbAdapterTest > 
testSelectByMultipleSkForceIndexAsPrimaryKey()
          2.8sec, 
org.apache.calcite.adapter.innodb.InnodbAdapterTest > 
testSelectByMultipleSkRangeQueryPushDownPartialCondition3()
          4.5sec, 
org.apache.calcite.adapter.innodb.InnodbAdapterTest > 
testSelectBySkDateRangeQueryLtProjectSomeFieldsOrderByDesc()
          3.5sec, 
org.apache.calcite.adapter.innodb.InnodbAdapterTest > 
testJoinProjectAndFilterPushDown()
          2.7sec, 
org.apache.calcite.adapter.innodb.InnodbAdapterTest > 
testJoinProjectAndFilterPushDown2()
          2.4sec, 
org.apache.calcite.adapter.innodb.InnodbAdapterTest > 
testGroupByFilterPushDown()
          6.5sec, 
org.apache.calcite.adapter.innodb.InnodbAdapterTest > 
testSelectByPrimaryKeyRangeQueryGteLteEqualsProjectSomeFields()
          4.8sec, 
org.apache.calcite.adapter.innodb.InnodbAdapterTest > 
testSelectByPrimaryKey()
         32.6sec,   83 completed,   0 failed,   0 skipped, 
org.apache.calcite.adapter.innodb.InnodbAdapterTest
         39.2sec,   85 completed,   0 failed,   0 skipped, Gradle Test Run 
:innodb:test

> Task :redis:test
         20.3sec, 
org.apache.calcite.adapter.redis.RedisAdapterCaseBase > 
testSqlWithJoin()
          4.5sec, 
org.apache.calcite.adapter.redis.RedisAdapterCaseBase > 
testRedisBySql()
         51.7sec,    2 completed,   0 failed,   0 skipped, 
org.apache.calcite.adapter.redis.RedisAdapterCaseBase
WARNING  59.0sec,    3 completed,   0 failed,   1 
skipped, Gradle Test Run :redis:test

> Task :plus:test
         50.8sec, org.apache.calcite.adapter.tpch.TpchTest 
> testQuery02Conversion()
         52.1sec, org.apache.calcite.adapter.tpch.TpchTest 
> testQuery02()

> Task :spark:test
         42.2sec, org.apache.calcite.test.SparkAdapterTest 
> testFilterIsNotNull()
         42.2sec, org.apache.calcite.test.SparkAdapterTest 
> testUnionAll()
         42.1sec, org.apache.calcite.test.SparkAdapterTest 
> testSelectDistinct()
         42.4sec, org.apache.calcite.test.SparkAdapterTest 
> testUnion()
         42.4sec, org.apache.calcite.test.SparkAdapterTest 
> testFilterIsNull()
         42.4sec, org.apache.calcite.test.SparkAdapterTest 
> testOrderByLimit()
         42.4sec, org.apache.calcite.test.SparkAdapterTest 
> testFilterFalse()
         42.5sec, org.apache.calcite.test.SparkAdapterTest 
> testFilterTrue()
         42.4sec, org.apache.calcite.test.SparkAdapterTest 
> testGroupByOrderByAsc()
         42.3sec, org.apache.calcite.test.SparkAdapterTest 
> testArithmeticPlus()
         42.4sec, org.apache.calcite.test.SparkAdapterTest 
> testFilterOr()
         42.4sec, org.apache.calcite.test.SparkAdapterTest 
> testSortXDescYAscProjectY()
         42.6sec, org.apache.calcite.test.SparkAdapterTest 
> testLimit()
         42.6sec, org.apache.calcite.test.SparkAdapterTest 
> testSortXDescYDescProjectY()
         42.4sec, org.apache.calcite.test.SparkAdapterTest 
> testArithmeticMul()
         42.4sec, org.apache.calcite.test.SparkAdapterTest 
> testSortXAscProjectY()
         42.4sec, org.apache.calcite.test.SparkAdapterTest 
> testArithmeticDiv()
         42.4sec, org.apache.calcite.test.SparkAdapterTest 
> testSortXAscYDescProjectY()
         42.4sec, org.apache.calcite.test.SparkAdapterTest 
> testJoinProjectAliasProject()
         42.3sec, org.apache.calcite.test.SparkAdapterTest 
> testJoinProject()
         42.4sec, org.apache.calcite.test.SparkAdapterTest 
> testUnionWithFiltersProject()
         43.8sec, org.apache.calcite.test.SparkAdapterTest 
> testGroupByMinMaxCountCountDistinctOrderByAsc()
         44.0sec, org.apache.calcite.test.SparkAdapterTest 
> testAggFuncNoGroupBy()
         44.1sec, org.apache.calcite.test.SparkAdapterTest 
> testGroupBy()
          2.3sec, org.apache.calcite.test.SparkAdapterTest 
> testGroupByMiMaxCountCountDistinctOrderByDesc()
WARNING  45.2sec,   38 completed,   0 failed,   4 
skipped, org.apache.calcite.test.SparkAdapterTest
WARNING  55.7sec,   38 completed,   0 failed,   4 
skipped, Gradle Test Run :spark:test

> Task :piglet:test
         21.3sec, org.apache.calcite.test.PigletTest > 
testLimitExample()
         21.7sec, org.apache.calcite.test.PigletTest > 
testGroupExample()
         22.3sec, org.apache.calcite.test.PigletTest > 
testFilterExample()
WARNING  22.7sec,   19 completed,   0 failed,   1 
skipped, org.apache.calcite.test.PigletTest
         25.3sec, org.apache.calcite.test.PigRelExTest > 
testIsNotNull()
         25.5sec, org.apache.calcite.test.PigRelExTest > 
testNegation()
          5.0sec, org.apache.calcite.test.PigRelExTest > 
testGreaterThanEqual()
         25.5sec, org.apache.calcite.test.PigRelExTest > 
testLessThan()
          7.8sec, org.apache.calcite.test.PigRelExTest > 
testAnd()
          4.4sec, org.apache.calcite.test.PigRelExTest > 
testSubtract()
         25.6sec, org.apache.calcite.test.PigRelExTest > 
testNotEqual()
         24.7sec, org.apache.calcite.test.PigRelExTest > 
testAdd()
          7.6sec, org.apache.calcite.test.PigRelExTest > 
testNot()
         26.1sec, org.apache.calcite.test.PigRelOpTest > 
testLoadWithSchema()
          8.4sec, org.apache.calcite.test.PigRelExTest > 
testMod()
          4.4sec, org.apache.calcite.test.PigRelOpTest > 
testLoadWithoutSchema()
          4.6sec, org.apache.calcite.test.PigRelOpTest > 
testFlattenStrSplit()
         27.1sec, org.apache.calcite.test.PigScriptTest > 
testReadScript()
         27.8sec,    1 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.PigScriptTest
          2.1sec, org.apache.calcite.test.PigRelExTest > 
testEqual()
          2.1sec, org.apache.calcite.test.PigRelOpTest > 
testSimpleForEach1()
          8.7sec, org.apache.calcite.test.PigRelOpTest > 
testLimit()
          2.5sec, org.apache.calcite.test.PigRelOpTest > 
testSample()
         28.7sec, org.apache.calcite.test.PigRelOpTest > 
testUnionDifferentSchemas1()
         11.3sec, org.apache.calcite.test.PigRelOpTest > 
testUdf()
         11.3sec, org.apache.calcite.test.PigRelOpTest > 
testAggregate2half()
          8.6sec, org.apache.calcite.test.PigRelOpTest > 
testSplit()
          3.2sec, org.apache.calcite.test.PigRelOpTest > 
testRankAndFilter()
         30.0sec, org.apache.calcite.test.PigRelOpTest > 
testUnionDifferentSchemas2()
          3.9sec, org.apache.calcite.test.PigRelOpTest > 
testSimpleForEach2()
          3.8sec, org.apache.calcite.test.PigRelOpTest > 
testSimpleForEach3()
          4.9sec, org.apache.calcite.test.PigRelOpTest > 
testMultipleStores()
          5.4sec, org.apache.calcite.test.PigRelOpTest > 
testGroupby()
          3.7sec, org.apache.calcite.test.PigRelOpTest > 
testAggregate4()
         31.0sec, org.apache.calcite.test.PigRelOpTest > 
testOrderBy()
         13.4sec, org.apache.calcite.test.PigRelOpTest > 
testCross()
          2.5sec, org.apache.calcite.test.PigRelOpTest > 
testDistinct()
         10.0sec, org.apache.calcite.test.PigRelOpTest > 
testRank()
          2.6sec, org.apache.calcite.test.PigRelOpTest > 
testLoadFromFile()
          3.8sec, org.apache.calcite.test.PigRelOpTest > 
testCubeCube()
          2.3sec, org.apache.calcite.test.PigRelOpTest > 
testGroupby2()
          2.3sec, org.apache.calcite.test.PigRelOpTest > 
testUnionSameSchema()
          3.8sec, org.apache.calcite.test.PigRelOpTest > 
testAggregate()
          5.1sec, org.apache.calcite.test.PigRelOpTest > 
testAggregate2()
          6.7sec, org.apache.calcite.test.PigRelExTest > 
testCast()
          5.0sec, org.apache.calcite.test.PigRelOpTest > 
testCoGroup()
WARNING  33.0sec,   29 completed,   0 failed,   1 
skipped, org.apache.calcite.test.PigRelExTest

> Task :testkit:test

FixtureTest > testMetadata() STANDARD_ERROR
    SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
    SLF4J: Defaulting to no-operation (NOP) logger implementation
    SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further 
details.
          0.9sec,    1 completed,   0 failed,   0 skipped, 
org.apache.calcite.TestKtTest
          1.1sec,    5 completed,   0 failed,   0 skipped, 
org.apache.calcite.util.TestUtilTest
          2.1sec, org.apache.calcite.test.FixtureTest > 
testSqlToRelFixtureEnsure()
          2.1sec, org.apache.calcite.test.FixtureTest > 
testSqlToRelFixtureNeedsDiffRepos()
          3.4sec, org.apache.calcite.test.FixtureTest > 
testParserFixture()
          4.7sec, org.apache.calcite.test.FixtureTest > 
testValidatorFixture()
         10.1sec, org.apache.calcite.test.FixtureTest > 
testSqlToRelFixture()
         10.3sec, org.apache.calcite.test.FixtureTest > 
testRuleFixtureNeedsDiffRepos()
         11.1sec, org.apache.calcite.test.FixtureTest > 
testMetadata()
         11.7sec, org.apache.calcite.test.FixtureTest > 
testRuleFixture()
         13.4sec, org.apache.calcite.test.FixtureTest > 
testOperatorFixture()
         13.8sec,    9 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.FixtureTest
         22.0sec,   15 completed,   0 failed,   0 skipped, Gradle Test Run 
:testkit:test

> Task :elasticsearch:test
    2023-07-03 08:06:35,903 [elasticsearch[fake-elastic][scheduler][T#1]] WARN  
- [gc][1] overhead, spent [1.2s] collecting in the last [1.9s]

> Task :piglet:test
          6.9sec, org.apache.calcite.test.PigRelOpTest > 
testJoin3Rels()
          2.6sec, org.apache.calcite.test.PigRelOpTest > 
testCubeRollup()
          5.5sec, org.apache.calcite.test.PigRelOpTest > 
testAggregate3()
          7.1sec, org.apache.calcite.test.PigRelOpTest > 
testJoin2Rels()
          4.5sec, org.apache.calcite.test.PigRelOpTest > 
testForEachNested()
         33.4sec,   35 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.PigRelOpTest
WARNING  43.2sec,  106 completed,   0 failed,   2 
skipped, Gradle Test Run :piglet:test

> Task :plus:test
         33.0sec, org.apache.calcite.adapter.tpch.TpchTest 
> testQuery21()

> Task :geode:test
         17.6sec, 
org.apache.calcite.adapter.geode.rel.GeodeBookstoreTest > 
testSqlSimple()
         17.6sec, 
org.apache.calcite.adapter.geode.rel.GeodeAllDataTypesTest > 
testSqlSingleBooleanWhereFilter()
         18.0sec, 
org.apache.calcite.adapter.geode.rel.GeodeAllDataTypesTest > 
testSqlBooleanColumnNotFilter()
         18.1sec, 
org.apache.calcite.adapter.geode.rel.GeodeAllDataTypesTest > 
testSqlMultipleTimestampWhereFilter()
         18.0sec, 
org.apache.calcite.adapter.geode.rel.GeodeAllDataTypesTest > 
testSqlMultipleDateWhereFilter()
         18.0sec, 
org.apache.calcite.adapter.geode.rel.GeodeAllDataTypesTest > 
testSqlMultipleBooleanWhereFilter()
         18.0sec, 
org.apache.calcite.adapter.geode.rel.GeodeAllDataTypesTest > 
testSqlMultipleTimeWhereFilter()
         18.0sec, 
org.apache.calcite.adapter.geode.rel.GeodeAllDataTypesTest > 
testSqlBooleanColumnFilter()
         17.8sec, 
org.apache.calcite.adapter.geode.rel.GeodeBookstoreTest > 
testInSetFilterWithNestedStringField()
         18.0sec, 
org.apache.calcite.adapter.geode.rel.GeodeAllDataTypesTest > 
testSqlWhereWithMultipleOrForLiteralFields()
         18.1sec, 
org.apache.calcite.adapter.geode.rel.GeodeAllDataTypesTest > 
testSqlWhereWithMultipleOrForAllFields()
         17.8sec, 
org.apache.calcite.adapter.geode.rel.GeodeZipsTest > 
testWhereWithOrForNumericField()
         17.9sec, 
org.apache.calcite.adapter.geode.rel.GeodeZipsTest > 
testWhereWithOrForNestedNumericField()
         18.0sec, 
org.apache.calcite.adapter.geode.rel.GeodeBookstoreTest > 
testMissingProjectRelationOnGroupByColumnMatchingProjectedFields()
         18.0sec, 
org.apache.calcite.adapter.geode.rel.GeodeBookstoreTest > 
testAddMissingGroupByColumnToProjectedFields()
         18.0sec, 
org.apache.calcite.adapter.geode.rel.GeodeBookstoreTest > 
testSortWithProjectionAndLimit()
         18.0sec, 
org.apache.calcite.adapter.geode.rel.GeodeBookstoreTest > 
testSortWithProjection()
         17.9sec, 
org.apache.calcite.adapter.geode.rel.GeodeZipsTest > 
testMaxRaw()
         18.5sec, 
org.apache.calcite.adapter.geode.rel.GeodeAllDataTypesTest > 
testSqlSingleTimeWhereFilter()
         18.3sec, 
org.apache.calcite.adapter.geode.rel.GeodeBookstoreTest > 
testFilterWithNestedField()
         18.6sec, 
org.apache.calcite.adapter.geode.rel.GeodeBookstoreTest > 
testWhereWithOr()
         18.9sec, 
org.apache.calcite.adapter.geode.rel.GeodeAllDataTypesTest > 
testSqlSingleDateWhereFilter()
         19.0sec, 
org.apache.calcite.adapter.geode.rel.GeodeAllDataTypesTest > 
testSqlSingleTimestampWhereFilter()
         31.9sec,   12 completed,   0 failed,   0 skipped, 
org.apache.calcite.adapter.geode.rel.GeodeAllDataTypesTest
WARNING  32.5sec,   14 completed,   0 failed,   3 
skipped, org.apache.calcite.adapter.geode.rel.GeodeZipsTest
         32.8sec,   36 completed,   0 failed,   0 skipped, 
org.apache.calcite.adapter.geode.rel.GeodeBookstoreTest
WARNING  46.4sec,   62 completed,   0 failed,   3 
skipped, Gradle Test Run :geode:test

> Task :babel:test
         12.4sec, org.apache.calcite.test.BabelQuidemTest > 
test(String)[5], [5] sql/redshift.iq
         58.0sec,    5 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.BabelQuidemTest > test(String)
         58.1sec,    5 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.BabelQuidemTest
WARNING  67.1sec,  493 completed,   0 failed,   5 
skipped, Gradle Test Run :babel:test

> Task :plus:test
         61.3sec, org.apache.calcite.adapter.tpch.TpchTest 
> testQuery05()

> Task :core:javadoc
100 warnings

> Task :elasticsearch:test
          4.9sec, 
org.apache.calcite.adapter.elasticsearch.AggregationTest > 
integerCat()
          4.9sec, 
org.apache.calcite.adapter.elasticsearch.AggregationTest > 
cat1Cat3()
          4.9sec, 
org.apache.calcite.adapter.elasticsearch.AggregationTest > 
dateCat()
          4.9sec, 
org.apache.calcite.adapter.elasticsearch.AggregationTest > 
cat1Cat2Cat3()
          4.9sec, 
org.apache.calcite.adapter.elasticsearch.Projection2Test > 
projection()
          4.9sec, 
org.apache.calcite.adapter.elasticsearch.Projection2Test > 
projection2()
          3.2sec, 
org.apache.calcite.adapter.elasticsearch.MatchTest > 
testMatchQuery()
         66.3sec,    1 completed,   0 failed,   0 skipped, 
org.apache.calcite.adapter.elasticsearch.MatchTest
          5.2sec, 
org.apache.calcite.adapter.elasticsearch.AggregationTest > 
cat1Cat2()
          5.1sec, 
org.apache.calcite.adapter.elasticsearch.Projection2Test > 
projection3()
          5.3sec, 
org.apache.calcite.adapter.elasticsearch.AggregationTest > 
aggregationWithCast()
          5.5sec, 
org.apache.calcite.adapter.elasticsearch.AggregationTest > 
cat2()
          5.5sec, 
org.apache.calcite.adapter.elasticsearch.AggregationTest > 
anyValue()
          5.5sec, 
org.apache.calcite.adapter.elasticsearch.AggregationTest > 
anyValueWithOtherAgg()
          5.6sec, 
org.apache.calcite.adapter.elasticsearch.AggregationTest > 
approximateCountDistinct()
          5.7sec, 
org.apache.calcite.adapter.elasticsearch.AggregationTest > 
all()
          5.8sec, 
org.apache.calcite.adapter.elasticsearch.AggregationTest > 
cat1()
          5.6sec, 
org.apache.calcite.adapter.elasticsearch.Projection2Test > 
projectionStringLiteralAndColumn()
          6.1sec, 
org.apache.calcite.adapter.elasticsearch.ProjectionTest > 
projection()
         67.3sec,    1 completed,   0 failed,   0 skipped, 
org.apache.calcite.adapter.elasticsearch.ProjectionTest
          4.9sec, 
org.apache.calcite.adapter.elasticsearch.ElasticSearchAdapterTest > 
testFilterSort()
          6.4sec, 
org.apache.calcite.adapter.elasticsearch.AggregationTest > 
countStar()
WARNING  67.5sec,   14 completed,   0 failed,   1 
skipped, org.apache.calcite.adapter.elasticsearch.AggregationTest
          6.3sec, 
org.apache.calcite.adapter.elasticsearch.Projection2Test > 
projectionWithIdField()
         67.6sec,    7 completed,   0 failed,   0 skipped, 
org.apache.calcite.adapter.elasticsearch.Projection2Test
WARNING  68.8sec,   24 completed,   0 failed,   1 
skipped, 
org.apache.calcite.adapter.elasticsearch.ElasticSearchAdapterTest
WARNING   1.4sec,    1 completed,   0 failed,   1 
skipped, org.apache.calcite.adapter.elasticsearch.ScrollingTest
          2.5sec, 
org.apache.calcite.adapter.elasticsearch.BooleanLogicTest > 
expressions()
          3.5sec,    2 completed,   0 failed,   0 skipped, 
org.apache.calcite.adapter.elasticsearch.BooleanLogicTest
WARNING  82.3sec,   66 completed,   0 failed,   3 
skipped, Gradle Test Run :elasticsearch:test

> Task :plus:test
        107.2sec, org.apache.calcite.adapter.tpch.TpchTest 
> testQuery07()
WARNING 108.8sec,   29 completed,   0 failed,   7 
skipped, org.apache.calcite.adapter.tpch.TpchTest
WARNING 115.4sec,   51 completed,   0 failed,  11 
skipped, Gradle Test Run :plus:test

FAILURE: Build failed with an exception.

* What went wrong:
Execution failed for task ':server:test'.
> There were failing tests. See the report at: 
> file://<https://ci-builds.apache.org/job/Calcite/job/Calcite-snapshots/ws/server/build/reports/tests/test/index.html>

* Try:
> Run with --stacktrace option to get the stack trace.
> Run with --info or --debug option to get more log output.

* Get more help at https://help.gradle.org

Deprecated Gradle features were used in this build, making it incompatible with 
Gradle 8.0.

You can use '--warning-mode all' to show the individual deprecation warnings 
and determine if they come from your own scripts or plugins.

See 
https://docs.gradle.org/7.6.1/userguide/command_line_interface.html#sec:command_line_warnings

BUILD FAILED in 5m 1s
452 actionable tasks: 452 executed

Publishing build scan...
https://ge.apache.org/s/ob4e62zmui6di


See the profiling report at: 
file://<https://ci-builds.apache.org/job/Calcite/job/Calcite-snapshots/ws/build/reports/profile/profile-2023-07-03-08-02-39.html>
A fine-grained performance profile is available: use the --scan option.
Build step 'Invoke Gradle script' changed build result to FAILURE
Build step 'Invoke Gradle script' marked build as failure
Recording test results
[Checks API] No suitable checks publisher found.

Reply via email to