You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@spark.apache.org by gu...@apache.org on 2022/06/15 11:20:30 UTC
[spark] branch master updated: [SPARK-39477][SQL] Remove "Number of queries" info from the golden files of SQLQueryTestSuite
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 <ge...@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 <ge...@apache.org>
Signed-off-by: Hyukjin Kwon <gu...@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-unsubscribe@spark.apache.org
For additional commands, e-mail: commits-help@spark.apache.org