[CALCITE-6282] Avatica ignores time precision when returning TIME results #12257
Annotations
10 errors and 2 warnings
Test:
CoreQuidemTest.java#L103
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)
|
Test:
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.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
|
Test:
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.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
|
Test:
org.apache.calcite.test.CoreQuidemTest > test(String)[19%5D#L1
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 |
< +---------------------+----+---------+-------+-------------------------+-
|
Test:
org.apache.calcite.test.CoreQuidemTest > test(String)[27%5D#L1
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.
|
Test:
org.apache.calcite.test.SqlOperatorUnparseTest > testCeilFuncDateTime()#L1
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)
|
Test:
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.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)
|
Test:
org.apache.calcite.test.CalciteSqlOperatorTest > testFloorFuncDateTime()#L1
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
|
Test:
org.apache.calcite.test.SqlOperatorUnparseTest > testFloorFuncDateTime()#L1
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)
|
Test:
org.apache.calcite.test.SqlOperatorUnparseTest > testCastDateTime(CastType#L1
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)
|
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/
|
Loading