8.1sec org.apache.calcite.test.CoreQuidemTest > test(String)[1], [1] sql/misc.iq org.opentest4j.AssertionFailedError: Files differ: /home/runner/work/calcite/calcite/core/build/quidem/test/sql/misc.iq /home/runner/work/calcite/calcite/core/build/resources/test/sql/misc.iq 2149,2153c2149,2153 < +-------------------------+---------------------+---------------------+-----------------------+------------------------+-------------------------+-------------------------+-------------------------+ < | EXPR$0 | EXPR$1 | EXPR$2 | EXPR$3 | EXPR$4 | EXPR$5 | EXPR$6 | EXPR$7 | < +-------------------------+---------------------+---------------------+-----------------------+------------------------+-------------------------+-------------------------+-------------------------+ < | 2016-02-26 19:06:00.123 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00.1 | 2016-02-26 19:06:00.12 | 2016-02-26 19:06:00.123 | 2016-02-26 19:06:00.123 | 2016-02-26 19:06:00.123 | < +-------------------------+---------------------+---------------------+-----------------------+------------------------+-------------------------+-------------------------+-------------------------+ --- > +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ > | EXPR$0 | EXPR$1 | EXPR$2 | EXPR$3 | EXPR$4 | EXPR$5 | EXPR$6 | EXPR$7 | > +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ > | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | > +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ 2167,2171c2167,2171 < +-------------------------+---------------------+--------+ < | EXPR$0 | EXPR$1 | EXPR$2 | < +-------------------------+---------------------+--------+ < | 2016-02-26 19:06:00.123 | 2016-02-26 19:06:00 | 0 | < +-------------------------+---------------------+--------+ --- > +---------------------+---------------------+--------+ > | EXPR$0 | EXPR$1 | EXPR$2 | > +---------------------+---------------------+--------+ > | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 0 | > +---------------------+---------------------+--------+ at app//org.junit.jupiter.api.AssertionUtils.fail(AssertionUtils.java:38) at app//org.junit.jupiter.api.Assertions.fail(Assertions.java:135) at app//org.apache.calcite.test.QuidemTest.checkRun(QuidemTest.java:186) at app//org.apache.calcite.test.CoreQuidemTest.testSqlMisc(CoreQuidemTest.java:103)

0.1sec org.apache.calcite.test.CalciteSqlOperatorTest > testCeilFuncDateTime() java.lang.AssertionError: Query: values (ceil(timestamp '2015-02-19 12:34:56.78' to second)) Expected: is "2015-02-19 12:34:57.00" but: was "2015-02-19 12:34:57" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.apache.calcite.sql.test.ResultCheckers.compareResultSetWithMatcher(ResultCheckers.java:252) at org.apache.calcite.sql.test.ResultCheckers$MatcherResultChecker.checkResult(ResultCheckers.java:321) at org.apache.calcite.test.SqlOperatorTest$TesterImpl.check(SqlOperatorTest.java:14473) at org.apache.calcite.sql.test.SqlTester.check(SqlTester.java:160) at org.apache.calcite.test.SqlOperatorFixtureImpl.lambda$checkScalar$2(SqlOperatorFixtureImpl.java:226) at org.apache.calcite.sql.test.AbstractSqlTester.forEachQuery(AbstractSqlTester.java:450) at org.apache.calcite.test.SqlOperatorFixtureImpl.checkScalar(SqlOperatorFixtureImpl.java:225) at org.apache.calcite.sql.test.SqlOperatorFixture.checkScalar(SqlOperatorFixture.java:221) at org.apache.calcite.test.SqlOperatorTest.testCeilFuncDateTime(SqlOperatorTest.java:11576) at org.junit.platform.commons.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:727) at org.junit.jupiter.engine.execution.MethodInvocation.proceed(MethodInvocation.java:60) at org.junit.jupiter.engine.execution.InvocationInterceptorChain$ValidatingInvocation.proceed(InvocationInterceptorChain.java:131) at org.junit.jupiter.engine.extension.SameThreadTimeoutInvocation.proceed(SameThreadTimeoutInvocation.java:45) at org.junit.jupiter.engine.extension.TimeoutExtension.intercept(TimeoutExtension.java:156) at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestableMethod(TimeoutExtension.java:147) at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestMethod(TimeoutExtension.java:86) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker$ReflectiveInterceptorCall.lambda$ofVoidMethod$0(InterceptingExecutableInvoker.java:103) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.lambda$invoke$0(InterceptingExecutableInvoker.java:93) at org.junit.jupiter.engine.execution.InvocationInterceptorChain$InterceptedInvocation.proceed(InvocationInterceptorChain.java:106) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.proceed(InvocationInterceptorChain.java:64) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.chainAndInvoke(InvocationInterceptorChain.java:45) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.invoke(InvocationInterceptorChain.java:37) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:92) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:86) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.lambda$invokeTestMethod$7(TestMethodTestDescriptor.java:217) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.invokeTestMethod(TestMethodTestDescriptor.java:213) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:138) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:68) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$6(NodeTestTask.java:151) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:141) at org.junit.platform.engine.support.hierarchical.Node.around(Node.java:137) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$9(NodeTestTask.java:139) at org.junit.platform.engine.suppor

0.0sec org.apache.calcite.test.CalciteSqlOperatorTest > testTimestampAdd() java.lang.AssertionError: Query: values (timestampadd(FRAC_SECOND, 2000000, timestamp '2016-02-24 12:42:25')) Expected: is "2016-02-24 12:42:27.000" but: was "2016-02-24 12:42:27" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.apache.calcite.sql.test.ResultCheckers.compareResultSetWithMatcher(ResultCheckers.java:252) at org.apache.calcite.sql.test.ResultCheckers$MatcherResultChecker.checkResult(ResultCheckers.java:321) at org.apache.calcite.test.SqlOperatorTest$TesterImpl.check(SqlOperatorTest.java:14473) at org.apache.calcite.sql.test.SqlTester.check(SqlTester.java:160) at org.apache.calcite.test.SqlOperatorFixtureImpl.lambda$checkScalar$2(SqlOperatorFixtureImpl.java:226) at org.apache.calcite.sql.test.AbstractSqlTester.forEachQuery(AbstractSqlTester.java:450) at org.apache.calcite.test.SqlOperatorFixtureImpl.checkScalar(SqlOperatorFixtureImpl.java:225) at org.apache.calcite.sql.test.SqlOperatorFixture.checkScalar(SqlOperatorFixture.java:221) at org.apache.calcite.test.SqlOperatorTest.lambda$testTimestampAdd$64(SqlOperatorTest.java:11719) at java.base/java.util.Arrays$ArrayList.forEach(Arrays.java:4204) at org.apache.calcite.test.SqlOperatorTest.testTimestampAdd(SqlOperatorTest.java:11718) at org.junit.platform.commons.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:727) at org.junit.jupiter.engine.execution.MethodInvocation.proceed(MethodInvocation.java:60) at org.junit.jupiter.engine.execution.InvocationInterceptorChain$ValidatingInvocation.proceed(InvocationInterceptorChain.java:131) at org.junit.jupiter.engine.extension.SameThreadTimeoutInvocation.proceed(SameThreadTimeoutInvocation.java:45) at org.junit.jupiter.engine.extension.TimeoutExtension.intercept(TimeoutExtension.java:156) at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestableMethod(TimeoutExtension.java:147) at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestMethod(TimeoutExtension.java:86) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker$ReflectiveInterceptorCall.lambda$ofVoidMethod$0(InterceptingExecutableInvoker.java:103) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.lambda$invoke$0(InterceptingExecutableInvoker.java:93) at org.junit.jupiter.engine.execution.InvocationInterceptorChain$InterceptedInvocation.proceed(InvocationInterceptorChain.java:106) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.proceed(InvocationInterceptorChain.java:64) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.chainAndInvoke(InvocationInterceptorChain.java:45) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.invoke(InvocationInterceptorChain.java:37) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:92) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:86) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.lambda$invokeTestMethod$7(TestMethodTestDescriptor.java:217) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.invokeTestMethod(TestMethodTestDescriptor.java:213) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:138) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:68) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$6(NodeTestTask.java:151) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:141) at org.junit.platform.engine.support.hierarchical.No

0.1sec org.apache.calcite.test.CoreQuidemTest > test(String)[19], [19] sql/stream.iq org.opentest4j.AssertionFailedError: Files differ: /home/runner/work/calcite/calcite/core/build/quidem/test/sql/stream.iq /home/runner/work/calcite/calcite/core/build/resources/test/sql/stream.iq 25,33c25,33 < +---------------------+----+---------+-------+-------------------------+-------------------------+ < | ROWTIME | ID | PRODUCT | UNITS | window_start | window_end | < +---------------------+----+---------+-------+-------------------------+-------------------------+ < | 2015-02-15 10:15:00 | 1 | paint | 10 | 2015-02-15 10:15:00.000 | 2015-02-15 10:16:00.000 | < | 2015-02-15 10:24:15 | 2 | paper | 5 | 2015-02-15 10:24:00.000 | 2015-02-15 10:25:00.000 | < | 2015-02-15 10:24:45 | 3 | brush | 12 | 2015-02-15 10:24:00.000 | 2015-02-15 10:25:00.000 | < | 2015-02-15 10:58:00 | 4 | paint | 3 | 2015-02-15 10:58:00.000 | 2015-02-15 10:59:00.000 | < | 2015-02-15 11:10:00 | 5 | paint | 3 | 2015-02-15 11:10:00.000 | 2015-02-15 11:11:00.000 | < +---------------------+----+---------+-------+-------------------------+-------------------------+ --- > +---------------------+----+---------+-------+---------------------+---------------------+ > | ROWTIME | ID | PRODUCT | UNITS | window_start | window_end | > +---------------------+----+---------+-------+---------------------+---------------------+ > | 2015-02-15 10:15:00 | 1 | paint | 10 | 2015-02-15 10:15:00 | 2015-02-15 10:16:00 | > | 2015-02-15 10:24:15 | 2 | paper | 5 | 2015-02-15 10:24:00 | 2015-02-15 10:25:00 | > | 2015-02-15 10:24:45 | 3 | brush | 12 | 2015-02-15 10:24:00 | 2015-02-15 10:25:00 | > | 2015-02-15 10:58:00 | 4 | paint | 3 | 2015-02-15 10:58:00 | 2015-02-15 10:59:00 | > | 2015-02-15 11:10:00 | 5 | paint | 3 | 2015-02-15 11:10:00 | 2015-02-15 11:11:00 | > +---------------------+----+---------+-------+---------------------+---------------------+ 39,47c39,47 < +---------------------+----+---------+-------+-------------------------+-------------------------+ < | ROWTIME | ID | PRODUCT | UNITS | window_start | window_end | < +---------------------+----+---------+-------+-------------------------+-------------------------+ < | 2015-02-15 10:15:00 | 1 | paint | 10 | 2015-02-15 10:15:00.000 | 2015-02-15 10:16:00.000 | < | 2015-02-15 10:24:15 | 2 | paper | 5 | 2015-02-15 10:24:00.000 | 2015-02-15 10:25:00.000 | < | 2015-02-15 10:24:45 | 3 | brush | 12 | 2015-02-15 10:24:00.000 | 2015-02-15 10:25:00.000 | < | 2015-02-15 10:58:00 | 4 | paint | 3 | 2015-02-15 10:58:00.000 | 2015-02-15 10:59:00.000 | < | 2015-02-15 11:10:00 | 5 | paint | 3 | 2015-02-15 11:10:00.000 | 2015-02-15 11:11:00.000 | < +---------------------+----+---------+-------+-------------------------+-------------------------+ --- > +---------------------+----+---------+-------+---------------------+---------------------+ > | ROWTIME | ID | PRODUCT | UNITS | window_start | window_end | > +---------------------+----+---------+-------+---------------------+---------------------+ > | 2015-02-15 10:15:00 | 1 | paint | 10 | 2015-02-15 10:15:00 | 2015-02-15 10:16:00 | > | 2015-02-15 10:24:15 | 2 | paper | 5 | 2015-02-15 10:24:00 | 2015-02-15 10:25:00 | > | 2015-02-15 10:24:45 | 3 | brush | 12 | 2015-02-15 10:24:00 | 2015-02-15 10:25:00 | > | 2015-02-15 10:58:00 | 4 | paint | 3 | 2015-02-15 10:58:00 | 2015-02-15 10:59:00 | > | 2015-02-15 11:10:00 | 5 | paint | 3 | 2015-02-15 11:10:00 | 2015-02-15 11:11:00 | > +---------------------+----+---------+-------+---------------------+---------------------+ 53,61c53,61 < +---------------------+----+---------+-------+-------------------------+-------------------------+ < | ROWTIME | ID | PRODUCT | UNITS | window_start | window_end | < +---------------------+----+---------+-------+-------------------------+-

0.6sec org.apache.calcite.test.CoreQuidemTest > test(String)[27], [27] sql/operator.iq org.opentest4j.AssertionFailedError: Files differ: /home/runner/work/calcite/calcite/core/build/quidem/test/sql/operator.iq /home/runner/work/calcite/calcite/core/build/resources/test/sql/operator.iq 238,243c238,243 < +------------+-------+------------+------------+------------+------------+------------+------------+------------+------------+ < | V | OP | Y | Q | M | W | D | H | MI | S | < +------------+-------+------------+------------+------------+------------+------------+------------+------------+------------+ < | 12:34:56.7 | ceil | 12:34:57.0 | 12:34:56.7 | 12:34:56.7 | 12:34:56.7 | 12:34:56.7 | 13:00:00.0 | 12:35:00.0 | 12:34:57.0 | < | 12:34:56.7 | floor | 12:34:56.6 | 12:34:56.6 | 12:34:56.6 | 12:34:56.6 | 12:34:56.7 | 12:00:00.0 | 12:34:00.0 | 12:34:56.0 | < +------------+-------+------------+------------+------------+------------+------------+------------+------------+------------+ --- > +----------+-------+----------+----------+----------+----------+----------+----------+----------+----------+ > | V | OP | Y | Q | M | W | D | H | MI | S | > +----------+-------+----------+----------+----------+----------+----------+----------+----------+----------+ > | 12:34:56 | ceil | 12:34:57 | 12:34:56 | 12:34:56 | 12:34:56 | 12:34:56 | 13:00:00 | 12:35:00 | 12:34:57 | > | 12:34:56 | floor | 12:34:56 | 12:34:56 | 12:34:56 | 12:34:56 | 12:34:56 | 12:00:00 | 12:34:00 | 12:34:56 | > +----------+-------+----------+----------+----------+----------+----------+----------+----------+----------+ at app//org.junit.jupiter.api.AssertionUtils.fail(AssertionUtils.java:38) at app//org.junit.jupiter.api.Assertions.fail(Assertions.java:135) at app//org.apache.calcite.test.QuidemTest.checkRun(QuidemTest.java:186) at app//org.apache.calcite.test.QuidemTest.test(QuidemTest.java:239) at app//org.junit.platform.commons.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:727) at app//org.junit.jupiter.engine.execution.MethodInvocation.proceed(MethodInvocation.java:60) at app//org.junit.jupiter.engine.execution.InvocationInterceptorChain$ValidatingInvocation.proceed(InvocationInterceptorChain.java:131) at app//org.junit.jupiter.engine.extension.SameThreadTimeoutInvocation.proceed(SameThreadTimeoutInvocation.java:45) at app//org.junit.jupiter.engine.extension.TimeoutExtension.intercept(TimeoutExtension.java:156) at app//org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestableMethod(TimeoutExtension.java:147) at app//org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestTemplateMethod(TimeoutExtension.java:94) at app//org.junit.jupiter.engine.execution.InterceptingExecutableInvoker$ReflectiveInterceptorCall.lambda$ofVoidMethod$0(InterceptingExecutableInvoker.java:103) at app//org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.lambda$invoke$0(InterceptingExecutableInvoker.java:93) at app//org.junit.jupiter.engine.execution.InvocationInterceptorChain$InterceptedInvocation.proceed(InvocationInterceptorChain.java:106) at app//org.junit.jupiter.engine.execution.InvocationInterceptorChain.proceed(InvocationInterceptorChain.java:64) at app//org.junit.jupiter.engine.execution.InvocationInterceptorChain.chainAndInvoke(InvocationInterceptorChain.java:45) at app//org.junit.jupiter.engine.execution.InvocationInterceptorChain.invoke(InvocationInterceptorChain.java:37) at app//org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:92) at app//org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:86) at app//org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.lambda$invokeTestMethod$7(TestMethodTestDescriptor.java:217) at app//org.junit.platform.engine.support.hierarchical.ThrowableCollector.

0.1sec org.apache.calcite.test.SqlOperatorUnparseTest > testCeilFuncDateTime() java.lang.AssertionError: Query: SELECT CEIL("P0" TO SECOND) FROM (VALUES ROW(TIMESTAMP '2015-02-19 12:34:56.78')) AS "T" ("P0") Expected: is "2015-02-19 12:34:57.00" but: was "2015-02-19 12:34:57" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.apache.calcite.sql.test.ResultCheckers.compareResultSetWithMatcher(ResultCheckers.java:252) at org.apache.calcite.sql.test.ResultCheckers$MatcherResultChecker.checkResult(ResultCheckers.java:321) at org.apache.calcite.test.SqlOperatorTest$TesterImpl.check(SqlOperatorTest.java:14473) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.check(SqlOperatorUnparseTest.java:95) at org.apache.calcite.sql.test.SqlTester.check(SqlTester.java:160) at org.apache.calcite.test.SqlOperatorFixtureImpl.lambda$checkScalar$2(SqlOperatorFixtureImpl.java:226) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.forEachQuery(SqlOperatorUnparseTest.java:88)

0.0sec org.apache.calcite.test.SqlOperatorUnparseTest > testTimestampAdd() java.lang.AssertionError: Query: SELECT TIMESTAMPADD("FRAC_SECOND", "P1", "P0") FROM (VALUES ROW(TIMESTAMP '2016-02-24 12:42:25', 2000000)) AS "T" ("P0", "P1") Expected: is "2016-02-24 12:42:27.000" but: was "2016-02-24 12:42:27" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.apache.calcite.sql.test.ResultCheckers.compareResultSetWithMatcher(ResultCheckers.java:252) at org.apache.calcite.sql.test.ResultCheckers$MatcherResultChecker.checkResult(ResultCheckers.java:321) at org.apache.calcite.test.SqlOperatorTest$TesterImpl.check(SqlOperatorTest.java:14473) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.check(SqlOperatorUnparseTest.java:95) at org.apache.calcite.sql.test.SqlTester.check(SqlTester.java:160) at org.apache.calcite.test.SqlOperatorFixtureImpl.lambda$checkScalar$2(SqlOperatorFixtureImpl.java:226) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.forEachQuery(SqlOperatorUnparseTest.java:88)

0.0sec org.apache.calcite.test.CalciteSqlOperatorTest > testFloorFuncDateTime() java.lang.AssertionError: Query: values (floor(timestamp '2015-02-19 12:34:56.78' to second)) Expected: is "2015-02-19 12:34:56.00" but: was "2015-02-19 12:34:56" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.apache.calcite.sql.test.ResultCheckers.compareResultSetWithMatcher(ResultCheckers.java:252) at org.apache.calcite.sql.test.ResultCheckers$MatcherResultChecker.checkResult(ResultCheckers.java:321) at org.apache.calcite.test.SqlOperatorTest$TesterImpl.check(SqlOperatorTest.java:14473) at org.apache.calcite.sql.test.SqlTester.check(SqlTester.java:160) at org.apache.calcite.test.SqlOperatorFixtureImpl.lambda$checkScalar$2(SqlOperatorFixtureImpl.java:226) at org.apache.calcite.sql.test.AbstractSqlTester.forEachQuery(AbstractSqlTester.java:450) at org.apache.calcite.test.SqlOperatorFixtureImpl.checkScalar(SqlOperatorFixtureImpl.java:225) at org.apache.calcite.sql.test.SqlOperatorFixture.checkScalar(SqlOperatorFixture.java:221) at org.apache.calcite.test.SqlOperatorTest.testFloorFuncDateTime(SqlOperatorTest.java:11531) at org.junit.platform.commons.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:727) at org.junit.jupiter.engine.execution.MethodInvocation.proceed(MethodInvocation.java:60) at org.junit.jupiter.engine.execution.InvocationInterceptorChain$ValidatingInvocation.proceed(InvocationInterceptorChain.java:131) at org.junit.jupiter.engine.extension.SameThreadTimeoutInvocation.proceed(SameThreadTimeoutInvocation.java:45) at org.junit.jupiter.engine.extension.TimeoutExtension.intercept(TimeoutExtension.java:156) at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestableMethod(TimeoutExtension.java:147) at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestMethod(TimeoutExtension.java:86) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker$ReflectiveInterceptorCall.lambda$ofVoidMethod$0(InterceptingExecutableInvoker.java:103) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.lambda$invoke$0(InterceptingExecutableInvoker.java:93) at org.junit.jupiter.engine.execution.InvocationInterceptorChain$InterceptedInvocation.proceed(InvocationInterceptorChain.java:106) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.proceed(InvocationInterceptorChain.java:64) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.chainAndInvoke(InvocationInterceptorChain.java:45) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.invoke(InvocationInterceptorChain.java:37) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:92) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:86) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.lambda$invokeTestMethod$7(TestMethodTestDescriptor.java:217) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.invokeTestMethod(TestMethodTestDescriptor.java:213) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:138) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:68) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$6(NodeTestTask.java:151) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:141) at org.junit.platform.engine.support.hierarchical.Node.around(Node.java:137) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$9(NodeTestTask.java:139) at org.junit.platform.engine.sup

0.0sec org.apache.calcite.test.SqlOperatorUnparseTest > testFloorFuncDateTime() java.lang.AssertionError: Query: SELECT FLOOR("P0" TO SECOND) FROM (VALUES ROW(TIMESTAMP '2015-02-19 12:34:56.78')) AS "T" ("P0") Expected: is "2015-02-19 12:34:56.00" but: was "2015-02-19 12:34:56" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.apache.calcite.sql.test.ResultCheckers.compareResultSetWithMatcher(ResultCheckers.java:252) at org.apache.calcite.sql.test.ResultCheckers$MatcherResultChecker.checkResult(ResultCheckers.java:321) at org.apache.calcite.test.SqlOperatorTest$TesterImpl.check(SqlOperatorTest.java:14473) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.check(SqlOperatorUnparseTest.java:95) at org.apache.calcite.sql.test.SqlTester.check(SqlTester.java:160) at org.apache.calcite.test.SqlOperatorFixtureImpl.lambda$checkScalar$2(SqlOperatorFixtureImpl.java:226) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.forEachQuery(SqlOperatorUnparseTest.java:88)

0.0sec org.apache.calcite.test.SqlOperatorUnparseTest > testCastDateTime(CastType, SqlOperatorFixture)[1], [1] CAST, org.apache.calcite.test.SqlOperatorUnparseTest$SqlOperatorFixtureUnparseImpl@c22012b java.lang.AssertionError: Query: SELECT CAST("P0" AS TIME(2)) FROM (VALUES ROW(TIME '12:42:25.34')) AS "T" ("P0") Expected: is "12:42:25.34" but: was "12:42:25" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.apache.calcite.sql.test.ResultCheckers.compareResultSetWithMatcher(ResultCheckers.java:252) at org.apache.calcite.sql.test.ResultCheckers$MatcherResultChecker.checkResult(ResultCheckers.java:321) at org.apache.calcite.test.SqlOperatorTest$TesterImpl.check(SqlOperatorTest.java:14473) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.check(SqlOperatorUnparseTest.java:95) at org.apache.calcite.sql.test.SqlTester.check(SqlTester.java:160) at org.apache.calcite.test.SqlOperatorFixtureImpl.lambda$checkScalar$2(SqlOperatorFixtureImpl.java:226) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.forEachQuery(SqlOperatorUnparseTest.java:88)

7.9sec org.apache.calcite.test.CoreQuidemTest > test(String)[1], [1] sql/misc.iq org.opentest4j.AssertionFailedError: Files differ: /home/runner/work/calcite/calcite/core/build/quidem/test/sql/misc.iq /home/runner/work/calcite/calcite/core/build/resources/test/sql/misc.iq 2149,2153c2149,2153 < +-------------------------+---------------------+---------------------+-----------------------+------------------------+-------------------------+-------------------------+-------------------------+ < | EXPR$0 | EXPR$1 | EXPR$2 | EXPR$3 | EXPR$4 | EXPR$5 | EXPR$6 | EXPR$7 | < +-------------------------+---------------------+---------------------+-----------------------+------------------------+-------------------------+-------------------------+-------------------------+ < | 2016-02-26 19:06:00.123 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00.1 | 2016-02-26 19:06:00.12 | 2016-02-26 19:06:00.123 | 2016-02-26 19:06:00.123 | 2016-02-26 19:06:00.123 | < +-------------------------+---------------------+---------------------+-----------------------+------------------------+-------------------------+-------------------------+-------------------------+ --- > +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ > | EXPR$0 | EXPR$1 | EXPR$2 | EXPR$3 | EXPR$4 | EXPR$5 | EXPR$6 | EXPR$7 | > +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ > | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | > +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ 2167,2171c2167,2171 < +-------------------------+---------------------+--------+ < | EXPR$0 | EXPR$1 | EXPR$2 | < +-------------------------+---------------------+--------+ < | 2016-02-26 19:06:00.123 | 2016-02-26 19:06:00 | 0 | < +-------------------------+---------------------+--------+ --- > +---------------------+---------------------+--------+ > | EXPR$0 | EXPR$1 | EXPR$2 | > +---------------------+---------------------+--------+ > | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 0 | > +---------------------+---------------------+--------+ at app//org.junit.jupiter.api.AssertionUtils.fail(AssertionUtils.java:38) at app//org.junit.jupiter.api.Assertions.fail(Assertions.java:135) at app//org.apache.calcite.test.QuidemTest.checkRun(QuidemTest.java:186) at app//org.apache.calcite.test.CoreQuidemTest.testSqlMisc(CoreQuidemTest.java:103)

