Skip to content

[CALCITE-6282] Avatica ignores time precision when returning TIME results #589

[CALCITE-6282] Avatica ignores time precision when returning TIME results

[CALCITE-6282] Avatica ignores time precision when returning TIME results #589

Triggered via pull request February 27, 2024 01:31
Status Failure
Total duration 9m 19s
Artifacts

main.yml

on: pull_request
Windows (JDK 11)
5m 21s
Windows (JDK 11)
Linux (JDK 8)
4m 11s
Linux (JDK 8)
Linux (JDK 8), Avatica main
9m 10s
Linux (JDK 8), Avatica main
Linux (JDK 11), Oldest Guava, Pacific/Chatham Timezone
4m 12s
Linux (JDK 11), Oldest Guava, Pacific/Chatham Timezone
Linux (JDK 11), Calcite Minimum Guava, America/New_York Timezone
3m 56s
Linux (JDK 11), Calcite Minimum Guava, America/New_York Timezone
Linux (JDK 11), Middle-Aged Guava
3m 53s
Linux (JDK 11), Middle-Aged Guava
Linux (JDK 11), Newest Guava
3m 57s
Linux (JDK 11), Newest Guava
Linux (JDK 17)
4m 19s
Linux (JDK 17)
Linux (JDK 19)
3m 53s
Linux (JDK 19)
macOS (JDK 19)
5m 8s
macOS (JDK 19)
Fit to window
Zoom out
Zoom in

Annotations

