This is an automated email from the ASF dual-hosted git repository. gurwls223 pushed a commit to branch master in repository https://gitbox.apache.org/repos/asf/spark.git
The following commit(s) were added to refs/heads/master by this push: new 86b216752c4 [SPARK-39477][SQL] Remove "Number of queries" info from the golden files of SQLQueryTestSuite 86b216752c4 is described below commit 86b216752c41a2bedc06da3b28651b4a9aaa51ed Author: Gengliang Wang <gengli...@apache.org> AuthorDate: Wed Jun 15 20:19:39 2022 +0900 [SPARK-39477][SQL] Remove "Number of queries" info from the golden files of SQLQueryTestSuite ### What changes were proposed in this pull request? Remove "Number of queries" info from the golden files of SQLQueryTestSuite ### Why are the changes needed? At the beginning of each golden file, there is one line with the text "Number of queries...". I suggest removing it for the following reasons: - The text is actually useless, SQLQueryTestSuite compares the number of queries by splitting the input file with `-- !query`. - It causes code conflicts on backporting fixes to released branches. - It causes code conflict on the open PRs if there are other merged PRs that update the same golden files. I made this PR in 15 minutes, and Github shows that the PR conflicts with newly merged PRs already. <img width="929" alt="Screen Shot 2022-06-14 at 10 53 41 PM" src="https://user-images.githubusercontent.com/1097932/173753804-c82c47bf-ebd2-4698-bfe2-fa9ad6e1636a.png"> ### Does this PR introduce _any_ user-facing change? No ### How was this patch tested? Existing UT Closes #36875 from gengliangwang/removeNumberOfQueries. Authored-by: Gengliang Wang <gengli...@apache.org> Signed-off-by: Hyukjin Kwon <gurwls...@apache.org> --- .../resources/sql-tests/results/ansi/array.sql.out | 3 --- .../resources/sql-tests/results/ansi/cast.sql.out | 3 --- .../results/ansi/conditional-functions.sql.out | 3 --- .../resources/sql-tests/results/ansi/date.sql.out | 3 --- .../results/ansi/datetime-parsing-invalid.sql.out | 3 --- .../sql-tests/results/ansi/datetime-special.sql.out | 3 --- .../results/ansi/decimalArithmeticOperations.sql.out | 3 --- .../results/ansi/higher-order-functions.sql.out | 3 --- .../resources/sql-tests/results/ansi/interval.sql.out | 3 --- .../resources/sql-tests/results/ansi/literals.sql.out | 3 --- .../test/resources/sql-tests/results/ansi/map.sql.out | 3 --- .../results/ansi/parse-schema-string.sql.out | 3 --- .../sql-tests/results/ansi/string-functions.sql.out | 3 --- .../sql-tests/results/ansi/timestamp.sql.out | 3 --- .../sql-tests/results/ansi/try_aggregates.sql.out | 3 --- .../sql-tests/results/ansi/try_arithmetic.sql.out | 3 --- .../sql-tests/results/ansi/try_element_at.sql.out | 3 --- .../test/resources/sql-tests/results/array.sql.out | 3 --- .../test/resources/sql-tests/results/bitwise.sql.out | 3 --- .../src/test/resources/sql-tests/results/cast.sql.out | 3 --- .../results/ceil-floor-with-scale-param.sql.out | 3 --- .../resources/sql-tests/results/change-column.sql.out | 3 --- .../resources/sql-tests/results/charvarchar.sql.out | 3 --- .../results/columnresolution-negative.sql.out | 3 --- .../sql-tests/results/columnresolution-views.sql.out | 3 --- .../sql-tests/results/columnresolution.sql.out | 3 --- .../test/resources/sql-tests/results/comments.sql.out | 3 --- .../resources/sql-tests/results/comparator.sql.out | 3 --- .../test/resources/sql-tests/results/count.sql.out | 3 --- .../resources/sql-tests/results/cross-join.sql.out | 3 --- .../resources/sql-tests/results/csv-functions.sql.out | 3 --- .../resources/sql-tests/results/cte-legacy.sql.out | 3 --- .../resources/sql-tests/results/cte-nested.sql.out | 3 --- .../resources/sql-tests/results/cte-nonlegacy.sql.out | 3 --- .../src/test/resources/sql-tests/results/cte.sql.out | 3 --- .../results/current_database_catalog.sql.out | 3 --- .../src/test/resources/sql-tests/results/date.sql.out | 3 --- .../results/datetime-formatting-invalid.sql.out | 3 --- .../results/datetime-formatting-legacy.sql.out | 3 --- .../sql-tests/results/datetime-formatting.sql.out | 3 --- .../sql-tests/results/datetime-legacy.sql.out | 3 --- .../results/datetime-parsing-invalid.sql.out | 3 --- .../sql-tests/results/datetime-parsing-legacy.sql.out | 3 --- .../sql-tests/results/datetime-parsing.sql.out | 3 --- .../sql-tests/results/datetime-special.sql.out | 3 --- .../results/decimalArithmeticOperations.sql.out | 3 --- .../results/describe-part-after-analyze.sql.out | 3 --- .../sql-tests/results/describe-query.sql.out | 3 --- .../results/describe-table-after-alter-table.sql.out | 3 --- .../sql-tests/results/describe-table-column.sql.out | 3 --- .../test/resources/sql-tests/results/describe.sql.out | 3 --- .../resources/sql-tests/results/except-all.sql.out | 3 --- .../test/resources/sql-tests/results/except.sql.out | 3 --- .../resources/sql-tests/results/explain-aqe.sql.out | 3 --- .../resources/sql-tests/results/explain-cbo.sql.out | 3 --- .../test/resources/sql-tests/results/explain.sql.out | 3 --- .../test/resources/sql-tests/results/extract.sql.out | 3 --- .../sql-tests/results/group-analytics.sql.out | 3 --- .../sql-tests/results/group-by-filter.sql.out | 3 --- .../sql-tests/results/group-by-ordinal.sql.out | 3 --- .../test/resources/sql-tests/results/group-by.sql.out | 3 --- .../resources/sql-tests/results/grouping_set.sql.out | 3 --- .../test/resources/sql-tests/results/having.sql.out | 3 --- .../sql-tests/results/higher-order-functions.sql.out | 3 --- .../resources/sql-tests/results/ilike-all.sql.out | 3 --- .../resources/sql-tests/results/ilike-any.sql.out | 3 --- .../test/resources/sql-tests/results/ilike.sql.out | 3 --- .../resources/sql-tests/results/inline-table.sql.out | 3 --- .../resources/sql-tests/results/inner-join.sql.out | 3 --- .../resources/sql-tests/results/intersect-all.sql.out | 3 --- .../test/resources/sql-tests/results/interval.sql.out | 3 --- .../sql-tests/results/join-empty-relation.sql.out | 3 --- .../resources/sql-tests/results/join-lateral.sql.out | 3 --- .../sql-tests/results/json-functions.sql.out | 3 --- .../test/resources/sql-tests/results/like-all.sql.out | 3 --- .../test/resources/sql-tests/results/like-any.sql.out | 3 --- .../test/resources/sql-tests/results/limit.sql.out | 3 --- .../sql-tests/results/linear-regression.sql.out | 3 --- .../test/resources/sql-tests/results/literals.sql.out | 3 --- .../src/test/resources/sql-tests/results/map.sql.out | 3 --- .../sql-tests/results/misc-functions.sql.out | 3 --- .../resources/sql-tests/results/natural-join.sql.out | 3 --- .../sql-tests/results/non-excludable-rule.sql.out | 3 --- .../resources/sql-tests/results/null-handling.sql.out | 3 --- .../sql-tests/results/null-propagation.sql.out | 3 --- .../resources/sql-tests/results/operators.sql.out | 3 --- .../sql-tests/results/order-by-nulls-ordering.sql.out | 3 --- .../sql-tests/results/order-by-ordinal.sql.out | 3 --- .../resources/sql-tests/results/outer-join.sql.out | 3 --- .../sql-tests/results/parse-schema-string.sql.out | 3 --- .../resources/sql-tests/results/percentiles.sql.out | 3 --- .../test/resources/sql-tests/results/pivot.sql.out | 3 --- .../results/postgreSQL/aggregates_part1.sql.out | 3 --- .../results/postgreSQL/aggregates_part2.sql.out | 3 --- .../results/postgreSQL/aggregates_part3.sql.out | 3 --- .../results/postgreSQL/aggregates_part4.sql.out | 3 --- .../sql-tests/results/postgreSQL/boolean.sql.out | 3 --- .../sql-tests/results/postgreSQL/case.sql.out | 3 --- .../sql-tests/results/postgreSQL/comments.sql.out | 3 --- .../sql-tests/results/postgreSQL/create_view.sql.out | 3 --- .../sql-tests/results/postgreSQL/date.sql.out | 3 --- .../sql-tests/results/postgreSQL/float4.sql.out | 3 --- .../sql-tests/results/postgreSQL/float8.sql.out | 3 --- .../sql-tests/results/postgreSQL/groupingsets.sql.out | 3 --- .../sql-tests/results/postgreSQL/insert.sql.out | 3 --- .../sql-tests/results/postgreSQL/int2.sql.out | 3 --- .../sql-tests/results/postgreSQL/int4.sql.out | 3 --- .../sql-tests/results/postgreSQL/int8.sql.out | 3 --- .../sql-tests/results/postgreSQL/interval.sql.out | 3 --- .../sql-tests/results/postgreSQL/join.sql.out | 3 --- .../sql-tests/results/postgreSQL/limit.sql.out | 3 --- .../sql-tests/results/postgreSQL/numeric.sql.out | 3 --- .../sql-tests/results/postgreSQL/select.sql.out | 3 --- .../results/postgreSQL/select_distinct.sql.out | 3 --- .../results/postgreSQL/select_having.sql.out | 3 --- .../results/postgreSQL/select_implicit.sql.out | 3 --- .../sql-tests/results/postgreSQL/strings.sql.out | 3 --- .../sql-tests/results/postgreSQL/text.sql.out | 3 --- .../sql-tests/results/postgreSQL/timestamp.sql.out | 3 --- .../sql-tests/results/postgreSQL/union.sql.out | 3 --- .../sql-tests/results/postgreSQL/window_part1.sql.out | 3 --- .../sql-tests/results/postgreSQL/window_part2.sql.out | 3 --- .../sql-tests/results/postgreSQL/window_part3.sql.out | 3 --- .../sql-tests/results/postgreSQL/window_part4.sql.out | 3 --- .../sql-tests/results/postgreSQL/with.sql.out | 3 --- .../resources/sql-tests/results/pred-pushdown.sql.out | 3 --- .../sql-tests/results/predicate-functions.sql.out | 3 --- .../sql-tests/results/query_regex_column.sql.out | 3 --- .../test/resources/sql-tests/results/random.sql.out | 3 --- .../sql-tests/results/regexp-functions.sql.out | 3 --- .../sql-tests/results/show-create-table.sql.out | 3 --- .../resources/sql-tests/results/show-tables.sql.out | 3 --- .../sql-tests/results/show-tblproperties.sql.out | 3 --- .../resources/sql-tests/results/show-views.sql.out | 3 --- .../resources/sql-tests/results/show_columns.sql.out | 3 --- .../results/sql-compatibility-functions.sql.out | 3 --- .../sql-tests/results/string-functions.sql.out | 3 --- .../test/resources/sql-tests/results/struct.sql.out | 3 --- .../sql-tests/results/subexp-elimination.sql.out | 3 --- .../subquery/exists-subquery/exists-aggregate.sql.out | 3 --- .../subquery/exists-subquery/exists-basic.sql.out | 3 --- .../subquery/exists-subquery/exists-cte.sql.out | 3 --- .../subquery/exists-subquery/exists-having.sql.out | 3 --- .../exists-subquery/exists-joins-and-set-ops.sql.out | 3 --- .../exists-subquery/exists-orderby-limit.sql.out | 3 --- .../exists-subquery/exists-outside-filter.sql.out | 3 --- .../exists-subquery/exists-within-and-or.sql.out | 3 --- .../results/subquery/in-subquery/in-basic.sql.out | 3 --- .../results/subquery/in-subquery/in-group-by.sql.out | 3 --- .../results/subquery/in-subquery/in-having.sql.out | 3 --- .../results/subquery/in-subquery/in-joins.sql.out | 3 --- .../results/subquery/in-subquery/in-limit.sql.out | 3 --- .../subquery/in-subquery/in-multiple-columns.sql.out | 3 --- .../results/subquery/in-subquery/in-order-by.sql.out | 3 --- .../subquery/in-subquery/in-set-operations.sql.out | 3 --- .../results/subquery/in-subquery/in-with-cte.sql.out | 3 --- .../subquery/in-subquery/nested-not-in.sql.out | 3 --- .../subquery/in-subquery/not-in-group-by.sql.out | 3 --- .../results/subquery/in-subquery/not-in-joins.sql.out | 3 --- .../not-in-unit-tests-multi-column-literal.sql.out | 3 --- .../not-in-unit-tests-multi-column.sql.out | 3 --- .../not-in-unit-tests-single-column-literal.sql.out | 3 --- .../not-in-unit-tests-single-column.sql.out | 3 --- .../results/subquery/in-subquery/simple-in.sql.out | 3 --- .../negative-cases/invalid-correlation.sql.out | 3 --- .../negative-cases/subq-input-typecheck.sql.out | 3 --- .../scalar-subquery/scalar-subquery-predicate.sql.out | 3 --- .../scalar-subquery/scalar-subquery-select.sql.out | 3 --- .../results/subquery/subquery-in-from.sql.out | 3 --- .../resources/sql-tests/results/table-aliases.sql.out | 3 --- .../sql-tests/results/table-valued-functions.sql.out | 3 --- .../sql-tests/results/tablesample-negative.sql.out | 3 --- .../resources/sql-tests/results/timestamp-ltz.sql.out | 3 --- .../resources/sql-tests/results/timestamp-ntz.sql.out | 3 --- .../resources/sql-tests/results/timestamp.sql.out | 3 --- .../results/timestampNTZ/datetime-special.sql.out | 3 --- .../results/timestampNTZ/timestamp-ansi.sql.out | 3 --- .../sql-tests/results/timestampNTZ/timestamp.sql.out | 3 --- .../test/resources/sql-tests/results/timezone.sql.out | 3 --- .../resources/sql-tests/results/transform.sql.out | 3 --- .../sql-tests/results/try-string-functions.sql.out | Bin 1925 -> 1898 bytes .../sql-tests/results/try_aggregates.sql.out | 3 --- .../sql-tests/results/try_arithmetic.sql.out | 3 --- .../test/resources/sql-tests/results/try_cast.sql.out | 3 --- .../sql-tests/results/try_element_at.sql.out | 3 --- .../results/typeCoercion/native/arrayJoin.sql.out | 3 --- .../typeCoercion/native/binaryComparison.sql.out | 3 --- .../typeCoercion/native/booleanEquality.sql.out | 3 --- .../typeCoercion/native/caseWhenCoercion.sql.out | 3 --- .../results/typeCoercion/native/concat.sql.out | 3 --- .../typeCoercion/native/dateTimeOperations.sql.out | 3 --- .../typeCoercion/native/decimalPrecision.sql.out | 3 --- .../results/typeCoercion/native/division.sql.out | 3 --- .../sql-tests/results/typeCoercion/native/elt.sql.out | 3 --- .../results/typeCoercion/native/ifCoercion.sql.out | 3 --- .../typeCoercion/native/implicitTypeCasts.sql.out | 3 --- .../results/typeCoercion/native/inConversion.sql.out | 3 --- .../results/typeCoercion/native/mapZipWith.sql.out | 3 --- .../results/typeCoercion/native/mapconcat.sql.out | 3 --- .../typeCoercion/native/promoteStrings.sql.out | 3 --- .../native/stringCastAndExpressions.sql.out | 3 --- .../native/widenSetOperationTypes.sql.out | 3 --- .../typeCoercion/native/windowFrameCoercion.sql.out | 3 --- .../src/test/resources/sql-tests/results/udaf.sql.out | 3 --- .../udf/postgreSQL/udf-aggregates_part1.sql.out | 3 --- .../udf/postgreSQL/udf-aggregates_part2.sql.out | 3 --- .../udf/postgreSQL/udf-aggregates_part3.sql.out | 3 --- .../udf/postgreSQL/udf-aggregates_part4.sql.out | 3 --- .../sql-tests/results/udf/postgreSQL/udf-case.sql.out | 3 --- .../sql-tests/results/udf/postgreSQL/udf-join.sql.out | 3 --- .../results/udf/postgreSQL/udf-select_having.sql.out | 3 --- .../udf/postgreSQL/udf-select_implicit.sql.out | 3 --- .../resources/sql-tests/results/udf/udf-count.sql.out | 3 --- .../sql-tests/results/udf/udf-cross-join.sql.out | 3 --- .../sql-tests/results/udf/udf-except-all.sql.out | 3 --- .../sql-tests/results/udf/udf-except.sql.out | 3 --- .../sql-tests/results/udf/udf-group-analytics.sql.out | 3 --- .../sql-tests/results/udf/udf-group-by.sql.out | 3 --- .../sql-tests/results/udf/udf-having.sql.out | 3 --- .../sql-tests/results/udf/udf-inline-table.sql.out | 3 --- .../sql-tests/results/udf/udf-inner-join.sql.out | 3 --- .../sql-tests/results/udf/udf-intersect-all.sql.out | 3 --- .../results/udf/udf-join-empty-relation.sql.out | 3 --- .../sql-tests/results/udf/udf-natural-join.sql.out | 3 --- .../sql-tests/results/udf/udf-outer-join.sql.out | 3 --- .../resources/sql-tests/results/udf/udf-pivot.sql.out | 3 --- .../sql-tests/results/udf/udf-special-values.sql.out | 3 --- .../resources/sql-tests/results/udf/udf-udaf.sql.out | 3 --- .../resources/sql-tests/results/udf/udf-union.sql.out | 3 --- .../sql-tests/results/udf/udf-window.sql.out | 3 --- .../test/resources/sql-tests/results/union.sql.out | 3 --- .../resources/sql-tests/results/using-join.sql.out | 3 --- .../test/resources/sql-tests/results/window.sql.out | 3 --- .../org/apache/spark/sql/SQLQueryTestSuite.scala | 1 - 234 files changed, 697 deletions(-) diff --git a/sql/core/src/test/resources/sql-tests/results/ansi/array.sql.out b/sql/core/src/test/resources/sql-tests/results/ansi/array.sql.out index f94a740f790..6e2d2e478bc 100644 --- a/sql/core/src/test/resources/sql-tests/results/ansi/array.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/ansi/array.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 38 - - -- !query create temporary view data as select * from values ("one", array(11, 12, 13), array(array(111, 112, 113), array(121, 122, 123))), diff --git a/sql/core/src/test/resources/sql-tests/results/ansi/cast.sql.out b/sql/core/src/test/resources/sql-tests/results/ansi/cast.sql.out index b05a85d2927..11753f2b5ca 100644 --- a/sql/core/src/test/resources/sql-tests/results/ansi/cast.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/ansi/cast.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 81 - - -- !query SELECT CAST('1.23' AS int) -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/ansi/conditional-functions.sql.out b/sql/core/src/test/resources/sql-tests/results/ansi/conditional-functions.sql.out index e62654c3e23..bdfbb9404b2 100644 --- a/sql/core/src/test/resources/sql-tests/results/ansi/conditional-functions.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/ansi/conditional-functions.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 14 - - -- !query CREATE TABLE conditional_t USING PARQUET AS SELECT c1, c2 FROM VALUES(1d, 0),(2d, 1),(null, 1),(CAST('NaN' AS DOUBLE), 0) AS t(c1, c2) -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/ansi/date.sql.out b/sql/core/src/test/resources/sql-tests/results/ansi/date.sql.out index 49bd9934b11..f02c1b3053a 100644 --- a/sql/core/src/test/resources/sql-tests/results/ansi/date.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/ansi/date.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 97 - - -- !query create temporary view date_view as select '2011-11-11' date_str, '1' int_str -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/ansi/datetime-parsing-invalid.sql.out b/sql/core/src/test/resources/sql-tests/results/ansi/datetime-parsing-invalid.sql.out index 4891a6885a7..b927e242168 100644 --- a/sql/core/src/test/resources/sql-tests/results/ansi/datetime-parsing-invalid.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/ansi/datetime-parsing-invalid.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 28 - - -- !query select to_timestamp('294248', 'y') -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/ansi/datetime-special.sql.out b/sql/core/src/test/resources/sql-tests/results/ansi/datetime-special.sql.out index d60811f0a97..4f7ecf4b03f 100644 --- a/sql/core/src/test/resources/sql-tests/results/ansi/datetime-special.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/ansi/datetime-special.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 4 - - -- !query select date'999999-03-18', date'-0001-1-28', date'0015' -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/ansi/decimalArithmeticOperations.sql.out b/sql/core/src/test/resources/sql-tests/results/ansi/decimalArithmeticOperations.sql.out index ec4174c212e..ab46a74f9c9 100644 --- a/sql/core/src/test/resources/sql-tests/results/ansi/decimalArithmeticOperations.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/ansi/decimalArithmeticOperations.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 24 - - -- !query create table decimals_test(id int, a decimal(38,18), b decimal(38,18)) using parquet -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/ansi/higher-order-functions.sql.out b/sql/core/src/test/resources/sql-tests/results/ansi/higher-order-functions.sql.out index 7b31b569099..c6bbb4fb717 100644 --- a/sql/core/src/test/resources/sql-tests/results/ansi/higher-order-functions.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/ansi/higher-order-functions.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 30 - - -- !query create or replace temporary view nested as values (1, array(32, 97), array(array(12, 99), array(123, 42), array(1))), diff --git a/sql/core/src/test/resources/sql-tests/results/ansi/interval.sql.out b/sql/core/src/test/resources/sql-tests/results/ansi/interval.sql.out index d0f2be0d519..d79cc37ab78 100644 --- a/sql/core/src/test/resources/sql-tests/results/ansi/interval.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/ansi/interval.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 286 - - -- !query select 3 * (timestamp'2019-10-15 10:11:12.001002' - date'2019-10-15') -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/ansi/literals.sql.out b/sql/core/src/test/resources/sql-tests/results/ansi/literals.sql.out index f6341caed81..6edd513ea2f 100644 --- a/sql/core/src/test/resources/sql-tests/results/ansi/literals.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/ansi/literals.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 54 - - -- !query select null, Null, nUll -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/ansi/map.sql.out b/sql/core/src/test/resources/sql-tests/results/ansi/map.sql.out index 14df691c003..c9d4186a27b 100644 --- a/sql/core/src/test/resources/sql-tests/results/ansi/map.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/ansi/map.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 14 - - -- !query select element_at(map(1, 'a', 2, 'b'), 5) -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/ansi/parse-schema-string.sql.out b/sql/core/src/test/resources/sql-tests/results/ansi/parse-schema-string.sql.out index 4440dd763bd..793b545b324 100644 --- a/sql/core/src/test/resources/sql-tests/results/ansi/parse-schema-string.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/ansi/parse-schema-string.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 4 - - -- !query select from_csv('1', 'create INT') -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/ansi/string-functions.sql.out b/sql/core/src/test/resources/sql-tests/results/ansi/string-functions.sql.out index 5193eaf5f4b..899135610fc 100644 --- a/sql/core/src/test/resources/sql-tests/results/ansi/string-functions.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/ansi/string-functions.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 143 - - -- !query select concat_ws() -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/ansi/timestamp.sql.out b/sql/core/src/test/resources/sql-tests/results/ansi/timestamp.sql.out index 4427a174b51..bb730bb94ae 100644 --- a/sql/core/src/test/resources/sql-tests/results/ansi/timestamp.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/ansi/timestamp.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 98 - - -- !query select timestamp '2019-01-01\t' -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/ansi/try_aggregates.sql.out b/sql/core/src/test/resources/sql-tests/results/ansi/try_aggregates.sql.out index 724553f6bd1..862f2488c5f 100644 --- a/sql/core/src/test/resources/sql-tests/results/ansi/try_aggregates.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/ansi/try_aggregates.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 20 - - -- !query SELECT try_sum(col) FROM VALUES (5), (10), (15) AS tab(col) -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/ansi/try_arithmetic.sql.out b/sql/core/src/test/resources/sql-tests/results/ansi/try_arithmetic.sql.out index f3c483cfafe..8622b97a205 100644 --- a/sql/core/src/test/resources/sql-tests/results/ansi/try_arithmetic.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/ansi/try_arithmetic.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 49 - - -- !query SELECT try_add(1, 1) -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/ansi/try_element_at.sql.out b/sql/core/src/test/resources/sql-tests/results/ansi/try_element_at.sql.out index 80709678c87..c1c0980ea52 100644 --- a/sql/core/src/test/resources/sql-tests/results/ansi/try_element_at.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/ansi/try_element_at.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 8 - - -- !query SELECT try_element_at(array(1, 2, 3), 0) -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/array.sql.out b/sql/core/src/test/resources/sql-tests/results/array.sql.out index 1ff2a1790ce..78f4c85fa05 100644 --- a/sql/core/src/test/resources/sql-tests/results/array.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/array.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 29 - - -- !query create temporary view data as select * from values ("one", array(11, 12, 13), array(array(111, 112, 113), array(121, 122, 123))), diff --git a/sql/core/src/test/resources/sql-tests/results/bitwise.sql.out b/sql/core/src/test/resources/sql-tests/results/bitwise.sql.out index 649cf21b51e..84d2e9e50ba 100644 --- a/sql/core/src/test/resources/sql-tests/results/bitwise.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/bitwise.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 32 - - -- !query select bit_count(null) -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/cast.sql.out b/sql/core/src/test/resources/sql-tests/results/cast.sql.out index dbb32a5ed31..9c00e1b985e 100644 --- a/sql/core/src/test/resources/sql-tests/results/cast.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/cast.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 81 - - -- !query SELECT CAST('1.23' AS int) -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/ceil-floor-with-scale-param.sql.out b/sql/core/src/test/resources/sql-tests/results/ceil-floor-with-scale-param.sql.out index 84eb503c07b..38efdac4092 100644 --- a/sql/core/src/test/resources/sql-tests/results/ceil-floor-with-scale-param.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/ceil-floor-with-scale-param.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 28 - - -- !query SELECT CEIL(2.5, 0) -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/change-column.sql.out b/sql/core/src/test/resources/sql-tests/results/change-column.sql.out index 07e8bdad1f9..ed5871d3855 100644 --- a/sql/core/src/test/resources/sql-tests/results/change-column.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/change-column.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 28 - - -- !query CREATE TABLE test_change(a INT, b STRING, c INT) using parquet -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/charvarchar.sql.out b/sql/core/src/test/resources/sql-tests/results/charvarchar.sql.out index 6345702e00e..94c8fb7a3f5 100644 --- a/sql/core/src/test/resources/sql-tests/results/charvarchar.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/charvarchar.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 83 - - -- !query create table char_tbl(c char(5), v varchar(6)) using parquet -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/columnresolution-negative.sql.out b/sql/core/src/test/resources/sql-tests/results/columnresolution-negative.sql.out index 03ba62c314a..0dc27fdca15 100644 --- a/sql/core/src/test/resources/sql-tests/results/columnresolution-negative.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/columnresolution-negative.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 28 - - -- !query CREATE DATABASE mydb1 -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/columnresolution-views.sql.out b/sql/core/src/test/resources/sql-tests/results/columnresolution-views.sql.out index 16ff4f51bd5..91e1eb8ee5d 100644 --- a/sql/core/src/test/resources/sql-tests/results/columnresolution-views.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/columnresolution-views.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 17 - - -- !query CREATE OR REPLACE TEMPORARY VIEW view1 AS SELECT 2 AS i1 -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/columnresolution.sql.out b/sql/core/src/test/resources/sql-tests/results/columnresolution.sql.out index dcfd48b687b..80ddd32db21 100644 --- a/sql/core/src/test/resources/sql-tests/results/columnresolution.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/columnresolution.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 55 - - -- !query CREATE DATABASE mydb1 -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/comments.sql.out b/sql/core/src/test/resources/sql-tests/results/comments.sql.out index da9dbd5fa32..f05d188740f 100644 --- a/sql/core/src/test/resources/sql-tests/results/comments.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/comments.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 12 - - -- !query /* This is the first example of bracketed comment. SELECT 'ommented out content' AS first; diff --git a/sql/core/src/test/resources/sql-tests/results/comparator.sql.out b/sql/core/src/test/resources/sql-tests/results/comparator.sql.out index a19b3228a7f..f979a0ef609 100644 --- a/sql/core/src/test/resources/sql-tests/results/comparator.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/comparator.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 10 - - -- !query select x'00' < x'0f' -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/count.sql.out b/sql/core/src/test/resources/sql-tests/results/count.sql.out index c0a04a1ddff..ab9b543a9f8 100644 --- a/sql/core/src/test/resources/sql-tests/results/count.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/count.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 21 - - -- !query CREATE OR REPLACE TEMPORARY VIEW testData AS SELECT * FROM VALUES (1, 1), (1, 2), (2, 1), (1, 1), (null, 2), (1, null), (null, null) diff --git a/sql/core/src/test/resources/sql-tests/results/cross-join.sql.out b/sql/core/src/test/resources/sql-tests/results/cross-join.sql.out index ce2305cb7ec..5be5883df01 100644 --- a/sql/core/src/test/resources/sql-tests/results/cross-join.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/cross-join.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 13 - - -- !query create temporary view nt1 as select * from values ("one", 1), diff --git a/sql/core/src/test/resources/sql-tests/results/csv-functions.sql.out b/sql/core/src/test/resources/sql-tests/results/csv-functions.sql.out index d6a3de30f63..301e5cc78df 100644 --- a/sql/core/src/test/resources/sql-tests/results/csv-functions.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/csv-functions.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 17 - - -- !query select from_csv('1, 3.14', 'a INT, f FLOAT') -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/cte-legacy.sql.out b/sql/core/src/test/resources/sql-tests/results/cte-legacy.sql.out index db7d420a745..34f11d9da53 100644 --- a/sql/core/src/test/resources/sql-tests/results/cte-legacy.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/cte-legacy.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 17 - - -- !query WITH t as ( WITH t2 AS (SELECT 1) diff --git a/sql/core/src/test/resources/sql-tests/results/cte-nested.sql.out b/sql/core/src/test/resources/sql-tests/results/cte-nested.sql.out index f714a11d1df..13b4d10304e 100644 --- a/sql/core/src/test/resources/sql-tests/results/cte-nested.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/cte-nested.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 17 - - -- !query WITH t as ( WITH t2 AS (SELECT 1) diff --git a/sql/core/src/test/resources/sql-tests/results/cte-nonlegacy.sql.out b/sql/core/src/test/resources/sql-tests/results/cte-nonlegacy.sql.out index 2ab13003d04..7da691363fd 100644 --- a/sql/core/src/test/resources/sql-tests/results/cte-nonlegacy.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/cte-nonlegacy.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 17 - - -- !query WITH t as ( WITH t2 AS (SELECT 1) diff --git a/sql/core/src/test/resources/sql-tests/results/cte.sql.out b/sql/core/src/test/resources/sql-tests/results/cte.sql.out index fd6eb833d66..21faff0d321 100644 --- a/sql/core/src/test/resources/sql-tests/results/cte.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/cte.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 15 - - -- !query create temporary view t as select * from values 0, 1, 2 as t(id) -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/current_database_catalog.sql.out b/sql/core/src/test/resources/sql-tests/results/current_database_catalog.sql.out index b714463a0aa..9b1ca765978 100644 --- a/sql/core/src/test/resources/sql-tests/results/current_database_catalog.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/current_database_catalog.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 1 - - -- !query select current_database(), current_catalog() -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/date.sql.out b/sql/core/src/test/resources/sql-tests/results/date.sql.out index f5df5f7577d..7eb12a635cf 100644 --- a/sql/core/src/test/resources/sql-tests/results/date.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/date.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 97 - - -- !query create temporary view date_view as select '2011-11-11' date_str, '1' int_str -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/datetime-formatting-invalid.sql.out b/sql/core/src/test/resources/sql-tests/results/datetime-formatting-invalid.sql.out index dee770a916e..d565dfd7bae 100644 --- a/sql/core/src/test/resources/sql-tests/results/datetime-formatting-invalid.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/datetime-formatting-invalid.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 37 - - -- !query select date_format('2018-11-17 13:33:33.333', 'GGGGG') -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/datetime-formatting-legacy.sql.out b/sql/core/src/test/resources/sql-tests/results/datetime-formatting-legacy.sql.out index b37922b2080..ed43af9cb51 100644 --- a/sql/core/src/test/resources/sql-tests/results/datetime-formatting-legacy.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/datetime-formatting-legacy.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 31 - - -- !query create temporary view v as select col from values (timestamp '1582-06-01 11:33:33.123UTC+080000'), diff --git a/sql/core/src/test/resources/sql-tests/results/datetime-formatting.sql.out b/sql/core/src/test/resources/sql-tests/results/datetime-formatting.sql.out index 5bed88e168f..960de2af4a3 100644 --- a/sql/core/src/test/resources/sql-tests/results/datetime-formatting.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/datetime-formatting.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 31 - - -- !query create temporary view v as select col from values (timestamp '1582-06-01 11:33:33.123UTC+080000'), diff --git a/sql/core/src/test/resources/sql-tests/results/datetime-legacy.sql.out b/sql/core/src/test/resources/sql-tests/results/datetime-legacy.sql.out index 08c64b35739..5ff20b35d5e 100644 --- a/sql/core/src/test/resources/sql-tests/results/datetime-legacy.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/datetime-legacy.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 195 - - -- !query create temporary view date_view as select '2011-11-11' date_str, '1' int_str -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/datetime-parsing-invalid.sql.out b/sql/core/src/test/resources/sql-tests/results/datetime-parsing-invalid.sql.out index 66b5e2fc3d6..6de89f9eda4 100644 --- a/sql/core/src/test/resources/sql-tests/results/datetime-parsing-invalid.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/datetime-parsing-invalid.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 28 - - -- !query select to_timestamp('294248', 'y') -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/datetime-parsing-legacy.sql.out b/sql/core/src/test/resources/sql-tests/results/datetime-parsing-legacy.sql.out index bb7ce74a29e..97908f782ad 100644 --- a/sql/core/src/test/resources/sql-tests/results/datetime-parsing-legacy.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/datetime-parsing-legacy.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 25 - - -- !query select to_timestamp('1', 'y') -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/datetime-parsing.sql.out b/sql/core/src/test/resources/sql-tests/results/datetime-parsing.sql.out index 98146a189a0..a28e2d33cba 100644 --- a/sql/core/src/test/resources/sql-tests/results/datetime-parsing.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/datetime-parsing.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 25 - - -- !query select to_timestamp('1', 'y') -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/datetime-special.sql.out b/sql/core/src/test/resources/sql-tests/results/datetime-special.sql.out index d60811f0a97..4f7ecf4b03f 100644 --- a/sql/core/src/test/resources/sql-tests/results/datetime-special.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/datetime-special.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 4 - - -- !query select date'999999-03-18', date'-0001-1-28', date'0015' -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/decimalArithmeticOperations.sql.out b/sql/core/src/test/resources/sql-tests/results/decimalArithmeticOperations.sql.out index c0ab65f41bc..42e60398184 100644 --- a/sql/core/src/test/resources/sql-tests/results/decimalArithmeticOperations.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/decimalArithmeticOperations.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 55 - - -- !query CREATE TEMPORARY VIEW t AS SELECT 1.0 as a, 0.0 as b -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/describe-part-after-analyze.sql.out b/sql/core/src/test/resources/sql-tests/results/describe-part-after-analyze.sql.out index 24927c34c57..b04ad638dd2 100644 --- a/sql/core/src/test/resources/sql-tests/results/describe-part-after-analyze.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/describe-part-after-analyze.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 15 - - -- !query CREATE TABLE t (key STRING, value STRING, ds STRING, hr INT) USING parquet PARTITIONED BY (ds, hr) diff --git a/sql/core/src/test/resources/sql-tests/results/describe-query.sql.out b/sql/core/src/test/resources/sql-tests/results/describe-query.sql.out index 041116974cb..60b352f04a6 100644 --- a/sql/core/src/test/resources/sql-tests/results/describe-query.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/describe-query.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 19 - - -- !query CREATE table desc_temp1 (key int COMMENT 'column_comment', val string) USING PARQUET -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/describe-table-after-alter-table.sql.out b/sql/core/src/test/resources/sql-tests/results/describe-table-after-alter-table.sql.out index 3029fa8e830..0ca58cb45e8 100644 --- a/sql/core/src/test/resources/sql-tests/results/describe-table-after-alter-table.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/describe-table-after-alter-table.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 12 - - -- !query CREATE TABLE table_with_comment (a STRING, b INT, c STRING, d STRING) USING parquet COMMENT 'added' -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/describe-table-column.sql.out b/sql/core/src/test/resources/sql-tests/results/describe-table-column.sql.out index cc5b836b741..f650d248425 100644 --- a/sql/core/src/test/resources/sql-tests/results/describe-table-column.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/describe-table-column.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 30 - - -- !query CREATE TEMPORARY VIEW desc_col_temp_view (key int COMMENT 'column_comment', col struct<x:int, y:string>) USING PARQUET -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/describe.sql.out b/sql/core/src/test/resources/sql-tests/results/describe.sql.out index 8a6471bf239..c14cee948fc 100644 --- a/sql/core/src/test/resources/sql-tests/results/describe.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/describe.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 42 - - -- !query CREATE TABLE t (a STRING, b INT, c STRING, d STRING) USING parquet OPTIONS (a '1', b '2', password 'password') diff --git a/sql/core/src/test/resources/sql-tests/results/except-all.sql.out b/sql/core/src/test/resources/sql-tests/results/except-all.sql.out index 553d85a3cd6..c510ad1d831 100644 --- a/sql/core/src/test/resources/sql-tests/results/except-all.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/except-all.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 27 - - -- !query CREATE TEMPORARY VIEW tab1 AS SELECT * FROM VALUES (0), (1), (2), (2), (2), (2), (3), (null), (null) AS tab1(c1) diff --git a/sql/core/src/test/resources/sql-tests/results/except.sql.out b/sql/core/src/test/resources/sql-tests/results/except.sql.out index 061b122eac7..db5be40ad57 100644 --- a/sql/core/src/test/resources/sql-tests/results/except.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/except.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 15 - - -- !query create temporary view t1 as select * from values ("one", 1), diff --git a/sql/core/src/test/resources/sql-tests/results/explain-aqe.sql.out b/sql/core/src/test/resources/sql-tests/results/explain-aqe.sql.out index e6dbb1f415d..fc9d8525f0a 100644 --- a/sql/core/src/test/resources/sql-tests/results/explain-aqe.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/explain-aqe.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 27 - - -- !query CREATE table explain_temp1 (key int, val int) USING PARQUET -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/explain-cbo.sql.out b/sql/core/src/test/resources/sql-tests/results/explain-cbo.sql.out index 902af430b55..8c1a4f748a4 100644 --- a/sql/core/src/test/resources/sql-tests/results/explain-cbo.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/explain-cbo.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 7 - - -- !query CREATE TABLE explain_temp1(a INT, b INT) USING PARQUET -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/explain.sql.out b/sql/core/src/test/resources/sql-tests/results/explain.sql.out index b21f1836e3f..ea0c465a8cc 100644 --- a/sql/core/src/test/resources/sql-tests/results/explain.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/explain.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 27 - - -- !query CREATE table explain_temp1 (key int, val int) USING PARQUET -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/extract.sql.out b/sql/core/src/test/resources/sql-tests/results/extract.sql.out index 55776d32436..890c31f81db 100644 --- a/sql/core/src/test/resources/sql-tests/results/extract.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/extract.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 127 - - -- !query CREATE TEMPORARY VIEW t AS select '2011-05-06 07:08:09.1234567' as c, to_timestamp_ntz('2011-05-06 07:08:09.1234567') as ntz, interval 10 year 20 month as i, interval 30 day 40 hour 50 minute 6.7890 second as j -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/group-analytics.sql.out b/sql/core/src/test/resources/sql-tests/results/group-analytics.sql.out index 98d93868457..4645bb1dd47 100644 --- a/sql/core/src/test/resources/sql-tests/results/group-analytics.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/group-analytics.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 52 - - -- !query CREATE OR REPLACE TEMPORARY VIEW testData AS SELECT * FROM VALUES (1, 1), (1, 2), (2, 1), (2, 2), (3, 1), (3, 2) diff --git a/sql/core/src/test/resources/sql-tests/results/group-by-filter.sql.out b/sql/core/src/test/resources/sql-tests/results/group-by-filter.sql.out index 6105071ff2c..cd47c70ea85 100644 --- a/sql/core/src/test/resources/sql-tests/results/group-by-filter.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/group-by-filter.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 76 - - -- !query CREATE OR REPLACE TEMPORARY VIEW testData AS SELECT * FROM VALUES (1, 1), (1, 2), (2, 1), (2, 2), (3, 1), (3, 2), (null, 1), (3, null), (null, null) diff --git a/sql/core/src/test/resources/sql-tests/results/group-by-ordinal.sql.out b/sql/core/src/test/resources/sql-tests/results/group-by-ordinal.sql.out index 92e4a861fa1..0e4ec436b3b 100644 --- a/sql/core/src/test/resources/sql-tests/results/group-by-ordinal.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/group-by-ordinal.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 33 - - -- !query create temporary view data as select * from values (1, 1), diff --git a/sql/core/src/test/resources/sql-tests/results/group-by.sql.out b/sql/core/src/test/resources/sql-tests/results/group-by.sql.out index 50f933dfc44..09876a057c9 100644 --- a/sql/core/src/test/resources/sql-tests/results/group-by.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/group-by.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 83 - - -- !query CREATE OR REPLACE TEMPORARY VIEW testData AS SELECT * FROM VALUES (1, 1), (1, 2), (2, 1), (2, 2), (3, 1), (3, 2), (null, 1), (3, null), (null, null) diff --git a/sql/core/src/test/resources/sql-tests/results/grouping_set.sql.out b/sql/core/src/test/resources/sql-tests/results/grouping_set.sql.out index c0f1a6975d1..bb6371a97f7 100644 --- a/sql/core/src/test/resources/sql-tests/results/grouping_set.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/grouping_set.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 18 - - -- !query CREATE TEMPORARY VIEW grouping AS SELECT * FROM VALUES ("1", "2", "3", 1), diff --git a/sql/core/src/test/resources/sql-tests/results/having.sql.out b/sql/core/src/test/resources/sql-tests/results/having.sql.out index 22e71f4f8a6..fff470b3d81 100644 --- a/sql/core/src/test/resources/sql-tests/results/having.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/having.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 13 - - -- !query create temporary view hav as select * from values ("one", 1), diff --git a/sql/core/src/test/resources/sql-tests/results/higher-order-functions.sql.out b/sql/core/src/test/resources/sql-tests/results/higher-order-functions.sql.out index 7b31b569099..c6bbb4fb717 100644 --- a/sql/core/src/test/resources/sql-tests/results/higher-order-functions.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/higher-order-functions.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 30 - - -- !query create or replace temporary view nested as values (1, array(32, 97), array(array(12, 99), array(123, 42), array(1))), diff --git a/sql/core/src/test/resources/sql-tests/results/ilike-all.sql.out b/sql/core/src/test/resources/sql-tests/results/ilike-all.sql.out index c9cf707ae18..54dd03d32ea 100644 --- a/sql/core/src/test/resources/sql-tests/results/ilike-all.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/ilike-all.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 14 - - -- !query CREATE OR REPLACE TEMPORARY VIEW ilike_all_table AS SELECT * FROM (VALUES ('gOOgle', '%oo%'), diff --git a/sql/core/src/test/resources/sql-tests/results/ilike-any.sql.out b/sql/core/src/test/resources/sql-tests/results/ilike-any.sql.out index 8fc5b345ee3..91a2f403864 100644 --- a/sql/core/src/test/resources/sql-tests/results/ilike-any.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/ilike-any.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 14 - - -- !query CREATE OR REPLACE TEMPORARY VIEW ilike_any_table AS SELECT * FROM (VALUES ('Google', '%Oo%'), diff --git a/sql/core/src/test/resources/sql-tests/results/ilike.sql.out b/sql/core/src/test/resources/sql-tests/results/ilike.sql.out index 1bcd6d2e257..d618d3ee10a 100644 --- a/sql/core/src/test/resources/sql-tests/results/ilike.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/ilike.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 26 - - -- !query select null ilike 'a' -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/inline-table.sql.out b/sql/core/src/test/resources/sql-tests/results/inline-table.sql.out index 401d684a55b..84c7f8a86cd 100644 --- a/sql/core/src/test/resources/sql-tests/results/inline-table.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/inline-table.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 17 - - -- !query select * from values ("one", 1) -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/inner-join.sql.out b/sql/core/src/test/resources/sql-tests/results/inner-join.sql.out index 7c3774c8bd7..e7074c11d36 100644 --- a/sql/core/src/test/resources/sql-tests/results/inner-join.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/inner-join.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 7 - - -- !query CREATE TEMPORARY VIEW t1 AS SELECT * FROM VALUES (1) AS GROUPING(a) -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/intersect-all.sql.out b/sql/core/src/test/resources/sql-tests/results/intersect-all.sql.out index 3e12542da0a..062c3761d25 100644 --- a/sql/core/src/test/resources/sql-tests/results/intersect-all.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/intersect-all.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 26 - - -- !query CREATE TEMPORARY VIEW tab1 AS SELECT * FROM VALUES (1, 2), diff --git a/sql/core/src/test/resources/sql-tests/results/interval.sql.out b/sql/core/src/test/resources/sql-tests/results/interval.sql.out index 1cbe117a05b..652e1e724b9 100644 --- a/sql/core/src/test/resources/sql-tests/results/interval.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/interval.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 286 - - -- !query select 3 * (timestamp'2019-10-15 10:11:12.001002' - date'2019-10-15') -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/join-empty-relation.sql.out b/sql/core/src/test/resources/sql-tests/results/join-empty-relation.sql.out index 6b7edfb2356..7fede20fe3c 100644 --- a/sql/core/src/test/resources/sql-tests/results/join-empty-relation.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/join-empty-relation.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 24 - - -- !query CREATE TEMPORARY VIEW t1 AS SELECT * FROM VALUES (1) AS GROUPING(a) -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/join-lateral.sql.out b/sql/core/src/test/resources/sql-tests/results/join-lateral.sql.out index 625607a8db0..63446155938 100644 --- a/sql/core/src/test/resources/sql-tests/results/join-lateral.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/join-lateral.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 71 - - -- !query CREATE VIEW t1(c1, c2) AS VALUES (0, 1), (1, 2) -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/json-functions.sql.out b/sql/core/src/test/resources/sql-tests/results/json-functions.sql.out index 7efd31f6c3e..55d80d95ccf 100644 --- a/sql/core/src/test/resources/sql-tests/results/json-functions.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/json-functions.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 73 - - -- !query select to_json(named_struct('a', 1, 'b', 2)) -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/like-all.sql.out b/sql/core/src/test/resources/sql-tests/results/like-all.sql.out index d06f06247da..3a252d84ba1 100644 --- a/sql/core/src/test/resources/sql-tests/results/like-all.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/like-all.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 14 - - -- !query CREATE OR REPLACE TEMPORARY VIEW like_all_table AS SELECT * FROM (VALUES ('google', '%oo%'), diff --git a/sql/core/src/test/resources/sql-tests/results/like-any.sql.out b/sql/core/src/test/resources/sql-tests/results/like-any.sql.out index e46ac6d8589..ecf7b6e7bbc 100644 --- a/sql/core/src/test/resources/sql-tests/results/like-any.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/like-any.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 14 - - -- !query CREATE OR REPLACE TEMPORARY VIEW like_any_table AS SELECT * FROM (VALUES ('google', '%oo%'), diff --git a/sql/core/src/test/resources/sql-tests/results/limit.sql.out b/sql/core/src/test/resources/sql-tests/results/limit.sql.out index 3b10bbd5740..7d1c1e2b34d 100644 --- a/sql/core/src/test/resources/sql-tests/results/limit.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/limit.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 14 - - -- !query SELECT * FROM testdata LIMIT 2 -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/linear-regression.sql.out b/sql/core/src/test/resources/sql-tests/results/linear-regression.sql.out index 0066ff8f064..1379713a9fb 100644 --- a/sql/core/src/test/resources/sql-tests/results/linear-regression.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/linear-regression.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 33 - - -- !query CREATE OR REPLACE TEMPORARY VIEW testRegression AS SELECT * FROM VALUES (1, 10, null), (2, 10, 11), (2, 20, 22), (2, 25, null), (2, 30, 35) diff --git a/sql/core/src/test/resources/sql-tests/results/literals.sql.out b/sql/core/src/test/resources/sql-tests/results/literals.sql.out index f6341caed81..6edd513ea2f 100644 --- a/sql/core/src/test/resources/sql-tests/results/literals.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/literals.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 54 - - -- !query select null, Null, nUll -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/map.sql.out b/sql/core/src/test/resources/sql-tests/results/map.sql.out index b615a625811..cd7cf9a60ce 100644 --- a/sql/core/src/test/resources/sql-tests/results/map.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/map.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 10 - - -- !query select element_at(map(1, 'a', 2, 'b'), 5) -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/misc-functions.sql.out b/sql/core/src/test/resources/sql-tests/results/misc-functions.sql.out index bf29cc26b7e..7e9bb2f7acd 100644 --- a/sql/core/src/test/resources/sql-tests/results/misc-functions.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/misc-functions.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 16 - - -- !query select typeof(null) -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/natural-join.sql.out b/sql/core/src/test/resources/sql-tests/results/natural-join.sql.out index a146ee74b8e..fc840486daf 100644 --- a/sql/core/src/test/resources/sql-tests/results/natural-join.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/natural-join.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 29 - - -- !query create temporary view nt1 as select * from values ("one", 1), diff --git a/sql/core/src/test/resources/sql-tests/results/non-excludable-rule.sql.out b/sql/core/src/test/resources/sql-tests/results/non-excludable-rule.sql.out index fa8b2bbec4e..b45e35ea4d8 100644 --- a/sql/core/src/test/resources/sql-tests/results/non-excludable-rule.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/non-excludable-rule.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 4 - - -- !query SET spark.sql.optimizer.excludedRules=org.apache.spark.sql.catalyst.optimizer.ReplaceCTERefWithRepartition -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/null-handling.sql.out b/sql/core/src/test/resources/sql-tests/results/null-handling.sql.out index 44776bad6dc..ece6dbef160 100644 --- a/sql/core/src/test/resources/sql-tests/results/null-handling.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/null-handling.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 29 - - -- !query create table t1(a int, b int, c int) using parquet -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/null-propagation.sql.out b/sql/core/src/test/resources/sql-tests/results/null-propagation.sql.out index b972d963c8d..ef16981ff1d 100644 --- a/sql/core/src/test/resources/sql-tests/results/null-propagation.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/null-propagation.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 4 - - -- !query SELECT COUNT(NULL) FROM VALUES 1, 2, 3 -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/operators.sql.out b/sql/core/src/test/resources/sql-tests/results/operators.sql.out index a2ed7d0b547..93ac6b49b01 100644 --- a/sql/core/src/test/resources/sql-tests/results/operators.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/operators.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 77 - - -- !query select -100 -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/order-by-nulls-ordering.sql.out b/sql/core/src/test/resources/sql-tests/results/order-by-nulls-ordering.sql.out index 67d271790ee..4523c0d6dae 100644 --- a/sql/core/src/test/resources/sql-tests/results/order-by-nulls-ordering.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/order-by-nulls-ordering.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 17 - - -- !query create table spark_10747(col1 int, col2 int, col3 int) using parquet -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/order-by-ordinal.sql.out b/sql/core/src/test/resources/sql-tests/results/order-by-ordinal.sql.out index 44c811a7439..581d7d4ae2d 100644 --- a/sql/core/src/test/resources/sql-tests/results/order-by-ordinal.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/order-by-ordinal.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 12 - - -- !query create temporary view data as select * from values (1, 1), diff --git a/sql/core/src/test/resources/sql-tests/results/outer-join.sql.out b/sql/core/src/test/resources/sql-tests/results/outer-join.sql.out index 703ce231c53..83983a68e63 100644 --- a/sql/core/src/test/resources/sql-tests/results/outer-join.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/outer-join.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 6 - - -- !query CREATE OR REPLACE TEMPORARY VIEW t1 AS SELECT * FROM VALUES (-234), (145), (367), (975), (298) diff --git a/sql/core/src/test/resources/sql-tests/results/parse-schema-string.sql.out b/sql/core/src/test/resources/sql-tests/results/parse-schema-string.sql.out index 4440dd763bd..793b545b324 100644 --- a/sql/core/src/test/resources/sql-tests/results/parse-schema-string.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/parse-schema-string.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 4 - - -- !query select from_csv('1', 'create INT') -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/percentiles.sql.out b/sql/core/src/test/resources/sql-tests/results/percentiles.sql.out index 65acc59b9cb..9107f459c93 100644 --- a/sql/core/src/test/resources/sql-tests/results/percentiles.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/percentiles.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 23 - - -- !query CREATE OR REPLACE TEMPORARY VIEW aggr AS SELECT * FROM VALUES (0, 0), (0, 10), (0, 20), (0, 30), (0, 40), (1, 10), (1, 20), (2, 10), (2, 20), (2, 25), (2, 30), (3, 60), (4, null) diff --git a/sql/core/src/test/resources/sql-tests/results/pivot.sql.out b/sql/core/src/test/resources/sql-tests/results/pivot.sql.out index ef20f8fe7e6..613ced1dce2 100644 --- a/sql/core/src/test/resources/sql-tests/results/pivot.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/pivot.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 32 - - -- !query create temporary view courseSales as select * from values ("dotNET", 2012, 10000), diff --git a/sql/core/src/test/resources/sql-tests/results/postgreSQL/aggregates_part1.sql.out b/sql/core/src/test/resources/sql-tests/results/postgreSQL/aggregates_part1.sql.out index ee44cd9171a..eeffa07e11e 100644 --- a/sql/core/src/test/resources/sql-tests/results/postgreSQL/aggregates_part1.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/postgreSQL/aggregates_part1.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 57 - - -- !query SELECT avg(four) AS avg_1 FROM onek -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/postgreSQL/aggregates_part2.sql.out b/sql/core/src/test/resources/sql-tests/results/postgreSQL/aggregates_part2.sql.out index 6633bf5d114..f9a816286ba 100644 --- a/sql/core/src/test/resources/sql-tests/results/postgreSQL/aggregates_part2.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/postgreSQL/aggregates_part2.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 29 - - -- !query create temporary view int4_tbl as select * from values (0), diff --git a/sql/core/src/test/resources/sql-tests/results/postgreSQL/aggregates_part3.sql.out b/sql/core/src/test/resources/sql-tests/results/postgreSQL/aggregates_part3.sql.out index f3ab092baf6..450dd5ca743 100644 --- a/sql/core/src/test/resources/sql-tests/results/postgreSQL/aggregates_part3.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/postgreSQL/aggregates_part3.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 5 - - -- !query select max(min(unique1)) from tenk1 -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/postgreSQL/aggregates_part4.sql.out b/sql/core/src/test/resources/sql-tests/results/postgreSQL/aggregates_part4.sql.out index 8c21a5067bf..45f00b36f16 100644 --- a/sql/core/src/test/resources/sql-tests/results/postgreSQL/aggregates_part4.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/postgreSQL/aggregates_part4.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 4 - - -- !query select percentile_cont(0.5) within group (order by b) from aggtest -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/postgreSQL/boolean.sql.out b/sql/core/src/test/resources/sql-tests/results/postgreSQL/boolean.sql.out index af8cc852554..83020db06d9 100644 --- a/sql/core/src/test/resources/sql-tests/results/postgreSQL/boolean.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/postgreSQL/boolean.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 92 - - -- !query SELECT 1 AS one -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/postgreSQL/case.sql.out b/sql/core/src/test/resources/sql-tests/results/postgreSQL/case.sql.out index 603df103846..66b018b838c 100644 --- a/sql/core/src/test/resources/sql-tests/results/postgreSQL/case.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/postgreSQL/case.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 35 - - -- !query CREATE TABLE CASE_TBL ( i integer, diff --git a/sql/core/src/test/resources/sql-tests/results/postgreSQL/comments.sql.out b/sql/core/src/test/resources/sql-tests/results/postgreSQL/comments.sql.out index d583a4a5d42..44db80e4888 100644 --- a/sql/core/src/test/resources/sql-tests/results/postgreSQL/comments.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/postgreSQL/comments.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 6 - - -- !query SELECT 'trailing' AS first -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/postgreSQL/create_view.sql.out b/sql/core/src/test/resources/sql-tests/results/postgreSQL/create_view.sql.out index a3637eca958..cb338bbc4cd 100644 --- a/sql/core/src/test/resources/sql-tests/results/postgreSQL/create_view.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/postgreSQL/create_view.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 195 - - -- !query CREATE TABLE emp ( name string, diff --git a/sql/core/src/test/resources/sql-tests/results/postgreSQL/date.sql.out b/sql/core/src/test/resources/sql-tests/results/postgreSQL/date.sql.out index 36fa5f7c2be..7edda980be3 100755 --- a/sql/core/src/test/resources/sql-tests/results/postgreSQL/date.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/postgreSQL/date.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 60 - - -- !query CREATE TABLE DATE_TBL (f1 date) USING parquet -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/postgreSQL/float4.sql.out b/sql/core/src/test/resources/sql-tests/results/postgreSQL/float4.sql.out index 9f946f40e77..4002a41295f 100644 --- a/sql/core/src/test/resources/sql-tests/results/postgreSQL/float4.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/postgreSQL/float4.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 43 - - -- !query CREATE TABLE FLOAT4_TBL (f1 float) USING parquet -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/postgreSQL/float8.sql.out b/sql/core/src/test/resources/sql-tests/results/postgreSQL/float8.sql.out index 3c6f903f2cd..ddc2b70250b 100644 --- a/sql/core/src/test/resources/sql-tests/results/postgreSQL/float8.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/postgreSQL/float8.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 95 - - -- !query CREATE TABLE FLOAT8_TBL(f1 double) USING parquet -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/postgreSQL/groupingsets.sql.out b/sql/core/src/test/resources/sql-tests/results/postgreSQL/groupingsets.sql.out index a7786e83daa..43fafb4eaae 100644 --- a/sql/core/src/test/resources/sql-tests/results/postgreSQL/groupingsets.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/postgreSQL/groupingsets.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 55 - - -- !query create temp view gstest1(a,b,v) as values (1,1,10),(1,1,11),(1,2,12),(1,2,13),(1,3,14), diff --git a/sql/core/src/test/resources/sql-tests/results/postgreSQL/insert.sql.out b/sql/core/src/test/resources/sql-tests/results/postgreSQL/insert.sql.out index 63ad74aac32..91e2f9ed439 100644 --- a/sql/core/src/test/resources/sql-tests/results/postgreSQL/insert.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/postgreSQL/insert.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 9 - - -- !query create table inserttest (col1 int, col2 int /* NOT NULL */, col3 string /* default 'testing' */) using parquet -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/postgreSQL/int2.sql.out b/sql/core/src/test/resources/sql-tests/results/postgreSQL/int2.sql.out index dee21ced28d..ca55b6accc6 100755 --- a/sql/core/src/test/resources/sql-tests/results/postgreSQL/int2.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/postgreSQL/int2.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 35 - - -- !query CREATE TABLE INT2_TBL(f1 smallint) USING parquet -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/postgreSQL/int4.sql.out b/sql/core/src/test/resources/sql-tests/results/postgreSQL/int4.sql.out index 7f36a1da5bc..730607e5c16 100755 --- a/sql/core/src/test/resources/sql-tests/results/postgreSQL/int4.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/postgreSQL/int4.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 53 - - -- !query CREATE TABLE INT4_TBL(f1 int) USING parquet -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/postgreSQL/int8.sql.out b/sql/core/src/test/resources/sql-tests/results/postgreSQL/int8.sql.out index e0ef89081de..8da1a1ca139 100755 --- a/sql/core/src/test/resources/sql-tests/results/postgreSQL/int8.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/postgreSQL/int8.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 91 - - -- !query CREATE TABLE INT8_TBL(q1 bigint, q2 bigint) USING parquet -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/postgreSQL/interval.sql.out b/sql/core/src/test/resources/sql-tests/results/postgreSQL/interval.sql.out index 3f023982fc8..04df07bff57 100644 --- a/sql/core/src/test/resources/sql-tests/results/postgreSQL/interval.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/postgreSQL/interval.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 24 - - -- !query SELECT interval '999' second -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/postgreSQL/join.sql.out b/sql/core/src/test/resources/sql-tests/results/postgreSQL/join.sql.out index 3e0ca060e8f..9228558c87a 100644 --- a/sql/core/src/test/resources/sql-tests/results/postgreSQL/join.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/postgreSQL/join.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 193 - - -- !query CREATE OR REPLACE TEMPORARY VIEW INT2_TBL(f1) AS VALUES (smallint(trim('0 '))), diff --git a/sql/core/src/test/resources/sql-tests/results/postgreSQL/limit.sql.out b/sql/core/src/test/resources/sql-tests/results/postgreSQL/limit.sql.out index d6526d77d3c..ece34bf3f1c 100644 --- a/sql/core/src/test/resources/sql-tests/results/postgreSQL/limit.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/postgreSQL/limit.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 13 - - -- !query SELECT '' AS two, unique1, unique2, stringu1 FROM onek WHERE unique1 > 50 diff --git a/sql/core/src/test/resources/sql-tests/results/postgreSQL/numeric.sql.out b/sql/core/src/test/resources/sql-tests/results/postgreSQL/numeric.sql.out index c075775ca50..c5614e98ff8 100644 --- a/sql/core/src/test/resources/sql-tests/results/postgreSQL/numeric.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/postgreSQL/numeric.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 606 - - -- !query CREATE TABLE num_data (id int, val decimal(38,10)) USING parquet -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/postgreSQL/select.sql.out b/sql/core/src/test/resources/sql-tests/results/postgreSQL/select.sql.out index d3674d6bc12..8e76755992c 100644 --- a/sql/core/src/test/resources/sql-tests/results/postgreSQL/select.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/postgreSQL/select.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 37 - - -- !query create or replace temporary view onek2 as select * from onek -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/postgreSQL/select_distinct.sql.out b/sql/core/src/test/resources/sql-tests/results/postgreSQL/select_distinct.sql.out index 53003e70f28..9bf31ae1a94 100644 --- a/sql/core/src/test/resources/sql-tests/results/postgreSQL/select_distinct.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/postgreSQL/select_distinct.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 19 - - -- !query CREATE OR REPLACE TEMPORARY VIEW tmp AS SELECT two, stringu1, ten, string4 diff --git a/sql/core/src/test/resources/sql-tests/results/postgreSQL/select_having.sql.out b/sql/core/src/test/resources/sql-tests/results/postgreSQL/select_having.sql.out index 600d260b094..11b278aa42a 100644 --- a/sql/core/src/test/resources/sql-tests/results/postgreSQL/select_having.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/postgreSQL/select_having.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 22 - - -- !query CREATE TABLE test_having (a int, b int, c string, d string) USING parquet -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/postgreSQL/select_implicit.sql.out b/sql/core/src/test/resources/sql-tests/results/postgreSQL/select_implicit.sql.out index d12d17ff17b..41147e2b779 100755 --- a/sql/core/src/test/resources/sql-tests/results/postgreSQL/select_implicit.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/postgreSQL/select_implicit.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 38 - - -- !query CREATE TABLE test_missing_target (a int, b int, c string, d string) using parquet -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/postgreSQL/strings.sql.out b/sql/core/src/test/resources/sql-tests/results/postgreSQL/strings.sql.out index 28904629df3..81f964b4bea 100644 --- a/sql/core/src/test/resources/sql-tests/results/postgreSQL/strings.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/postgreSQL/strings.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 124 - - -- !query SELECT 'first line' ' - next line' diff --git a/sql/core/src/test/resources/sql-tests/results/postgreSQL/text.sql.out b/sql/core/src/test/resources/sql-tests/results/postgreSQL/text.sql.out index f9d3ad69f99..65db4be077c 100755 --- a/sql/core/src/test/resources/sql-tests/results/postgreSQL/text.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/postgreSQL/text.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 42 - - -- !query SELECT string('this is a text string') = string('this is a text string') AS true -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/postgreSQL/timestamp.sql.out b/sql/core/src/test/resources/sql-tests/results/postgreSQL/timestamp.sql.out index 5068a37130b..d936fba96d8 100644 --- a/sql/core/src/test/resources/sql-tests/results/postgreSQL/timestamp.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/postgreSQL/timestamp.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 30 - - -- !query CREATE TABLE TIMESTAMP_TBL (d1 timestamp) USING parquet -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/postgreSQL/union.sql.out b/sql/core/src/test/resources/sql-tests/results/postgreSQL/union.sql.out index e042fc96768..24ebd227e0f 100644 --- a/sql/core/src/test/resources/sql-tests/results/postgreSQL/union.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/postgreSQL/union.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 72 - - -- !query CREATE OR REPLACE TEMPORARY VIEW INT4_TBL AS SELECT * FROM (VALUES (0), (123456), (-123456), (2147483647), (-2147483647)) diff --git a/sql/core/src/test/resources/sql-tests/results/postgreSQL/window_part1.sql.out b/sql/core/src/test/resources/sql-tests/results/postgreSQL/window_part1.sql.out index ba449ccf393..7f16547b50f 100755 --- a/sql/core/src/test/resources/sql-tests/results/postgreSQL/window_part1.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/postgreSQL/window_part1.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 43 - - -- !query CREATE TEMPORARY VIEW tenk2 AS SELECT * FROM tenk1 -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/postgreSQL/window_part2.sql.out b/sql/core/src/test/resources/sql-tests/results/postgreSQL/window_part2.sql.out index 13b46259f01..cb374eb62bd 100644 --- a/sql/core/src/test/resources/sql-tests/results/postgreSQL/window_part2.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/postgreSQL/window_part2.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 31 - - -- !query CREATE TABLE empsalary ( depname string, diff --git a/sql/core/src/test/resources/sql-tests/results/postgreSQL/window_part3.sql.out b/sql/core/src/test/resources/sql-tests/results/postgreSQL/window_part3.sql.out index 29ef79ad0e1..68fde56dba1 100644 --- a/sql/core/src/test/resources/sql-tests/results/postgreSQL/window_part3.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/postgreSQL/window_part3.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 30 - - -- !query CREATE TEMPORARY VIEW tenk2 AS SELECT * FROM tenk1 -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/postgreSQL/window_part4.sql.out b/sql/core/src/test/resources/sql-tests/results/postgreSQL/window_part4.sql.out index 0e7a80aa2a3..60806a97b5b 100644 --- a/sql/core/src/test/resources/sql-tests/results/postgreSQL/window_part4.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/postgreSQL/window_part4.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 39 - - -- !query SELECT i,AVG(v) OVER (ORDER BY i ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING) FROM (VALUES(1,1),(2,2),(3,NULL),(4,NULL)) t(i,v) diff --git a/sql/core/src/test/resources/sql-tests/results/postgreSQL/with.sql.out b/sql/core/src/test/resources/sql-tests/results/postgreSQL/with.sql.out index b3db45719ff..0a4e2f179d8 100644 --- a/sql/core/src/test/resources/sql-tests/results/postgreSQL/with.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/postgreSQL/with.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 51 - - -- !query WITH q1(x,y) AS (SELECT 1,2) SELECT * FROM q1, q1 AS q2 diff --git a/sql/core/src/test/resources/sql-tests/results/pred-pushdown.sql.out b/sql/core/src/test/resources/sql-tests/results/pred-pushdown.sql.out index a64b8d3f663..da4f1637637 100644 --- a/sql/core/src/test/resources/sql-tests/results/pred-pushdown.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/pred-pushdown.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 4 - - -- !query CREATE OR REPLACE TEMPORARY VIEW tbl_a AS VALUES (1, 1), (2, 1), (3, 6) AS T(c1, c2) -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/predicate-functions.sql.out b/sql/core/src/test/resources/sql-tests/results/predicate-functions.sql.out index 32f9efde688..1cdf26d6eac 100644 --- a/sql/core/src/test/resources/sql-tests/results/predicate-functions.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/predicate-functions.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 53 - - -- !query select 1 = 1 -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/query_regex_column.sql.out b/sql/core/src/test/resources/sql-tests/results/query_regex_column.sql.out index 3cdbbe475b3..f46bfd6c885 100644 --- a/sql/core/src/test/resources/sql-tests/results/query_regex_column.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/query_regex_column.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 34 - - -- !query set spark.sql.parser.quotedRegexColumnNames=false -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/random.sql.out b/sql/core/src/test/resources/sql-tests/results/random.sql.out index b269d40c356..e3edddb26d9 100644 --- a/sql/core/src/test/resources/sql-tests/results/random.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/random.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 10 - - -- !query SELECT rand(0) -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/regexp-functions.sql.out b/sql/core/src/test/resources/sql-tests/results/regexp-functions.sql.out index f0a6fa064d0..7f7b52febdd 100644 --- a/sql/core/src/test/resources/sql-tests/results/regexp-functions.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/regexp-functions.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 46 - - -- !query SELECT regexp_extract('1a 2b 14m', '\\d+') -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/show-create-table.sql.out b/sql/core/src/test/resources/sql-tests/results/show-create-table.sql.out index 66df0565efc..190356aad7f 100644 --- a/sql/core/src/test/resources/sql-tests/results/show-create-table.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/show-create-table.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 41 - - -- !query CREATE TABLE tbl (a INT, b STRING, c INT) USING parquet -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/show-tables.sql.out b/sql/core/src/test/resources/sql-tests/results/show-tables.sql.out index 808d76b4aa4..26e6b260e68 100644 --- a/sql/core/src/test/resources/sql-tests/results/show-tables.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/show-tables.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 27 - - -- !query CREATE DATABASE showdb -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/show-tblproperties.sql.out b/sql/core/src/test/resources/sql-tests/results/show-tblproperties.sql.out index f4b0c3d6bbe..196a30141e2 100644 --- a/sql/core/src/test/resources/sql-tests/results/show-tblproperties.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/show-tblproperties.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 13 - - -- !query CREATE TABLE tbl (a INT, b STRING, c INT) USING parquet TBLPROPERTIES('p1'='v1', 'p2'='v2', password = 'password') diff --git a/sql/core/src/test/resources/sql-tests/results/show-views.sql.out b/sql/core/src/test/resources/sql-tests/results/show-views.sql.out index c80f8fab433..8dc2f663ba0 100644 --- a/sql/core/src/test/resources/sql-tests/results/show-views.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/show-views.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 20 - - -- !query CREATE DATABASE showdb -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/show_columns.sql.out b/sql/core/src/test/resources/sql-tests/results/show_columns.sql.out index d8d0926d242..8a858343b24 100644 --- a/sql/core/src/test/resources/sql-tests/results/show_columns.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/show_columns.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 25 - - -- !query CREATE DATABASE showdb -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/sql-compatibility-functions.sql.out b/sql/core/src/test/resources/sql-tests/results/sql-compatibility-functions.sql.out index 065424dfd7a..9521cbf0bf2 100644 --- a/sql/core/src/test/resources/sql-tests/results/sql-compatibility-functions.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/sql-compatibility-functions.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 14 - - -- !query SELECT ifnull(null, 'x'), ifnull('y', 'x'), ifnull(null, null) -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/string-functions.sql.out b/sql/core/src/test/resources/sql-tests/results/string-functions.sql.out index dc72dfe137d..faf6165a888 100644 --- a/sql/core/src/test/resources/sql-tests/results/string-functions.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/string-functions.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 143 - - -- !query select concat_ws() -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/struct.sql.out b/sql/core/src/test/resources/sql-tests/results/struct.sql.out index 3b2da6c8588..d642321e218 100644 --- a/sql/core/src/test/resources/sql-tests/results/struct.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/struct.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 9 - - -- !query CREATE TEMPORARY VIEW tbl_x AS VALUES (1, NAMED_STRUCT('C', 'gamma', 'D', 'delta')), diff --git a/sql/core/src/test/resources/sql-tests/results/subexp-elimination.sql.out b/sql/core/src/test/resources/sql-tests/results/subexp-elimination.sql.out index aca2c4c2f54..0f7ff3f1075 100644 --- a/sql/core/src/test/resources/sql-tests/results/subexp-elimination.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/subexp-elimination.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 10 - - -- !query CREATE OR REPLACE TEMPORARY VIEW testData AS SELECT * FROM VALUES ('{"a":1, "b":"2"}', '[{"a": 1, "b":2}, {"a":2, "b":2}]'), ('{"a":1, "b":"2"}', null), ('{"a":2, "b":"3"}', '[{"a": 3, "b":4}, {"a":4, "b":5}]'), ('{"a":5, "b":"6"}', '[{"a": 6, "b":7}, {"a":8, "b":9}]'), (null, '[{"a": 1, "b":2}, {"a":2, "b":2}]') diff --git a/sql/core/src/test/resources/sql-tests/results/subquery/exists-subquery/exists-aggregate.sql.out b/sql/core/src/test/resources/sql-tests/results/subquery/exists-subquery/exists-aggregate.sql.out index 9f11b46d408..5a2f3aad715 100644 --- a/sql/core/src/test/resources/sql-tests/results/subquery/exists-subquery/exists-aggregate.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/subquery/exists-subquery/exists-aggregate.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 11 - - -- !query CREATE TEMPORARY VIEW EMP AS SELECT * FROM VALUES (100, "emp 1", date "2005-01-01", 100.00D, 10), diff --git a/sql/core/src/test/resources/sql-tests/results/subquery/exists-subquery/exists-basic.sql.out b/sql/core/src/test/resources/sql-tests/results/subquery/exists-subquery/exists-basic.sql.out index a54fb47fe34..cb806fdaf82 100644 --- a/sql/core/src/test/resources/sql-tests/results/subquery/exists-subquery/exists-basic.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/subquery/exists-subquery/exists-basic.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 13 - - -- !query CREATE TEMPORARY VIEW EMP AS SELECT * FROM VALUES (100, "emp 1", date "2005-01-01", 100.00D, 10), diff --git a/sql/core/src/test/resources/sql-tests/results/subquery/exists-subquery/exists-cte.sql.out b/sql/core/src/test/resources/sql-tests/results/subquery/exists-subquery/exists-cte.sql.out index 3c8a19998a7..09d8cb3bccc 100644 --- a/sql/core/src/test/resources/sql-tests/results/subquery/exists-subquery/exists-cte.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/subquery/exists-subquery/exists-cte.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 8 - - -- !query CREATE TEMPORARY VIEW EMP AS SELECT * FROM VALUES (100, "emp 1", date "2005-01-01", 100.00D, 10), diff --git a/sql/core/src/test/resources/sql-tests/results/subquery/exists-subquery/exists-having.sql.out b/sql/core/src/test/resources/sql-tests/results/subquery/exists-subquery/exists-having.sql.out index aa4d2ab7e41..ae4cf010ffc 100644 --- a/sql/core/src/test/resources/sql-tests/results/subquery/exists-subquery/exists-having.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/subquery/exists-subquery/exists-having.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 8 - - -- !query CREATE TEMPORARY VIEW EMP AS SELECT * FROM VALUES (100, "emp 1", date "2005-01-01", 100.00D, 10), diff --git a/sql/core/src/test/resources/sql-tests/results/subquery/exists-subquery/exists-joins-and-set-ops.sql.out b/sql/core/src/test/resources/sql-tests/results/subquery/exists-subquery/exists-joins-and-set-ops.sql.out index 1a529493042..21e06c398eb 100644 --- a/sql/core/src/test/resources/sql-tests/results/subquery/exists-subquery/exists-joins-and-set-ops.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/subquery/exists-subquery/exists-joins-and-set-ops.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 17 - - -- !query CREATE TEMPORARY VIEW EMP AS SELECT * FROM VALUES (100, "emp 1", date "2005-01-01", 100.00D, 10), diff --git a/sql/core/src/test/resources/sql-tests/results/subquery/exists-subquery/exists-orderby-limit.sql.out b/sql/core/src/test/resources/sql-tests/results/subquery/exists-subquery/exists-orderby-limit.sql.out index 3442cfd689a..9f7aa09cb21 100644 --- a/sql/core/src/test/resources/sql-tests/results/subquery/exists-subquery/exists-orderby-limit.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/subquery/exists-subquery/exists-orderby-limit.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 20 - - -- !query CREATE TEMPORARY VIEW EMP AS SELECT * FROM VALUES (100, "emp 1", date "2005-01-01", 100.00D, 10), diff --git a/sql/core/src/test/resources/sql-tests/results/subquery/exists-subquery/exists-outside-filter.sql.out b/sql/core/src/test/resources/sql-tests/results/subquery/exists-subquery/exists-outside-filter.sql.out index af7cd9d11e7..8e92017f24d 100644 --- a/sql/core/src/test/resources/sql-tests/results/subquery/exists-subquery/exists-outside-filter.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/subquery/exists-subquery/exists-outside-filter.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 15 - - -- !query CREATE TEMPORARY VIEW EMP AS SELECT * FROM VALUES (100, "emp 1", date "2005-01-01", 100.00D, 10), diff --git a/sql/core/src/test/resources/sql-tests/results/subquery/exists-subquery/exists-within-and-or.sql.out b/sql/core/src/test/resources/sql-tests/results/subquery/exists-subquery/exists-within-and-or.sql.out index 6a17c2fc86d..b6f4c5c5c31 100644 --- a/sql/core/src/test/resources/sql-tests/results/subquery/exists-subquery/exists-within-and-or.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/subquery/exists-subquery/exists-within-and-or.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 8 - - -- !query CREATE TEMPORARY VIEW EMP AS SELECT * FROM VALUES (100, "emp 1", date "2005-01-01", 100.00D, 10), diff --git a/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/in-basic.sql.out b/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/in-basic.sql.out index 2acea22e91b..6962aea4220 100644 --- a/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/in-basic.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/in-basic.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 7 - - -- !query create temporary view tab_a as select * from values (1, 1) as tab_a(a1, b1) -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/in-group-by.sql.out b/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/in-group-by.sql.out index f378664014f..4c715342bee 100644 --- a/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/in-group-by.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/in-group-by.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 19 - - -- !query create temporary view t1 as select * from values ("t1a", 6S, 8, 10L, float(15.0), 20D, 20E2BD, timestamp '2014-04-04 01:00:00.000', date '2014-04-04'), diff --git a/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/in-having.sql.out b/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/in-having.sql.out index 09b6adbe62b..e4b5db98c56 100644 --- a/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/in-having.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/in-having.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 12 - - -- !query create temporary view t1 as select * from values ("val1a", 6S, 8, 10L, float(15.0), 20D, 20E2, timestamp '2014-04-04 01:00:00.000', date '2014-04-04'), diff --git a/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/in-joins.sql.out b/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/in-joins.sql.out index 615b67f629e..9df4f1ca087 100644 --- a/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/in-joins.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/in-joins.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 34 - - -- !query create temporary view t1 as select * from values ("val1a", 6S, 8, 10L, float(15.0), 20D, 20E2, timestamp '2014-04-04 01:00:00.000', date '2014-04-04'), diff --git a/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/in-limit.sql.out b/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/in-limit.sql.out index 08f76f0936a..c1186c9db53 100644 --- a/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/in-limit.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/in-limit.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 18 - - -- !query create temporary view t1 as select * from values ("val1a", 6S, 8, 10L, float(15.0), 20D, 20E2BD, timestamp '2014-04-04 01:00:00.000', date '2014-04-04'), diff --git a/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/in-multiple-columns.sql.out b/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/in-multiple-columns.sql.out index c6e13715bd9..d37dec0dfbc 100644 --- a/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/in-multiple-columns.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/in-multiple-columns.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 8 - - -- !query create temporary view t1 as select * from values ("val1a", 6S, 8, 10L, float(15.0), 20D, 20E2, timestamp '2014-04-04 01:00:00.000', date '2014-04-04'), diff --git a/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/in-order-by.sql.out b/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/in-order-by.sql.out index 5a9d7502759..d687b593883 100644 --- a/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/in-order-by.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/in-order-by.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 18 - - -- !query create temporary view t1 as select * from values ("val1a", 6S, 8, 10L, float(15.0), 20D, 20E2BD, timestamp '2014-04-04 01:00:00.000', date '2014-04-04'), diff --git a/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/in-set-operations.sql.out b/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/in-set-operations.sql.out index 783f4031a45..5c961c10e0f 100644 --- a/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/in-set-operations.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/in-set-operations.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 16 - - -- !query create temporary view t1 as select * from values ("val1a", 6S, 8, 10L, float(15.0), 20D, 20E2BD, timestamp '2014-04-04 01:00:00.000', date '2014-04-04'), diff --git a/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/in-with-cte.sql.out b/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/in-with-cte.sql.out index b9cc68a3397..562b8302e1c 100644 --- a/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/in-with-cte.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/in-with-cte.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 13 - - -- !query create temporary view t1 as select * from values ("val1a", 6S, 8, 10L, float(15.0), 20D, 20E2, timestamp '2014-04-04 01:00:00.000', date '2014-04-04'), diff --git a/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/nested-not-in.sql.out b/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/nested-not-in.sql.out index 86f967eee1e..874e7a602e7 100644 --- a/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/nested-not-in.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/nested-not-in.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 21 - - -- !query CREATE TEMPORARY VIEW EMP AS SELECT * FROM VALUES (100, "emp 1", 10), diff --git a/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/not-in-group-by.sql.out b/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/not-in-group-by.sql.out index 720db9e8bdb..1b51206950c 100644 --- a/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/not-in-group-by.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/not-in-group-by.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 8 - - -- !query create temporary view t1 as select * from values ("val1a", 6S, 8, 10L, float(15.0), 20D, 20E2, timestamp '2014-04-04 01:00:00.000', date '2014-04-04'), diff --git a/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/not-in-joins.sql.out b/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/not-in-joins.sql.out index 4872e3c953f..9aeff336c6d 100644 --- a/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/not-in-joins.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/not-in-joins.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 9 - - -- !query create temporary view t1 as select * from values ("val1a", 6S, 8, 10L, float(15.0), 20D, 20E2, timestamp '2014-04-04 01:00:00.000', date '2014-04-04'), diff --git a/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/not-in-unit-tests-multi-column-literal.sql.out b/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/not-in-unit-tests-multi-column-literal.sql.out index bc9e6f84255..2dc9d63c42b 100644 --- a/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/not-in-unit-tests-multi-column-literal.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/not-in-unit-tests-multi-column-literal.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 4 - - -- !query CREATE TEMPORARY VIEW m AS SELECT * FROM VALUES (null, null), diff --git a/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/not-in-unit-tests-multi-column.sql.out b/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/not-in-unit-tests-multi-column.sql.out index 54d6da8d0da..525179f7ffc 100644 --- a/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/not-in-unit-tests-multi-column.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/not-in-unit-tests-multi-column.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 9 - - -- !query CREATE TEMPORARY VIEW m AS SELECT * FROM VALUES (null, null), diff --git a/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/not-in-unit-tests-single-column-literal.sql.out b/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/not-in-unit-tests-single-column-literal.sql.out index 0fc9cf28915..084a4fdbee2 100644 --- a/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/not-in-unit-tests-single-column-literal.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/not-in-unit-tests-single-column-literal.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 5 - - -- !query CREATE TEMPORARY VIEW m AS SELECT * FROM VALUES (null, 1.0), diff --git a/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/not-in-unit-tests-single-column.sql.out b/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/not-in-unit-tests-single-column.sql.out index ef40fd462f8..fe115fb9753 100644 --- a/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/not-in-unit-tests-single-column.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/not-in-unit-tests-single-column.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 10 - - -- !query CREATE TEMPORARY VIEW m AS SELECT * FROM VALUES (null, 1.0), diff --git a/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/simple-in.sql.out b/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/simple-in.sql.out index 0661e1c9e4d..c917bba4dbf 100644 --- a/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/simple-in.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/simple-in.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 14 - - -- !query create temporary view t1 as select * from values ("t1a", 6S, 8, 10L, float(15.0), 20D, 20E2BD, timestamp '2014-04-04 01:00:00.000', date '2014-04-04'), diff --git a/sql/core/src/test/resources/sql-tests/results/subquery/negative-cases/invalid-correlation.sql.out b/sql/core/src/test/resources/sql-tests/results/subquery/negative-cases/invalid-correlation.sql.out index 32b7a4361c9..cf6b57efa2f 100644 --- a/sql/core/src/test/resources/sql-tests/results/subquery/negative-cases/invalid-correlation.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/subquery/negative-cases/invalid-correlation.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 10 - - -- !query CREATE TEMPORARY VIEW t1 AS SELECT * FROM VALUES (1, 2, 3) diff --git a/sql/core/src/test/resources/sql-tests/results/subquery/negative-cases/subq-input-typecheck.sql.out b/sql/core/src/test/resources/sql-tests/results/subquery/negative-cases/subq-input-typecheck.sql.out index 0b1bfdf50c5..8a8334fb57d 100644 --- a/sql/core/src/test/resources/sql-tests/results/subquery/negative-cases/subq-input-typecheck.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/subquery/negative-cases/subq-input-typecheck.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 10 - - -- !query CREATE TEMPORARY VIEW t1 AS SELECT * FROM VALUES (1, 2, 3) diff --git a/sql/core/src/test/resources/sql-tests/results/subquery/scalar-subquery/scalar-subquery-predicate.sql.out b/sql/core/src/test/resources/sql-tests/results/subquery/scalar-subquery/scalar-subquery-predicate.sql.out index b7eef929864..e2074aa515d 100644 --- a/sql/core/src/test/resources/sql-tests/results/subquery/scalar-subquery/scalar-subquery-predicate.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/subquery/scalar-subquery/scalar-subquery-predicate.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 27 - - -- !query CREATE OR REPLACE TEMPORARY VIEW p AS VALUES (1, 1) AS T(pk, pv) -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/subquery/scalar-subquery/scalar-subquery-select.sql.out b/sql/core/src/test/resources/sql-tests/results/subquery/scalar-subquery/scalar-subquery-select.sql.out index 3eb1c6ffba1..97bb9b145ac 100644 --- a/sql/core/src/test/resources/sql-tests/results/subquery/scalar-subquery/scalar-subquery-select.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/subquery/scalar-subquery/scalar-subquery-select.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 26 - - -- !query create temporary view t1 as select * from values ('val1a', 6S, 8, 10L, float(15.0), 20D, 20E2, timestamp '2014-04-04 00:00:00.000', date '2014-04-04'), diff --git a/sql/core/src/test/resources/sql-tests/results/subquery/subquery-in-from.sql.out b/sql/core/src/test/resources/sql-tests/results/subquery/subquery-in-from.sql.out index 11a51dca253..dfb29478467 100644 --- a/sql/core/src/test/resources/sql-tests/results/subquery/subquery-in-from.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/subquery/subquery-in-from.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 6 - - -- !query SELECT * FROM (SELECT * FROM testData) AS t WHERE key = 1 -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/table-aliases.sql.out b/sql/core/src/test/resources/sql-tests/results/table-aliases.sql.out index d5f72147956..c72e5a309bb 100644 --- a/sql/core/src/test/resources/sql-tests/results/table-aliases.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/table-aliases.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 15 - - -- !query CREATE OR REPLACE TEMPORARY VIEW testData AS SELECT * FROM VALUES (1, 1), (1, 2), (2, 1) AS testData(a, b) -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/table-valued-functions.sql.out b/sql/core/src/test/resources/sql-tests/results/table-valued-functions.sql.out index cd853082998..1ce6fbbdbc8 100644 --- a/sql/core/src/test/resources/sql-tests/results/table-valued-functions.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/table-valued-functions.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 10 - - -- !query select * from dummy(3) -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/tablesample-negative.sql.out b/sql/core/src/test/resources/sql-tests/results/tablesample-negative.sql.out index 0188cdd0f8e..9624cdfe7b9 100644 --- a/sql/core/src/test/resources/sql-tests/results/tablesample-negative.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/tablesample-negative.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 6 - - -- !query CREATE DATABASE mydb1 -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/timestamp-ltz.sql.out b/sql/core/src/test/resources/sql-tests/results/timestamp-ltz.sql.out index c2ede2f8953..334632ca2bb 100644 --- a/sql/core/src/test/resources/sql-tests/results/timestamp-ltz.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/timestamp-ltz.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 8 - - -- !query select timestamp_ltz'2016-12-31 00:12:00', timestamp_ltz'2016-12-31' -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/timestamp-ntz.sql.out b/sql/core/src/test/resources/sql-tests/results/timestamp-ntz.sql.out index 1388f640d5b..acdc65a23f4 100644 --- a/sql/core/src/test/resources/sql-tests/results/timestamp-ntz.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/timestamp-ntz.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 19 - - -- !query select timestamp_ntz'2016-12-31 00:12:00', timestamp_ntz'2016-12-31' -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/timestamp.sql.out b/sql/core/src/test/resources/sql-tests/results/timestamp.sql.out index ada9f33c7f4..8894b07fa9e 100644 --- a/sql/core/src/test/resources/sql-tests/results/timestamp.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/timestamp.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 98 - - -- !query select timestamp '2019-01-01\t' -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/timestampNTZ/datetime-special.sql.out b/sql/core/src/test/resources/sql-tests/results/timestampNTZ/datetime-special.sql.out index 6c5e7cdc430..c8cdec4eeb9 100644 --- a/sql/core/src/test/resources/sql-tests/results/timestampNTZ/datetime-special.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/timestampNTZ/datetime-special.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 4 - - -- !query select date'999999-03-18', date'-0001-1-28', date'0015' -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/timestampNTZ/timestamp-ansi.sql.out b/sql/core/src/test/resources/sql-tests/results/timestampNTZ/timestamp-ansi.sql.out index 0e48bda34fd..7165e753968 100644 --- a/sql/core/src/test/resources/sql-tests/results/timestampNTZ/timestamp-ansi.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/timestampNTZ/timestamp-ansi.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 98 - - -- !query select timestamp '2019-01-01\t' -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/timestampNTZ/timestamp.sql.out b/sql/core/src/test/resources/sql-tests/results/timestampNTZ/timestamp.sql.out index d5e03691e0b..6b575697af6 100644 --- a/sql/core/src/test/resources/sql-tests/results/timestampNTZ/timestamp.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/timestampNTZ/timestamp.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 98 - - -- !query select timestamp '2019-01-01\t' -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/timezone.sql.out b/sql/core/src/test/resources/sql-tests/results/timezone.sql.out index 67f76b6e76e..7dbdb174be0 100644 --- a/sql/core/src/test/resources/sql-tests/results/timezone.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/timezone.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 12 - - -- !query SET TIME ZONE 'Asia/Hong_Kong' -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/transform.sql.out b/sql/core/src/test/resources/sql-tests/results/transform.sql.out index 6d7d112b352..b921518bf8d 100644 --- a/sql/core/src/test/resources/sql-tests/results/transform.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/transform.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 51 - - -- !query CREATE OR REPLACE TEMPORARY VIEW t AS SELECT * FROM VALUES ('1', true, unhex('537061726B2053514C'), tinyint(1), 1, smallint(100), bigint(1), float(1.0), 1.0, Decimal(1.0), timestamp('1997-01-02'), date('2000-04-01')), diff --git a/sql/core/src/test/resources/sql-tests/results/try-string-functions.sql.out b/sql/core/src/test/resources/sql-tests/results/try-string-functions.sql.out index bda723fd19e..b3d3197ee7d 100644 Binary files a/sql/core/src/test/resources/sql-tests/results/try-string-functions.sql.out and b/sql/core/src/test/resources/sql-tests/results/try-string-functions.sql.out differ diff --git a/sql/core/src/test/resources/sql-tests/results/try_aggregates.sql.out b/sql/core/src/test/resources/sql-tests/results/try_aggregates.sql.out index 724553f6bd1..862f2488c5f 100644 --- a/sql/core/src/test/resources/sql-tests/results/try_aggregates.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/try_aggregates.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 20 - - -- !query SELECT try_sum(col) FROM VALUES (5), (10), (15) AS tab(col) -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/try_arithmetic.sql.out b/sql/core/src/test/resources/sql-tests/results/try_arithmetic.sql.out index f3c483cfafe..8622b97a205 100644 --- a/sql/core/src/test/resources/sql-tests/results/try_arithmetic.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/try_arithmetic.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 49 - - -- !query SELECT try_add(1, 1) -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/try_cast.sql.out b/sql/core/src/test/resources/sql-tests/results/try_cast.sql.out index 8be8d6be343..ff11bf29e73 100644 --- a/sql/core/src/test/resources/sql-tests/results/try_cast.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/try_cast.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 29 - - -- !query SELECT TRY_CAST('1.23' AS int) -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/try_element_at.sql.out b/sql/core/src/test/resources/sql-tests/results/try_element_at.sql.out index 80709678c87..c1c0980ea52 100644 --- a/sql/core/src/test/resources/sql-tests/results/try_element_at.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/try_element_at.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 8 - - -- !query SELECT try_element_at(array(1, 2, 3), 0) -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/arrayJoin.sql.out b/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/arrayJoin.sql.out index d23b8665145..6e33fab7a32 100644 --- a/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/arrayJoin.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/arrayJoin.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 11 - - -- !query SELECT array_join(array(true, false), ', ') -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/binaryComparison.sql.out b/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/binaryComparison.sql.out index 4cc005d2155..ee0536967ad 100644 --- a/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/binaryComparison.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/binaryComparison.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 265 - - -- !query CREATE TEMPORARY VIEW t AS SELECT 1 -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/booleanEquality.sql.out b/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/booleanEquality.sql.out index 1b63931d922..75a8baea6aa 100644 --- a/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/booleanEquality.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/booleanEquality.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 97 - - -- !query CREATE TEMPORARY VIEW t AS SELECT 1 -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/caseWhenCoercion.sql.out b/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/caseWhenCoercion.sql.out index da1d1993b90..11725df9951 100644 --- a/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/caseWhenCoercion.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/caseWhenCoercion.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 145 - - -- !query CREATE TEMPORARY VIEW t AS SELECT 1 -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/concat.sql.out b/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/concat.sql.out index bd157c474d2..bb02058f6c4 100644 --- a/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/concat.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/concat.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 14 - - -- !query SELECT (col1 || col2 || col3) col FROM ( diff --git a/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/dateTimeOperations.sql.out b/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/dateTimeOperations.sql.out index b25d854070e..94422bd2089 100644 --- a/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/dateTimeOperations.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/dateTimeOperations.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 40 - - -- !query CREATE TEMPORARY VIEW t AS SELECT 1 -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/decimalPrecision.sql.out b/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/decimalPrecision.sql.out index f046438b0fb..2dbe93f312d 100644 --- a/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/decimalPrecision.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/decimalPrecision.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 1145 - - -- !query CREATE TEMPORARY VIEW t AS SELECT 1 -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/division.sql.out b/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/division.sql.out index 987b4dda729..f08d2255f18 100644 --- a/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/division.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/division.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 145 - - -- !query CREATE TEMPORARY VIEW t AS SELECT 1 -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/elt.sql.out b/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/elt.sql.out index 5e335df904a..61ea81f999b 100644 --- a/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/elt.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/elt.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 6 - - -- !query SELECT elt(2, col1, col2, col3, col4, col5) col FROM ( diff --git a/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/ifCoercion.sql.out b/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/ifCoercion.sql.out index a9424db391b..2ef149f5f37 100644 --- a/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/ifCoercion.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/ifCoercion.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 145 - - -- !query CREATE TEMPORARY VIEW t AS SELECT 1 -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/implicitTypeCasts.sql.out b/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/implicitTypeCasts.sql.out index 4e70f8dd5a6..a746500c746 100644 --- a/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/implicitTypeCasts.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/implicitTypeCasts.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 44 - - -- !query CREATE TEMPORARY VIEW t AS SELECT 1 -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/inConversion.sql.out b/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/inConversion.sql.out index 7f87029a2ea..d81ae31f1b8 100644 --- a/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/inConversion.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/inConversion.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 289 - - -- !query CREATE TEMPORARY VIEW t AS SELECT 1 -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/mapZipWith.sql.out b/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/mapZipWith.sql.out index c1ae1bea3e9..2f176951df8 100644 --- a/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/mapZipWith.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/mapZipWith.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 16 - - -- !query CREATE TEMPORARY VIEW various_maps AS SELECT * FROM VALUES ( map(true, false), diff --git a/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/mapconcat.sql.out b/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/mapconcat.sql.out index c8831f3b088..916d32c5e35 100644 --- a/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/mapconcat.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/mapconcat.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 8 - - -- !query CREATE TEMPORARY VIEW various_maps AS SELECT * FROM VALUES ( map(true, false), map(false, true), diff --git a/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/promoteStrings.sql.out b/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/promoteStrings.sql.out index f8ba3e2bb93..c24b06768e9 100644 --- a/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/promoteStrings.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/promoteStrings.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 316 - - -- !query CREATE TEMPORARY VIEW t AS SELECT 1 -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/stringCastAndExpressions.sql.out b/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/stringCastAndExpressions.sql.out index 365a088292b..e987cf4f71c 100644 --- a/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/stringCastAndExpressions.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/stringCastAndExpressions.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 32 - - -- !query CREATE TEMPORARY VIEW t AS SELECT 'aa' as a -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/widenSetOperationTypes.sql.out b/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/widenSetOperationTypes.sql.out index 4f663b9b4fe..f830797212a 100644 --- a/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/widenSetOperationTypes.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/widenSetOperationTypes.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 145 - - -- !query CREATE TEMPORARY VIEW t AS SELECT 1 -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/windowFrameCoercion.sql.out b/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/windowFrameCoercion.sql.out index 33ced918ff3..10346500482 100644 --- a/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/windowFrameCoercion.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/typeCoercion/native/windowFrameCoercion.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 25 - - -- !query CREATE TEMPORARY VIEW t AS SELECT 1 -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/udaf.sql.out b/sql/core/src/test/resources/sql-tests/results/udaf.sql.out index 9f4229a11b6..8dd714c002f 100644 --- a/sql/core/src/test/resources/sql-tests/results/udaf.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/udaf.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 8 - - -- !query CREATE OR REPLACE TEMPORARY VIEW t1 AS SELECT * FROM VALUES (1), (2), (3), (4) diff --git a/sql/core/src/test/resources/sql-tests/results/udf/postgreSQL/udf-aggregates_part1.sql.out b/sql/core/src/test/resources/sql-tests/results/udf/postgreSQL/udf-aggregates_part1.sql.out index 49d3fbd7d87..6d9ab399aca 100644 --- a/sql/core/src/test/resources/sql-tests/results/udf/postgreSQL/udf-aggregates_part1.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/udf/postgreSQL/udf-aggregates_part1.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 56 - - -- !query SELECT avg(udf(four)) AS avg_1 FROM onek -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/udf/postgreSQL/udf-aggregates_part2.sql.out b/sql/core/src/test/resources/sql-tests/results/udf/postgreSQL/udf-aggregates_part2.sql.out index a0008c3dd55..ff5dce8f076 100644 --- a/sql/core/src/test/resources/sql-tests/results/udf/postgreSQL/udf-aggregates_part2.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/udf/postgreSQL/udf-aggregates_part2.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 25 - - -- !query create temporary view int4_tbl as select * from values (0), diff --git a/sql/core/src/test/resources/sql-tests/results/udf/postgreSQL/udf-aggregates_part3.sql.out b/sql/core/src/test/resources/sql-tests/results/udf/postgreSQL/udf-aggregates_part3.sql.out index 17b77a8a7ae..f44b69eaadc 100644 --- a/sql/core/src/test/resources/sql-tests/results/udf/postgreSQL/udf-aggregates_part3.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/udf/postgreSQL/udf-aggregates_part3.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 2 - - -- !query select udf(max(min(unique1))) from tenk1 -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/udf/postgreSQL/udf-aggregates_part4.sql.out b/sql/core/src/test/resources/sql-tests/results/udf/postgreSQL/udf-aggregates_part4.sql.out index 8c21a5067bf..45f00b36f16 100644 --- a/sql/core/src/test/resources/sql-tests/results/udf/postgreSQL/udf-aggregates_part4.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/udf/postgreSQL/udf-aggregates_part4.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 4 - - -- !query select percentile_cont(0.5) within group (order by b) from aggtest -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/udf/postgreSQL/udf-case.sql.out b/sql/core/src/test/resources/sql-tests/results/udf/postgreSQL/udf-case.sql.out index 7c0a37ee667..cf2bdc1efab 100755 --- a/sql/core/src/test/resources/sql-tests/results/udf/postgreSQL/udf-case.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/udf/postgreSQL/udf-case.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 34 - - -- !query CREATE TABLE CASE_TBL ( i integer, diff --git a/sql/core/src/test/resources/sql-tests/results/udf/postgreSQL/udf-join.sql.out b/sql/core/src/test/resources/sql-tests/results/udf/postgreSQL/udf-join.sql.out index 0365f8d8bb1..870a1537971 100644 --- a/sql/core/src/test/resources/sql-tests/results/udf/postgreSQL/udf-join.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/udf/postgreSQL/udf-join.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 197 - - -- !query CREATE OR REPLACE TEMPORARY VIEW INT2_TBL(f1) AS VALUES (smallint(trim('0 '))), diff --git a/sql/core/src/test/resources/sql-tests/results/udf/postgreSQL/udf-select_having.sql.out b/sql/core/src/test/resources/sql-tests/results/udf/postgreSQL/udf-select_having.sql.out index f299dddaed7..3308be92072 100644 --- a/sql/core/src/test/resources/sql-tests/results/udf/postgreSQL/udf-select_having.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/udf/postgreSQL/udf-select_having.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 22 - - -- !query CREATE TABLE test_having (a int, b int, c string, d string) USING parquet -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/udf/postgreSQL/udf-select_implicit.sql.out b/sql/core/src/test/resources/sql-tests/results/udf/postgreSQL/udf-select_implicit.sql.out index 2012a60d9e9..305d099cc4c 100755 --- a/sql/core/src/test/resources/sql-tests/results/udf/postgreSQL/udf-select_implicit.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/udf/postgreSQL/udf-select_implicit.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 38 - - -- !query CREATE TABLE test_missing_target (a int, b int, c string, d string) using parquet -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/udf/udf-count.sql.out b/sql/core/src/test/resources/sql-tests/results/udf/udf-count.sql.out index 4bd8da61860..ce8d5a93a35 100644 --- a/sql/core/src/test/resources/sql-tests/results/udf/udf-count.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/udf/udf-count.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 5 - - -- !query CREATE OR REPLACE TEMPORARY VIEW testData AS SELECT * FROM VALUES (1, 1), (1, 2), (2, 1), (1, 1), (null, 2), (1, null), (null, null) diff --git a/sql/core/src/test/resources/sql-tests/results/udf/udf-cross-join.sql.out b/sql/core/src/test/resources/sql-tests/results/udf/udf-cross-join.sql.out index 3843363f5a7..edfd359a7f4 100644 --- a/sql/core/src/test/resources/sql-tests/results/udf/udf-cross-join.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/udf/udf-cross-join.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 13 - - -- !query create temporary view nt1 as select * from values ("one", 1), diff --git a/sql/core/src/test/resources/sql-tests/results/udf/udf-except-all.sql.out b/sql/core/src/test/resources/sql-tests/results/udf/udf-except-all.sql.out index b8317fd4bd1..997308bdbf6 100644 --- a/sql/core/src/test/resources/sql-tests/results/udf/udf-except-all.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/udf/udf-except-all.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 27 - - -- !query CREATE TEMPORARY VIEW tab1 AS SELECT * FROM VALUES (0), (1), (2), (2), (2), (2), (3), (null), (null) AS tab1(c1) diff --git a/sql/core/src/test/resources/sql-tests/results/udf/udf-except.sql.out b/sql/core/src/test/resources/sql-tests/results/udf/udf-except.sql.out index 7d21715fbaa..0134ad74f52 100644 --- a/sql/core/src/test/resources/sql-tests/results/udf/udf-except.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/udf/udf-except.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 9 - - -- !query create temporary view t1 as select * from values ("one", 1), diff --git a/sql/core/src/test/resources/sql-tests/results/udf/udf-group-analytics.sql.out b/sql/core/src/test/resources/sql-tests/results/udf/udf-group-analytics.sql.out index b180f70d969..7038cfc8a8b 100644 --- a/sql/core/src/test/resources/sql-tests/results/udf/udf-group-analytics.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/udf/udf-group-analytics.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 29 - - -- !query CREATE OR REPLACE TEMPORARY VIEW testData AS SELECT * FROM VALUES (1, 1), (1, 2), (2, 1), (2, 2), (3, 1), (3, 2) diff --git a/sql/core/src/test/resources/sql-tests/results/udf/udf-group-by.sql.out b/sql/core/src/test/resources/sql-tests/results/udf/udf-group-by.sql.out index 1d2a3a63256..753556c911b 100644 --- a/sql/core/src/test/resources/sql-tests/results/udf/udf-group-by.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/udf/udf-group-by.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 52 - - -- !query CREATE OR REPLACE TEMPORARY VIEW testData AS SELECT * FROM VALUES (1, 1), (1, 2), (2, 1), (2, 2), (3, 1), (3, 2), (null, 1), (3, null), (null, null) diff --git a/sql/core/src/test/resources/sql-tests/results/udf/udf-having.sql.out b/sql/core/src/test/resources/sql-tests/results/udf/udf-having.sql.out index fb0a5b04dc1..147c0e24cd9 100644 --- a/sql/core/src/test/resources/sql-tests/results/udf/udf-having.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/udf/udf-having.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 5 - - -- !query create temporary view hav as select * from values ("one", 1), diff --git a/sql/core/src/test/resources/sql-tests/results/udf/udf-inline-table.sql.out b/sql/core/src/test/resources/sql-tests/results/udf/udf-inline-table.sql.out index e7891b56390..b6c017118a6 100644 --- a/sql/core/src/test/resources/sql-tests/results/udf/udf-inline-table.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/udf/udf-inline-table.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 17 - - -- !query select udf(col1), udf(col2) from values ("one", 1) -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/udf/udf-inner-join.sql.out b/sql/core/src/test/resources/sql-tests/results/udf/udf-inner-join.sql.out index 107fe9eb2fe..2ac134fa666 100644 --- a/sql/core/src/test/resources/sql-tests/results/udf/udf-inner-join.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/udf/udf-inner-join.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 7 - - -- !query CREATE TEMPORARY VIEW t1 AS SELECT * FROM VALUES (1) AS GROUPING(a) -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/udf/udf-intersect-all.sql.out b/sql/core/src/test/resources/sql-tests/results/udf/udf-intersect-all.sql.out index 6210f1d0127..29febc747ea 100644 --- a/sql/core/src/test/resources/sql-tests/results/udf/udf-intersect-all.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/udf/udf-intersect-all.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 22 - - -- !query CREATE TEMPORARY VIEW tab1 AS SELECT * FROM VALUES (1, 2), diff --git a/sql/core/src/test/resources/sql-tests/results/udf/udf-join-empty-relation.sql.out b/sql/core/src/test/resources/sql-tests/results/udf/udf-join-empty-relation.sql.out index 94ac49588e3..5dbfb54b4b1 100644 --- a/sql/core/src/test/resources/sql-tests/results/udf/udf-join-empty-relation.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/udf/udf-join-empty-relation.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 24 - - -- !query CREATE TEMPORARY VIEW t1 AS SELECT * FROM VALUES (1) AS GROUPING(a) -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/udf/udf-natural-join.sql.out b/sql/core/src/test/resources/sql-tests/results/udf/udf-natural-join.sql.out index dd6ba9d6ddd..ca3dae070e7 100644 --- a/sql/core/src/test/resources/sql-tests/results/udf/udf-natural-join.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/udf/udf-natural-join.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 6 - - -- !query create temporary view nt1 as select * from values ("one", 1), diff --git a/sql/core/src/test/resources/sql-tests/results/udf/udf-outer-join.sql.out b/sql/core/src/test/resources/sql-tests/results/udf/udf-outer-join.sql.out index c9a3a519c5e..2771d144cde 100644 --- a/sql/core/src/test/resources/sql-tests/results/udf/udf-outer-join.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/udf/udf-outer-join.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 8 - - -- !query CREATE OR REPLACE TEMPORARY VIEW t1 AS SELECT * FROM VALUES (-234), (145), (367), (975), (298) diff --git a/sql/core/src/test/resources/sql-tests/results/udf/udf-pivot.sql.out b/sql/core/src/test/resources/sql-tests/results/udf/udf-pivot.sql.out index b03e8ded167..7f92e489e22 100644 --- a/sql/core/src/test/resources/sql-tests/results/udf/udf-pivot.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/udf/udf-pivot.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 30 - - -- !query create temporary view courseSales as select * from values ("dotNET", 2012, 10000), diff --git a/sql/core/src/test/resources/sql-tests/results/udf/udf-special-values.sql.out b/sql/core/src/test/resources/sql-tests/results/udf/udf-special-values.sql.out index f7e1874477e..73c0a0642da 100644 --- a/sql/core/src/test/resources/sql-tests/results/udf/udf-special-values.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/udf/udf-special-values.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 6 - - -- !query SELECT udf(x) FROM (VALUES (1), (2), (NULL)) v(x) -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/udf/udf-udaf.sql.out b/sql/core/src/test/resources/sql-tests/results/udf/udf-udaf.sql.out index 19221947b4a..78ffe9197d0 100644 --- a/sql/core/src/test/resources/sql-tests/results/udf/udf-udaf.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/udf/udf-udaf.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 8 - - -- !query CREATE OR REPLACE TEMPORARY VIEW t1 AS SELECT * FROM VALUES (1), (2), (3), (4) diff --git a/sql/core/src/test/resources/sql-tests/results/udf/udf-union.sql.out b/sql/core/src/test/resources/sql-tests/results/udf/udf-union.sql.out index c06c35d34cd..a355bdb1658 100644 --- a/sql/core/src/test/resources/sql-tests/results/udf/udf-union.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/udf/udf-union.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 16 - - -- !query CREATE OR REPLACE TEMPORARY VIEW t1 AS VALUES (1, 'a'), (2, 'b') tbl(c1, c2) -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/udf/udf-window.sql.out b/sql/core/src/test/resources/sql-tests/results/udf/udf-window.sql.out index aa25ddb6e7c..076c7dd6a15 100644 --- a/sql/core/src/test/resources/sql-tests/results/udf/udf-window.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/udf/udf-window.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 23 - - -- !query CREATE OR REPLACE TEMPORARY VIEW testData AS SELECT * FROM VALUES (null, 1L, 1.0D, date("2017-08-01"), timestamp_seconds(1501545600), "a"), diff --git a/sql/core/src/test/resources/sql-tests/results/union.sql.out b/sql/core/src/test/resources/sql-tests/results/union.sql.out index ce3c761bc5d..674e58cd102 100644 --- a/sql/core/src/test/resources/sql-tests/results/union.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/union.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 20 - - -- !query CREATE OR REPLACE TEMPORARY VIEW t1 AS VALUES (1, 'a'), (2, 'b') tbl(c1, c2) -- !query schema diff --git a/sql/core/src/test/resources/sql-tests/results/using-join.sql.out b/sql/core/src/test/resources/sql-tests/results/using-join.sql.out index 1d2ae9d96ec..c2483f24b41 100644 --- a/sql/core/src/test/resources/sql-tests/results/using-join.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/using-join.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 31 - - -- !query create temporary view nt1 as select * from values ("one", 1), diff --git a/sql/core/src/test/resources/sql-tests/results/window.sql.out b/sql/core/src/test/resources/sql-tests/results/window.sql.out index 5d1f7a44f0d..57725a2d3e9 100644 --- a/sql/core/src/test/resources/sql-tests/results/window.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/window.sql.out @@ -1,7 +1,4 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 55 - - -- !query CREATE OR REPLACE TEMPORARY VIEW testData AS SELECT * FROM VALUES (null, 1L, 1.0D, date("2017-08-01"), timestamp_seconds(1501545600), "a"), diff --git a/sql/core/src/test/scala/org/apache/spark/sql/SQLQueryTestSuite.scala b/sql/core/src/test/scala/org/apache/spark/sql/SQLQueryTestSuite.scala index d6a7c69018f..0601dce1d4b 100644 --- a/sql/core/src/test/scala/org/apache/spark/sql/SQLQueryTestSuite.scala +++ b/sql/core/src/test/scala/org/apache/spark/sql/SQLQueryTestSuite.scala @@ -412,7 +412,6 @@ class SQLQueryTestSuite extends QueryTest with SharedSparkSession with SQLHelper // Again, we are explicitly not using multi-line string due to stripMargin removing "|". val goldenOutput = { s"-- Automatically generated by ${getClass.getSimpleName}\n" + - s"-- Number of queries: ${outputs.size}\n\n\n" + outputs.mkString("\n\n\n") + "\n" } val resultFile = new File(testCase.resultFile) --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@spark.apache.org For additional commands, e-mail: commits-h...@spark.apache.org