0.0sec org.apache.calcite.test.CalciteSqlOperatorTest > testCeilFuncDateTime() java.lang.AssertionError: Query: values (ceil(timestamp '2015-02-19 12:34:56.78' to second)) Expected: is "2015-02-19 12:34:57.00" but: was "2015-02-19 12:34:57" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.apache.calcite.sql.test.ResultCheckers.compareResultSetWithMatcher(ResultCheckers.java:252) at org.apache.calcite.sql.test.ResultCheckers$MatcherResultChecker.checkResult(ResultCheckers.java:321) at org.apache.calcite.test.SqlOperatorTest$TesterImpl.check(SqlOperatorTest.java:14473) at org.apache.calcite.sql.test.SqlTester.check(SqlTester.java:160) at org.apache.calcite.test.SqlOperatorFixtureImpl.lambda$checkScalar$2(SqlOperatorFixtureImpl.java:226) at org.apache.calcite.sql.test.AbstractSqlTester.forEachQuery(AbstractSqlTester.java:450) at org.apache.calcite.test.SqlOperatorFixtureImpl.checkScalar(SqlOperatorFixtureImpl.java:225) at org.apache.calcite.sql.test.SqlOperatorFixture.checkScalar(SqlOperatorFixture.java:221) at org.apache.calcite.test.SqlOperatorTest.testCeilFuncDateTime(SqlOperatorTest.java:11576) at org.junit.platform.commons.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:727) at org.junit.jupiter.engine.execution.MethodInvocation.proceed(MethodInvocation.java:60) at org.junit.jupiter.engine.execution.InvocationInterceptorChain$ValidatingInvocation.proceed(InvocationInterceptorChain.java:131) at org.junit.jupiter.engine.extension.SameThreadTimeoutInvocation.proceed(SameThreadTimeoutInvocation.java:45) at org.junit.jupiter.engine.extension.TimeoutExtension.intercept(TimeoutExtension.java:156) at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestableMethod(TimeoutExtension.java:147) at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestMethod(TimeoutExtension.java:86) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker$ReflectiveInterceptorCall.lambda$ofVoidMethod$0(InterceptingExecutableInvoker.java:103) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.lambda$invoke$0(InterceptingExecutableInvoker.java:93) at org.junit.jupiter.engine.execution.InvocationInterceptorChain$InterceptedInvocation.proceed(InvocationInterceptorChain.java:106) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.proceed(InvocationInterceptorChain.java:64) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.chainAndInvoke(InvocationInterceptorChain.java:45) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.invoke(InvocationInterceptorChain.java:37) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:92) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:86) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.lambda$invokeTestMethod$7(TestMethodTestDescriptor.java:217) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.invokeTestMethod(TestMethodTestDescriptor.java:213) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:138) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:68) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$6(NodeTestTask.java:151) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:141) at org.junit.platform.engine.support.hierarchical.Node.around(Node.java:137) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$9(NodeTestTask.java:139) at org.junit.platform.engine.suppor

0.0sec org.apache.calcite.test.CalciteSqlOperatorTest > testTimestampAdd() java.lang.AssertionError: Query: values (timestampadd(FRAC_SECOND, 2000000, timestamp '2016-02-24 12:42:25')) Expected: is "2016-02-24 12:42:27.000" but: was "2016-02-24 12:42:27" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.apache.calcite.sql.test.ResultCheckers.compareResultSetWithMatcher(ResultCheckers.java:252) at org.apache.calcite.sql.test.ResultCheckers$MatcherResultChecker.checkResult(ResultCheckers.java:321) at org.apache.calcite.test.SqlOperatorTest$TesterImpl.check(SqlOperatorTest.java:14473) at org.apache.calcite.sql.test.SqlTester.check(SqlTester.java:160) at org.apache.calcite.test.SqlOperatorFixtureImpl.lambda$checkScalar$2(SqlOperatorFixtureImpl.java:226) at org.apache.calcite.sql.test.AbstractSqlTester.forEachQuery(AbstractSqlTester.java:450) at org.apache.calcite.test.SqlOperatorFixtureImpl.checkScalar(SqlOperatorFixtureImpl.java:225) at org.apache.calcite.sql.test.SqlOperatorFixture.checkScalar(SqlOperatorFixture.java:221) at org.apache.calcite.test.SqlOperatorTest.lambda$testTimestampAdd$64(SqlOperatorTest.java:11719) at java.base/java.util.Arrays$ArrayList.forEach(Arrays.java:4390) at org.apache.calcite.test.SqlOperatorTest.testTimestampAdd(SqlOperatorTest.java:11718) at org.junit.platform.commons.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:727) at org.junit.jupiter.engine.execution.MethodInvocation.proceed(MethodInvocation.java:60) at org.junit.jupiter.engine.execution.InvocationInterceptorChain$ValidatingInvocation.proceed(InvocationInterceptorChain.java:131) at org.junit.jupiter.engine.extension.SameThreadTimeoutInvocation.proceed(SameThreadTimeoutInvocation.java:45) at org.junit.jupiter.engine.extension.TimeoutExtension.intercept(TimeoutExtension.java:156) at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestableMethod(TimeoutExtension.java:147) at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestMethod(TimeoutExtension.java:86) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker$ReflectiveInterceptorCall.lambda$ofVoidMethod$0(InterceptingExecutableInvoker.java:103) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.lambda$invoke$0(InterceptingExecutableInvoker.java:93) at org.junit.jupiter.engine.execution.InvocationInterceptorChain$InterceptedInvocation.proceed(InvocationInterceptorChain.java:106) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.proceed(InvocationInterceptorChain.java:64) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.chainAndInvoke(InvocationInterceptorChain.java:45) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.invoke(InvocationInterceptorChain.java:37) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:92) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:86) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.lambda$invokeTestMethod$7(TestMethodTestDescriptor.java:217) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.invokeTestMethod(TestMethodTestDescriptor.java:213) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:138) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:68) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$6(NodeTestTask.java:151) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:141) at org.junit.platform.engine.support.hierarchical.No

0.1sec org.apache.calcite.test.CoreQuidemTest > test(String)[19], [19] sql/stream.iq org.opentest4j.AssertionFailedError: Files differ: /home/runner/work/calcite/calcite/core/build/quidem/test/sql/stream.iq /home/runner/work/calcite/calcite/core/build/resources/test/sql/stream.iq 25,33c25,33 < +---------------------+----+---------+-------+-------------------------+-------------------------+ < | ROWTIME | ID | PRODUCT | UNITS | window_start | window_end | < +---------------------+----+---------+-------+-------------------------+-------------------------+ < | 2015-02-15 10:15:00 | 1 | paint | 10 | 2015-02-15 10:15:00.000 | 2015-02-15 10:16:00.000 | < | 2015-02-15 10:24:15 | 2 | paper | 5 | 2015-02-15 10:24:00.000 | 2015-02-15 10:25:00.000 | < | 2015-02-15 10:24:45 | 3 | brush | 12 | 2015-02-15 10:24:00.000 | 2015-02-15 10:25:00.000 | < | 2015-02-15 10:58:00 | 4 | paint | 3 | 2015-02-15 10:58:00.000 | 2015-02-15 10:59:00.000 | < | 2015-02-15 11:10:00 | 5 | paint | 3 | 2015-02-15 11:10:00.000 | 2015-02-15 11:11:00.000 | < +---------------------+----+---------+-------+-------------------------+-------------------------+ --- > +---------------------+----+---------+-------+---------------------+---------------------+ > | ROWTIME | ID | PRODUCT | UNITS | window_start | window_end | > +---------------------+----+---------+-------+---------------------+---------------------+ > | 2015-02-15 10:15:00 | 1 | paint | 10 | 2015-02-15 10:15:00 | 2015-02-15 10:16:00 | > | 2015-02-15 10:24:15 | 2 | paper | 5 | 2015-02-15 10:24:00 | 2015-02-15 10:25:00 | > | 2015-02-15 10:24:45 | 3 | brush | 12 | 2015-02-15 10:24:00 | 2015-02-15 10:25:00 | > | 2015-02-15 10:58:00 | 4 | paint | 3 | 2015-02-15 10:58:00 | 2015-02-15 10:59:00 | > | 2015-02-15 11:10:00 | 5 | paint | 3 | 2015-02-15 11:10:00 | 2015-02-15 11:11:00 | > +---------------------+----+---------+-------+---------------------+---------------------+ 39,47c39,47 < +---------------------+----+---------+-------+-------------------------+-------------------------+ < | ROWTIME | ID | PRODUCT | UNITS | window_start | window_end | < +---------------------+----+---------+-------+-------------------------+-------------------------+ < | 2015-02-15 10:15:00 | 1 | paint | 10 | 2015-02-15 10:15:00.000 | 2015-02-15 10:16:00.000 | < | 2015-02-15 10:24:15 | 2 | paper | 5 | 2015-02-15 10:24:00.000 | 2015-02-15 10:25:00.000 | < | 2015-02-15 10:24:45 | 3 | brush | 12 | 2015-02-15 10:24:00.000 | 2015-02-15 10:25:00.000 | < | 2015-02-15 10:58:00 | 4 | paint | 3 | 2015-02-15 10:58:00.000 | 2015-02-15 10:59:00.000 | < | 2015-02-15 11:10:00 | 5 | paint | 3 | 2015-02-15 11:10:00.000 | 2015-02-15 11:11:00.000 | < +---------------------+----+---------+-------+-------------------------+-------------------------+ --- > +---------------------+----+---------+-------+---------------------+---------------------+ > | ROWTIME | ID | PRODUCT | UNITS | window_start | window_end | > +---------------------+----+---------+-------+---------------------+---------------------+ > | 2015-02-15 10:15:00 | 1 | paint | 10 | 2015-02-15 10:15:00 | 2015-02-15 10:16:00 | > | 2015-02-15 10:24:15 | 2 | paper | 5 | 2015-02-15 10:24:00 | 2015-02-15 10:25:00 | > | 2015-02-15 10:24:45 | 3 | brush | 12 | 2015-02-15 10:24:00 | 2015-02-15 10:25:00 | > | 2015-02-15 10:58:00 | 4 | paint | 3 | 2015-02-15 10:58:00 | 2015-02-15 10:59:00 | > | 2015-02-15 11:10:00 | 5 | paint | 3 | 2015-02-15 11:10:00 | 2015-02-15 11:11:00 | > +---------------------+----+---------+-------+---------------------+---------------------+ 53,61c53,61 < +---------------------+----+---------+-------+-------------------------+-------------------------+ < | ROWTIME | ID | PRODUCT | UNITS | window_start | window_end | < +---------------------+----+---------+-------+-------------------------+-

0.0sec org.apache.calcite.test.SqlOperatorUnparseTest > testCeilFuncDateTime() java.lang.AssertionError: Query: SELECT CEIL("P0" TO SECOND) FROM (VALUES ROW(TIMESTAMP '2015-02-19 12:34:56.78')) AS "T" ("P0") Expected: is "2015-02-19 12:34:57.00" but: was "2015-02-19 12:34:57" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.apache.calcite.sql.test.ResultCheckers.compareResultSetWithMatcher(ResultCheckers.java:252) at org.apache.calcite.sql.test.ResultCheckers$MatcherResultChecker.checkResult(ResultCheckers.java:321) at org.apache.calcite.test.SqlOperatorTest$TesterImpl.check(SqlOperatorTest.java:14473) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.check(SqlOperatorUnparseTest.java:95) at org.apache.calcite.sql.test.SqlTester.check(SqlTester.java:160) at org.apache.calcite.test.SqlOperatorFixtureImpl.lambda$checkScalar$2(SqlOperatorFixtureImpl.java:226) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.forEachQuery(SqlOperatorUnparseTest.java:88)

0.7sec org.apache.calcite.test.CoreQuidemTest > test(String)[27], [27] sql/operator.iq org.opentest4j.AssertionFailedError: Files differ: /home/runner/work/calcite/calcite/core/build/quidem/test/sql/operator.iq /home/runner/work/calcite/calcite/core/build/resources/test/sql/operator.iq 238,243c238,243 < +------------+-------+------------+------------+------------+------------+------------+------------+------------+------------+ < | V | OP | Y | Q | M | W | D | H | MI | S | < +------------+-------+------------+------------+------------+------------+------------+------------+------------+------------+ < | 12:34:56.7 | ceil | 12:34:57.0 | 12:34:56.7 | 12:34:56.7 | 12:34:56.7 | 12:34:56.7 | 13:00:00.0 | 12:35:00.0 | 12:34:57.0 | < | 12:34:56.7 | floor | 12:34:56.6 | 12:34:56.6 | 12:34:56.6 | 12:34:56.6 | 12:34:56.7 | 12:00:00.0 | 12:34:00.0 | 12:34:56.0 | < +------------+-------+------------+------------+------------+------------+------------+------------+------------+------------+ --- > +----------+-------+----------+----------+----------+----------+----------+----------+----------+----------+ > | V | OP | Y | Q | M | W | D | H | MI | S | > +----------+-------+----------+----------+----------+----------+----------+----------+----------+----------+ > | 12:34:56 | ceil | 12:34:57 | 12:34:56 | 12:34:56 | 12:34:56 | 12:34:56 | 13:00:00 | 12:35:00 | 12:34:57 | > | 12:34:56 | floor | 12:34:56 | 12:34:56 | 12:34:56 | 12:34:56 | 12:34:56 | 12:00:00 | 12:34:00 | 12:34:56 | > +----------+-------+----------+----------+----------+----------+----------+----------+----------+----------+ at app//org.junit.jupiter.api.AssertionUtils.fail(AssertionUtils.java:38) at app//org.junit.jupiter.api.Assertions.fail(Assertions.java:135) at app//org.apache.calcite.test.QuidemTest.checkRun(QuidemTest.java:186) at app//org.apache.calcite.test.QuidemTest.test(QuidemTest.java:239) at app//org.junit.platform.commons.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:727) at app//org.junit.jupiter.engine.execution.MethodInvocation.proceed(MethodInvocation.java:60) at app//org.junit.jupiter.engine.execution.InvocationInterceptorChain$ValidatingInvocation.proceed(InvocationInterceptorChain.java:131) at app//org.junit.jupiter.engine.extension.SameThreadTimeoutInvocation.proceed(SameThreadTimeoutInvocation.java:45) at app//org.junit.jupiter.engine.extension.TimeoutExtension.intercept(TimeoutExtension.java:156) at app//org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestableMethod(TimeoutExtension.java:147) at app//org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestTemplateMethod(TimeoutExtension.java:94) at app//org.junit.jupiter.engine.execution.InterceptingExecutableInvoker$ReflectiveInterceptorCall.lambda$ofVoidMethod$0(InterceptingExecutableInvoker.java:103) at app//org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.lambda$invoke$0(InterceptingExecutableInvoker.java:93) at app//org.junit.jupiter.engine.execution.InvocationInterceptorChain$InterceptedInvocation.proceed(InvocationInterceptorChain.java:106) at app//org.junit.jupiter.engine.execution.InvocationInterceptorChain.proceed(InvocationInterceptorChain.java:64) at app//org.junit.jupiter.engine.execution.InvocationInterceptorChain.chainAndInvoke(InvocationInterceptorChain.java:45) at app//org.junit.jupiter.engine.execution.InvocationInterceptorChain.invoke(InvocationInterceptorChain.java:37) at app//org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:92) at app//org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:86) at app//org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.lambda$invokeTestMethod$7(TestMethodTestDescriptor.java:217) at app//org.junit.platform.engine.support.hierarchical.ThrowableCollector.

0.0sec org.apache.calcite.test.SqlOperatorUnparseTest > testTimestampAdd() java.lang.AssertionError: Query: SELECT TIMESTAMPADD("FRAC_SECOND", "P1", "P0") FROM (VALUES ROW(TIMESTAMP '2016-02-24 12:42:25', 2000000)) AS "T" ("P0", "P1") Expected: is "2016-02-24 12:42:27.000" but: was "2016-02-24 12:42:27" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.apache.calcite.sql.test.ResultCheckers.compareResultSetWithMatcher(ResultCheckers.java:252) at org.apache.calcite.sql.test.ResultCheckers$MatcherResultChecker.checkResult(ResultCheckers.java:321) at org.apache.calcite.test.SqlOperatorTest$TesterImpl.check(SqlOperatorTest.java:14473) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.check(SqlOperatorUnparseTest.java:95) at org.apache.calcite.sql.test.SqlTester.check(SqlTester.java:160) at org.apache.calcite.test.SqlOperatorFixtureImpl.lambda$checkScalar$2(SqlOperatorFixtureImpl.java:226) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.forEachQuery(SqlOperatorUnparseTest.java:88)

0.1sec org.apache.calcite.test.CalciteSqlOperatorTest > testFloorFuncDateTime() java.lang.AssertionError: Query: values (floor(timestamp '2015-02-19 12:34:56.78' to second)) Expected: is "2015-02-19 12:34:56.00" but: was "2015-02-19 12:34:56" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.apache.calcite.sql.test.ResultCheckers.compareResultSetWithMatcher(ResultCheckers.java:252) at org.apache.calcite.sql.test.ResultCheckers$MatcherResultChecker.checkResult(ResultCheckers.java:321) at org.apache.calcite.test.SqlOperatorTest$TesterImpl.check(SqlOperatorTest.java:14473) at org.apache.calcite.sql.test.SqlTester.check(SqlTester.java:160) at org.apache.calcite.test.SqlOperatorFixtureImpl.lambda$checkScalar$2(SqlOperatorFixtureImpl.java:226) at org.apache.calcite.sql.test.AbstractSqlTester.forEachQuery(AbstractSqlTester.java:450) at org.apache.calcite.test.SqlOperatorFixtureImpl.checkScalar(SqlOperatorFixtureImpl.java:225) at org.apache.calcite.sql.test.SqlOperatorFixture.checkScalar(SqlOperatorFixture.java:221) at org.apache.calcite.test.SqlOperatorTest.testFloorFuncDateTime(SqlOperatorTest.java:11531) at org.junit.platform.commons.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:727) at org.junit.jupiter.engine.execution.MethodInvocation.proceed(MethodInvocation.java:60) at org.junit.jupiter.engine.execution.InvocationInterceptorChain$ValidatingInvocation.proceed(InvocationInterceptorChain.java:131) at org.junit.jupiter.engine.extension.SameThreadTimeoutInvocation.proceed(SameThreadTimeoutInvocation.java:45) at org.junit.jupiter.engine.extension.TimeoutExtension.intercept(TimeoutExtension.java:156) at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestableMethod(TimeoutExtension.java:147) at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestMethod(TimeoutExtension.java:86) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker$ReflectiveInterceptorCall.lambda$ofVoidMethod$0(InterceptingExecutableInvoker.java:103) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.lambda$invoke$0(InterceptingExecutableInvoker.java:93) at org.junit.jupiter.engine.execution.InvocationInterceptorChain$InterceptedInvocation.proceed(InvocationInterceptorChain.java:106) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.proceed(InvocationInterceptorChain.java:64) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.chainAndInvoke(InvocationInterceptorChain.java:45) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.invoke(InvocationInterceptorChain.java:37) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:92) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:86) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.lambda$invokeTestMethod$7(TestMethodTestDescriptor.java:217) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.invokeTestMethod(TestMethodTestDescriptor.java:213) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:138) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:68) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$6(NodeTestTask.java:151) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:141) at org.junit.platform.engine.support.hierarchical.Node.around(Node.java:137) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$9(NodeTestTask.java:139) at org.junit.platform.engine.sup

0.0sec org.apache.calcite.test.SqlOperatorUnparseTest > testFloorFuncDateTime() java.lang.AssertionError: Query: SELECT FLOOR("P0" TO SECOND) FROM (VALUES ROW(TIMESTAMP '2015-02-19 12:34:56.78')) AS "T" ("P0") Expected: is "2015-02-19 12:34:56.00" but: was "2015-02-19 12:34:56" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.apache.calcite.sql.test.ResultCheckers.compareResultSetWithMatcher(ResultCheckers.java:252) at org.apache.calcite.sql.test.ResultCheckers$MatcherResultChecker.checkResult(ResultCheckers.java:321) at org.apache.calcite.test.SqlOperatorTest$TesterImpl.check(SqlOperatorTest.java:14473) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.check(SqlOperatorUnparseTest.java:95) at org.apache.calcite.sql.test.SqlTester.check(SqlTester.java:160) at org.apache.calcite.test.SqlOperatorFixtureImpl.lambda$checkScalar$2(SqlOperatorFixtureImpl.java:226) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.forEachQuery(SqlOperatorUnparseTest.java:88)

0.0sec org.apache.calcite.test.SqlOperatorUnparseTest > testCastDateTime(CastType, SqlOperatorFixture)[1], [1] CAST, org.apache.calcite.test.SqlOperatorUnparseTest$SqlOperatorFixtureUnparseImpl@6bcb15a0 java.lang.AssertionError: Query: SELECT CAST("P0" AS TIME(2)) FROM (VALUES ROW(TIME '12:42:25.34')) AS "T" ("P0") Expected: is "12:42:25.34" but: was "12:42:25" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.apache.calcite.sql.test.ResultCheckers.compareResultSetWithMatcher(ResultCheckers.java:252) at org.apache.calcite.sql.test.ResultCheckers$MatcherResultChecker.checkResult(ResultCheckers.java:321) at org.apache.calcite.test.SqlOperatorTest$TesterImpl.check(SqlOperatorTest.java:14473) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.check(SqlOperatorUnparseTest.java:95) at org.apache.calcite.sql.test.SqlTester.check(SqlTester.java:160) at org.apache.calcite.test.SqlOperatorFixtureImpl.lambda$checkScalar$2(SqlOperatorFixtureImpl.java:226) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.forEachQuery(SqlOperatorUnparseTest.java:88)

7.7sec org.apache.calcite.test.CoreQuidemTest > test(String)[1], [1] sql/misc.iq org.opentest4j.AssertionFailedError: Files differ: /home/runner/work/calcite/calcite/core/build/quidem/test/sql/misc.iq /home/runner/work/calcite/calcite/core/build/resources/test/sql/misc.iq 2149,2153c2149,2153 < +-------------------------+---------------------+---------------------+-----------------------+------------------------+-------------------------+-------------------------+-------------------------+ < | EXPR$0 | EXPR$1 | EXPR$2 | EXPR$3 | EXPR$4 | EXPR$5 | EXPR$6 | EXPR$7 | < +-------------------------+---------------------+---------------------+-----------------------+------------------------+-------------------------+-------------------------+-------------------------+ < | 2016-02-26 19:06:00.123 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00.1 | 2016-02-26 19:06:00.12 | 2016-02-26 19:06:00.123 | 2016-02-26 19:06:00.123 | 2016-02-26 19:06:00.123 | < +-------------------------+---------------------+---------------------+-----------------------+------------------------+-------------------------+-------------------------+-------------------------+ --- > +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ > | EXPR$0 | EXPR$1 | EXPR$2 | EXPR$3 | EXPR$4 | EXPR$5 | EXPR$6 | EXPR$7 | > +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ > | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | > +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ 2167,2171c2167,2171 < +-------------------------+---------------------+--------+ < | EXPR$0 | EXPR$1 | EXPR$2 | < +-------------------------+---------------------+--------+ < | 2016-02-26 19:06:00.123 | 2016-02-26 19:06:00 | 0 | < +-------------------------+---------------------+--------+ --- > +---------------------+---------------------+--------+ > | EXPR$0 | EXPR$1 | EXPR$2 | > +---------------------+---------------------+--------+ > | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 0 | > +---------------------+---------------------+--------+ at org.junit.jupiter.api.AssertionUtils.fail(AssertionUtils.java:38) at org.junit.jupiter.api.Assertions.fail(Assertions.java:135) at org.apache.calcite.test.QuidemTest.checkRun(QuidemTest.java:186) at org.apache.calcite.test.CoreQuidemTest.testSqlMisc(CoreQuidemTest.java:103)

0.1sec org.apache.calcite.test.CalciteSqlOperatorTest > testCeilFuncDateTime() java.lang.AssertionError: Query: values (ceil(timestamp '2015-02-19 12:34:56.78' to second)) Expected: is "2015-02-19 12:34:57.00" but: was "2015-02-19 12:34:57" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.apache.calcite.sql.test.ResultCheckers.compareResultSetWithMatcher(ResultCheckers.java:252) at org.apache.calcite.sql.test.ResultCheckers$MatcherResultChecker.checkResult(ResultCheckers.java:321) at org.apache.calcite.test.SqlOperatorTest$TesterImpl.check(SqlOperatorTest.java:14473) at org.apache.calcite.sql.test.SqlTester.check(SqlTester.java:160) at org.apache.calcite.test.SqlOperatorFixtureImpl.lambda$checkScalar$2(SqlOperatorFixtureImpl.java:226) at org.apache.calcite.sql.test.AbstractSqlTester.forEachQuery(AbstractSqlTester.java:450) at org.apache.calcite.test.SqlOperatorFixtureImpl.checkScalar(SqlOperatorFixtureImpl.java:225) at org.apache.calcite.sql.test.SqlOperatorFixture.checkScalar(SqlOperatorFixture.java:221) at org.apache.calcite.test.SqlOperatorTest.testCeilFuncDateTime(SqlOperatorTest.java:11576) at org.junit.platform.commons.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:727) at org.junit.jupiter.engine.execution.MethodInvocation.proceed(MethodInvocation.java:60) at org.junit.jupiter.engine.execution.InvocationInterceptorChain$ValidatingInvocation.proceed(InvocationInterceptorChain.java:131) at org.junit.jupiter.engine.extension.SameThreadTimeoutInvocation.proceed(SameThreadTimeoutInvocation.java:45) at org.junit.jupiter.engine.extension.TimeoutExtension.intercept(TimeoutExtension.java:156) at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestableMethod(TimeoutExtension.java:147) at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestMethod(TimeoutExtension.java:86) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker$ReflectiveInterceptorCall.lambda$ofVoidMethod$0(InterceptingExecutableInvoker.java:103) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.lambda$invoke$0(InterceptingExecutableInvoker.java:93) at org.junit.jupiter.engine.execution.InvocationInterceptorChain$InterceptedInvocation.proceed(InvocationInterceptorChain.java:106) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.proceed(InvocationInterceptorChain.java:64) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.chainAndInvoke(InvocationInterceptorChain.java:45) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.invoke(InvocationInterceptorChain.java:37) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:92) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:86) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.lambda$invokeTestMethod$7(TestMethodTestDescriptor.java:217) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.invokeTestMethod(TestMethodTestDescriptor.java:213) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:138) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:68) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$6(NodeTestTask.java:151) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:141) at org.junit.platform.engine.support.hierarchical.Node.around(Node.java:137) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$9(NodeTestTask.java:139) at org.junit.platform.engine.suppor