10 errors and 20 warnings
Linux (JDK 8), Avatica main: org.apache.calcite.test.CoreQuidemTest > test(String)[13%5D#L1
0.7sec org.apache.calcite.test.CoreQuidemTest > test(String)[13], [13] sql/operator.iq org.opentest4j.AssertionFailedError: Files differ: /home/runner/work/calcite-avatica/calcite/core/build/quidem/test/sql/operator.iq /home/runner/work/calcite-avatica/calcite/core/build/resources/test/sql/operator.iq 238,243c238,243 < +----------+-------+----------+----------+----------+----------+----------+----------+----------+----------+ < | 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 | < +----------+-------+----------+----------+----------+----------+----------+----------+----------+----------+ --- > +------------+-------+------------+------------+------------+------------+------------+------------+------------+------------+ > | 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 | > +------------+-------+------------+------------+------------+------------+------------+------------+------------+------------+ 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.TestMethod
Linux (JDK 8), Avatica main: org.apache.calcite.test.CalciteSqlOperatorTest > testCeilFuncDateTime()#L1
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" but: was "2015-02-19 12:34:57.00" 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:14245) 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:229) at org.apache.calcite.test.SqlOperatorTest.testCeilFuncDateTime(SqlOperatorTest.java:11357) 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
Linux (JDK 8), Avatica main: org.apache.calcite.test.CalciteSqlOperatorTest > testTimestampAdd()#L1
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" but: was "2016-02-24 12:42:27.000" 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:14245) 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:229) at org.apache.calcite.test.SqlOperatorTest.lambda$testTimestampAdd$61(SqlOperatorTest.java:11500) at java.util.Arrays$ArrayList.forEach(Arrays.java:3880) at org.apache.calcite.test.SqlOperatorTest.testTimestampAdd(SqlOperatorTest.java:11499) 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(
Linux (JDK 8), Avatica main: org.apache.calcite.test.CalciteSqlOperatorTest > testCurrentTimestampFuncWithFixedTime()#L1
0.0sec org.apache.calcite.test.CalciteSqlOperatorTest > testCurrentTimestampFuncWithFixedTime() org.opentest4j.AssertionFailedError: Query "values (CURRENT_TIMESTAMP(1))"returned '2014-09-07 17:08:48.0', expected '[0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9] [0-9][0-9]:[0-9][0-9]:[0-9][0-9]' at org.junit.jupiter.api.AssertionUtils.fail(AssertionUtils.java:38) at org.junit.jupiter.api.Assertions.fail(Assertions.java:135) at org.apache.calcite.sql.test.ResultCheckers.compareResultSetWithPattern(ResultCheckers.java:225) at org.apache.calcite.sql.test.ResultCheckers$PatternResultChecker.checkResult(ResultCheckers.java:302) at org.apache.calcite.test.SqlOperatorTest$TesterImpl.check(SqlOperatorTest.java:14245) 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:229) at org.apache.calcite.test.SqlOperatorTest.testCurrentTimestampFunc(SqlOperatorTest.java:8767) at org.apache.calcite.test.SqlOperatorTest.testCurrentTimestampFuncWithFixedTime(SqlOperatorTest.java:8753) 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
Linux (JDK 8), Avatica main: CoreQuidemTest.java#L103
9.1sec org.apache.calcite.test.CoreQuidemTest > test(String)[23], [23] sql/misc.iq org.opentest4j.AssertionFailedError: Files differ: /home/runner/work/calcite-avatica/calcite/core/build/quidem/test/sql/misc.iq /home/runner/work/calcite-avatica/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 | 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 | < +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ --- > +-------------------------+---------------------+---------------------+-----------------------+------------------------+-------------------------+-------------------------+-------------------------+ > | 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 | > +-------------------------+---------------------+---------------------+-----------------------+------------------------+-------------------------+-------------------------+-------------------------+ 2167,2171c2167,2171 < +---------------------+---------------------+--------+ < | EXPR$0 | EXPR$1 | EXPR$2 | < +---------------------+---------------------+--------+ < | 2016-02-26 19:06:00 | 2016-02-26 19:06:00 | 0 | < +---------------------+---------------------+--------+ --- > +-------------------------+---------------------+--------+ > | EXPR$0 | EXPR$1 | EXPR$2 | > +-------------------------+---------------------+--------+ > | 2016-02-26 19:06:00.123 | 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)
Linux (JDK 8), Avatica main: org.apache.calcite.test.CalciteSqlOperatorTest > testFloorFuncDateTime()#L1
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" but: was "2015-02-19 12:34:56.00" 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:14245) 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:229) at org.apache.calcite.test.SqlOperatorTest.testFloorFuncDateTime(SqlOperatorTest.java:11312) 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
Linux (JDK 8), Avatica main: org.apache.calcite.test.CoreQuidemTest > test(String)[26%5D#L1
0.2sec org.apache.calcite.test.CoreQuidemTest > test(String)[26], [26] sql/stream.iq org.opentest4j.AssertionFailedError: Files differ: /home/runner/work/calcite-avatica/calcite/core/build/quidem/test/sql/stream.iq /home/runner/work/calcite-avatica/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 | 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 | < +---------------------+----+---------+-------+---------------------+---------------------+ --- > +---------------------+----+---------+-------+-------------------------+-------------------------+ > | 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 | > +---------------------+----+---------+-------+-------------------------+-------------------------+ 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 | 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 | < +---------------------+----+---------+-------+---------------------+---------------------+ --- > +---------------------+----+---------+-------+-------------------------+-------------------------+ > | 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 | > +---------------------+----+---------+-------+-------------------------+-------------------------+ 53,61c53,61 < +---------------------+----+---------+-------+---------------------+---------------------+ < | ROWTIME | ID | PRODUCT | UNITS | window_start | window_end | < +---------------------+----+---------+-------+---------------------+-----
Linux (JDK 8), Avatica main: org.apache.calcite.test.CalciteSqlOperatorTest > testLocalTimeFuncWithFixedTime()#L1
0.0sec org.apache.calcite.test.CalciteSqlOperatorTest > testLocalTimeFuncWithFixedTime() org.opentest4j.AssertionFailedError: Query "values (LOCALTIME(1))"returned '17:08:48.0', expected '[0-9][0-9]:[0-9][0-9]:[0-9][0-9]' at org.junit.jupiter.api.AssertionUtils.fail(AssertionUtils.java:38) at org.junit.jupiter.api.Assertions.fail(Assertions.java:135) at org.apache.calcite.sql.test.ResultCheckers.compareResultSetWithPattern(ResultCheckers.java:225) at org.apache.calcite.sql.test.ResultCheckers$PatternResultChecker.checkResult(ResultCheckers.java:302) at org.apache.calcite.test.SqlOperatorTest$TesterImpl.check(SqlOperatorTest.java:14245) 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:229) at org.apache.calcite.test.SqlOperatorTest.testLocalTimeFunc(SqlOperatorTest.java:8674) at org.apache.calcite.test.SqlOperatorTest.testLocalTimeFuncWithFixedTime(SqlOperatorTest.java:8664) 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 or
Linux (JDK 8), Avatica main: org.apache.calcite.test.SqlOperatorUnparseTest > testCeilFuncDateTime()#L1
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" but: was "2015-02-19 12:34:57.00" 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:14245) 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)
Linux (JDK 8), Avatica main: org.apache.calcite.test.SqlOperatorUnparseTest > testTimestampAdd()#L1
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" but: was "2016-02-24 12:42:27.000" 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:14245) 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)
Linux (JDK 11), Middle-Aged Guava
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/setup-java@v2, actions/checkout@v3. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Linux (JDK 11), Middle-Aged Guava
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/
Linux (JDK 19)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/setup-java@v2, actions/checkout@v3. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Linux (JDK 19)
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/
Linux (JDK 11), Calcite Minimum Guava, America/New_York Timezone
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/setup-java@v2, actions/checkout@v3. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Linux (JDK 11), Calcite Minimum Guava, America/New_York Timezone
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/
Linux (JDK 11), Newest Guava
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/setup-java@v2, actions/checkout@v3. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Linux (JDK 11), Newest Guava
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/
Linux (JDK 11), Oldest Guava, Pacific/Chatham Timezone
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/setup-java@v2, actions/checkout@v3. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Linux (JDK 11), Oldest Guava, Pacific/Chatham Timezone
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/
Linux (JDK 8)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/setup-java@v2, actions/checkout@v3. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Linux (JDK 8)
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/
Linux (JDK 17)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/setup-java@v2, actions/checkout@v3. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Linux (JDK 17)
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/
macOS (JDK 19)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, actions/setup-java@v2. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
macOS (JDK 19)
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/
Windows (JDK 11)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, actions/setup-java@v2. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Windows (JDK 11)
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/
Linux (JDK 8), Avatica main
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/setup-java@v2, actions/checkout@v3. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Linux (JDK 8), Avatica main
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/