Skip to content

Improve messages for INTERVAL literal semantic errors #72285

Improve messages for INTERVAL literal semantic errors

Improve messages for INTERVAL literal semantic errors #72285

Triggered via pull request November 22, 2024 16:34
Status Failure
Total duration 45m 29s
Artifacts 73

ci.yml

on: pull_request
check-commits-dispatcher
33s
check-commits-dispatcher
build-test-matrix
1m 10s
build-test-matrix
Matrix: hive-tests
Matrix: maven-checks
Matrix: check-commit
Matrix: pt
Matrix: test
Fit to window
Zoom out
Zoom in

Annotations

10 errors
TestGoogleSheets.testSheetQueryWithNoDataInRangeFails: plugin/trino-google-sheets/src/test/java/io/trino/plugin/google/sheets/TestGoogleSheets.java#L281
Expecting throwable message: "Failed reading data from sheet: 1S625j2oTptRepg6Yci68fCYE1269tdoSjljNOmTgQ3U#number_text!D1:D1" to contain: "No non-empty cells found in sheet: 1S625j2oTptRepg6Yci68fCYE1269tdoSjljNOmTgQ3U#number_text!D1:D1" but did not. Throwable that failed the check: io.trino.testing.QueryFailedException: Failed reading data from sheet: 1S625j2oTptRepg6Yci68fCYE1269tdoSjljNOmTgQ3U#number_text!D1:D1 at io.trino.testing.AbstractTestingTrinoClient.execute(AbstractTestingTrinoClient.java:138) at io.trino.testing.DistributedQueryRunner.executeInternal(DistributedQueryRunner.java:565) at io.trino.testing.DistributedQueryRunner.execute(DistributedQueryRunner.java:548) at io.trino.sql.query.QueryAssertions$QueryAssert.lambda$new$1(QueryAssertions.java:317) at com.google.common.base.Suppliers$NonSerializableMemoizingSupplier.get(Suppliers.java:200) at org.assertj.core.api.ThrowableAssert.catchThrowable(ThrowableAssert.java:63) at org.assertj.core.api.AssertionsForClassTypes.catchThrowable(AssertionsForClassTypes.java:904) at org.assertj.core.api.Assertions.catchThrowable(Assertions.java:1470) at io.trino.testing.assertions.TrinoExceptionAssert.assertTrinoExceptionThrownBy(TrinoExceptionAssert.java:67) at io.trino.sql.query.QueryAssertions$QueryAssert.failure(QueryAssertions.java:400) at io.trino.plugin.google.sheets.TestGoogleSheets.testSheetQueryWithNoDataInRangeFails(TestGoogleSheets.java:281) at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103) at java.base/java.lang.reflect.Method.invoke(Method.java:580) at org.junit.platform.commons.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:767) 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.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$8(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:156) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask
TestGoogleSheets.testSheetQueryWithSheetAndColumnRange: plugin/trino-google-sheets/src/test/java/io/trino/plugin/google/sheets/TestGoogleSheets.java#L240
Execution of 'actual' query 20241122_164127_00007_zxdxj failed: SELECT * FROM TABLE(gsheets.system.sheet(id => '1S625j2oTptRepg6Yci68fCYE1269tdoSjljNOmTgQ3U', range => 'number_text!A1:A6'))WHERE number = number
TestGoogleSheets.testSheetQueryWithSheetAndRangeWithoutHeader: plugin/trino-google-sheets/src/test/java/io/trino/plugin/google/sheets/TestGoogleSheets.java#L215
Execution of 'actual' query 20241122_164225_00008_zxdxj failed: SELECT * FROM TABLE(gsheets.system.sheet(id => '1S625j2oTptRepg6Yci68fCYE1269tdoSjljNOmTgQ3U', range => 'number_text!A2:B6'))WHERE "1" = "1" and "one" = "one"
TestGoogleSheets.testSheetQueryWithSheetAndRowAndColumnRange: plugin/trino-google-sheets/src/test/java/io/trino/plugin/google/sheets/TestGoogleSheets.java#L254
Execution of 'actual' query 20241122_164225_00010_zxdxj failed: SELECT * FROM TABLE(gsheets.system.sheet(id => '1S625j2oTptRepg6Yci68fCYE1269tdoSjljNOmTgQ3U', range => 'number_text!B3:B5'))WHERE "two" = "two"
TestGoogleSheets.testSheetQuerySimple: plugin/trino-google-sheets/src/test/java/io/trino/plugin/google/sheets/TestGoogleSheets.java#L178
Execution of 'actual' query 20241122_164228_00029_zxdxj failed: SELECT * FROM TABLE(gsheets.system.sheet(id => '1S625j2oTptRepg6Yci68fCYE1269tdoSjljNOmTgQ3U'))
TestGoogleSheets.testSheetQueryFilter: plugin/trino-google-sheets/src/test/java/io/trino/plugin/google/sheets/TestGoogleSheets.java#L191
Execution of 'actual' query 20241122_164227_00024_zxdxj failed: SELECT * FROM TABLE(gsheets.system.sheet(id => '1S625j2oTptRepg6Yci68fCYE1269tdoSjljNOmTgQ3U'))WHERE number = '1' and text = 'one'
TestGoogleSheets.testSheetQueryWithSheet: plugin/trino-google-sheets/src/test/java/io/trino/plugin/google/sheets/TestGoogleSheets.java#L201
Execution of 'actual' query 20241122_164228_00028_zxdxj failed: SELECT * FROM TABLE(gsheets.system.sheet(id => '1S625j2oTptRepg6Yci68fCYE1269tdoSjljNOmTgQ3U', range => 'number_text'))
TestGoogleSheetsWithoutMetadataSheetId.testSheetQuerySimple: plugin/trino-google-sheets/src/test/java/io/trino/plugin/google/sheets/TestGoogleSheetsWithoutMetadataSheetId.java#L37
Execution of 'actual' query 20241122_164125_00000_v9xgy failed: SELECT * FROM TABLE(gsheets.system.sheet(id => '1S625j2oTptRepg6Yci68fCYE1269tdoSjljNOmTgQ3U'))
TestGoogleSheets.testSheetQueryWithSheetAndRowRange: plugin/trino-google-sheets/src/test/java/io/trino/plugin/google/sheets/TestGoogleSheets.java#L228
Execution of 'actual' query 20241122_164125_00000_zxdxj failed: SELECT * FROM TABLE(gsheets.system.sheet(id => '1S625j2oTptRepg6Yci68fCYE1269tdoSjljNOmTgQ3U', range => 'number_text!A1:B4'))WHERE number = number and text = text
test (plugin/trino-google-sheets)
Process completed with exit code 1.