0.0sec org.apache.calcite.test.CalciteSqlOperatorTest > testTimestampAdd() java.lang.AssertionError: Query: values (timestampadd(FRAC_SECOND, 2000000, timestamp '2016-02-24 12:42:25')) Expected: is "2016-02-24 12:42:27.000" but: was "2016-02-24 12:42:27" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.apache.calcite.sql.test.ResultCheckers.compareResultSetWithMatcher(ResultCheckers.java:252) at org.apache.calcite.sql.test.ResultCheckers$MatcherResultChecker.checkResult(ResultCheckers.java:321) at org.apache.calcite.test.SqlOperatorTest$TesterImpl.check(SqlOperatorTest.java:14473) at org.apache.calcite.sql.test.SqlTester.check(SqlTester.java:160) at org.apache.calcite.test.SqlOperatorFixtureImpl.lambda$checkScalar$2(SqlOperatorFixtureImpl.java:226) at org.apache.calcite.sql.test.AbstractSqlTester.forEachQuery(AbstractSqlTester.java:450) at org.apache.calcite.test.SqlOperatorFixtureImpl.checkScalar(SqlOperatorFixtureImpl.java:225) at org.apache.calcite.sql.test.SqlOperatorFixture.checkScalar(SqlOperatorFixture.java:221) at org.apache.calcite.test.SqlOperatorTest.lambda$testTimestampAdd$64(SqlOperatorTest.java:11719) at java.util.Arrays$ArrayList.forEach(Arrays.java:3880) at org.apache.calcite.test.SqlOperatorTest.testTimestampAdd(SqlOperatorTest.java:11718) at org.junit.platform.commons.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:727) at org.junit.jupiter.engine.execution.MethodInvocation.proceed(MethodInvocation.java:60) at org.junit.jupiter.engine.execution.InvocationInterceptorChain$ValidatingInvocation.proceed(InvocationInterceptorChain.java:131) at org.junit.jupiter.engine.extension.SameThreadTimeoutInvocation.proceed(SameThreadTimeoutInvocation.java:45) at org.junit.jupiter.engine.extension.TimeoutExtension.intercept(TimeoutExtension.java:156) at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestableMethod(TimeoutExtension.java:147) at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestMethod(TimeoutExtension.java:86) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker$ReflectiveInterceptorCall.lambda$ofVoidMethod$0(InterceptingExecutableInvoker.java:103) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.lambda$invoke$0(InterceptingExecutableInvoker.java:93) at org.junit.jupiter.engine.execution.InvocationInterceptorChain$InterceptedInvocation.proceed(InvocationInterceptorChain.java:106) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.proceed(InvocationInterceptorChain.java:64) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.chainAndInvoke(InvocationInterceptorChain.java:45) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.invoke(InvocationInterceptorChain.java:37) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:92) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:86) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.lambda$invokeTestMethod$7(TestMethodTestDescriptor.java:217) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.invokeTestMethod(TestMethodTestDescriptor.java:213) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:138) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:68) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$6(NodeTestTask.java:151) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:141) at org.junit.platform.engine.support.hierarchical.Node.around(

0.1sec org.apache.calcite.test.CoreQuidemTest > test(String)[19], [19] sql/stream.iq org.opentest4j.AssertionFailedError: Files differ: /home/runner/work/calcite/calcite/core/build/quidem/test/sql/stream.iq /home/runner/work/calcite/calcite/core/build/resources/test/sql/stream.iq 25,33c25,33 < +---------------------+----+---------+-------+-------------------------+-------------------------+ < | ROWTIME | ID | PRODUCT | UNITS | window_start | window_end | < +---------------------+----+---------+-------+-------------------------+-------------------------+ < | 2015-02-15 10:15:00 | 1 | paint | 10 | 2015-02-15 10:15:00.000 | 2015-02-15 10:16:00.000 | < | 2015-02-15 10:24:15 | 2 | paper | 5 | 2015-02-15 10:24:00.000 | 2015-02-15 10:25:00.000 | < | 2015-02-15 10:24:45 | 3 | brush | 12 | 2015-02-15 10:24:00.000 | 2015-02-15 10:25:00.000 | < | 2015-02-15 10:58:00 | 4 | paint | 3 | 2015-02-15 10:58:00.000 | 2015-02-15 10:59:00.000 | < | 2015-02-15 11:10:00 | 5 | paint | 3 | 2015-02-15 11:10:00.000 | 2015-02-15 11:11:00.000 | < +---------------------+----+---------+-------+-------------------------+-------------------------+ --- > +---------------------+----+---------+-------+---------------------+---------------------+ > | ROWTIME | ID | PRODUCT | UNITS | window_start | window_end | > +---------------------+----+---------+-------+---------------------+---------------------+ > | 2015-02-15 10:15:00 | 1 | paint | 10 | 2015-02-15 10:15:00 | 2015-02-15 10:16:00 | > | 2015-02-15 10:24:15 | 2 | paper | 5 | 2015-02-15 10:24:00 | 2015-02-15 10:25:00 | > | 2015-02-15 10:24:45 | 3 | brush | 12 | 2015-02-15 10:24:00 | 2015-02-15 10:25:00 | > | 2015-02-15 10:58:00 | 4 | paint | 3 | 2015-02-15 10:58:00 | 2015-02-15 10:59:00 | > | 2015-02-15 11:10:00 | 5 | paint | 3 | 2015-02-15 11:10:00 | 2015-02-15 11:11:00 | > +---------------------+----+---------+-------+---------------------+---------------------+ 39,47c39,47 < +---------------------+----+---------+-------+-------------------------+-------------------------+ < | ROWTIME | ID | PRODUCT | UNITS | window_start | window_end | < +---------------------+----+---------+-------+-------------------------+-------------------------+ < | 2015-02-15 10:15:00 | 1 | paint | 10 | 2015-02-15 10:15:00.000 | 2015-02-15 10:16:00.000 | < | 2015-02-15 10:24:15 | 2 | paper | 5 | 2015-02-15 10:24:00.000 | 2015-02-15 10:25:00.000 | < | 2015-02-15 10:24:45 | 3 | brush | 12 | 2015-02-15 10:24:00.000 | 2015-02-15 10:25:00.000 | < | 2015-02-15 10:58:00 | 4 | paint | 3 | 2015-02-15 10:58:00.000 | 2015-02-15 10:59:00.000 | < | 2015-02-15 11:10:00 | 5 | paint | 3 | 2015-02-15 11:10:00.000 | 2015-02-15 11:11:00.000 | < +---------------------+----+---------+-------+-------------------------+-------------------------+ --- > +---------------------+----+---------+-------+---------------------+---------------------+ > | ROWTIME | ID | PRODUCT | UNITS | window_start | window_end | > +---------------------+----+---------+-------+---------------------+---------------------+ > | 2015-02-15 10:15:00 | 1 | paint | 10 | 2015-02-15 10:15:00 | 2015-02-15 10:16:00 | > | 2015-02-15 10:24:15 | 2 | paper | 5 | 2015-02-15 10:24:00 | 2015-02-15 10:25:00 | > | 2015-02-15 10:24:45 | 3 | brush | 12 | 2015-02-15 10:24:00 | 2015-02-15 10:25:00 | > | 2015-02-15 10:58:00 | 4 | paint | 3 | 2015-02-15 10:58:00 | 2015-02-15 10:59:00 | > | 2015-02-15 11:10:00 | 5 | paint | 3 | 2015-02-15 11:10:00 | 2015-02-15 11:11:00 | > +---------------------+----+---------+-------+---------------------+---------------------+ 53,61c53,61 < +---------------------+----+---------+-------+-------------------------+-------------------------+ < | ROWTIME | ID | PRODUCT | UNITS | window_start | window_end | < +---------------------+----+---------+-------+-------------------------+-

0.9sec org.apache.calcite.test.CoreQuidemTest > test(String)[27], [27] sql/operator.iq org.opentest4j.AssertionFailedError: Files differ: /home/runner/work/calcite/calcite/core/build/quidem/test/sql/operator.iq /home/runner/work/calcite/calcite/core/build/resources/test/sql/operator.iq 238,243c238,243 < +------------+-------+------------+------------+------------+------------+------------+------------+------------+------------+ < | V | OP | Y | Q | M | W | D | H | MI | S | < +------------+-------+------------+------------+------------+------------+------------+------------+------------+------------+ < | 12:34:56.7 | ceil | 12:34:57.0 | 12:34:56.7 | 12:34:56.7 | 12:34:56.7 | 12:34:56.7 | 13:00:00.0 | 12:35:00.0 | 12:34:57.0 | < | 12:34:56.7 | floor | 12:34:56.6 | 12:34:56.6 | 12:34:56.6 | 12:34:56.6 | 12:34:56.7 | 12:00:00.0 | 12:34:00.0 | 12:34:56.0 | < +------------+-------+------------+------------+------------+------------+------------+------------+------------+------------+ --- > +----------+-------+----------+----------+----------+----------+----------+----------+----------+----------+ > | V | OP | Y | Q | M | W | D | H | MI | S | > +----------+-------+----------+----------+----------+----------+----------+----------+----------+----------+ > | 12:34:56 | ceil | 12:34:57 | 12:34:56 | 12:34:56 | 12:34:56 | 12:34:56 | 13:00:00 | 12:35:00 | 12:34:57 | > | 12:34:56 | floor | 12:34:56 | 12:34:56 | 12:34:56 | 12:34:56 | 12:34:56 | 12:00:00 | 12:34:00 | 12:34:56 | > +----------+-------+----------+----------+----------+----------+----------+----------+----------+----------+ at org.junit.jupiter.api.AssertionUtils.fail(AssertionUtils.java:38) at org.junit.jupiter.api.Assertions.fail(Assertions.java:135) at org.apache.calcite.test.QuidemTest.checkRun(QuidemTest.java:186) at org.apache.calcite.test.QuidemTest.test(QuidemTest.java:239) at org.junit.platform.commons.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:727) at org.junit.jupiter.engine.execution.MethodInvocation.proceed(MethodInvocation.java:60) at org.junit.jupiter.engine.execution.InvocationInterceptorChain$ValidatingInvocation.proceed(InvocationInterceptorChain.java:131) at org.junit.jupiter.engine.extension.SameThreadTimeoutInvocation.proceed(SameThreadTimeoutInvocation.java:45) at org.junit.jupiter.engine.extension.TimeoutExtension.intercept(TimeoutExtension.java:156) at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestableMethod(TimeoutExtension.java:147) at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestTemplateMethod(TimeoutExtension.java:94) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker$ReflectiveInterceptorCall.lambda$ofVoidMethod$0(InterceptingExecutableInvoker.java:103) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.lambda$invoke$0(InterceptingExecutableInvoker.java:93) at org.junit.jupiter.engine.execution.InvocationInterceptorChain$InterceptedInvocation.proceed(InvocationInterceptorChain.java:106) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.proceed(InvocationInterceptorChain.java:64) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.chainAndInvoke(InvocationInterceptorChain.java:45) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.invoke(InvocationInterceptorChain.java:37) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:92) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:86) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.lambda$invokeTestMethod$7(TestMethodTestDescriptor.java:217) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.i

0.1sec org.apache.calcite.test.CalciteSqlOperatorTest > testFloorFuncDateTime() java.lang.AssertionError: Query: values (floor(timestamp '2015-02-19 12:34:56.78' to second)) Expected: is "2015-02-19 12:34:56.00" but: was "2015-02-19 12:34:56" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.apache.calcite.sql.test.ResultCheckers.compareResultSetWithMatcher(ResultCheckers.java:252) at org.apache.calcite.sql.test.ResultCheckers$MatcherResultChecker.checkResult(ResultCheckers.java:321) at org.apache.calcite.test.SqlOperatorTest$TesterImpl.check(SqlOperatorTest.java:14473) at org.apache.calcite.sql.test.SqlTester.check(SqlTester.java:160) at org.apache.calcite.test.SqlOperatorFixtureImpl.lambda$checkScalar$2(SqlOperatorFixtureImpl.java:226) at org.apache.calcite.sql.test.AbstractSqlTester.forEachQuery(AbstractSqlTester.java:450) at org.apache.calcite.test.SqlOperatorFixtureImpl.checkScalar(SqlOperatorFixtureImpl.java:225) at org.apache.calcite.sql.test.SqlOperatorFixture.checkScalar(SqlOperatorFixture.java:221) at org.apache.calcite.test.SqlOperatorTest.testFloorFuncDateTime(SqlOperatorTest.java:11531) at org.junit.platform.commons.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:727) at org.junit.jupiter.engine.execution.MethodInvocation.proceed(MethodInvocation.java:60) at org.junit.jupiter.engine.execution.InvocationInterceptorChain$ValidatingInvocation.proceed(InvocationInterceptorChain.java:131) at org.junit.jupiter.engine.extension.SameThreadTimeoutInvocation.proceed(SameThreadTimeoutInvocation.java:45) at org.junit.jupiter.engine.extension.TimeoutExtension.intercept(TimeoutExtension.java:156) at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestableMethod(TimeoutExtension.java:147) at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestMethod(TimeoutExtension.java:86) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker$ReflectiveInterceptorCall.lambda$ofVoidMethod$0(InterceptingExecutableInvoker.java:103) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.lambda$invoke$0(InterceptingExecutableInvoker.java:93) at org.junit.jupiter.engine.execution.InvocationInterceptorChain$InterceptedInvocation.proceed(InvocationInterceptorChain.java:106) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.proceed(InvocationInterceptorChain.java:64) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.chainAndInvoke(InvocationInterceptorChain.java:45) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.invoke(InvocationInterceptorChain.java:37) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:92) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:86) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.lambda$invokeTestMethod$7(TestMethodTestDescriptor.java:217) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.invokeTestMethod(TestMethodTestDescriptor.java:213) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:138) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:68) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$6(NodeTestTask.java:151) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:141) at org.junit.platform.engine.support.hierarchical.Node.around(Node.java:137) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$9(NodeTestTask.java:139) at org.junit.platform.engine.sup

0.0sec org.apache.calcite.test.SqlOperatorUnparseTest > testCeilFuncDateTime() java.lang.AssertionError: Query: SELECT CEIL("P0" TO SECOND) FROM (VALUES ROW(TIMESTAMP '2015-02-19 12:34:56.78')) AS "T" ("P0") Expected: is "2015-02-19 12:34:57.00" but: was "2015-02-19 12:34:57" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.apache.calcite.sql.test.ResultCheckers.compareResultSetWithMatcher(ResultCheckers.java:252) at org.apache.calcite.sql.test.ResultCheckers$MatcherResultChecker.checkResult(ResultCheckers.java:321) at org.apache.calcite.test.SqlOperatorTest$TesterImpl.check(SqlOperatorTest.java:14473) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.check(SqlOperatorUnparseTest.java:95) at org.apache.calcite.sql.test.SqlTester.check(SqlTester.java:160) at org.apache.calcite.test.SqlOperatorFixtureImpl.lambda$checkScalar$2(SqlOperatorFixtureImpl.java:226) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.forEachQuery(SqlOperatorUnparseTest.java:88)

0.0sec org.apache.calcite.test.SqlOperatorUnparseTest > testTimestampAdd() java.lang.AssertionError: Query: SELECT TIMESTAMPADD("FRAC_SECOND", "P1", "P0") FROM (VALUES ROW(TIMESTAMP '2016-02-24 12:42:25', 2000000)) AS "T" ("P0", "P1") Expected: is "2016-02-24 12:42:27.000" but: was "2016-02-24 12:42:27" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.apache.calcite.sql.test.ResultCheckers.compareResultSetWithMatcher(ResultCheckers.java:252) at org.apache.calcite.sql.test.ResultCheckers$MatcherResultChecker.checkResult(ResultCheckers.java:321) at org.apache.calcite.test.SqlOperatorTest$TesterImpl.check(SqlOperatorTest.java:14473) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.check(SqlOperatorUnparseTest.java:95) at org.apache.calcite.sql.test.SqlTester.check(SqlTester.java:160) at org.apache.calcite.test.SqlOperatorFixtureImpl.lambda$checkScalar$2(SqlOperatorFixtureImpl.java:226) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.forEachQuery(SqlOperatorUnparseTest.java:88)

0.0sec org.apache.calcite.test.SqlOperatorUnparseTest > testFloorFuncDateTime() java.lang.AssertionError: Query: SELECT FLOOR("P0" TO SECOND) FROM (VALUES ROW(TIMESTAMP '2015-02-19 12:34:56.78')) AS "T" ("P0") Expected: is "2015-02-19 12:34:56.00" but: was "2015-02-19 12:34:56" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.apache.calcite.sql.test.ResultCheckers.compareResultSetWithMatcher(ResultCheckers.java:252) at org.apache.calcite.sql.test.ResultCheckers$MatcherResultChecker.checkResult(ResultCheckers.java:321) at org.apache.calcite.test.SqlOperatorTest$TesterImpl.check(SqlOperatorTest.java:14473) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.check(SqlOperatorUnparseTest.java:95) at org.apache.calcite.sql.test.SqlTester.check(SqlTester.java:160) at org.apache.calcite.test.SqlOperatorFixtureImpl.lambda$checkScalar$2(SqlOperatorFixtureImpl.java:226) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.forEachQuery(SqlOperatorUnparseTest.java:88)

0.0sec org.apache.calcite.test.SqlOperatorUnparseTest > testCastDateTime(CastType, SqlOperatorFixture)[1], [1] CAST, org.apache.calcite.test.SqlOperatorUnparseTest$SqlOperatorFixtureUnparseImpl@44975086 java.lang.AssertionError: Query: SELECT CAST("P0" AS TIME(2)) FROM (VALUES ROW(TIME '12:42:25.34')) AS "T" ("P0") Expected: is "12:42:25.34" but: was "12:42:25" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.apache.calcite.sql.test.ResultCheckers.compareResultSetWithMatcher(ResultCheckers.java:252) at org.apache.calcite.sql.test.ResultCheckers$MatcherResultChecker.checkResult(ResultCheckers.java:321) at org.apache.calcite.test.SqlOperatorTest$TesterImpl.check(SqlOperatorTest.java:14473) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.check(SqlOperatorUnparseTest.java:95) at org.apache.calcite.sql.test.SqlTester.check(SqlTester.java:160) at org.apache.calcite.test.SqlOperatorFixtureImpl.lambda$checkScalar$2(SqlOperatorFixtureImpl.java:226) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.forEachQuery(SqlOperatorUnparseTest.java:88)

10.3sec org.apache.calcite.test.CoreQuidemTest > test(String)[1], [1] sql/misc.iq org.opentest4j.AssertionFailedError: Files differ: /home/runner/work/calcite/calcite/core/build/quidem/test/sql/misc.iq /home/runner/work/calcite/calcite/core/build/resources/test/sql/misc.iq 2149,2153c2149,2153 < +-------------------------+---------------------+---------------------+-----------------------+------------------------+-------------------------+-------------------------+-------------------------+ < | EXPR$0 | EXPR$1 | EXPR$2 | EXPR$3 | EXPR$4 | EXPR$5 | EXPR$6 | EXPR$7 | < +-------------------------+---------------------+---------------------+-----------------------+------------------------+-------------------------+-------------------------+-------------------------+ < | 2016-02-26 19:06:00.123 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00.1 | 2016-02-26 19:06:00.12 | 2016-02-26 19:06:00.123 | 2016-02-26 19:06:00.123 | 2016-02-26 19:06:00.123 | < +-------------------------+---------------------+---------------------+-----------------------+------------------------+-------------------------+-------------------------+-------------------------+ --- > +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ > | EXPR$0 | EXPR$1 | EXPR$2 | EXPR$3 | EXPR$4 | EXPR$5 | EXPR$6 | EXPR$7 | > +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ > | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | > +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ 2167,2171c2167,2171 < +-------------------------+---------------------+--------+ < | EXPR$0 | EXPR$1 | EXPR$2 | < +-------------------------+---------------------+--------+ < | 2016-02-26 19:06:00.123 | 2016-02-26 19:06:00 | 0 | < +-------------------------+---------------------+--------+ --- > +---------------------+---------------------+--------+ > | EXPR$0 | EXPR$1 | EXPR$2 | > +---------------------+---------------------+--------+ > | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 0 | > +---------------------+---------------------+--------+ at app//org.junit.jupiter.api.AssertionUtils.fail(AssertionUtils.java:38) at app//org.junit.jupiter.api.Assertions.fail(Assertions.java:135) at app//org.apache.calcite.test.QuidemTest.checkRun(QuidemTest.java:186) at app//org.apache.calcite.test.CoreQuidemTest.testSqlMisc(CoreQuidemTest.java:103)

0.1sec org.apache.calcite.test.CalciteSqlOperatorTest > testCeilFuncDateTime() java.lang.AssertionError: Query: values (ceil(timestamp '2015-02-19 12:34:56.78' to second)) Expected: is "2015-02-19 12:34:57.00" but: was "2015-02-19 12:34:57" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.apache.calcite.sql.test.ResultCheckers.compareResultSetWithMatcher(ResultCheckers.java:252) at org.apache.calcite.sql.test.ResultCheckers$MatcherResultChecker.checkResult(ResultCheckers.java:321) at org.apache.calcite.test.SqlOperatorTest$TesterImpl.check(SqlOperatorTest.java:14473) at org.apache.calcite.sql.test.SqlTester.check(SqlTester.java:160) at org.apache.calcite.test.SqlOperatorFixtureImpl.lambda$checkScalar$2(SqlOperatorFixtureImpl.java:226) at org.apache.calcite.sql.test.AbstractSqlTester.forEachQuery(AbstractSqlTester.java:450) at org.apache.calcite.test.SqlOperatorFixtureImpl.checkScalar(SqlOperatorFixtureImpl.java:225) at org.apache.calcite.sql.test.SqlOperatorFixture.checkScalar(SqlOperatorFixture.java:221) at org.apache.calcite.test.SqlOperatorTest.testCeilFuncDateTime(SqlOperatorTest.java:11576) at org.junit.platform.commons.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:727) at org.junit.jupiter.engine.execution.MethodInvocation.proceed(MethodInvocation.java:60) at org.junit.jupiter.engine.execution.InvocationInterceptorChain$ValidatingInvocation.proceed(InvocationInterceptorChain.java:131) at org.junit.jupiter.engine.extension.SameThreadTimeoutInvocation.proceed(SameThreadTimeoutInvocation.java:45) at org.junit.jupiter.engine.extension.TimeoutExtension.intercept(TimeoutExtension.java:156) at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestableMethod(TimeoutExtension.java:147) at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestMethod(TimeoutExtension.java:86) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker$ReflectiveInterceptorCall.lambda$ofVoidMethod$0(InterceptingExecutableInvoker.java:103) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.lambda$invoke$0(InterceptingExecutableInvoker.java:93) at org.junit.jupiter.engine.execution.InvocationInterceptorChain$InterceptedInvocation.proceed(InvocationInterceptorChain.java:106) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.proceed(InvocationInterceptorChain.java:64) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.chainAndInvoke(InvocationInterceptorChain.java:45) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.invoke(InvocationInterceptorChain.java:37) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:92) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:86) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.lambda$invokeTestMethod$7(TestMethodTestDescriptor.java:217) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.invokeTestMethod(TestMethodTestDescriptor.java:213) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:138) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:68) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$6(NodeTestTask.java:151) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:141) at org.junit.platform.engine.support.hierarchical.Node.around(Node.java:137) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$9(NodeTestTask.java:139) at org.junit.platform.engine.suppor

0.0sec org.apache.calcite.test.CalciteSqlOperatorTest > testTimestampAdd() java.lang.AssertionError: Query: values (timestampadd(FRAC_SECOND, 2000000, timestamp '2016-02-24 12:42:25')) Expected: is "2016-02-24 12:42:27.000" but: was "2016-02-24 12:42:27" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.apache.calcite.sql.test.ResultCheckers.compareResultSetWithMatcher(ResultCheckers.java:252) at org.apache.calcite.sql.test.ResultCheckers$MatcherResultChecker.checkResult(ResultCheckers.java:321) at org.apache.calcite.test.SqlOperatorTest$TesterImpl.check(SqlOperatorTest.java:14473) at org.apache.calcite.sql.test.SqlTester.check(SqlTester.java:160) at org.apache.calcite.test.SqlOperatorFixtureImpl.lambda$checkScalar$2(SqlOperatorFixtureImpl.java:226) at org.apache.calcite.sql.test.AbstractSqlTester.forEachQuery(AbstractSqlTester.java:450) at org.apache.calcite.test.SqlOperatorFixtureImpl.checkScalar(SqlOperatorFixtureImpl.java:225) at org.apache.calcite.sql.test.SqlOperatorFixture.checkScalar(SqlOperatorFixture.java:221) at org.apache.calcite.test.SqlOperatorTest.lambda$testTimestampAdd$64(SqlOperatorTest.java:11719) at java.base/java.util.Arrays$ArrayList.forEach(Arrays.java:4204) at org.apache.calcite.test.SqlOperatorTest.testTimestampAdd(SqlOperatorTest.java:11718) at org.junit.platform.commons.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:727) at org.junit.jupiter.engine.execution.MethodInvocation.proceed(MethodInvocation.java:60) at org.junit.jupiter.engine.execution.InvocationInterceptorChain$ValidatingInvocation.proceed(InvocationInterceptorChain.java:131) at org.junit.jupiter.engine.extension.SameThreadTimeoutInvocation.proceed(SameThreadTimeoutInvocation.java:45) at org.junit.jupiter.engine.extension.TimeoutExtension.intercept(TimeoutExtension.java:156) at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestableMethod(TimeoutExtension.java:147) at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestMethod(TimeoutExtension.java:86) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker$ReflectiveInterceptorCall.lambda$ofVoidMethod$0(InterceptingExecutableInvoker.java:103) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.lambda$invoke$0(InterceptingExecutableInvoker.java:93) at org.junit.jupiter.engine.execution.InvocationInterceptorChain$InterceptedInvocation.proceed(InvocationInterceptorChain.java:106) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.proceed(InvocationInterceptorChain.java:64) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.chainAndInvoke(InvocationInterceptorChain.java:45) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.invoke(InvocationInterceptorChain.java:37) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:92) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:86) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.lambda$invokeTestMethod$7(TestMethodTestDescriptor.java:217) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.invokeTestMethod(TestMethodTestDescriptor.java:213) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:138) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:68) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$6(NodeTestTask.java:151) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:141) at org.junit.platform.engine.support.hierarchical.No

0.2sec org.apache.calcite.test.CoreQuidemTest > test(String)[19], [19] sql/stream.iq org.opentest4j.AssertionFailedError: Files differ: /home/runner/work/calcite/calcite/core/build/quidem/test/sql/stream.iq /home/runner/work/calcite/calcite/core/build/resources/test/sql/stream.iq 25,33c25,33 < +---------------------+----+---------+-------+-------------------------+-------------------------+ < | ROWTIME | ID | PRODUCT | UNITS | window_start | window_end | < +---------------------+----+---------+-------+-------------------------+-------------------------+ < | 2015-02-15 10:15:00 | 1 | paint | 10 | 2015-02-15 10:15:00.000 | 2015-02-15 10:16:00.000 | < | 2015-02-15 10:24:15 | 2 | paper | 5 | 2015-02-15 10:24:00.000 | 2015-02-15 10:25:00.000 | < | 2015-02-15 10:24:45 | 3 | brush | 12 | 2015-02-15 10:24:00.000 | 2015-02-15 10:25:00.000 | < | 2015-02-15 10:58:00 | 4 | paint | 3 | 2015-02-15 10:58:00.000 | 2015-02-15 10:59:00.000 | < | 2015-02-15 11:10:00 | 5 | paint | 3 | 2015-02-15 11:10:00.000 | 2015-02-15 11:11:00.000 | < +---------------------+----+---------+-------+-------------------------+-------------------------+ --- > +---------------------+----+---------+-------+---------------------+---------------------+ > | ROWTIME | ID | PRODUCT | UNITS | window_start | window_end | > +---------------------+----+---------+-------+---------------------+---------------------+ > | 2015-02-15 10:15:00 | 1 | paint | 10 | 2015-02-15 10:15:00 | 2015-02-15 10:16:00 | > | 2015-02-15 10:24:15 | 2 | paper | 5 | 2015-02-15 10:24:00 | 2015-02-15 10:25:00 | > | 2015-02-15 10:24:45 | 3 | brush | 12 | 2015-02-15 10:24:00 | 2015-02-15 10:25:00 | > | 2015-02-15 10:58:00 | 4 | paint | 3 | 2015-02-15 10:58:00 | 2015-02-15 10:59:00 | > | 2015-02-15 11:10:00 | 5 | paint | 3 | 2015-02-15 11:10:00 | 2015-02-15 11:11:00 | > +---------------------+----+---------+-------+---------------------+---------------------+ 39,47c39,47 < +---------------------+----+---------+-------+-------------------------+-------------------------+ < | ROWTIME | ID | PRODUCT | UNITS | window_start | window_end | < +---------------------+----+---------+-------+-------------------------+-------------------------+ < | 2015-02-15 10:15:00 | 1 | paint | 10 | 2015-02-15 10:15:00.000 | 2015-02-15 10:16:00.000 | < | 2015-02-15 10:24:15 | 2 | paper | 5 | 2015-02-15 10:24:00.000 | 2015-02-15 10:25:00.000 | < | 2015-02-15 10:24:45 | 3 | brush | 12 | 2015-02-15 10:24:00.000 | 2015-02-15 10:25:00.000 | < | 2015-02-15 10:58:00 | 4 | paint | 3 | 2015-02-15 10:58:00.000 | 2015-02-15 10:59:00.000 | < | 2015-02-15 11:10:00 | 5 | paint | 3 | 2015-02-15 11:10:00.000 | 2015-02-15 11:11:00.000 | < +---------------------+----+---------+-------+-------------------------+-------------------------+ --- > +---------------------+----+---------+-------+---------------------+---------------------+ > | ROWTIME | ID | PRODUCT | UNITS | window_start | window_end | > +---------------------+----+---------+-------+---------------------+---------------------+ > | 2015-02-15 10:15:00 | 1 | paint | 10 | 2015-02-15 10:15:00 | 2015-02-15 10:16:00 | > | 2015-02-15 10:24:15 | 2 | paper | 5 | 2015-02-15 10:24:00 | 2015-02-15 10:25:00 | > | 2015-02-15 10:24:45 | 3 | brush | 12 | 2015-02-15 10:24:00 | 2015-02-15 10:25:00 | > | 2015-02-15 10:58:00 | 4 | paint | 3 | 2015-02-15 10:58:00 | 2015-02-15 10:59:00 | > | 2015-02-15 11:10:00 | 5 | paint | 3 | 2015-02-15 11:10:00 | 2015-02-15 11:11:00 | > +---------------------+----+---------+-------+---------------------+---------------------+ 53,61c53,61 < +---------------------+----+---------+-------+-------------------------+-------------------------+ < | ROWTIME | ID | PRODUCT | UNITS | window_start | window_end | < +---------------------+----+---------+-------+-------------------------+-

0.1sec org.apache.calcite.test.SqlOperatorUnparseTest > testCeilFuncDateTime() java.lang.AssertionError: Query: SELECT CEIL("P0" TO SECOND) FROM (VALUES ROW(TIMESTAMP '2015-02-19 12:34:56.78')) AS "T" ("P0") Expected: is "2015-02-19 12:34:57.00" but: was "2015-02-19 12:34:57" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.apache.calcite.sql.test.ResultCheckers.compareResultSetWithMatcher(ResultCheckers.java:252) at org.apache.calcite.sql.test.ResultCheckers$MatcherResultChecker.checkResult(ResultCheckers.java:321) at org.apache.calcite.test.SqlOperatorTest$TesterImpl.check(SqlOperatorTest.java:14473) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.check(SqlOperatorUnparseTest.java:95) at org.apache.calcite.sql.test.SqlTester.check(SqlTester.java:160) at org.apache.calcite.test.SqlOperatorFixtureImpl.lambda$checkScalar$2(SqlOperatorFixtureImpl.java:226) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.forEachQuery(SqlOperatorUnparseTest.java:88)

0.8sec org.apache.calcite.test.CoreQuidemTest > test(String)[27], [27] sql/operator.iq org.opentest4j.AssertionFailedError: Files differ: /home/runner/work/calcite/calcite/core/build/quidem/test/sql/operator.iq /home/runner/work/calcite/calcite/core/build/resources/test/sql/operator.iq 238,243c238,243 < +------------+-------+------------+------------+------------+------------+------------+------------+------------+------------+ < | V | OP | Y | Q | M | W | D | H | MI | S | < +------------+-------+------------+------------+------------+------------+------------+------------+------------+------------+ < | 12:34:56.7 | ceil | 12:34:57.0 | 12:34:56.7 | 12:34:56.7 | 12:34:56.7 | 12:34:56.7 | 13:00:00.0 | 12:35:00.0 | 12:34:57.0 | < | 12:34:56.7 | floor | 12:34:56.6 | 12:34:56.6 | 12:34:56.6 | 12:34:56.6 | 12:34:56.7 | 12:00:00.0 | 12:34:00.0 | 12:34:56.0 | < +------------+-------+------------+------------+------------+------------+------------+------------+------------+------------+ --- > +----------+-------+----------+----------+----------+----------+----------+----------+----------+----------+ > | V | OP | Y | Q | M | W | D | H | MI | S | > +----------+-------+----------+----------+----------+----------+----------+----------+----------+----------+ > | 12:34:56 | ceil | 12:34:57 | 12:34:56 | 12:34:56 | 12:34:56 | 12:34:56 | 13:00:00 | 12:35:00 | 12:34:57 | > | 12:34:56 | floor | 12:34:56 | 12:34:56 | 12:34:56 | 12:34:56 | 12:34:56 | 12:00:00 | 12:34:00 | 12:34:56 | > +----------+-------+----------+----------+----------+----------+----------+----------+----------+----------+ at app//org.junit.jupiter.api.AssertionUtils.fail(AssertionUtils.java:38) at app//org.junit.jupiter.api.Assertions.fail(Assertions.java:135) at app//org.apache.calcite.test.QuidemTest.checkRun(QuidemTest.java:186) at app//org.apache.calcite.test.QuidemTest.test(QuidemTest.java:239) at app//org.junit.platform.commons.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:727) at app//org.junit.jupiter.engine.execution.MethodInvocation.proceed(MethodInvocation.java:60) at app//org.junit.jupiter.engine.execution.InvocationInterceptorChain$ValidatingInvocation.proceed(InvocationInterceptorChain.java:131) at app//org.junit.jupiter.engine.extension.SameThreadTimeoutInvocation.proceed(SameThreadTimeoutInvocation.java:45) at app//org.junit.jupiter.engine.extension.TimeoutExtension.intercept(TimeoutExtension.java:156) at app//org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestableMethod(TimeoutExtension.java:147) at app//org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestTemplateMethod(TimeoutExtension.java:94) at app//org.junit.jupiter.engine.execution.InterceptingExecutableInvoker$ReflectiveInterceptorCall.lambda$ofVoidMethod$0(InterceptingExecutableInvoker.java:103) at app//org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.lambda$invoke$0(InterceptingExecutableInvoker.java:93) at app//org.junit.jupiter.engine.execution.InvocationInterceptorChain$InterceptedInvocation.proceed(InvocationInterceptorChain.java:106) at app//org.junit.jupiter.engine.execution.InvocationInterceptorChain.proceed(InvocationInterceptorChain.java:64) at app//org.junit.jupiter.engine.execution.InvocationInterceptorChain.chainAndInvoke(InvocationInterceptorChain.java:45) at app//org.junit.jupiter.engine.execution.InvocationInterceptorChain.invoke(InvocationInterceptorChain.java:37) at app//org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:92) at app//org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:86) at app//org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.lambda$invokeTestMethod$7(TestMethodTestDescriptor.java:217) at app//org.junit.platform.engine.support.hierarchical.ThrowableCollector.

0.0sec org.apache.calcite.test.SqlOperatorUnparseTest > testTimestampAdd() java.lang.AssertionError: Query: SELECT TIMESTAMPADD("FRAC_SECOND", "P1", "P0") FROM (VALUES ROW(TIMESTAMP '2016-02-24 12:42:25', 2000000)) AS "T" ("P0", "P1") Expected: is "2016-02-24 12:42:27.000" but: was "2016-02-24 12:42:27" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.apache.calcite.sql.test.ResultCheckers.compareResultSetWithMatcher(ResultCheckers.java:252) at org.apache.calcite.sql.test.ResultCheckers$MatcherResultChecker.checkResult(ResultCheckers.java:321) at org.apache.calcite.test.SqlOperatorTest$TesterImpl.check(SqlOperatorTest.java:14473) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.check(SqlOperatorUnparseTest.java:95) at org.apache.calcite.sql.test.SqlTester.check(SqlTester.java:160) at org.apache.calcite.test.SqlOperatorFixtureImpl.lambda$checkScalar$2(SqlOperatorFixtureImpl.java:226) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.forEachQuery(SqlOperatorUnparseTest.java:88)

0.1sec org.apache.calcite.test.CalciteSqlOperatorTest > testFloorFuncDateTime() java.lang.AssertionError: Query: values (floor(timestamp '2015-02-19 12:34:56.78' to second)) Expected: is "2015-02-19 12:34:56.00" but: was "2015-02-19 12:34:56" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.apache.calcite.sql.test.ResultCheckers.compareResultSetWithMatcher(ResultCheckers.java:252) at org.apache.calcite.sql.test.ResultCheckers$MatcherResultChecker.checkResult(ResultCheckers.java:321) at org.apache.calcite.test.SqlOperatorTest$TesterImpl.check(SqlOperatorTest.java:14473) at org.apache.calcite.sql.test.SqlTester.check(SqlTester.java:160) at org.apache.calcite.test.SqlOperatorFixtureImpl.lambda$checkScalar$2(SqlOperatorFixtureImpl.java:226) at org.apache.calcite.sql.test.AbstractSqlTester.forEachQuery(AbstractSqlTester.java:450) at org.apache.calcite.test.SqlOperatorFixtureImpl.checkScalar(SqlOperatorFixtureImpl.java:225) at org.apache.calcite.sql.test.SqlOperatorFixture.checkScalar(SqlOperatorFixture.java:221) at org.apache.calcite.test.SqlOperatorTest.testFloorFuncDateTime(SqlOperatorTest.java:11531) at org.junit.platform.commons.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:727) at org.junit.jupiter.engine.execution.MethodInvocation.proceed(MethodInvocation.java:60) at org.junit.jupiter.engine.execution.InvocationInterceptorChain$ValidatingInvocation.proceed(InvocationInterceptorChain.java:131) at org.junit.jupiter.engine.extension.SameThreadTimeoutInvocation.proceed(SameThreadTimeoutInvocation.java:45) at org.junit.jupiter.engine.extension.TimeoutExtension.intercept(TimeoutExtension.java:156) at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestableMethod(TimeoutExtension.java:147) at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestMethod(TimeoutExtension.java:86) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker$ReflectiveInterceptorCall.lambda$ofVoidMethod$0(InterceptingExecutableInvoker.java:103) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.lambda$invoke$0(InterceptingExecutableInvoker.java:93) at org.junit.jupiter.engine.execution.InvocationInterceptorChain$InterceptedInvocation.proceed(InvocationInterceptorChain.java:106) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.proceed(InvocationInterceptorChain.java:64) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.chainAndInvoke(InvocationInterceptorChain.java:45) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.invoke(InvocationInterceptorChain.java:37) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:92) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:86) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.lambda$invokeTestMethod$7(TestMethodTestDescriptor.java:217) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.invokeTestMethod(TestMethodTestDescriptor.java:213) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:138) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:68) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$6(NodeTestTask.java:151) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:141) at org.junit.platform.engine.support.hierarchical.Node.around(Node.java:137) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$9(NodeTestTask.java:139) at org.junit.platform.engine.sup

0.0sec org.apache.calcite.test.SqlOperatorUnparseTest > testFloorFuncDateTime() java.lang.AssertionError: Query: SELECT FLOOR("P0" TO SECOND) FROM (VALUES ROW(TIMESTAMP '2015-02-19 12:34:56.78')) AS "T" ("P0") Expected: is "2015-02-19 12:34:56.00" but: was "2015-02-19 12:34:56" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.apache.calcite.sql.test.ResultCheckers.compareResultSetWithMatcher(ResultCheckers.java:252) at org.apache.calcite.sql.test.ResultCheckers$MatcherResultChecker.checkResult(ResultCheckers.java:321) at org.apache.calcite.test.SqlOperatorTest$TesterImpl.check(SqlOperatorTest.java:14473) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.check(SqlOperatorUnparseTest.java:95) at org.apache.calcite.sql.test.SqlTester.check(SqlTester.java:160) at org.apache.calcite.test.SqlOperatorFixtureImpl.lambda$checkScalar$2(SqlOperatorFixtureImpl.java:226) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.forEachQuery(SqlOperatorUnparseTest.java:88)

0.0sec org.apache.calcite.test.SqlOperatorUnparseTest > testCastDateTime(CastType, SqlOperatorFixture)[1], [1] CAST, org.apache.calcite.test.SqlOperatorUnparseTest$SqlOperatorFixtureUnparseImpl@73b02e22 java.lang.AssertionError: Query: SELECT CAST("P0" AS TIME(2)) FROM (VALUES ROW(TIME '12:42:25.34')) AS "T" ("P0") Expected: is "12:42:25.34" but: was "12:42:25" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.apache.calcite.sql.test.ResultCheckers.compareResultSetWithMatcher(ResultCheckers.java:252) at org.apache.calcite.sql.test.ResultCheckers$MatcherResultChecker.checkResult(ResultCheckers.java:321) at org.apache.calcite.test.SqlOperatorTest$TesterImpl.check(SqlOperatorTest.java:14473) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.check(SqlOperatorUnparseTest.java:95) at org.apache.calcite.sql.test.SqlTester.check(SqlTester.java:160) at org.apache.calcite.test.SqlOperatorFixtureImpl.lambda$checkScalar$2(SqlOperatorFixtureImpl.java:226) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.forEachQuery(SqlOperatorUnparseTest.java:88)

8.1sec org.apache.calcite.test.CoreQuidemTest > test(String)[1], [1] sql/misc.iq org.opentest4j.AssertionFailedError: Files differ: /home/runner/work/calcite/calcite/core/build/quidem/test/sql/misc.iq /home/runner/work/calcite/calcite/core/build/resources/test/sql/misc.iq 2149,2153c2149,2153 < +-------------------------+---------------------+---------------------+-----------------------+------------------------+-------------------------+-------------------------+-------------------------+ < | EXPR$0 | EXPR$1 | EXPR$2 | EXPR$3 | EXPR$4 | EXPR$5 | EXPR$6 | EXPR$7 | < +-------------------------+---------------------+---------------------+-----------------------+------------------------+-------------------------+-------------------------+-------------------------+ < | 2016-02-26 19:06:00.123 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00.1 | 2016-02-26 19:06:00.12 | 2016-02-26 19:06:00.123 | 2016-02-26 19:06:00.123 | 2016-02-26 19:06:00.123 | < +-------------------------+---------------------+---------------------+-----------------------+------------------------+-------------------------+-------------------------+-------------------------+ --- > +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ > | EXPR$0 | EXPR$1 | EXPR$2 | EXPR$3 | EXPR$4 | EXPR$5 | EXPR$6 | EXPR$7 | > +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ > | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | > +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ 2167,2171c2167,2171 < +-------------------------+---------------------+--------+ < | EXPR$0 | EXPR$1 | EXPR$2 | < +-------------------------+---------------------+--------+ < | 2016-02-26 19:06:00.123 | 2016-02-26 19:06:00 | 0 | < +-------------------------+---------------------+--------+ --- > +---------------------+---------------------+--------+ > | EXPR$0 | EXPR$1 | EXPR$2 | > +---------------------+---------------------+--------+ > | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 0 | > +---------------------+---------------------+--------+ at app//org.junit.jupiter.api.AssertionUtils.fail(AssertionUtils.java:38) at app//org.junit.jupiter.api.Assertions.fail(Assertions.java:135) at app//org.apache.calcite.test.QuidemTest.checkRun(QuidemTest.java:186) at app//org.apache.calcite.test.CoreQuidemTest.testSqlMisc(CoreQuidemTest.java:103)

0.1sec org.apache.calcite.test.CalciteSqlOperatorTest > testCeilFuncDateTime() java.lang.AssertionError: Query: values (ceil(timestamp '2015-02-19 12:34:56.78' to second)) Expected: is "2015-02-19 12:34:57.00" but: was "2015-02-19 12:34:57" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.apache.calcite.sql.test.ResultCheckers.compareResultSetWithMatcher(ResultCheckers.java:252) at org.apache.calcite.sql.test.ResultCheckers$MatcherResultChecker.checkResult(ResultCheckers.java:321) at org.apache.calcite.test.SqlOperatorTest$TesterImpl.check(SqlOperatorTest.java:14473) at org.apache.calcite.sql.test.SqlTester.check(SqlTester.java:160) at org.apache.calcite.test.SqlOperatorFixtureImpl.lambda$checkScalar$2(SqlOperatorFixtureImpl.java:226) at org.apache.calcite.sql.test.AbstractSqlTester.forEachQuery(AbstractSqlTester.java:450) at org.apache.calcite.test.SqlOperatorFixtureImpl.checkScalar(SqlOperatorFixtureImpl.java:225) at org.apache.calcite.sql.test.SqlOperatorFixture.checkScalar(SqlOperatorFixture.java:221) at org.apache.calcite.test.SqlOperatorTest.testCeilFuncDateTime(SqlOperatorTest.java:11576) at org.junit.platform.commons.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:727) at org.junit.jupiter.engine.execution.MethodInvocation.proceed(MethodInvocation.java:60) at org.junit.jupiter.engine.execution.InvocationInterceptorChain$ValidatingInvocation.proceed(InvocationInterceptorChain.java:131) at org.junit.jupiter.engine.extension.SameThreadTimeoutInvocation.proceed(SameThreadTimeoutInvocation.java:45) at org.junit.jupiter.engine.extension.TimeoutExtension.intercept(TimeoutExtension.java:156) at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestableMethod(TimeoutExtension.java:147) at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestMethod(TimeoutExtension.java:86) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker$ReflectiveInterceptorCall.lambda$ofVoidMethod$0(InterceptingExecutableInvoker.java:103) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.lambda$invoke$0(InterceptingExecutableInvoker.java:93) at org.junit.jupiter.engine.execution.InvocationInterceptorChain$InterceptedInvocation.proceed(InvocationInterceptorChain.java:106) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.proceed(InvocationInterceptorChain.java:64) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.chainAndInvoke(InvocationInterceptorChain.java:45) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.invoke(InvocationInterceptorChain.java:37) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:92) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:86) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.lambda$invokeTestMethod$7(TestMethodTestDescriptor.java:217) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.invokeTestMethod(TestMethodTestDescriptor.java:213) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:138) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:68) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$6(NodeTestTask.java:151) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:141) at org.junit.platform.engine.support.hierarchical.Node.around(Node.java:137) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$9(NodeTestTask.java:139) at org.junit.platform.engine.suppor

0.0sec org.apache.calcite.test.CalciteSqlOperatorTest > testTimestampAdd() java.lang.AssertionError: Query: values (timestampadd(FRAC_SECOND, 2000000, timestamp '2016-02-24 12:42:25')) Expected: is "2016-02-24 12:42:27.000" but: was "2016-02-24 12:42:27" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.apache.calcite.sql.test.ResultCheckers.compareResultSetWithMatcher(ResultCheckers.java:252) at org.apache.calcite.sql.test.ResultCheckers$MatcherResultChecker.checkResult(ResultCheckers.java:321) at org.apache.calcite.test.SqlOperatorTest$TesterImpl.check(SqlOperatorTest.java:14473) at org.apache.calcite.sql.test.SqlTester.check(SqlTester.java:160) at org.apache.calcite.test.SqlOperatorFixtureImpl.lambda$checkScalar$2(SqlOperatorFixtureImpl.java:226) at org.apache.calcite.sql.test.AbstractSqlTester.forEachQuery(AbstractSqlTester.java:450) at org.apache.calcite.test.SqlOperatorFixtureImpl.checkScalar(SqlOperatorFixtureImpl.java:225) at org.apache.calcite.sql.test.SqlOperatorFixture.checkScalar(SqlOperatorFixture.java:221) at org.apache.calcite.test.SqlOperatorTest.lambda$testTimestampAdd$64(SqlOperatorTest.java:11719) at java.base/java.util.Arrays$ArrayList.forEach(Arrays.java:4390) at org.apache.calcite.test.SqlOperatorTest.testTimestampAdd(SqlOperatorTest.java:11718) at org.junit.platform.commons.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:727) at org.junit.jupiter.engine.execution.MethodInvocation.proceed(MethodInvocation.java:60) at org.junit.jupiter.engine.execution.InvocationInterceptorChain$ValidatingInvocation.proceed(InvocationInterceptorChain.java:131) at org.junit.jupiter.engine.extension.SameThreadTimeoutInvocation.proceed(SameThreadTimeoutInvocation.java:45) at org.junit.jupiter.engine.extension.TimeoutExtension.intercept(TimeoutExtension.java:156) at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestableMethod(TimeoutExtension.java:147) at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestMethod(TimeoutExtension.java:86) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker$ReflectiveInterceptorCall.lambda$ofVoidMethod$0(InterceptingExecutableInvoker.java:103) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.lambda$invoke$0(InterceptingExecutableInvoker.java:93) at org.junit.jupiter.engine.execution.InvocationInterceptorChain$InterceptedInvocation.proceed(InvocationInterceptorChain.java:106) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.proceed(InvocationInterceptorChain.java:64) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.chainAndInvoke(InvocationInterceptorChain.java:45) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.invoke(InvocationInterceptorChain.java:37) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:92) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:86) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.lambda$invokeTestMethod$7(TestMethodTestDescriptor.java:217) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.invokeTestMethod(TestMethodTestDescriptor.java:213) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:138) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:68) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$6(NodeTestTask.java:151) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:141) at org.junit.platform.engine.support.hierarchical.No

0.2sec org.apache.calcite.test.CoreQuidemTest > test(String)[19], [19] sql/stream.iq org.opentest4j.AssertionFailedError: Files differ: /home/runner/work/calcite/calcite/core/build/quidem/test/sql/stream.iq /home/runner/work/calcite/calcite/core/build/resources/test/sql/stream.iq 25,33c25,33 < +---------------------+----+---------+-------+-------------------------+-------------------------+ < | ROWTIME | ID | PRODUCT | UNITS | window_start | window_end | < +---------------------+----+---------+-------+-------------------------+-------------------------+ < | 2015-02-15 10:15:00 | 1 | paint | 10 | 2015-02-15 10:15:00.000 | 2015-02-15 10:16:00.000 | < | 2015-02-15 10:24:15 | 2 | paper | 5 | 2015-02-15 10:24:00.000 | 2015-02-15 10:25:00.000 | < | 2015-02-15 10:24:45 | 3 | brush | 12 | 2015-02-15 10:24:00.000 | 2015-02-15 10:25:00.000 | < | 2015-02-15 10:58:00 | 4 | paint | 3 | 2015-02-15 10:58:00.000 | 2015-02-15 10:59:00.000 | < | 2015-02-15 11:10:00 | 5 | paint | 3 | 2015-02-15 11:10:00.000 | 2015-02-15 11:11:00.000 | < +---------------------+----+---------+-------+-------------------------+-------------------------+ --- > +---------------------+----+---------+-------+---------------------+---------------------+ > | ROWTIME | ID | PRODUCT | UNITS | window_start | window_end | > +---------------------+----+---------+-------+---------------------+---------------------+ > | 2015-02-15 10:15:00 | 1 | paint | 10 | 2015-02-15 10:15:00 | 2015-02-15 10:16:00 | > | 2015-02-15 10:24:15 | 2 | paper | 5 | 2015-02-15 10:24:00 | 2015-02-15 10:25:00 | > | 2015-02-15 10:24:45 | 3 | brush | 12 | 2015-02-15 10:24:00 | 2015-02-15 10:25:00 | > | 2015-02-15 10:58:00 | 4 | paint | 3 | 2015-02-15 10:58:00 | 2015-02-15 10:59:00 | > | 2015-02-15 11:10:00 | 5 | paint | 3 | 2015-02-15 11:10:00 | 2015-02-15 11:11:00 | > +---------------------+----+---------+-------+---------------------+---------------------+ 39,47c39,47 < +---------------------+----+---------+-------+-------------------------+-------------------------+ < | ROWTIME | ID | PRODUCT | UNITS | window_start | window_end | < +---------------------+----+---------+-------+-------------------------+-------------------------+ < | 2015-02-15 10:15:00 | 1 | paint | 10 | 2015-02-15 10:15:00.000 | 2015-02-15 10:16:00.000 | < | 2015-02-15 10:24:15 | 2 | paper | 5 | 2015-02-15 10:24:00.000 | 2015-02-15 10:25:00.000 | < | 2015-02-15 10:24:45 | 3 | brush | 12 | 2015-02-15 10:24:00.000 | 2015-02-15 10:25:00.000 | < | 2015-02-15 10:58:00 | 4 | paint | 3 | 2015-02-15 10:58:00.000 | 2015-02-15 10:59:00.000 | < | 2015-02-15 11:10:00 | 5 | paint | 3 | 2015-02-15 11:10:00.000 | 2015-02-15 11:11:00.000 | < +---------------------+----+---------+-------+-------------------------+-------------------------+ --- > +---------------------+----+---------+-------+---------------------+---------------------+ > | ROWTIME | ID | PRODUCT | UNITS | window_start | window_end | > +---------------------+----+---------+-------+---------------------+---------------------+ > | 2015-02-15 10:15:00 | 1 | paint | 10 | 2015-02-15 10:15:00 | 2015-02-15 10:16:00 | > | 2015-02-15 10:24:15 | 2 | paper | 5 | 2015-02-15 10:24:00 | 2015-02-15 10:25:00 | > | 2015-02-15 10:24:45 | 3 | brush | 12 | 2015-02-15 10:24:00 | 2015-02-15 10:25:00 | > | 2015-02-15 10:58:00 | 4 | paint | 3 | 2015-02-15 10:58:00 | 2015-02-15 10:59:00 | > | 2015-02-15 11:10:00 | 5 | paint | 3 | 2015-02-15 11:10:00 | 2015-02-15 11:11:00 | > +---------------------+----+---------+-------+---------------------+---------------------+ 53,61c53,61 < +---------------------+----+---------+-------+-------------------------+-------------------------+ < | ROWTIME | ID | PRODUCT | UNITS | window_start | window_end | < +---------------------+----+---------+-------+-------------------------+-