Artifacts

Produced during runtime
Name Size
product tests and server tarball Expired
1.31 GB
results plugin_trino-google-sheets, ,
45.2 KB
test report client_trino-jdbc,plugin_trino-base-jdbc,plugin_trino-memory,plugin_trino-thrift, ,
706 KB
test report core_trino-main, ,
13.4 MB
test report lib_trino-filesystem,lib_trino-filesystem-azure,lib_trino-filesystem-manager,lib_trino-filesystem-s3
307 KB
test report lib_trino-hdfs, cloud-tests,
5.99 KB
test report lib_trino-orc,lib_trino-parquet, ,
999 KB
test report plugin_trino-bigquery, ,
92.7 KB
test report plugin_trino-cassandra, ,
149 KB
test report plugin_trino-clickhouse, ,
68.1 KB
test report plugin_trino-delta-lake, ,
1.09 MB
test report plugin_trino-delta-lake, fte-tests,
57.8 KB
test report plugin_trino-druid, ,
44.6 KB
test report plugin_trino-elasticsearch, ,
68.4 KB
test report plugin_trino-exasol, ,
36.8 KB
test report plugin_trino-google-sheets, ,
37.6 KB
test report plugin_trino-hive, ,
2.45 MB
test report plugin_trino-hive, fte-tests,
88.9 KB
test report plugin_trino-hive, test-parquet,
15.2 KB
test report plugin_trino-hudi, ,
187 KB
test report plugin_trino-iceberg, ,
1.35 MB
test report plugin_trino-iceberg, fte-tests,
68.7 KB
test report plugin_trino-iceberg, minio-and-avro,
124 KB
test report plugin_trino-ignite, ,
47.2 KB
test report plugin_trino-kafka, ,
239 KB
test report plugin_trino-kudu, ,
139 KB
test report plugin_trino-mariadb, ,
170 KB
test report plugin_trino-mongodb, ,
257 KB
test report plugin_trino-mysql, ,
263 KB
test report plugin_trino-openlineage, ,
50 KB
test report plugin_trino-opensearch, ,
103 KB
test report plugin_trino-oracle, ,
187 KB
test report plugin_trino-phoenix5, ,
46.6 KB
test report plugin_trino-pinot, ,
306 KB
test report plugin_trino-postgresql, ,
265 KB
test report plugin_trino-redis, ,
59.9 KB
test report plugin_trino-redshift, ,
25.2 KB
test report plugin_trino-resource-group-managers, ,
71.5 KB
test report plugin_trino-snowflake, ,
18.6 KB
test report plugin_trino-sqlserver, ,
253 KB
test report pt (apache-hive3, suite-hms-only, )
3.63 KB
test report pt (default, suite-1, )
15.6 KB
test report pt (default, suite-2, )
28.6 KB
test report pt (default, suite-3, )
18.9 KB
test report pt (default, suite-5, )
28.2 KB
test report pt (default, suite-6-non-generic, )
22.1 KB
test report pt (default, suite-7-non-generic, )
19.4 KB
test report pt (default, suite-all-connectors-smoke, )
884 Bytes
test report pt (default, suite-cassandra, )
977 Bytes
test report pt (default, suite-clickhouse, )
987 Bytes
test report pt (default, suite-clients, )
3.75 KB
test report pt (default, suite-compatibility, )
7.44 KB
test report pt (default, suite-delta-lake-oss, )
20.4 KB
test report pt (default, suite-functions, )
1.9 KB
test report pt (default, suite-hive-transactional, )
10.2 KB
test report pt (default, suite-hudi, )
3.26 KB
test report pt (default, suite-iceberg, )
27.7 KB
test report pt (default, suite-ignite, )
965 Bytes
test report pt (default, suite-kafka, )
8.52 KB
test report pt (default, suite-ldap, )
10.8 KB
test report pt (default, suite-mysql, )
2.44 KB
test report pt (default, suite-oauth2, )
7.59 KB
test report pt (default, suite-parquet, )
3 KB
test report pt (default, suite-storage-formats-detailed, )
3.64 KB
test report pt (default, suite-tpcds, )
4.89 KB
test report pt (default, suite-tpch, )
1.79 KB
test report test-jdbc-compatibility
26.5 KB
test report test-other-modules
1.5 MB
test report testing_trino-faulttolerant-tests, default,
59.8 KB
test report testing_trino-faulttolerant-tests, test-fault-tolerant-delta,
20.4 KB
test report testing_trino-faulttolerant-tests, test-fault-tolerant-hive,
203 KB
test report testing_trino-faulttolerant-tests, test-fault-tolerant-iceberg,
48.6 KB
test report testing_trino-tests, ,
1.79 MB