0.7sec org.apache.calcite.test.CoreQuidemTest > test(String)[27], [27] sql/operator.iq org.opentest4j.AssertionFailedError: Files differ: /home/runner/work/calcite/calcite/core/build/quidem/test/sql/operator.iq /home/runner/work/calcite/calcite/core/build/resources/test/sql/operator.iq 238,243c238,243 < +------------+-------+------------+------------+------------+------------+------------+------------+------------+------------+ < | V | OP | Y | Q | M | W | D | H | MI | S | < +------------+-------+------------+------------+------------+------------+------------+------------+------------+------------+ < | 12:34:56.7 | ceil | 12:34:57.0 | 12:34:56.7 | 12:34:56.7 | 12:34:56.7 | 12:34:56.7 | 13:00:00.0 | 12:35:00.0 | 12:34:57.0 | < | 12:34:56.7 | floor | 12:34:56.6 | 12:34:56.6 | 12:34:56.6 | 12:34:56.6 | 12:34:56.7 | 12:00:00.0 | 12:34:00.0 | 12:34:56.0 | < +------------+-------+------------+------------+------------+------------+------------+------------+------------+------------+ --- > +----------+-------+----------+----------+----------+----------+----------+----------+----------+----------+ > | V | OP | Y | Q | M | W | D | H | MI | S | > +----------+-------+----------+----------+----------+----------+----------+----------+----------+----------+ > | 12:34:56 | ceil | 12:34:57 | 12:34:56 | 12:34:56 | 12:34:56 | 12:34:56 | 13:00:00 | 12:35:00 | 12:34:57 | > | 12:34:56 | floor | 12:34:56 | 12:34:56 | 12:34:56 | 12:34:56 | 12:34:56 | 12:00:00 | 12:34:00 | 12:34:56 | > +----------+-------+----------+----------+----------+----------+----------+----------+----------+----------+ at app//org.junit.jupiter.api.AssertionUtils.fail(AssertionUtils.java:38) at app//org.junit.jupiter.api.Assertions.fail(Assertions.java:135) at app//org.apache.calcite.test.QuidemTest.checkRun(QuidemTest.java:186) at app//org.apache.calcite.test.QuidemTest.test(QuidemTest.java:239) at app//org.junit.platform.commons.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:727) at app//org.junit.jupiter.engine.execution.MethodInvocation.proceed(MethodInvocation.java:60) at app//org.junit.jupiter.engine.execution.InvocationInterceptorChain$ValidatingInvocation.proceed(InvocationInterceptorChain.java:131) at app//org.junit.jupiter.engine.extension.SameThreadTimeoutInvocation.proceed(SameThreadTimeoutInvocation.java:45) at app//org.junit.jupiter.engine.extension.TimeoutExtension.intercept(TimeoutExtension.java:156) at app//org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestableMethod(TimeoutExtension.java:147) at app//org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestTemplateMethod(TimeoutExtension.java:94) at app//org.junit.jupiter.engine.execution.InterceptingExecutableInvoker$ReflectiveInterceptorCall.lambda$ofVoidMethod$0(InterceptingExecutableInvoker.java:103) at app//org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.lambda$invoke$0(InterceptingExecutableInvoker.java:93) at app//org.junit.jupiter.engine.execution.InvocationInterceptorChain$InterceptedInvocation.proceed(InvocationInterceptorChain.java:106) at app//org.junit.jupiter.engine.execution.InvocationInterceptorChain.proceed(InvocationInterceptorChain.java:64) at app//org.junit.jupiter.engine.execution.InvocationInterceptorChain.chainAndInvoke(InvocationInterceptorChain.java:45) at app//org.junit.jupiter.engine.execution.InvocationInterceptorChain.invoke(InvocationInterceptorChain.java:37) at app//org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:92) at app//org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:86) at app//org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.lambda$invokeTestMethod$7(TestMethodTestDescriptor.java:217) at app//org.junit.platform.engine.support.hierarchical.ThrowableCollector.

0.1sec org.apache.calcite.test.SqlOperatorUnparseTest > testCeilFuncDateTime() java.lang.AssertionError: Query: SELECT CEIL("P0" TO SECOND) FROM (VALUES ROW(TIMESTAMP '2015-02-19 12:34:56.78')) AS "T" ("P0") Expected: is "2015-02-19 12:34:57.00" but: was "2015-02-19 12:34:57" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.apache.calcite.sql.test.ResultCheckers.compareResultSetWithMatcher(ResultCheckers.java:252) at org.apache.calcite.sql.test.ResultCheckers$MatcherResultChecker.checkResult(ResultCheckers.java:321) at org.apache.calcite.test.SqlOperatorTest$TesterImpl.check(SqlOperatorTest.java:14473) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.check(SqlOperatorUnparseTest.java:95) at org.apache.calcite.sql.test.SqlTester.check(SqlTester.java:160) at org.apache.calcite.test.SqlOperatorFixtureImpl.lambda$checkScalar$2(SqlOperatorFixtureImpl.java:226) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.forEachQuery(SqlOperatorUnparseTest.java:88)

0.1sec org.apache.calcite.test.CalciteSqlOperatorTest > testFloorFuncDateTime() java.lang.AssertionError: Query: values (floor(timestamp '2015-02-19 12:34:56.78' to second)) Expected: is "2015-02-19 12:34:56.00" but: was "2015-02-19 12:34:56" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.apache.calcite.sql.test.ResultCheckers.compareResultSetWithMatcher(ResultCheckers.java:252) at org.apache.calcite.sql.test.ResultCheckers$MatcherResultChecker.checkResult(ResultCheckers.java:321) at org.apache.calcite.test.SqlOperatorTest$TesterImpl.check(SqlOperatorTest.java:14473) at org.apache.calcite.sql.test.SqlTester.check(SqlTester.java:160) at org.apache.calcite.test.SqlOperatorFixtureImpl.lambda$checkScalar$2(SqlOperatorFixtureImpl.java:226) at org.apache.calcite.sql.test.AbstractSqlTester.forEachQuery(AbstractSqlTester.java:450) at org.apache.calcite.test.SqlOperatorFixtureImpl.checkScalar(SqlOperatorFixtureImpl.java:225) at org.apache.calcite.sql.test.SqlOperatorFixture.checkScalar(SqlOperatorFixture.java:221) at org.apache.calcite.test.SqlOperatorTest.testFloorFuncDateTime(SqlOperatorTest.java:11531) at org.junit.platform.commons.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:727) at org.junit.jupiter.engine.execution.MethodInvocation.proceed(MethodInvocation.java:60) at org.junit.jupiter.engine.execution.InvocationInterceptorChain$ValidatingInvocation.proceed(InvocationInterceptorChain.java:131) at org.junit.jupiter.engine.extension.SameThreadTimeoutInvocation.proceed(SameThreadTimeoutInvocation.java:45) at org.junit.jupiter.engine.extension.TimeoutExtension.intercept(TimeoutExtension.java:156) at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestableMethod(TimeoutExtension.java:147) at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestMethod(TimeoutExtension.java:86) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker$ReflectiveInterceptorCall.lambda$ofVoidMethod$0(InterceptingExecutableInvoker.java:103) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.lambda$invoke$0(InterceptingExecutableInvoker.java:93) at org.junit.jupiter.engine.execution.InvocationInterceptorChain$InterceptedInvocation.proceed(InvocationInterceptorChain.java:106) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.proceed(InvocationInterceptorChain.java:64) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.chainAndInvoke(InvocationInterceptorChain.java:45) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.invoke(InvocationInterceptorChain.java:37) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:92) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:86) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.lambda$invokeTestMethod$7(TestMethodTestDescriptor.java:217) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.invokeTestMethod(TestMethodTestDescriptor.java:213) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:138) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:68) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$6(NodeTestTask.java:151) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:141) at org.junit.platform.engine.support.hierarchical.Node.around(Node.java:137) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$9(NodeTestTask.java:139) at org.junit.platform.engine.sup

0.0sec org.apache.calcite.test.SqlOperatorUnparseTest > testTimestampAdd() java.lang.AssertionError: Query: SELECT TIMESTAMPADD("FRAC_SECOND", "P1", "P0") FROM (VALUES ROW(TIMESTAMP '2016-02-24 12:42:25', 2000000)) AS "T" ("P0", "P1") Expected: is "2016-02-24 12:42:27.000" but: was "2016-02-24 12:42:27" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.apache.calcite.sql.test.ResultCheckers.compareResultSetWithMatcher(ResultCheckers.java:252) at org.apache.calcite.sql.test.ResultCheckers$MatcherResultChecker.checkResult(ResultCheckers.java:321) at org.apache.calcite.test.SqlOperatorTest$TesterImpl.check(SqlOperatorTest.java:14473) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.check(SqlOperatorUnparseTest.java:95) at org.apache.calcite.sql.test.SqlTester.check(SqlTester.java:160) at org.apache.calcite.test.SqlOperatorFixtureImpl.lambda$checkScalar$2(SqlOperatorFixtureImpl.java:226) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.forEachQuery(SqlOperatorUnparseTest.java:88)

0.0sec org.apache.calcite.test.SqlOperatorUnparseTest > testFloorFuncDateTime() java.lang.AssertionError: Query: SELECT FLOOR("P0" TO SECOND) FROM (VALUES ROW(TIMESTAMP '2015-02-19 12:34:56.78')) AS "T" ("P0") Expected: is "2015-02-19 12:34:56.00" but: was "2015-02-19 12:34:56" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.apache.calcite.sql.test.ResultCheckers.compareResultSetWithMatcher(ResultCheckers.java:252) at org.apache.calcite.sql.test.ResultCheckers$MatcherResultChecker.checkResult(ResultCheckers.java:321) at org.apache.calcite.test.SqlOperatorTest$TesterImpl.check(SqlOperatorTest.java:14473) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.check(SqlOperatorUnparseTest.java:95) at org.apache.calcite.sql.test.SqlTester.check(SqlTester.java:160) at org.apache.calcite.test.SqlOperatorFixtureImpl.lambda$checkScalar$2(SqlOperatorFixtureImpl.java:226) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.forEachQuery(SqlOperatorUnparseTest.java:88)

0.0sec org.apache.calcite.test.SqlOperatorUnparseTest > testCastDateTime(CastType, SqlOperatorFixture)[1], [1] CAST, org.apache.calcite.test.SqlOperatorUnparseTest$SqlOperatorFixtureUnparseImpl@2e96cf67 java.lang.AssertionError: Query: SELECT CAST("P0" AS TIME(2)) FROM (VALUES ROW(TIME '12:42:25.34')) AS "T" ("P0") Expected: is "12:42:25.34" but: was "12:42:25" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.apache.calcite.sql.test.ResultCheckers.compareResultSetWithMatcher(ResultCheckers.java:252) at org.apache.calcite.sql.test.ResultCheckers$MatcherResultChecker.checkResult(ResultCheckers.java:321) at org.apache.calcite.test.SqlOperatorTest$TesterImpl.check(SqlOperatorTest.java:14473) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.check(SqlOperatorUnparseTest.java:95) at org.apache.calcite.sql.test.SqlTester.check(SqlTester.java:160) at org.apache.calcite.test.SqlOperatorFixtureImpl.lambda$checkScalar$2(SqlOperatorFixtureImpl.java:226) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.forEachQuery(SqlOperatorUnparseTest.java:88)

7.1sec org.apache.calcite.test.CoreQuidemTest > test(String)[1], [1] sql/misc.iq org.opentest4j.AssertionFailedError: Files differ: /home/runner/work/calcite/calcite/core/build/quidem/test/sql/misc.iq /home/runner/work/calcite/calcite/core/build/resources/test/sql/misc.iq 2149,2153c2149,2153 < +-------------------------+---------------------+---------------------+-----------------------+------------------------+-------------------------+-------------------------+-------------------------+ < | EXPR$0 | EXPR$1 | EXPR$2 | EXPR$3 | EXPR$4 | EXPR$5 | EXPR$6 | EXPR$7 | < +-------------------------+---------------------+---------------------+-----------------------+------------------------+-------------------------+-------------------------+-------------------------+ < | 2016-02-26 19:06:00.123 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00.1 | 2016-02-26 19:06:00.12 | 2016-02-26 19:06:00.123 | 2016-02-26 19:06:00.123 | 2016-02-26 19:06:00.123 | < +-------------------------+---------------------+---------------------+-----------------------+------------------------+-------------------------+-------------------------+-------------------------+ --- > +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ > | EXPR$0 | EXPR$1 | EXPR$2 | EXPR$3 | EXPR$4 | EXPR$5 | EXPR$6 | EXPR$7 | > +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ > | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | > +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ 2167,2171c2167,2171 < +-------------------------+---------------------+--------+ < | EXPR$0 | EXPR$1 | EXPR$2 | < +-------------------------+---------------------+--------+ < | 2016-02-26 19:06:00.123 | 2016-02-26 19:06:00 | 0 | < +-------------------------+---------------------+--------+ --- > +---------------------+---------------------+--------+ > | EXPR$0 | EXPR$1 | EXPR$2 | > +---------------------+---------------------+--------+ > | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 0 | > +---------------------+---------------------+--------+ at org.junit.jupiter.api.AssertionUtils.fail(AssertionUtils.java:38) at org.junit.jupiter.api.Assertions.fail(Assertions.java:135) at org.apache.calcite.test.QuidemTest.checkRun(QuidemTest.java:186) at org.apache.calcite.test.CoreQuidemTest.testSqlMisc(CoreQuidemTest.java:103)

0.1sec org.apache.calcite.test.CalciteSqlOperatorTest > testCeilFuncDateTime() java.lang.AssertionError: Query: values (ceil(timestamp '2015-02-19 12:34:56.78' to second)) Expected: is "2015-02-19 12:34:57.00" but: was "2015-02-19 12:34:57" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.apache.calcite.sql.test.ResultCheckers.compareResultSetWithMatcher(ResultCheckers.java:252) at org.apache.calcite.sql.test.ResultCheckers$MatcherResultChecker.checkResult(ResultCheckers.java:321) at org.apache.calcite.test.SqlOperatorTest$TesterImpl.check(SqlOperatorTest.java:14473) at org.apache.calcite.sql.test.SqlTester.check(SqlTester.java:160) at org.apache.calcite.test.SqlOperatorFixtureImpl.lambda$checkScalar$2(SqlOperatorFixtureImpl.java:226) at org.apache.calcite.sql.test.AbstractSqlTester.forEachQuery(AbstractSqlTester.java:450) at org.apache.calcite.test.SqlOperatorFixtureImpl.checkScalar(SqlOperatorFixtureImpl.java:225) at org.apache.calcite.sql.test.SqlOperatorFixture.checkScalar(SqlOperatorFixture.java:221) at org.apache.calcite.test.SqlOperatorTest.testCeilFuncDateTime(SqlOperatorTest.java:11576) at org.junit.platform.commons.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:727) at org.junit.jupiter.engine.execution.MethodInvocation.proceed(MethodInvocation.java:60) at org.junit.jupiter.engine.execution.InvocationInterceptorChain$ValidatingInvocation.proceed(InvocationInterceptorChain.java:131) at org.junit.jupiter.engine.extension.SameThreadTimeoutInvocation.proceed(SameThreadTimeoutInvocation.java:45) at org.junit.jupiter.engine.extension.TimeoutExtension.intercept(TimeoutExtension.java:156) at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestableMethod(TimeoutExtension.java:147) at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestMethod(TimeoutExtension.java:86) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker$ReflectiveInterceptorCall.lambda$ofVoidMethod$0(InterceptingExecutableInvoker.java:103) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.lambda$invoke$0(InterceptingExecutableInvoker.java:93) at org.junit.jupiter.engine.execution.InvocationInterceptorChain$InterceptedInvocation.proceed(InvocationInterceptorChain.java:106) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.proceed(InvocationInterceptorChain.java:64) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.chainAndInvoke(InvocationInterceptorChain.java:45) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.invoke(InvocationInterceptorChain.java:37) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:92) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:86) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.lambda$invokeTestMethod$7(TestMethodTestDescriptor.java:217) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.invokeTestMethod(TestMethodTestDescriptor.java:213) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:138) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:68) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$6(NodeTestTask.java:151) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:141) at org.junit.platform.engine.support.hierarchical.Node.around(Node.java:137) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$9(NodeTestTask.java:139) at org.junit.platform.engine.suppor

0.0sec org.apache.calcite.test.CalciteSqlOperatorTest > testTimestampAdd() java.lang.AssertionError: Query: values (timestampadd(FRAC_SECOND, 2000000, timestamp '2016-02-24 12:42:25')) Expected: is "2016-02-24 12:42:27.000" but: was "2016-02-24 12:42:27" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.apache.calcite.sql.test.ResultCheckers.compareResultSetWithMatcher(ResultCheckers.java:252) at org.apache.calcite.sql.test.ResultCheckers$MatcherResultChecker.checkResult(ResultCheckers.java:321) at org.apache.calcite.test.SqlOperatorTest$TesterImpl.check(SqlOperatorTest.java:14473) at org.apache.calcite.sql.test.SqlTester.check(SqlTester.java:160) at org.apache.calcite.test.SqlOperatorFixtureImpl.lambda$checkScalar$2(SqlOperatorFixtureImpl.java:226) at org.apache.calcite.sql.test.AbstractSqlTester.forEachQuery(AbstractSqlTester.java:450) at org.apache.calcite.test.SqlOperatorFixtureImpl.checkScalar(SqlOperatorFixtureImpl.java:225) at org.apache.calcite.sql.test.SqlOperatorFixture.checkScalar(SqlOperatorFixture.java:221) at org.apache.calcite.test.SqlOperatorTest.lambda$testTimestampAdd$64(SqlOperatorTest.java:11719) at java.util.Arrays$ArrayList.forEach(Arrays.java:3880) at org.apache.calcite.test.SqlOperatorTest.testTimestampAdd(SqlOperatorTest.java:11718) at org.junit.platform.commons.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:727) at org.junit.jupiter.engine.execution.MethodInvocation.proceed(MethodInvocation.java:60) at org.junit.jupiter.engine.execution.InvocationInterceptorChain$ValidatingInvocation.proceed(InvocationInterceptorChain.java:131) at org.junit.jupiter.engine.extension.SameThreadTimeoutInvocation.proceed(SameThreadTimeoutInvocation.java:45) at org.junit.jupiter.engine.extension.TimeoutExtension.intercept(TimeoutExtension.java:156) at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestableMethod(TimeoutExtension.java:147) at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestMethod(TimeoutExtension.java:86) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker$ReflectiveInterceptorCall.lambda$ofVoidMethod$0(InterceptingExecutableInvoker.java:103) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.lambda$invoke$0(InterceptingExecutableInvoker.java:93) at org.junit.jupiter.engine.execution.InvocationInterceptorChain$InterceptedInvocation.proceed(InvocationInterceptorChain.java:106) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.proceed(InvocationInterceptorChain.java:64) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.chainAndInvoke(InvocationInterceptorChain.java:45) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.invoke(InvocationInterceptorChain.java:37) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:92) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:86) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.lambda$invokeTestMethod$7(TestMethodTestDescriptor.java:217) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.invokeTestMethod(TestMethodTestDescriptor.java:213) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:138) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:68) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$6(NodeTestTask.java:151) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:141) at org.junit.platform.engine.support.hierarchical.Node.around(

0.2sec org.apache.calcite.test.CoreQuidemTest > test(String)[19], [19] sql/stream.iq org.opentest4j.AssertionFailedError: Files differ: /home/runner/work/calcite/calcite/core/build/quidem/test/sql/stream.iq /home/runner/work/calcite/calcite/core/build/resources/test/sql/stream.iq 25,33c25,33 < +---------------------+----+---------+-------+-------------------------+-------------------------+ < | ROWTIME | ID | PRODUCT | UNITS | window_start | window_end | < +---------------------+----+---------+-------+-------------------------+-------------------------+ < | 2015-02-15 10:15:00 | 1 | paint | 10 | 2015-02-15 10:15:00.000 | 2015-02-15 10:16:00.000 | < | 2015-02-15 10:24:15 | 2 | paper | 5 | 2015-02-15 10:24:00.000 | 2015-02-15 10:25:00.000 | < | 2015-02-15 10:24:45 | 3 | brush | 12 | 2015-02-15 10:24:00.000 | 2015-02-15 10:25:00.000 | < | 2015-02-15 10:58:00 | 4 | paint | 3 | 2015-02-15 10:58:00.000 | 2015-02-15 10:59:00.000 | < | 2015-02-15 11:10:00 | 5 | paint | 3 | 2015-02-15 11:10:00.000 | 2015-02-15 11:11:00.000 | < +---------------------+----+---------+-------+-------------------------+-------------------------+ --- > +---------------------+----+---------+-------+---------------------+---------------------+ > | ROWTIME | ID | PRODUCT | UNITS | window_start | window_end | > +---------------------+----+---------+-------+---------------------+---------------------+ > | 2015-02-15 10:15:00 | 1 | paint | 10 | 2015-02-15 10:15:00 | 2015-02-15 10:16:00 | > | 2015-02-15 10:24:15 | 2 | paper | 5 | 2015-02-15 10:24:00 | 2015-02-15 10:25:00 | > | 2015-02-15 10:24:45 | 3 | brush | 12 | 2015-02-15 10:24:00 | 2015-02-15 10:25:00 | > | 2015-02-15 10:58:00 | 4 | paint | 3 | 2015-02-15 10:58:00 | 2015-02-15 10:59:00 | > | 2015-02-15 11:10:00 | 5 | paint | 3 | 2015-02-15 11:10:00 | 2015-02-15 11:11:00 | > +---------------------+----+---------+-------+---------------------+---------------------+ 39,47c39,47 < +---------------------+----+---------+-------+-------------------------+-------------------------+ < | ROWTIME | ID | PRODUCT | UNITS | window_start | window_end | < +---------------------+----+---------+-------+-------------------------+-------------------------+ < | 2015-02-15 10:15:00 | 1 | paint | 10 | 2015-02-15 10:15:00.000 | 2015-02-15 10:16:00.000 | < | 2015-02-15 10:24:15 | 2 | paper | 5 | 2015-02-15 10:24:00.000 | 2015-02-15 10:25:00.000 | < | 2015-02-15 10:24:45 | 3 | brush | 12 | 2015-02-15 10:24:00.000 | 2015-02-15 10:25:00.000 | < | 2015-02-15 10:58:00 | 4 | paint | 3 | 2015-02-15 10:58:00.000 | 2015-02-15 10:59:00.000 | < | 2015-02-15 11:10:00 | 5 | paint | 3 | 2015-02-15 11:10:00.000 | 2015-02-15 11:11:00.000 | < +---------------------+----+---------+-------+-------------------------+-------------------------+ --- > +---------------------+----+---------+-------+---------------------+---------------------+ > | ROWTIME | ID | PRODUCT | UNITS | window_start | window_end | > +---------------------+----+---------+-------+---------------------+---------------------+ > | 2015-02-15 10:15:00 | 1 | paint | 10 | 2015-02-15 10:15:00 | 2015-02-15 10:16:00 | > | 2015-02-15 10:24:15 | 2 | paper | 5 | 2015-02-15 10:24:00 | 2015-02-15 10:25:00 | > | 2015-02-15 10:24:45 | 3 | brush | 12 | 2015-02-15 10:24:00 | 2015-02-15 10:25:00 | > | 2015-02-15 10:58:00 | 4 | paint | 3 | 2015-02-15 10:58:00 | 2015-02-15 10:59:00 | > | 2015-02-15 11:10:00 | 5 | paint | 3 | 2015-02-15 11:10:00 | 2015-02-15 11:11:00 | > +---------------------+----+---------+-------+---------------------+---------------------+ 53,61c53,61 < +---------------------+----+---------+-------+-------------------------+-------------------------+ < | ROWTIME | ID | PRODUCT | UNITS | window_start | window_end | < +---------------------+----+---------+-------+-------------------------+-

0.1sec org.apache.calcite.test.SqlOperatorUnparseTest > testCeilFuncDateTime() java.lang.AssertionError: Query: SELECT CEIL("P0" TO SECOND) FROM (VALUES ROW(TIMESTAMP '2015-02-19 12:34:56.78')) AS "T" ("P0") Expected: is "2015-02-19 12:34:57.00" but: was "2015-02-19 12:34:57" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.apache.calcite.sql.test.ResultCheckers.compareResultSetWithMatcher(ResultCheckers.java:252) at org.apache.calcite.sql.test.ResultCheckers$MatcherResultChecker.checkResult(ResultCheckers.java:321) at org.apache.calcite.test.SqlOperatorTest$TesterImpl.check(SqlOperatorTest.java:14473) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.check(SqlOperatorUnparseTest.java:95) at org.apache.calcite.sql.test.SqlTester.check(SqlTester.java:160) at org.apache.calcite.test.SqlOperatorFixtureImpl.lambda$checkScalar$2(SqlOperatorFixtureImpl.java:226) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.forEachQuery(SqlOperatorUnparseTest.java:88)

0.9sec org.apache.calcite.test.CoreQuidemTest > test(String)[27], [27] sql/operator.iq org.opentest4j.AssertionFailedError: Files differ: /home/runner/work/calcite/calcite/core/build/quidem/test/sql/operator.iq /home/runner/work/calcite/calcite/core/build/resources/test/sql/operator.iq 238,243c238,243 < +------------+-------+------------+------------+------------+------------+------------+------------+------------+------------+ < | V | OP | Y | Q | M | W | D | H | MI | S | < +------------+-------+------------+------------+------------+------------+------------+------------+------------+------------+ < | 12:34:56.7 | ceil | 12:34:57.0 | 12:34:56.7 | 12:34:56.7 | 12:34:56.7 | 12:34:56.7 | 13:00:00.0 | 12:35:00.0 | 12:34:57.0 | < | 12:34:56.7 | floor | 12:34:56.6 | 12:34:56.6 | 12:34:56.6 | 12:34:56.6 | 12:34:56.7 | 12:00:00.0 | 12:34:00.0 | 12:34:56.0 | < +------------+-------+------------+------------+------------+------------+------------+------------+------------+------------+ --- > +----------+-------+----------+----------+----------+----------+----------+----------+----------+----------+ > | V | OP | Y | Q | M | W | D | H | MI | S | > +----------+-------+----------+----------+----------+----------+----------+----------+----------+----------+ > | 12:34:56 | ceil | 12:34:57 | 12:34:56 | 12:34:56 | 12:34:56 | 12:34:56 | 13:00:00 | 12:35:00 | 12:34:57 | > | 12:34:56 | floor | 12:34:56 | 12:34:56 | 12:34:56 | 12:34:56 | 12:34:56 | 12:00:00 | 12:34:00 | 12:34:56 | > +----------+-------+----------+----------+----------+----------+----------+----------+----------+----------+ at org.junit.jupiter.api.AssertionUtils.fail(AssertionUtils.java:38) at org.junit.jupiter.api.Assertions.fail(Assertions.java:135) at org.apache.calcite.test.QuidemTest.checkRun(QuidemTest.java:186) at org.apache.calcite.test.QuidemTest.test(QuidemTest.java:239) at org.junit.platform.commons.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:727) at org.junit.jupiter.engine.execution.MethodInvocation.proceed(MethodInvocation.java:60) at org.junit.jupiter.engine.execution.InvocationInterceptorChain$ValidatingInvocation.proceed(InvocationInterceptorChain.java:131) at org.junit.jupiter.engine.extension.SameThreadTimeoutInvocation.proceed(SameThreadTimeoutInvocation.java:45) at org.junit.jupiter.engine.extension.TimeoutExtension.intercept(TimeoutExtension.java:156) at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestableMethod(TimeoutExtension.java:147) at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestTemplateMethod(TimeoutExtension.java:94) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker$ReflectiveInterceptorCall.lambda$ofVoidMethod$0(InterceptingExecutableInvoker.java:103) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.lambda$invoke$0(InterceptingExecutableInvoker.java:93) at org.junit.jupiter.engine.execution.InvocationInterceptorChain$InterceptedInvocation.proceed(InvocationInterceptorChain.java:106) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.proceed(InvocationInterceptorChain.java:64) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.chainAndInvoke(InvocationInterceptorChain.java:45) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.invoke(InvocationInterceptorChain.java:37) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:92) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:86) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.lambda$invokeTestMethod$7(TestMethodTestDescriptor.java:217) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.i

0.0sec org.apache.calcite.test.SqlOperatorUnparseTest > testTimestampAdd() java.lang.AssertionError: Query: SELECT TIMESTAMPADD("FRAC_SECOND", "P1", "P0") FROM (VALUES ROW(TIMESTAMP '2016-02-24 12:42:25', 2000000)) AS "T" ("P0", "P1") Expected: is "2016-02-24 12:42:27.000" but: was "2016-02-24 12:42:27" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.apache.calcite.sql.test.ResultCheckers.compareResultSetWithMatcher(ResultCheckers.java:252) at org.apache.calcite.sql.test.ResultCheckers$MatcherResultChecker.checkResult(ResultCheckers.java:321) at org.apache.calcite.test.SqlOperatorTest$TesterImpl.check(SqlOperatorTest.java:14473) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.check(SqlOperatorUnparseTest.java:95) at org.apache.calcite.sql.test.SqlTester.check(SqlTester.java:160) at org.apache.calcite.test.SqlOperatorFixtureImpl.lambda$checkScalar$2(SqlOperatorFixtureImpl.java:226) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.forEachQuery(SqlOperatorUnparseTest.java:88)

0.0sec org.apache.calcite.test.CalciteSqlOperatorTest > testFloorFuncDateTime() java.lang.AssertionError: Query: values (floor(timestamp '2015-02-19 12:34:56.78' to second)) Expected: is "2015-02-19 12:34:56.00" but: was "2015-02-19 12:34:56" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.apache.calcite.sql.test.ResultCheckers.compareResultSetWithMatcher(ResultCheckers.java:252) at org.apache.calcite.sql.test.ResultCheckers$MatcherResultChecker.checkResult(ResultCheckers.java:321) at org.apache.calcite.test.SqlOperatorTest$TesterImpl.check(SqlOperatorTest.java:14473) at org.apache.calcite.sql.test.SqlTester.check(SqlTester.java:160) at org.apache.calcite.test.SqlOperatorFixtureImpl.lambda$checkScalar$2(SqlOperatorFixtureImpl.java:226) at org.apache.calcite.sql.test.AbstractSqlTester.forEachQuery(AbstractSqlTester.java:450) at org.apache.calcite.test.SqlOperatorFixtureImpl.checkScalar(SqlOperatorFixtureImpl.java:225) at org.apache.calcite.sql.test.SqlOperatorFixture.checkScalar(SqlOperatorFixture.java:221) at org.apache.calcite.test.SqlOperatorTest.testFloorFuncDateTime(SqlOperatorTest.java:11531) at org.junit.platform.commons.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:727) at org.junit.jupiter.engine.execution.MethodInvocation.proceed(MethodInvocation.java:60) at org.junit.jupiter.engine.execution.InvocationInterceptorChain$ValidatingInvocation.proceed(InvocationInterceptorChain.java:131) at org.junit.jupiter.engine.extension.SameThreadTimeoutInvocation.proceed(SameThreadTimeoutInvocation.java:45) at org.junit.jupiter.engine.extension.TimeoutExtension.intercept(TimeoutExtension.java:156) at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestableMethod(TimeoutExtension.java:147) at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestMethod(TimeoutExtension.java:86) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker$ReflectiveInterceptorCall.lambda$ofVoidMethod$0(InterceptingExecutableInvoker.java:103) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.lambda$invoke$0(InterceptingExecutableInvoker.java:93) at org.junit.jupiter.engine.execution.InvocationInterceptorChain$InterceptedInvocation.proceed(InvocationInterceptorChain.java:106) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.proceed(InvocationInterceptorChain.java:64) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.chainAndInvoke(InvocationInterceptorChain.java:45) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.invoke(InvocationInterceptorChain.java:37) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:92) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:86) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.lambda$invokeTestMethod$7(TestMethodTestDescriptor.java:217) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.invokeTestMethod(TestMethodTestDescriptor.java:213) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:138) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:68) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$6(NodeTestTask.java:151) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:141) at org.junit.platform.engine.support.hierarchical.Node.around(Node.java:137) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$9(NodeTestTask.java:139) at org.junit.platform.engine.sup

0.0sec org.apache.calcite.test.SqlOperatorUnparseTest > testFloorFuncDateTime() java.lang.AssertionError: Query: SELECT FLOOR("P0" TO SECOND) FROM (VALUES ROW(TIMESTAMP '2015-02-19 12:34:56.78')) AS "T" ("P0") Expected: is "2015-02-19 12:34:56.00" but: was "2015-02-19 12:34:56" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.apache.calcite.sql.test.ResultCheckers.compareResultSetWithMatcher(ResultCheckers.java:252) at org.apache.calcite.sql.test.ResultCheckers$MatcherResultChecker.checkResult(ResultCheckers.java:321) at org.apache.calcite.test.SqlOperatorTest$TesterImpl.check(SqlOperatorTest.java:14473) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.check(SqlOperatorUnparseTest.java:95) at org.apache.calcite.sql.test.SqlTester.check(SqlTester.java:160) at org.apache.calcite.test.SqlOperatorFixtureImpl.lambda$checkScalar$2(SqlOperatorFixtureImpl.java:226) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.forEachQuery(SqlOperatorUnparseTest.java:88)

0.0sec org.apache.calcite.test.SqlOperatorUnparseTest > testCastDateTime(CastType, SqlOperatorFixture)[1], [1] CAST, org.apache.calcite.test.SqlOperatorUnparseTest$SqlOperatorFixtureUnparseImpl@2d7988a4 java.lang.AssertionError: Query: SELECT CAST("P0" AS TIME(2)) FROM (VALUES ROW(TIME '12:42:25.34')) AS "T" ("P0") Expected: is "12:42:25.34" but: was "12:42:25" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.apache.calcite.sql.test.ResultCheckers.compareResultSetWithMatcher(ResultCheckers.java:252) at org.apache.calcite.sql.test.ResultCheckers$MatcherResultChecker.checkResult(ResultCheckers.java:321) at org.apache.calcite.test.SqlOperatorTest$TesterImpl.check(SqlOperatorTest.java:14473) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.check(SqlOperatorUnparseTest.java:95) at org.apache.calcite.sql.test.SqlTester.check(SqlTester.java:160) at org.apache.calcite.test.SqlOperatorFixtureImpl.lambda$checkScalar$2(SqlOperatorFixtureImpl.java:226) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.forEachQuery(SqlOperatorUnparseTest.java:88)

9.2sec org.apache.calcite.test.CoreQuidemTest > test(String)[12], [12] sql\misc.iq org.opentest4j.AssertionFailedError: Files differ: D:\a\calcite\calcite\core\build\quidem\test\sql\misc.iq D:\a\calcite\calcite\core\build\resources\test\sql\misc.iq 2149,2153c2149,2153 < +-------------------------+---------------------+---------------------+-----------------------+------------------------+-------------------------+-------------------------+-------------------------+ < | EXPR$0 | EXPR$1 | EXPR$2 | EXPR$3 | EXPR$4 | EXPR$5 | EXPR$6 | EXPR$7 | < +-------------------------+---------------------+---------------------+-----------------------+------------------------+-------------------------+-------------------------+-------------------------+ < | 2016-02-26 19:06:00.123 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00.1 | 2016-02-26 19:06:00.12 | 2016-02-26 19:06:00.123 | 2016-02-26 19:06:00.123 | 2016-02-26 19:06:00.123 | < +-------------------------+---------------------+---------------------+-----------------------+------------------------+-------------------------+-------------------------+-------------------------+ --- > +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ > | EXPR$0 | EXPR$1 | EXPR$2 | EXPR$3 | EXPR$4 | EXPR$5 | EXPR$6 | EXPR$7 | > +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ > | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | > +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ 2167,2171c2167,2171 < +-------------------------+---------------------+--------+ < | EXPR$0 | EXPR$1 | EXPR$2 | < +-------------------------+---------------------+--------+ < | 2016-02-26 19:06:00.123 | 2016-02-26 19:06:00 | 0 | < +-------------------------+---------------------+--------+ --- > +---------------------+---------------------+--------+ > | EXPR$0 | EXPR$1 | EXPR$2 | > +---------------------+---------------------+--------+ > | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 0 | > +---------------------+---------------------+--------+ at org.junit.jupiter.api.AssertionUtils.fail(AssertionUtils.java:38) at org.junit.jupiter.api.Assertions.fail(Assertions.java:135) at org.apache.calcite.test.QuidemTest.checkRun(QuidemTest.java:186) at org.apache.calcite.test.CoreQuidemTest.testSqlMisc(CoreQuidemTest.java:103)

0.1sec org.apache.calcite.test.CalciteSqlOperatorTest > testCeilFuncDateTime() java.lang.AssertionError: Query: values (ceil(timestamp '2015-02-19 12:34:56.78' to second)) Expected: is "2015-02-19 12:34:57.00" but: was "2015-02-19 12:34:57" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.apache.calcite.sql.test.ResultCheckers.compareResultSetWithMatcher(ResultCheckers.java:252) at org.apache.calcite.sql.test.ResultCheckers$MatcherResultChecker.checkResult(ResultCheckers.java:321) at org.apache.calcite.test.SqlOperatorTest$TesterImpl.check(SqlOperatorTest.java:14473) at org.apache.calcite.sql.test.SqlTester.check(SqlTester.java:160) at org.apache.calcite.test.SqlOperatorFixtureImpl.lambda$checkScalar$2(SqlOperatorFixtureImpl.java:226) at org.apache.calcite.sql.test.AbstractSqlTester.forEachQuery(AbstractSqlTester.java:450) at org.apache.calcite.test.SqlOperatorFixtureImpl.checkScalar(SqlOperatorFixtureImpl.java:225) at org.apache.calcite.sql.test.SqlOperatorFixture.checkScalar(SqlOperatorFixture.java:221) at org.apache.calcite.test.SqlOperatorTest.testCeilFuncDateTime(SqlOperatorTest.java:11576) at org.junit.platform.commons.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:727) at org.junit.jupiter.engine.execution.MethodInvocation.proceed(MethodInvocation.java:60) at org.junit.jupiter.engine.execution.InvocationInterceptorChain$ValidatingInvocation.proceed(InvocationInterceptorChain.java:131) at org.junit.jupiter.engine.extension.SameThreadTimeoutInvocation.proceed(SameThreadTimeoutInvocation.java:45) at org.junit.jupiter.engine.extension.TimeoutExtension.intercept(TimeoutExtension.java:156) at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestableMethod(TimeoutExtension.java:147) at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestMethod(TimeoutExtension.java:86) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker$ReflectiveInterceptorCall.lambda$ofVoidMethod$0(InterceptingExecutableInvoker.java:103) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.lambda$invoke$0(InterceptingExecutableInvoker.java:93) at org.junit.jupiter.engine.execution.InvocationInterceptorChain$InterceptedInvocation.proceed(InvocationInterceptorChain.java:106) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.proceed(InvocationInterceptorChain.java:64) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.chainAndInvoke(InvocationInterceptorChain.java:45) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.invoke(InvocationInterceptorChain.java:37) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:92) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:86) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.lambda$invokeTestMethod$7(TestMethodTestDescriptor.java:217) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.invokeTestMethod(TestMethodTestDescriptor.java:213) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:138) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:68) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$6(NodeTestTask.java:151) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:141) at org.junit.platform.engine.support.hierarchical.Node.around(Node.java:137) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$9(NodeTestTask.java:139)

1.4sec org.apache.calcite.test.CoreQuidemTest > test(String)[13], [13] sql\operator.iq org.opentest4j.AssertionFailedError: Files differ: D:\a\calcite\calcite\core\build\quidem\test\sql\operator.iq D:\a\calcite\calcite\core\build\resources\test\sql\operator.iq 238,243c238,243 < +------------+-------+------------+------------+------------+------------+------------+------------+------------+------------+ < | V | OP | Y | Q | M | W | D | H | MI | S | < +------------+-------+------------+------------+------------+------------+------------+------------+------------+------------+ < | 12:34:56.7 | ceil | 12:34:57.0 | 12:34:56.7 | 12:34:56.7 | 12:34:56.7 | 12:34:56.7 | 13:00:00.0 | 12:35:00.0 | 12:34:57.0 | < | 12:34:56.7 | floor | 12:34:56.6 | 12:34:56.6 | 12:34:56.6 | 12:34:56.6 | 12:34:56.7 | 12:00:00.0 | 12:34:00.0 | 12:34:56.0 | < +------------+-------+------------+------------+------------+------------+------------+------------+------------+------------+ --- > +----------+-------+----------+----------+----------+----------+----------+----------+----------+----------+ > | V | OP | Y | Q | M | W | D | H | MI | S | > +----------+-------+----------+----------+----------+----------+----------+----------+----------+----------+ > | 12:34:56 | ceil | 12:34:57 | 12:34:56 | 12:34:56 | 12:34:56 | 12:34:56 | 13:00:00 | 12:35:00 | 12:34:57 | > | 12:34:56 | floor | 12:34:56 | 12:34:56 | 12:34:56 | 12:34:56 | 12:34:56 | 12:00:00 | 12:34:00 | 12:34:56 | > +----------+-------+----------+----------+----------+----------+----------+----------+----------+----------+ at org.junit.jupiter.api.AssertionUtils.fail(AssertionUtils.java:38) at org.junit.jupiter.api.Assertions.fail(Assertions.java:135) at org.apache.calcite.test.QuidemTest.checkRun(QuidemTest.java:186) at org.apache.calcite.test.QuidemTest.test(QuidemTest.java:239) at org.junit.platform.commons.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:727) at org.junit.jupiter.engine.execution.MethodInvocation.proceed(MethodInvocation.java:60) at org.junit.jupiter.engine.execution.InvocationInterceptorChain$ValidatingInvocation.proceed(InvocationInterceptorChain.java:131) at org.junit.jupiter.engine.extension.SameThreadTimeoutInvocation.proceed(SameThreadTimeoutInvocation.java:45) at org.junit.jupiter.engine.extension.TimeoutExtension.intercept(TimeoutExtension.java:156) at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestableMethod(TimeoutExtension.java:147) at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestTemplateMethod(TimeoutExtension.java:94) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker$ReflectiveInterceptorCall.lambda$ofVoidMethod$0(InterceptingExecutableInvoker.java:103) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.lambda$invoke$0(InterceptingExecutableInvoker.java:93) at org.junit.jupiter.engine.execution.InvocationInterceptorChain$InterceptedInvocation.proceed(InvocationInterceptorChain.java:106) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.proceed(InvocationInterceptorChain.java:64) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.chainAndInvoke(InvocationInterceptorChain.java:45) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.invoke(InvocationInterceptorChain.java:37) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:92) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:86) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.lambda$invokeTestMethod$7(TestMethodTestDescriptor.java:217) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.invo

0.0sec org.apache.calcite.test.CalciteSqlOperatorTest > testTimestampAdd() java.lang.AssertionError: Query: values (timestampadd(FRAC_SECOND, 2000000, timestamp '2016-02-24 12:42:25')) Expected: is "2016-02-24 12:42:27.000" but: was "2016-02-24 12:42:27" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.apache.calcite.sql.test.ResultCheckers.compareResultSetWithMatcher(ResultCheckers.java:252) at org.apache.calcite.sql.test.ResultCheckers$MatcherResultChecker.checkResult(ResultCheckers.java:321) at org.apache.calcite.test.SqlOperatorTest$TesterImpl.check(SqlOperatorTest.java:14473) at org.apache.calcite.sql.test.SqlTester.check(SqlTester.java:160) at org.apache.calcite.test.SqlOperatorFixtureImpl.lambda$checkScalar$2(SqlOperatorFixtureImpl.java:226) at org.apache.calcite.sql.test.AbstractSqlTester.forEachQuery(AbstractSqlTester.java:450) at org.apache.calcite.test.SqlOperatorFixtureImpl.checkScalar(SqlOperatorFixtureImpl.java:225) at org.apache.calcite.sql.test.SqlOperatorFixture.checkScalar(SqlOperatorFixture.java:221) at org.apache.calcite.test.SqlOperatorTest.lambda$testTimestampAdd$64(SqlOperatorTest.java:11719) at java.util.Arrays$ArrayList.forEach(Arrays.java:3880) at org.apache.calcite.test.SqlOperatorTest.testTimestampAdd(SqlOperatorTest.java:11718) at org.junit.platform.commons.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:727) at org.junit.jupiter.engine.execution.MethodInvocation.proceed(MethodInvocation.java:60) at org.junit.jupiter.engine.execution.InvocationInterceptorChain$ValidatingInvocation.proceed(InvocationInterceptorChain.java:131) at org.junit.jupiter.engine.extension.SameThreadTimeoutInvocation.proceed(SameThreadTimeoutInvocation.java:45) at org.junit.jupiter.engine.extension.TimeoutExtension.intercept(TimeoutExtension.java:156) at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestableMethod(TimeoutExtension.java:147) at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestMethod(TimeoutExtension.java:86) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker$ReflectiveInterceptorCall.lambda$ofVoidMethod$0(InterceptingExecutableInvoker.java:103) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.lambda$invoke$0(InterceptingExecutableInvoker.java:93) at org.junit.jupiter.engine.execution.InvocationInterceptorChain$InterceptedInvocation.proceed(InvocationInterceptorChain.java:106) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.proceed(InvocationInterceptorChain.java:64) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.chainAndInvoke(InvocationInterceptorChain.java:45) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.invoke(InvocationInterceptorChain.java:37) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:92) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:86) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.lambda$invokeTestMethod$7(TestMethodTestDescriptor.java:217) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.invokeTestMethod(TestMethodTestDescriptor.java:213) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:138) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:68) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$6(NodeTestTask.java:151) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:141) at org.junit.platform.eng

0.3sec org.apache.calcite.test.CoreQuidemTest > test(String)[24], [24] sql\stream.iq org.opentest4j.AssertionFailedError: Files differ: D:\a\calcite\calcite\core\build\quidem\test\sql\stream.iq D:\a\calcite\calcite\core\build\resources\test\sql\stream.iq 25,33c25,33 < +---------------------+----+---------+-------+-------------------------+-------------------------+ < | ROWTIME | ID | PRODUCT | UNITS | window_start | window_end | < +---------------------+----+---------+-------+-------------------------+-------------------------+ < | 2015-02-15 10:15:00 | 1 | paint | 10 | 2015-02-15 10:15:00.000 | 2015-02-15 10:16:00.000 | < | 2015-02-15 10:24:15 | 2 | paper | 5 | 2015-02-15 10:24:00.000 | 2015-02-15 10:25:00.000 | < | 2015-02-15 10:24:45 | 3 | brush | 12 | 2015-02-15 10:24:00.000 | 2015-02-15 10:25:00.000 | < | 2015-02-15 10:58:00 | 4 | paint | 3 | 2015-02-15 10:58:00.000 | 2015-02-15 10:59:00.000 | < | 2015-02-15 11:10:00 | 5 | paint | 3 | 2015-02-15 11:10:00.000 | 2015-02-15 11:11:00.000 | < +---------------------+----+---------+-------+-------------------------+-------------------------+ --- > +---------------------+----+---------+-------+---------------------+---------------------+ > | ROWTIME | ID | PRODUCT | UNITS | window_start | window_end | > +---------------------+----+---------+-------+---------------------+---------------------+ > | 2015-02-15 10:15:00 | 1 | paint | 10 | 2015-02-15 10:15:00 | 2015-02-15 10:16:00 | > | 2015-02-15 10:24:15 | 2 | paper | 5 | 2015-02-15 10:24:00 | 2015-02-15 10:25:00 | > | 2015-02-15 10:24:45 | 3 | brush | 12 | 2015-02-15 10:24:00 | 2015-02-15 10:25:00 | > | 2015-02-15 10:58:00 | 4 | paint | 3 | 2015-02-15 10:58:00 | 2015-02-15 10:59:00 | > | 2015-02-15 11:10:00 | 5 | paint | 3 | 2015-02-15 11:10:00 | 2015-02-15 11:11:00 | > +---------------------+----+---------+-------+---------------------+---------------------+ 39,47c39,47 < +---------------------+----+---------+-------+-------------------------+-------------------------+ < | ROWTIME | ID | PRODUCT | UNITS | window_start | window_end | < +---------------------+----+---------+-------+-------------------------+-------------------------+ < | 2015-02-15 10:15:00 | 1 | paint | 10 | 2015-02-15 10:15:00.000 | 2015-02-15 10:16:00.000 | < | 2015-02-15 10:24:15 | 2 | paper | 5 | 2015-02-15 10:24:00.000 | 2015-02-15 10:25:00.000 | < | 2015-02-15 10:24:45 | 3 | brush | 12 | 2015-02-15 10:24:00.000 | 2015-02-15 10:25:00.000 | < | 2015-02-15 10:58:00 | 4 | paint | 3 | 2015-02-15 10:58:00.000 | 2015-02-15 10:59:00.000 | < | 2015-02-15 11:10:00 | 5 | paint | 3 | 2015-02-15 11:10:00.000 | 2015-02-15 11:11:00.000 | < +---------------------+----+---------+-------+-------------------------+-------------------------+ --- > +---------------------+----+---------+-------+---------------------+---------------------+ > | ROWTIME | ID | PRODUCT | UNITS | window_start | window_end | > +---------------------+----+---------+-------+---------------------+---------------------+ > | 2015-02-15 10:15:00 | 1 | paint | 10 | 2015-02-15 10:15:00 | 2015-02-15 10:16:00 | > | 2015-02-15 10:24:15 | 2 | paper | 5 | 2015-02-15 10:24:00 | 2015-02-15 10:25:00 | > | 2015-02-15 10:24:45 | 3 | brush | 12 | 2015-02-15 10:24:00 | 2015-02-15 10:25:00 | > | 2015-02-15 10:58:00 | 4 | paint | 3 | 2015-02-15 10:58:00 | 2015-02-15 10:59:00 | > | 2015-02-15 11:10:00 | 5 | paint | 3 | 2015-02-15 11:10:00 | 2015-02-15 11:11:00 | > +---------------------+----+---------+-------+---------------------+---------------------+ 53,61c53,61 < +---------------------+----+---------+-------+-------------------------+-------------------------+ < | ROWTIME | ID | PRODUCT | UNITS | window_start | window_end | < +---------------------+----+---------+-------+-------------------------+-------------------------+

0.1sec org.apache.calcite.test.SqlOperatorUnparseTest > testCeilFuncDateTime() java.lang.AssertionError: Query: SELECT CEIL("P0" TO SECOND) FROM (VALUES ROW(TIMESTAMP '2015-02-19 12:34:56.78')) AS "T" ("P0") Expected: is "2015-02-19 12:34:57.00" but: was "2015-02-19 12:34:57" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.apache.calcite.sql.test.ResultCheckers.compareResultSetWithMatcher(ResultCheckers.java:252) at org.apache.calcite.sql.test.ResultCheckers$MatcherResultChecker.checkResult(ResultCheckers.java:321) at org.apache.calcite.test.SqlOperatorTest$TesterImpl.check(SqlOperatorTest.java:14473) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.check(SqlOperatorUnparseTest.java:95) at org.apache.calcite.sql.test.SqlTester.check(SqlTester.java:160) at org.apache.calcite.test.SqlOperatorFixtureImpl.lambda$checkScalar$2(SqlOperatorFixtureImpl.java:226) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.forEachQuery(SqlOperatorUnparseTest.java:88)

0.0sec org.apache.calcite.test.SqlOperatorUnparseTest > testTimestampAdd() java.lang.AssertionError: Query: SELECT TIMESTAMPADD("FRAC_SECOND", "P1", "P0") FROM (VALUES ROW(TIMESTAMP '2016-02-24 12:42:25', 2000000)) AS "T" ("P0", "P1") Expected: is "2016-02-24 12:42:27.000" but: was "2016-02-24 12:42:27" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.apache.calcite.sql.test.ResultCheckers.compareResultSetWithMatcher(ResultCheckers.java:252) at org.apache.calcite.sql.test.ResultCheckers$MatcherResultChecker.checkResult(ResultCheckers.java:321) at org.apache.calcite.test.SqlOperatorTest$TesterImpl.check(SqlOperatorTest.java:14473) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.check(SqlOperatorUnparseTest.java:95) at org.apache.calcite.sql.test.SqlTester.check(SqlTester.java:160) at org.apache.calcite.test.SqlOperatorFixtureImpl.lambda$checkScalar$2(SqlOperatorFixtureImpl.java:226) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.forEachQuery(SqlOperatorUnparseTest.java:88)

0.0sec org.apache.calcite.test.CalciteSqlOperatorTest > testFloorFuncDateTime() java.lang.AssertionError: Query: values (floor(timestamp '2015-02-19 12:34:56.78' to second)) Expected: is "2015-02-19 12:34:56.00" but: was "2015-02-19 12:34:56" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.apache.calcite.sql.test.ResultCheckers.compareResultSetWithMatcher(ResultCheckers.java:252) at org.apache.calcite.sql.test.ResultCheckers$MatcherResultChecker.checkResult(ResultCheckers.java:321) at org.apache.calcite.test.SqlOperatorTest$TesterImpl.check(SqlOperatorTest.java:14473) at org.apache.calcite.sql.test.SqlTester.check(SqlTester.java:160) at org.apache.calcite.test.SqlOperatorFixtureImpl.lambda$checkScalar$2(SqlOperatorFixtureImpl.java:226) at org.apache.calcite.sql.test.AbstractSqlTester.forEachQuery(AbstractSqlTester.java:450) at org.apache.calcite.test.SqlOperatorFixtureImpl.checkScalar(SqlOperatorFixtureImpl.java:225) at org.apache.calcite.sql.test.SqlOperatorFixture.checkScalar(SqlOperatorFixture.java:221) at org.apache.calcite.test.SqlOperatorTest.testFloorFuncDateTime(SqlOperatorTest.java:11531) at org.junit.platform.commons.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:727) at org.junit.jupiter.engine.execution.MethodInvocation.proceed(MethodInvocation.java:60) at org.junit.jupiter.engine.execution.InvocationInterceptorChain$ValidatingInvocation.proceed(InvocationInterceptorChain.java:131) at org.junit.jupiter.engine.extension.SameThreadTimeoutInvocation.proceed(SameThreadTimeoutInvocation.java:45) at org.junit.jupiter.engine.extension.TimeoutExtension.intercept(TimeoutExtension.java:156) at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestableMethod(TimeoutExtension.java:147) at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestMethod(TimeoutExtension.java:86) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker$ReflectiveInterceptorCall.lambda$ofVoidMethod$0(InterceptingExecutableInvoker.java:103) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.lambda$invoke$0(InterceptingExecutableInvoker.java:93) at org.junit.jupiter.engine.execution.InvocationInterceptorChain$InterceptedInvocation.proceed(InvocationInterceptorChain.java:106) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.proceed(InvocationInterceptorChain.java:64) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.chainAndInvoke(InvocationInterceptorChain.java:45) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.invoke(InvocationInterceptorChain.java:37) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:92) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:86) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.lambda$invokeTestMethod$7(TestMethodTestDescriptor.java:217) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.invokeTestMethod(TestMethodTestDescriptor.java:213) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:138) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:68) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$6(NodeTestTask.java:151) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:141) at org.junit.platform.engine.support.hierarchical.Node.around(Node.java:137) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$9(NodeTestTask.java:139)

0.0sec org.apache.calcite.test.SqlOperatorUnparseTest > testFloorFuncDateTime() java.lang.AssertionError: Query: SELECT FLOOR("P0" TO SECOND) FROM (VALUES ROW(TIMESTAMP '2015-02-19 12:34:56.78')) AS "T" ("P0") Expected: is "2015-02-19 12:34:56.00" but: was "2015-02-19 12:34:56" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.apache.calcite.sql.test.ResultCheckers.compareResultSetWithMatcher(ResultCheckers.java:252) at org.apache.calcite.sql.test.ResultCheckers$MatcherResultChecker.checkResult(ResultCheckers.java:321) at org.apache.calcite.test.SqlOperatorTest$TesterImpl.check(SqlOperatorTest.java:14473) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.check(SqlOperatorUnparseTest.java:95) at org.apache.calcite.sql.test.SqlTester.check(SqlTester.java:160) at org.apache.calcite.test.SqlOperatorFixtureImpl.lambda$checkScalar$2(SqlOperatorFixtureImpl.java:226) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.forEachQuery(SqlOperatorUnparseTest.java:88)

0.0sec org.apache.calcite.test.SqlOperatorUnparseTest > testCastDateTime(CastType, SqlOperatorFixture)[1], [1] CAST, org.apache.calcite.test.SqlOperatorUnparseTest$SqlOperatorFixtureUnparseImpl@3ed9e5fa java.lang.AssertionError: Query: SELECT CAST("P0" AS TIME(2)) FROM (VALUES ROW(TIME '12:42:25.34')) AS "T" ("P0") Expected: is "12:42:25.34" but: was "12:42:25" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.apache.calcite.sql.test.ResultCheckers.compareResultSetWithMatcher(ResultCheckers.java:252) at org.apache.calcite.sql.test.ResultCheckers$MatcherResultChecker.checkResult(ResultCheckers.java:321) at org.apache.calcite.test.SqlOperatorTest$TesterImpl.check(SqlOperatorTest.java:14473) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.check(SqlOperatorUnparseTest.java:95) at org.apache.calcite.sql.test.SqlTester.check(SqlTester.java:160) at org.apache.calcite.test.SqlOperatorFixtureImpl.lambda$checkScalar$2(SqlOperatorFixtureImpl.java:226) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.forEachQuery(SqlOperatorUnparseTest.java:88)

0.1sec org.apache.calcite.test.CalciteSqlOperatorTest > testCeilFuncDateTime() java.lang.AssertionError: Query: values (ceil(timestamp '2015-02-19 12:34:56.78' to second)) Expected: is "2015-02-19 12:34:57.00" but: was "2015-02-19 12:34:57" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.apache.calcite.sql.test.ResultCheckers.compareResultSetWithMatcher(ResultCheckers.java:252) at org.apache.calcite.sql.test.ResultCheckers$MatcherResultChecker.checkResult(ResultCheckers.java:321) at org.apache.calcite.test.SqlOperatorTest$TesterImpl.check(SqlOperatorTest.java:14473) at org.apache.calcite.sql.test.SqlTester.check(SqlTester.java:160) at org.apache.calcite.test.SqlOperatorFixtureImpl.lambda$checkScalar$2(SqlOperatorFixtureImpl.java:226) at org.apache.calcite.sql.test.AbstractSqlTester.forEachQuery(AbstractSqlTester.java:450) at org.apache.calcite.test.SqlOperatorFixtureImpl.checkScalar(SqlOperatorFixtureImpl.java:225) at org.apache.calcite.sql.test.SqlOperatorFixture.checkScalar(SqlOperatorFixture.java:221) at org.apache.calcite.test.SqlOperatorTest.testCeilFuncDateTime(SqlOperatorTest.java:11576) at org.junit.platform.commons.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:727) at org.junit.jupiter.engine.execution.MethodInvocation.proceed(MethodInvocation.java:60) at org.junit.jupiter.engine.execution.InvocationInterceptorChain$ValidatingInvocation.proceed(InvocationInterceptorChain.java:131) at org.junit.jupiter.engine.extension.SameThreadTimeoutInvocation.proceed(SameThreadTimeoutInvocation.java:45) at org.junit.jupiter.engine.extension.TimeoutExtension.intercept(TimeoutExtension.java:156) at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestableMethod(TimeoutExtension.java:147) at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestMethod(TimeoutExtension.java:86) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker$ReflectiveInterceptorCall.lambda$ofVoidMethod$0(InterceptingExecutableInvoker.java:103) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.lambda$invoke$0(InterceptingExecutableInvoker.java:93) at org.junit.jupiter.engine.execution.InvocationInterceptorChain$InterceptedInvocation.proceed(InvocationInterceptorChain.java:106) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.proceed(InvocationInterceptorChain.java:64) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.chainAndInvoke(InvocationInterceptorChain.java:45) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.invoke(InvocationInterceptorChain.java:37) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:92) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:86) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.lambda$invokeTestMethod$7(TestMethodTestDescriptor.java:217) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.invokeTestMethod(TestMethodTestDescriptor.java:213) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:138) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:68) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$6(NodeTestTask.java:151) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:141) at org.junit.platform.engine.support.hierarchical.Node.around(Node.java:137) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$9(NodeTestTask.java:139)

12.5sec org.apache.calcite.test.CoreQuidemTest > test(String)[12], [12] sql\misc.iq org.opentest4j.AssertionFailedError: Files differ: D:\a\calcite\calcite\core\build\quidem\test\sql\misc.iq D:\a\calcite\calcite\core\build\resources\test\sql\misc.iq 2149,2153c2149,2153 < +-------------------------+---------------------+---------------------+-----------------------+------------------------+-------------------------+-------------------------+-------------------------+ < | EXPR$0 | EXPR$1 | EXPR$2 | EXPR$3 | EXPR$4 | EXPR$5 | EXPR$6 | EXPR$7 | < +-------------------------+---------------------+---------------------+-----------------------+------------------------+-------------------------+-------------------------+-------------------------+ < | 2016-02-26 19:06:00.123 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00.1 | 2016-02-26 19:06:00.12 | 2016-02-26 19:06:00.123 | 2016-02-26 19:06:00.123 | 2016-02-26 19:06:00.123 | < +-------------------------+---------------------+---------------------+-----------------------+------------------------+-------------------------+-------------------------+-------------------------+ --- > +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ > | EXPR$0 | EXPR$1 | EXPR$2 | EXPR$3 | EXPR$4 | EXPR$5 | EXPR$6 | EXPR$7 | > +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ > | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | > +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ 2167,2171c2167,2171 < +-------------------------+---------------------+--------+ < | EXPR$0 | EXPR$1 | EXPR$2 | < +-------------------------+---------------------+--------+ < | 2016-02-26 19:06:00.123 | 2016-02-26 19:06:00 | 0 | < +-------------------------+---------------------+--------+ --- > +---------------------+---------------------+--------+ > | EXPR$0 | EXPR$1 | EXPR$2 | > +---------------------+---------------------+--------+ > | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 0 | > +---------------------+---------------------+--------+ at app//org.junit.jupiter.api.AssertionUtils.fail(AssertionUtils.java:38) at app//org.junit.jupiter.api.Assertions.fail(Assertions.java:135) at app//org.apache.calcite.test.QuidemTest.checkRun(QuidemTest.java:186) at app//org.apache.calcite.test.CoreQuidemTest.testSqlMisc(CoreQuidemTest.java:103)

0.0sec org.apache.calcite.test.CalciteSqlOperatorTest > testTimestampAdd() java.lang.AssertionError: Query: values (timestampadd(FRAC_SECOND, 2000000, timestamp '2016-02-24 12:42:25')) Expected: is "2016-02-24 12:42:27.000" but: was "2016-02-24 12:42:27" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.apache.calcite.sql.test.ResultCheckers.compareResultSetWithMatcher(ResultCheckers.java:252) at org.apache.calcite.sql.test.ResultCheckers$MatcherResultChecker.checkResult(ResultCheckers.java:321) at org.apache.calcite.test.SqlOperatorTest$TesterImpl.check(SqlOperatorTest.java:14473) at org.apache.calcite.sql.test.SqlTester.check(SqlTester.java:160) at org.apache.calcite.test.SqlOperatorFixtureImpl.lambda$checkScalar$2(SqlOperatorFixtureImpl.java:226) at org.apache.calcite.sql.test.AbstractSqlTester.forEachQuery(AbstractSqlTester.java:450) at org.apache.calcite.test.SqlOperatorFixtureImpl.checkScalar(SqlOperatorFixtureImpl.java:225) at org.apache.calcite.sql.test.SqlOperatorFixture.checkScalar(SqlOperatorFixture.java:221) at org.apache.calcite.test.SqlOperatorTest.lambda$testTimestampAdd$64(SqlOperatorTest.java:11719) at java.base/java.util.Arrays$ArrayList.forEach(Arrays.java:4204) at org.apache.calcite.test.SqlOperatorTest.testTimestampAdd(SqlOperatorTest.java:11718) at org.junit.platform.commons.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:727) at org.junit.jupiter.engine.execution.MethodInvocation.proceed(MethodInvocation.java:60) at org.junit.jupiter.engine.execution.InvocationInterceptorChain$ValidatingInvocation.proceed(InvocationInterceptorChain.java:131) at org.junit.jupiter.engine.extension.SameThreadTimeoutInvocation.proceed(SameThreadTimeoutInvocation.java:45) at org.junit.jupiter.engine.extension.TimeoutExtension.intercept(TimeoutExtension.java:156) at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestableMethod(TimeoutExtension.java:147) at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestMethod(TimeoutExtension.java:86) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker$ReflectiveInterceptorCall.lambda$ofVoidMethod$0(InterceptingExecutableInvoker.java:103) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.lambda$invoke$0(InterceptingExecutableInvoker.java:93) at org.junit.jupiter.engine.execution.InvocationInterceptorChain$InterceptedInvocation.proceed(InvocationInterceptorChain.java:106) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.proceed(InvocationInterceptorChain.java:64) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.chainAndInvoke(InvocationInterceptorChain.java:45) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.invoke(InvocationInterceptorChain.java:37) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:92) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:86) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.lambda$invokeTestMethod$7(TestMethodTestDescriptor.java:217) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.invokeTestMethod(TestMethodTestDescriptor.java:213) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:138) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:68) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$6(NodeTestTask.java:151) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:141) at org.junit.pl

2.3sec org.apache.calcite.test.CoreQuidemTest > test(String)[13], [13] sql\operator.iq org.opentest4j.AssertionFailedError: Files differ: D:\a\calcite\calcite\core\build\quidem\test\sql\operator.iq D:\a\calcite\calcite\core\build\resources\test\sql\operator.iq 238,243c238,243 < +------------+-------+------------+------------+------------+------------+------------+------------+------------+------------+ < | V | OP | Y | Q | M | W | D | H | MI | S | < +------------+-------+------------+------------+------------+------------+------------+------------+------------+------------+ < | 12:34:56.7 | ceil | 12:34:57.0 | 12:34:56.7 | 12:34:56.7 | 12:34:56.7 | 12:34:56.7 | 13:00:00.0 | 12:35:00.0 | 12:34:57.0 | < | 12:34:56.7 | floor | 12:34:56.6 | 12:34:56.6 | 12:34:56.6 | 12:34:56.6 | 12:34:56.7 | 12:00:00.0 | 12:34:00.0 | 12:34:56.0 | < +------------+-------+------------+------------+------------+------------+------------+------------+------------+------------+ --- > +----------+-------+----------+----------+----------+----------+----------+----------+----------+----------+ > | V | OP | Y | Q | M | W | D | H | MI | S | > +----------+-------+----------+----------+----------+----------+----------+----------+----------+----------+ > | 12:34:56 | ceil | 12:34:57 | 12:34:56 | 12:34:56 | 12:34:56 | 12:34:56 | 13:00:00 | 12:35:00 | 12:34:57 | > | 12:34:56 | floor | 12:34:56 | 12:34:56 | 12:34:56 | 12:34:56 | 12:34:56 | 12:00:00 | 12:34:00 | 12:34:56 | > +----------+-------+----------+----------+----------+----------+----------+----------+----------+----------+ at app//org.junit.jupiter.api.AssertionUtils.fail(AssertionUtils.java:38) at app//org.junit.jupiter.api.Assertions.fail(Assertions.java:135) at app//org.apache.calcite.test.QuidemTest.checkRun(QuidemTest.java:186) at app//org.apache.calcite.test.QuidemTest.test(QuidemTest.java:239) at app//org.junit.platform.commons.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:727) at app//org.junit.jupiter.engine.execution.MethodInvocation.proceed(MethodInvocation.java:60) at app//org.junit.jupiter.engine.execution.InvocationInterceptorChain$ValidatingInvocation.proceed(InvocationInterceptorChain.java:131) at app//org.junit.jupiter.engine.extension.SameThreadTimeoutInvocation.proceed(SameThreadTimeoutInvocation.java:45) at app//org.junit.jupiter.engine.extension.TimeoutExtension.intercept(TimeoutExtension.java:156) at app//org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestableMethod(TimeoutExtension.java:147) at app//org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestTemplateMethod(TimeoutExtension.java:94) at app//org.junit.jupiter.engine.execution.InterceptingExecutableInvoker$ReflectiveInterceptorCall.lambda$ofVoidMethod$0(InterceptingExecutableInvoker.java:103) at app//org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.lambda$invoke$0(InterceptingExecutableInvoker.java:93) at app//org.junit.jupiter.engine.execution.InvocationInterceptorChain$InterceptedInvocation.proceed(InvocationInterceptorChain.java:106) at app//org.junit.jupiter.engine.execution.InvocationInterceptorChain.proceed(InvocationInterceptorChain.java:64) at app//org.junit.jupiter.engine.execution.InvocationInterceptorChain.chainAndInvoke(InvocationInterceptorChain.java:45) at app//org.junit.jupiter.engine.execution.InvocationInterceptorChain.invoke(InvocationInterceptorChain.java:37) at app//org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:92) at app//org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:86) at app//org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.lambda$invokeTestMethod$7(TestMethodTestDescriptor.java:217) at app//org.junit.platform.engine.support.hierarchical.ThrowableCollector.exec

0.1sec org.apache.calcite.test.SqlOperatorUnparseTest > testCeilFuncDateTime() java.lang.AssertionError: Query: SELECT CEIL("P0" TO SECOND) FROM (VALUES ROW(TIMESTAMP '2015-02-19 12:34:56.78')) AS "T" ("P0") Expected: is "2015-02-19 12:34:57.00" but: was "2015-02-19 12:34:57" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.apache.calcite.sql.test.ResultCheckers.compareResultSetWithMatcher(ResultCheckers.java:252) at org.apache.calcite.sql.test.ResultCheckers$MatcherResultChecker.checkResult(ResultCheckers.java:321) at org.apache.calcite.test.SqlOperatorTest$TesterImpl.check(SqlOperatorTest.java:14473) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.check(SqlOperatorUnparseTest.java:95) at org.apache.calcite.sql.test.SqlTester.check(SqlTester.java:160) at org.apache.calcite.test.SqlOperatorFixtureImpl.lambda$checkScalar$2(SqlOperatorFixtureImpl.java:226) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.forEachQuery(SqlOperatorUnparseTest.java:88)

0.3sec org.apache.calcite.test.CoreQuidemTest > test(String)[24], [24] sql\stream.iq org.opentest4j.AssertionFailedError: Files differ: D:\a\calcite\calcite\core\build\quidem\test\sql\stream.iq D:\a\calcite\calcite\core\build\resources\test\sql\stream.iq 25,33c25,33 < +---------------------+----+---------+-------+-------------------------+-------------------------+ < | ROWTIME | ID | PRODUCT | UNITS | window_start | window_end | < +---------------------+----+---------+-------+-------------------------+-------------------------+ < | 2015-02-15 10:15:00 | 1 | paint | 10 | 2015-02-15 10:15:00.000 | 2015-02-15 10:16:00.000 | < | 2015-02-15 10:24:15 | 2 | paper | 5 | 2015-02-15 10:24:00.000 | 2015-02-15 10:25:00.000 | < | 2015-02-15 10:24:45 | 3 | brush | 12 | 2015-02-15 10:24:00.000 | 2015-02-15 10:25:00.000 | < | 2015-02-15 10:58:00 | 4 | paint | 3 | 2015-02-15 10:58:00.000 | 2015-02-15 10:59:00.000 | < | 2015-02-15 11:10:00 | 5 | paint | 3 | 2015-02-15 11:10:00.000 | 2015-02-15 11:11:00.000 | < +---------------------+----+---------+-------+-------------------------+-------------------------+ --- > +---------------------+----+---------+-------+---------------------+---------------------+ > | ROWTIME | ID | PRODUCT | UNITS | window_start | window_end | > +---------------------+----+---------+-------+---------------------+---------------------+ > | 2015-02-15 10:15:00 | 1 | paint | 10 | 2015-02-15 10:15:00 | 2015-02-15 10:16:00 | > | 2015-02-15 10:24:15 | 2 | paper | 5 | 2015-02-15 10:24:00 | 2015-02-15 10:25:00 | > | 2015-02-15 10:24:45 | 3 | brush | 12 | 2015-02-15 10:24:00 | 2015-02-15 10:25:00 | > | 2015-02-15 10:58:00 | 4 | paint | 3 | 2015-02-15 10:58:00 | 2015-02-15 10:59:00 | > | 2015-02-15 11:10:00 | 5 | paint | 3 | 2015-02-15 11:10:00 | 2015-02-15 11:11:00 | > +---------------------+----+---------+-------+---------------------+---------------------+ 39,47c39,47 < +---------------------+----+---------+-------+-------------------------+-------------------------+ < | ROWTIME | ID | PRODUCT | UNITS | window_start | window_end | < +---------------------+----+---------+-------+-------------------------+-------------------------+ < | 2015-02-15 10:15:00 | 1 | paint | 10 | 2015-02-15 10:15:00.000 | 2015-02-15 10:16:00.000 | < | 2015-02-15 10:24:15 | 2 | paper | 5 | 2015-02-15 10:24:00.000 | 2015-02-15 10:25:00.000 | < | 2015-02-15 10:24:45 | 3 | brush | 12 | 2015-02-15 10:24:00.000 | 2015-02-15 10:25:00.000 | < | 2015-02-15 10:58:00 | 4 | paint | 3 | 2015-02-15 10:58:00.000 | 2015-02-15 10:59:00.000 | < | 2015-02-15 11:10:00 | 5 | paint | 3 | 2015-02-15 11:10:00.000 | 2015-02-15 11:11:00.000 | < +---------------------+----+---------+-------+-------------------------+-------------------------+ --- > +---------------------+----+---------+-------+---------------------+---------------------+ > | ROWTIME | ID | PRODUCT | UNITS | window_start | window_end | > +---------------------+----+---------+-------+---------------------+---------------------+ > | 2015-02-15 10:15:00 | 1 | paint | 10 | 2015-02-15 10:15:00 | 2015-02-15 10:16:00 | > | 2015-02-15 10:24:15 | 2 | paper | 5 | 2015-02-15 10:24:00 | 2015-02-15 10:25:00 | > | 2015-02-15 10:24:45 | 3 | brush | 12 | 2015-02-15 10:24:00 | 2015-02-15 10:25:00 | > | 2015-02-15 10:58:00 | 4 | paint | 3 | 2015-02-15 10:58:00 | 2015-02-15 10:59:00 | > | 2015-02-15 11:10:00 | 5 | paint | 3 | 2015-02-15 11:10:00 | 2015-02-15 11:11:00 | > +---------------------+----+---------+-------+---------------------+---------------------+ 53,61c53,61 < +---------------------+----+---------+-------+-------------------------+-------------------------+ < | ROWTIME | ID | PRODUCT | UNITS | window_start | window_end | < +---------------------+----+---------+-------+-------------------------+-------------------------+

0.0sec org.apache.calcite.test.SqlOperatorUnparseTest > testTimestampAdd() java.lang.AssertionError: Query: SELECT TIMESTAMPADD("FRAC_SECOND", "P1", "P0") FROM (VALUES ROW(TIMESTAMP '2016-02-24 12:42:25', 2000000)) AS "T" ("P0", "P1") Expected: is "2016-02-24 12:42:27.000" but: was "2016-02-24 12:42:27" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.apache.calcite.sql.test.ResultCheckers.compareResultSetWithMatcher(ResultCheckers.java:252) at org.apache.calcite.sql.test.ResultCheckers$MatcherResultChecker.checkResult(ResultCheckers.java:321) at org.apache.calcite.test.SqlOperatorTest$TesterImpl.check(SqlOperatorTest.java:14473) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.check(SqlOperatorUnparseTest.java:95) at org.apache.calcite.sql.test.SqlTester.check(SqlTester.java:160) at org.apache.calcite.test.SqlOperatorFixtureImpl.lambda$checkScalar$2(SqlOperatorFixtureImpl.java:226) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.forEachQuery(SqlOperatorUnparseTest.java:88)

0.1sec org.apache.calcite.test.CalciteSqlOperatorTest > testFloorFuncDateTime() java.lang.AssertionError: Query: values (floor(timestamp '2015-02-19 12:34:56.78' to second)) Expected: is "2015-02-19 12:34:56.00" but: was "2015-02-19 12:34:56" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.apache.calcite.sql.test.ResultCheckers.compareResultSetWithMatcher(ResultCheckers.java:252) at org.apache.calcite.sql.test.ResultCheckers$MatcherResultChecker.checkResult(ResultCheckers.java:321) at org.apache.calcite.test.SqlOperatorTest$TesterImpl.check(SqlOperatorTest.java:14473) at org.apache.calcite.sql.test.SqlTester.check(SqlTester.java:160) at org.apache.calcite.test.SqlOperatorFixtureImpl.lambda$checkScalar$2(SqlOperatorFixtureImpl.java:226) at org.apache.calcite.sql.test.AbstractSqlTester.forEachQuery(AbstractSqlTester.java:450) at org.apache.calcite.test.SqlOperatorFixtureImpl.checkScalar(SqlOperatorFixtureImpl.java:225) at org.apache.calcite.sql.test.SqlOperatorFixture.checkScalar(SqlOperatorFixture.java:221) at org.apache.calcite.test.SqlOperatorTest.testFloorFuncDateTime(SqlOperatorTest.java:11531) at org.junit.platform.commons.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:727) at org.junit.jupiter.engine.execution.MethodInvocation.proceed(MethodInvocation.java:60) at org.junit.jupiter.engine.execution.InvocationInterceptorChain$ValidatingInvocation.proceed(InvocationInterceptorChain.java:131) at org.junit.jupiter.engine.extension.SameThreadTimeoutInvocation.proceed(SameThreadTimeoutInvocation.java:45) at org.junit.jupiter.engine.extension.TimeoutExtension.intercept(TimeoutExtension.java:156) at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestableMethod(TimeoutExtension.java:147) at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestMethod(TimeoutExtension.java:86) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker$ReflectiveInterceptorCall.lambda$ofVoidMethod$0(InterceptingExecutableInvoker.java:103) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.lambda$invoke$0(InterceptingExecutableInvoker.java:93) at org.junit.jupiter.engine.execution.InvocationInterceptorChain$InterceptedInvocation.proceed(InvocationInterceptorChain.java:106) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.proceed(InvocationInterceptorChain.java:64) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.chainAndInvoke(InvocationInterceptorChain.java:45) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.invoke(InvocationInterceptorChain.java:37) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:92) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:86) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.lambda$invokeTestMethod$7(TestMethodTestDescriptor.java:217) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.invokeTestMethod(TestMethodTestDescriptor.java:213) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:138) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:68) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$6(NodeTestTask.java:151) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:141) at org.junit.platform.engine.support.hierarchical.Node.around(Node.java:137) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$9(NodeTestTask.java:139)

0.0sec org.apache.calcite.test.SqlOperatorUnparseTest > testFloorFuncDateTime() java.lang.AssertionError: Query: SELECT FLOOR("P0" TO SECOND) FROM (VALUES ROW(TIMESTAMP '2015-02-19 12:34:56.78')) AS "T" ("P0") Expected: is "2015-02-19 12:34:56.00" but: was "2015-02-19 12:34:56" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.apache.calcite.sql.test.ResultCheckers.compareResultSetWithMatcher(ResultCheckers.java:252) at org.apache.calcite.sql.test.ResultCheckers$MatcherResultChecker.checkResult(ResultCheckers.java:321) at org.apache.calcite.test.SqlOperatorTest$TesterImpl.check(SqlOperatorTest.java:14473) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.check(SqlOperatorUnparseTest.java:95) at org.apache.calcite.sql.test.SqlTester.check(SqlTester.java:160) at org.apache.calcite.test.SqlOperatorFixtureImpl.lambda$checkScalar$2(SqlOperatorFixtureImpl.java:226) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.forEachQuery(SqlOperatorUnparseTest.java:88)

0.0sec org.apache.calcite.test.SqlOperatorUnparseTest > testCastDateTime(CastType, SqlOperatorFixture)[1], [1] CAST, org.apache.calcite.test.SqlOperatorUnparseTest$SqlOperatorFixtureUnparseImpl@6205bd01 java.lang.AssertionError: Query: SELECT CAST("P0" AS TIME(2)) FROM (VALUES ROW(TIME '12:42:25.34')) AS "T" ("P0") Expected: is "12:42:25.34" but: was "12:42:25" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.apache.calcite.sql.test.ResultCheckers.compareResultSetWithMatcher(ResultCheckers.java:252) at org.apache.calcite.sql.test.ResultCheckers$MatcherResultChecker.checkResult(ResultCheckers.java:321) at org.apache.calcite.test.SqlOperatorTest$TesterImpl.check(SqlOperatorTest.java:14473) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.check(SqlOperatorUnparseTest.java:95) at org.apache.calcite.sql.test.SqlTester.check(SqlTester.java:160) at org.apache.calcite.test.SqlOperatorFixtureImpl.lambda$checkScalar$2(SqlOperatorFixtureImpl.java:226) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.forEachQuery(SqlOperatorUnparseTest.java:88)

0.3sec org.apache.calcite.test.CalciteSqlOperatorTest > testCeilFuncDateTime() java.lang.AssertionError: Query: values (ceil(timestamp '2015-02-19 12:34:56.78' to second)) Expected: is "2015-02-19 12:34:57.00" but: was "2015-02-19 12:34:57" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.apache.calcite.sql.test.ResultCheckers.compareResultSetWithMatcher(ResultCheckers.java:252) at org.apache.calcite.sql.test.ResultCheckers$MatcherResultChecker.checkResult(ResultCheckers.java:321) at org.apache.calcite.test.SqlOperatorTest$TesterImpl.check(SqlOperatorTest.java:14473) at org.apache.calcite.sql.test.SqlTester.check(SqlTester.java:160) at org.apache.calcite.test.SqlOperatorFixtureImpl.lambda$checkScalar$2(SqlOperatorFixtureImpl.java:226) at org.apache.calcite.sql.test.AbstractSqlTester.forEachQuery(AbstractSqlTester.java:450) at org.apache.calcite.test.SqlOperatorFixtureImpl.checkScalar(SqlOperatorFixtureImpl.java:225) at org.apache.calcite.sql.test.SqlOperatorFixture.checkScalar(SqlOperatorFixture.java:221) at org.apache.calcite.test.SqlOperatorTest.testCeilFuncDateTime(SqlOperatorTest.java:11576) at org.junit.platform.commons.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:727) at org.junit.jupiter.engine.execution.MethodInvocation.proceed(MethodInvocation.java:60) at org.junit.jupiter.engine.execution.InvocationInterceptorChain$ValidatingInvocation.proceed(InvocationInterceptorChain.java:131) at org.junit.jupiter.engine.extension.SameThreadTimeoutInvocation.proceed(SameThreadTimeoutInvocation.java:45) at org.junit.jupiter.engine.extension.TimeoutExtension.intercept(TimeoutExtension.java:156) at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestableMethod(TimeoutExtension.java:147) at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestMethod(TimeoutExtension.java:86) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker$ReflectiveInterceptorCall.lambda$ofVoidMethod$0(InterceptingExecutableInvoker.java:103) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.lambda$invoke$0(InterceptingExecutableInvoker.java:93) at org.junit.jupiter.engine.execution.InvocationInterceptorChain$InterceptedInvocation.proceed(InvocationInterceptorChain.java:106) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.proceed(InvocationInterceptorChain.java:64) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.chainAndInvoke(InvocationInterceptorChain.java:45) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.invoke(InvocationInterceptorChain.java:37) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:92) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:86) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.lambda$invokeTestMethod$7(TestMethodTestDescriptor.java:217) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.invokeTestMethod(TestMethodTestDescriptor.java:213) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:138) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:68) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$6(NodeTestTask.java:151) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:141) at org.junit.platform.engine.support.hierarchical.Node.around(Node.java:137) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$9(NodeTestTask.java:139) at org.junit.platform.engine.suppor

0.0sec org.apache.calcite.test.CalciteSqlOperatorTest > testTimestampAdd() java.lang.AssertionError: Query: values (timestampadd(FRAC_SECOND, 2000000, timestamp '2016-02-24 12:42:25')) Expected: is "2016-02-24 12:42:27.000" but: was "2016-02-24 12:42:27" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.apache.calcite.sql.test.ResultCheckers.compareResultSetWithMatcher(ResultCheckers.java:252) at org.apache.calcite.sql.test.ResultCheckers$MatcherResultChecker.checkResult(ResultCheckers.java:321) at org.apache.calcite.test.SqlOperatorTest$TesterImpl.check(SqlOperatorTest.java:14473) at org.apache.calcite.sql.test.SqlTester.check(SqlTester.java:160) at org.apache.calcite.test.SqlOperatorFixtureImpl.lambda$checkScalar$2(SqlOperatorFixtureImpl.java:226) at org.apache.calcite.sql.test.AbstractSqlTester.forEachQuery(AbstractSqlTester.java:450) at org.apache.calcite.test.SqlOperatorFixtureImpl.checkScalar(SqlOperatorFixtureImpl.java:225) at org.apache.calcite.sql.test.SqlOperatorFixture.checkScalar(SqlOperatorFixture.java:221) at org.apache.calcite.test.SqlOperatorTest.lambda$testTimestampAdd$64(SqlOperatorTest.java:11719) at java.base/java.util.Arrays$ArrayList.forEach(Arrays.java:4204) at org.apache.calcite.test.SqlOperatorTest.testTimestampAdd(SqlOperatorTest.java:11718) at org.junit.platform.commons.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:727) at org.junit.jupiter.engine.execution.MethodInvocation.proceed(MethodInvocation.java:60) at org.junit.jupiter.engine.execution.InvocationInterceptorChain$ValidatingInvocation.proceed(InvocationInterceptorChain.java:131) at org.junit.jupiter.engine.extension.SameThreadTimeoutInvocation.proceed(SameThreadTimeoutInvocation.java:45) at org.junit.jupiter.engine.extension.TimeoutExtension.intercept(TimeoutExtension.java:156) at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestableMethod(TimeoutExtension.java:147) at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestMethod(TimeoutExtension.java:86) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker$ReflectiveInterceptorCall.lambda$ofVoidMethod$0(InterceptingExecutableInvoker.java:103) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.lambda$invoke$0(InterceptingExecutableInvoker.java:93) at org.junit.jupiter.engine.execution.InvocationInterceptorChain$InterceptedInvocation.proceed(InvocationInterceptorChain.java:106) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.proceed(InvocationInterceptorChain.java:64) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.chainAndInvoke(InvocationInterceptorChain.java:45) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.invoke(InvocationInterceptorChain.java:37) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:92) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:86) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.lambda$invokeTestMethod$7(TestMethodTestDescriptor.java:217) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.invokeTestMethod(TestMethodTestDescriptor.java:213) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:138) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:68) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$6(NodeTestTask.java:151) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:141) at org.junit.platform.engine.support.hierarchical.No

0.3sec org.apache.calcite.test.CoreQuidemTest > test(String)[20], [20] sql/stream.iq org.opentest4j.AssertionFailedError: Files differ: /Users/runner/work/calcite/calcite/core/build/quidem/test/sql/stream.iq /Users/runner/work/calcite/calcite/core/build/resources/test/sql/stream.iq 25,33c25,33 < +---------------------+----+---------+-------+-------------------------+-------------------------+ < | ROWTIME | ID | PRODUCT | UNITS | window_start | window_end | < +---------------------+----+---------+-------+-------------------------+-------------------------+ < | 2015-02-15 10:15:00 | 1 | paint | 10 | 2015-02-15 10:15:00.000 | 2015-02-15 10:16:00.000 | < | 2015-02-15 10:24:15 | 2 | paper | 5 | 2015-02-15 10:24:00.000 | 2015-02-15 10:25:00.000 | < | 2015-02-15 10:24:45 | 3 | brush | 12 | 2015-02-15 10:24:00.000 | 2015-02-15 10:25:00.000 | < | 2015-02-15 10:58:00 | 4 | paint | 3 | 2015-02-15 10:58:00.000 | 2015-02-15 10:59:00.000 | < | 2015-02-15 11:10:00 | 5 | paint | 3 | 2015-02-15 11:10:00.000 | 2015-02-15 11:11:00.000 | < +---------------------+----+---------+-------+-------------------------+-------------------------+ --- > +---------------------+----+---------+-------+---------------------+---------------------+ > | ROWTIME | ID | PRODUCT | UNITS | window_start | window_end | > +---------------------+----+---------+-------+---------------------+---------------------+ > | 2015-02-15 10:15:00 | 1 | paint | 10 | 2015-02-15 10:15:00 | 2015-02-15 10:16:00 | > | 2015-02-15 10:24:15 | 2 | paper | 5 | 2015-02-15 10:24:00 | 2015-02-15 10:25:00 | > | 2015-02-15 10:24:45 | 3 | brush | 12 | 2015-02-15 10:24:00 | 2015-02-15 10:25:00 | > | 2015-02-15 10:58:00 | 4 | paint | 3 | 2015-02-15 10:58:00 | 2015-02-15 10:59:00 | > | 2015-02-15 11:10:00 | 5 | paint | 3 | 2015-02-15 11:10:00 | 2015-02-15 11:11:00 | > +---------------------+----+---------+-------+---------------------+---------------------+ 39,47c39,47 < +---------------------+----+---------+-------+-------------------------+-------------------------+ < | ROWTIME | ID | PRODUCT | UNITS | window_start | window_end | < +---------------------+----+---------+-------+-------------------------+-------------------------+ < | 2015-02-15 10:15:00 | 1 | paint | 10 | 2015-02-15 10:15:00.000 | 2015-02-15 10:16:00.000 | < | 2015-02-15 10:24:15 | 2 | paper | 5 | 2015-02-15 10:24:00.000 | 2015-02-15 10:25:00.000 | < | 2015-02-15 10:24:45 | 3 | brush | 12 | 2015-02-15 10:24:00.000 | 2015-02-15 10:25:00.000 | < | 2015-02-15 10:58:00 | 4 | paint | 3 | 2015-02-15 10:58:00.000 | 2015-02-15 10:59:00.000 | < | 2015-02-15 11:10:00 | 5 | paint | 3 | 2015-02-15 11:10:00.000 | 2015-02-15 11:11:00.000 | < +---------------------+----+---------+-------+-------------------------+-------------------------+ --- > +---------------------+----+---------+-------+---------------------+---------------------+ > | ROWTIME | ID | PRODUCT | UNITS | window_start | window_end | > +---------------------+----+---------+-------+---------------------+---------------------+ > | 2015-02-15 10:15:00 | 1 | paint | 10 | 2015-02-15 10:15:00 | 2015-02-15 10:16:00 | > | 2015-02-15 10:24:15 | 2 | paper | 5 | 2015-02-15 10:24:00 | 2015-02-15 10:25:00 | > | 2015-02-15 10:24:45 | 3 | brush | 12 | 2015-02-15 10:24:00 | 2015-02-15 10:25:00 | > | 2015-02-15 10:58:00 | 4 | paint | 3 | 2015-02-15 10:58:00 | 2015-02-15 10:59:00 | > | 2015-02-15 11:10:00 | 5 | paint | 3 | 2015-02-15 11:10:00 | 2015-02-15 11:11:00 | > +---------------------+----+---------+-------+---------------------+---------------------+ 53,61c53,61 < +---------------------+----+---------+-------+-------------------------+-------------------------+ < | ROWTIME | ID | PRODUCT | UNITS | window_start | window_end | < +---------------------+----+---------+-------+-------------------------

1.2sec org.apache.calcite.test.CoreQuidemTest > test(String)[23], [23] sql/operator.iq org.opentest4j.AssertionFailedError: Files differ: /Users/runner/work/calcite/calcite/core/build/quidem/test/sql/operator.iq /Users/runner/work/calcite/calcite/core/build/resources/test/sql/operator.iq 238,243c238,243 < +------------+-------+------------+------------+------------+------------+------------+------------+------------+------------+ < | V | OP | Y | Q | M | W | D | H | MI | S | < +------------+-------+------------+------------+------------+------------+------------+------------+------------+------------+ < | 12:34:56.7 | ceil | 12:34:57.0 | 12:34:56.7 | 12:34:56.7 | 12:34:56.7 | 12:34:56.7 | 13:00:00.0 | 12:35:00.0 | 12:34:57.0 | < | 12:34:56.7 | floor | 12:34:56.6 | 12:34:56.6 | 12:34:56.6 | 12:34:56.6 | 12:34:56.7 | 12:00:00.0 | 12:34:00.0 | 12:34:56.0 | < +------------+-------+------------+------------+------------+------------+------------+------------+------------+------------+ --- > +----------+-------+----------+----------+----------+----------+----------+----------+----------+----------+ > | V | OP | Y | Q | M | W | D | H | MI | S | > +----------+-------+----------+----------+----------+----------+----------+----------+----------+----------+ > | 12:34:56 | ceil | 12:34:57 | 12:34:56 | 12:34:56 | 12:34:56 | 12:34:56 | 13:00:00 | 12:35:00 | 12:34:57 | > | 12:34:56 | floor | 12:34:56 | 12:34:56 | 12:34:56 | 12:34:56 | 12:34:56 | 12:00:00 | 12:34:00 | 12:34:56 | > +----------+-------+----------+----------+----------+----------+----------+----------+----------+----------+ at app//org.junit.jupiter.api.AssertionUtils.fail(AssertionUtils.java:38) at app//org.junit.jupiter.api.Assertions.fail(Assertions.java:135) at app//org.apache.calcite.test.QuidemTest.checkRun(QuidemTest.java:186) at app//org.apache.calcite.test.QuidemTest.test(QuidemTest.java:239) at app//org.junit.platform.commons.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:727) at app//org.junit.jupiter.engine.execution.MethodInvocation.proceed(MethodInvocation.java:60) at app//org.junit.jupiter.engine.execution.InvocationInterceptorChain$ValidatingInvocation.proceed(InvocationInterceptorChain.java:131) at app//org.junit.jupiter.engine.extension.SameThreadTimeoutInvocation.proceed(SameThreadTimeoutInvocation.java:45) at app//org.junit.jupiter.engine.extension.TimeoutExtension.intercept(TimeoutExtension.java:156) at app//org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestableMethod(TimeoutExtension.java:147) at app//org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestTemplateMethod(TimeoutExtension.java:94) at app//org.junit.jupiter.engine.execution.InterceptingExecutableInvoker$ReflectiveInterceptorCall.lambda$ofVoidMethod$0(InterceptingExecutableInvoker.java:103) at app//org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.lambda$invoke$0(InterceptingExecutableInvoker.java:93) at app//org.junit.jupiter.engine.execution.InvocationInterceptorChain$InterceptedInvocation.proceed(InvocationInterceptorChain.java:106) at app//org.junit.jupiter.engine.execution.InvocationInterceptorChain.proceed(InvocationInterceptorChain.java:64) at app//org.junit.jupiter.engine.execution.InvocationInterceptorChain.chainAndInvoke(InvocationInterceptorChain.java:45) at app//org.junit.jupiter.engine.execution.InvocationInterceptorChain.invoke(InvocationInterceptorChain.java:37) at app//org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:92) at app//org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:86) at app//org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.lambda$invokeTestMethod$7(TestMethodTestDescriptor.java:217) at app//org.junit.platform.engine.support.hierarchical.ThrowableCollecto

13.1sec org.apache.calcite.test.CoreQuidemTest > test(String)[26], [26] sql/misc.iq org.opentest4j.AssertionFailedError: Files differ: /Users/runner/work/calcite/calcite/core/build/quidem/test/sql/misc.iq /Users/runner/work/calcite/calcite/core/build/resources/test/sql/misc.iq 2149,2153c2149,2153 < +-------------------------+---------------------+---------------------+-----------------------+------------------------+-------------------------+-------------------------+-------------------------+ < | EXPR$0 | EXPR$1 | EXPR$2 | EXPR$3 | EXPR$4 | EXPR$5 | EXPR$6 | EXPR$7 | < +-------------------------+---------------------+---------------------+-----------------------+------------------------+-------------------------+-------------------------+-------------------------+ < | 2016-02-26 19:06:00.123 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00.1 | 2016-02-26 19:06:00.12 | 2016-02-26 19:06:00.123 | 2016-02-26 19:06:00.123 | 2016-02-26 19:06:00.123 | < +-------------------------+---------------------+---------------------+-----------------------+------------------------+-------------------------+-------------------------+-------------------------+ --- > +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ > | EXPR$0 | EXPR$1 | EXPR$2 | EXPR$3 | EXPR$4 | EXPR$5 | EXPR$6 | EXPR$7 | > +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ > | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | > +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ 2167,2171c2167,2171 < +-------------------------+---------------------+--------+ < | EXPR$0 | EXPR$1 | EXPR$2 | < +-------------------------+---------------------+--------+ < | 2016-02-26 19:06:00.123 | 2016-02-26 19:06:00 | 0 | < +-------------------------+---------------------+--------+ --- > +---------------------+---------------------+--------+ > | EXPR$0 | EXPR$1 | EXPR$2 | > +---------------------+---------------------+--------+ > | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 0 | > +---------------------+---------------------+--------+ at app//org.junit.jupiter.api.AssertionUtils.fail(AssertionUtils.java:38) at app//org.junit.jupiter.api.Assertions.fail(Assertions.java:135) at app//org.apache.calcite.test.QuidemTest.checkRun(QuidemTest.java:186) at app//org.apache.calcite.test.CoreQuidemTest.testSqlMisc(CoreQuidemTest.java:103)

0.1sec org.apache.calcite.test.SqlOperatorUnparseTest > testCeilFuncDateTime() java.lang.AssertionError: Query: SELECT CEIL("P0" TO SECOND) FROM (VALUES ROW(TIMESTAMP '2015-02-19 12:34:56.78')) AS "T" ("P0") Expected: is "2015-02-19 12:34:57.00" but: was "2015-02-19 12:34:57" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.apache.calcite.sql.test.ResultCheckers.compareResultSetWithMatcher(ResultCheckers.java:252) at org.apache.calcite.sql.test.ResultCheckers$MatcherResultChecker.checkResult(ResultCheckers.java:321) at org.apache.calcite.test.SqlOperatorTest$TesterImpl.check(SqlOperatorTest.java:14473) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.check(SqlOperatorUnparseTest.java:95) at org.apache.calcite.sql.test.SqlTester.check(SqlTester.java:160) at org.apache.calcite.test.SqlOperatorFixtureImpl.lambda$checkScalar$2(SqlOperatorFixtureImpl.java:226) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.forEachQuery(SqlOperatorUnparseTest.java:88)

0.0sec org.apache.calcite.test.SqlOperatorUnparseTest > testTimestampAdd() java.lang.AssertionError: Query: SELECT TIMESTAMPADD("FRAC_SECOND", "P1", "P0") FROM (VALUES ROW(TIMESTAMP '2016-02-24 12:42:25', 2000000)) AS "T" ("P0", "P1") Expected: is "2016-02-24 12:42:27.000" but: was "2016-02-24 12:42:27" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.apache.calcite.sql.test.ResultCheckers.compareResultSetWithMatcher(ResultCheckers.java:252) at org.apache.calcite.sql.test.ResultCheckers$MatcherResultChecker.checkResult(ResultCheckers.java:321) at org.apache.calcite.test.SqlOperatorTest$TesterImpl.check(SqlOperatorTest.java:14473) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.check(SqlOperatorUnparseTest.java:95) at org.apache.calcite.sql.test.SqlTester.check(SqlTester.java:160) at org.apache.calcite.test.SqlOperatorFixtureImpl.lambda$checkScalar$2(SqlOperatorFixtureImpl.java:226) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.forEachQuery(SqlOperatorUnparseTest.java:88)

0.0sec org.apache.calcite.test.CalciteSqlOperatorTest > testFloorFuncDateTime() java.lang.AssertionError: Query: values (floor(timestamp '2015-02-19 12:34:56.78' to second)) Expected: is "2015-02-19 12:34:56.00" but: was "2015-02-19 12:34:56" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.apache.calcite.sql.test.ResultCheckers.compareResultSetWithMatcher(ResultCheckers.java:252) at org.apache.calcite.sql.test.ResultCheckers$MatcherResultChecker.checkResult(ResultCheckers.java:321) at org.apache.calcite.test.SqlOperatorTest$TesterImpl.check(SqlOperatorTest.java:14473) at org.apache.calcite.sql.test.SqlTester.check(SqlTester.java:160) at org.apache.calcite.test.SqlOperatorFixtureImpl.lambda$checkScalar$2(SqlOperatorFixtureImpl.java:226) at org.apache.calcite.sql.test.AbstractSqlTester.forEachQuery(AbstractSqlTester.java:450) at org.apache.calcite.test.SqlOperatorFixtureImpl.checkScalar(SqlOperatorFixtureImpl.java:225) at org.apache.calcite.sql.test.SqlOperatorFixture.checkScalar(SqlOperatorFixture.java:221) at org.apache.calcite.test.SqlOperatorTest.testFloorFuncDateTime(SqlOperatorTest.java:11531) at org.junit.platform.commons.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:727) at org.junit.jupiter.engine.execution.MethodInvocation.proceed(MethodInvocation.java:60) at org.junit.jupiter.engine.execution.InvocationInterceptorChain$ValidatingInvocation.proceed(InvocationInterceptorChain.java:131) at org.junit.jupiter.engine.extension.SameThreadTimeoutInvocation.proceed(SameThreadTimeoutInvocation.java:45) at org.junit.jupiter.engine.extension.TimeoutExtension.intercept(TimeoutExtension.java:156) at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestableMethod(TimeoutExtension.java:147) at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestMethod(TimeoutExtension.java:86) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker$ReflectiveInterceptorCall.lambda$ofVoidMethod$0(InterceptingExecutableInvoker.java:103) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.lambda$invoke$0(InterceptingExecutableInvoker.java:93) at org.junit.jupiter.engine.execution.InvocationInterceptorChain$InterceptedInvocation.proceed(InvocationInterceptorChain.java:106) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.proceed(InvocationInterceptorChain.java:64) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.chainAndInvoke(InvocationInterceptorChain.java:45) at org.junit.jupiter.engine.execution.InvocationInterceptorChain.invoke(InvocationInterceptorChain.java:37) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:92) at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:86) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.lambda$invokeTestMethod$7(TestMethodTestDescriptor.java:217) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.invokeTestMethod(TestMethodTestDescriptor.java:213) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:138) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:68) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$6(NodeTestTask.java:151) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:141) at org.junit.platform.engine.support.hierarchical.Node.around(Node.java:137) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$9(NodeTestTask.java:139) at org.junit.platform.engine.sup

0.1sec org.apache.calcite.test.SqlOperatorUnparseTest > testFloorFuncDateTime() java.lang.AssertionError: Query: SELECT FLOOR("P0" TO SECOND) FROM (VALUES ROW(TIMESTAMP '2015-02-19 12:34:56.78')) AS "T" ("P0") Expected: is "2015-02-19 12:34:56.00" but: was "2015-02-19 12:34:56" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.apache.calcite.sql.test.ResultCheckers.compareResultSetWithMatcher(ResultCheckers.java:252) at org.apache.calcite.sql.test.ResultCheckers$MatcherResultChecker.checkResult(ResultCheckers.java:321) at org.apache.calcite.test.SqlOperatorTest$TesterImpl.check(SqlOperatorTest.java:14473) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.check(SqlOperatorUnparseTest.java:95) at org.apache.calcite.sql.test.SqlTester.check(SqlTester.java:160) at org.apache.calcite.test.SqlOperatorFixtureImpl.lambda$checkScalar$2(SqlOperatorFixtureImpl.java:226) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.forEachQuery(SqlOperatorUnparseTest.java:88)

0.1sec org.apache.calcite.test.SqlOperatorUnparseTest > testCastDateTime(CastType, SqlOperatorFixture)[1], [1] CAST, org.apache.calcite.test.SqlOperatorUnparseTest$SqlOperatorFixtureUnparseImpl@4f63a1ce java.lang.AssertionError: Query: SELECT CAST("P0" AS TIME(2)) FROM (VALUES ROW(TIME '12:42:25.34')) AS "T" ("P0") Expected: is "12:42:25.34" but: was "12:42:25" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.apache.calcite.sql.test.ResultCheckers.compareResultSetWithMatcher(ResultCheckers.java:252) at org.apache.calcite.sql.test.ResultCheckers$MatcherResultChecker.checkResult(ResultCheckers.java:321) at org.apache.calcite.test.SqlOperatorTest$TesterImpl.check(SqlOperatorTest.java:14473) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.check(SqlOperatorUnparseTest.java:95) at org.apache.calcite.sql.test.SqlTester.check(SqlTester.java:160) at org.apache.calcite.test.SqlOperatorFixtureImpl.lambda$checkScalar$2(SqlOperatorFixtureImpl.java:226) at org.apache.calcite.test.SqlOperatorUnparseTest$UnparseTester.forEachQuery(SqlOperatorUnparseTest.java:88)

Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, actions/setup-java@v2, burrunan/gradle-cache-action@v1. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.

The following actions uses node12 which is deprecated and will be forced to run on node16: actions/setup-java@v2. For more info: https://github.blog/changelog/2023-06-13-github-actions-all-actions-will-run-on-node16-instead-of-node12-by-default/

Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, actions/setup-java@v2, burrunan/gradle-cache-action@v1. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.

The following actions uses node12 which is deprecated and will be forced to run on node16: actions/setup-java@v2. For more info: https://github.blog/changelog/2023-06-13-github-actions-all-actions-will-run-on-node16-instead-of-node12-by-default/

Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, actions/setup-java@v2, burrunan/gradle-cache-action@v1. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.

The following actions uses node12 which is deprecated and will be forced to run on node16: actions/setup-java@v2. For more info: https://github.blog/changelog/2023-06-13-github-actions-all-actions-will-run-on-node16-instead-of-node12-by-default/

Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/setup-java@v2, actions/checkout@v3, burrunan/gradle-cache-action@v1. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.

The following actions uses node12 which is deprecated and will be forced to run on node16: actions/setup-java@v2. For more info: https://github.blog/changelog/2023-06-13-github-actions-all-actions-will-run-on-node16-instead-of-node12-by-default/

Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, actions/setup-java@v2, burrunan/gradle-cache-action@v1. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.

The following actions uses node12 which is deprecated and will be forced to run on node16: actions/setup-java@v2. For more info: https://github.blog/changelog/2023-06-13-github-actions-all-actions-will-run-on-node16-instead-of-node12-by-default/

Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, actions/setup-java@v2, burrunan/gradle-cache-action@v1. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.

The following actions uses node12 which is deprecated and will be forced to run on node16: actions/setup-java@v2. For more info: https://github.blog/changelog/2023-06-13-github-actions-all-actions-will-run-on-node16-instead-of-node12-by-default/

Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/setup-java@v2, burrunan/gradle-cache-action@v1, actions/checkout@v3. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.

The following actions uses node12 which is deprecated and will be forced to run on node16: actions/setup-java@v2. For more info: https://github.blog/changelog/2023-06-13-github-actions-all-actions-will-run-on-node16-instead-of-node12-by-default/

Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, actions/setup-java@v2, burrunan/gradle-cache-action@v1. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.

The following actions uses node12 which is deprecated and will be forced to run on node16: actions/setup-java@v2. For more info: https://github.blog/changelog/2023-06-13-github-actions-all-actions-will-run-on-node16-instead-of-node12-by-default/

Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, actions/setup-java@v2, burrunan/gradle-cache-action@v1. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.

The following actions uses node12 which is deprecated and will be forced to run on node16: actions/setup-java@v2. For more info: https://github.blog/changelog/2023-06-13-github-actions-all-actions-will-run-on-node16-instead-of-node12-by-default/

Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, actions/setup-java@v2, burrunan/gradle-cache-action@v1. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.

The following actions uses node12 which is deprecated and will be forced to run on node16: actions/setup-java@v2. For more info: https://github.blog/changelog/2023-06-13-github-actions-all-actions-will-run-on-node16-instead-of-node12-by-default/

Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, actions/setup-java@v2, burrunan/gradle-cache-action@v1. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.

The following actions uses node12 which is deprecated and will be forced to run on node16: actions/setup-java@v2. For more info: https://github.blog/changelog/2023-06-13-github-actions-all-actions-will-run-on-node16-instead-of-node12-by-default/

Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, actions/setup-java@v2, burrunan/gradle-cache-action@v1. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.

The following actions uses node12 which is deprecated and will be forced to run on node16: actions/setup-java@v2. For more info: https://github.blog/changelog/2023-06-13-github-actions-all-actions-will-run-on-node16-instead-of-node12-by-default/

Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, actions/setup-java@v2, burrunan/gradle-cache-action@v1. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.