This is an automated email from the ASF dual-hosted git repository.
findepi pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/datafusion.git
The following commit(s) were added to refs/heads/main by this push:
new 705ea42789 Update all spark SLT files (#16637)
705ea42789 is described below
commit 705ea42789d7aa0ed64d966e078867f067072476
Author: Piotr Findeisen <piotr.findei...@gmail.com>
AuthorDate: Wed Jul 2 21:04:10 2025 +0200
Update all spark SLT files (#16637)
Run `cargo test --test sqllogictests -- --complete` and commit the
results.
---
datafusion/sqllogictest/test_files/spark/bitwise/bit_count.slt | 1 -
datafusion/sqllogictest/test_files/spark/bitwise/bit_get.slt | 1 -
datafusion/sqllogictest/test_files/spark/bitwise/getbit.slt | 1 -
datafusion/sqllogictest/test_files/spark/bitwise/shiftright.slt | 1 -
datafusion/sqllogictest/test_files/spark/bitwise/shiftrightunsigned.slt | 1 -
datafusion/sqllogictest/test_files/spark/collection/concat.slt | 1 -
datafusion/sqllogictest/test_files/spark/collection/reverse.slt | 1 -
datafusion/sqllogictest/test_files/spark/conditional/coalesce.slt | 1 -
datafusion/sqllogictest/test_files/spark/conditional/if.slt | 1 -
datafusion/sqllogictest/test_files/spark/conditional/nullif.slt | 1 -
datafusion/sqllogictest/test_files/spark/conditional/nvl2.slt | 1 -
datafusion/sqllogictest/test_files/spark/csv/schema_of_csv.slt | 1 -
datafusion/sqllogictest/test_files/spark/datetime/add_months.slt | 1 -
datafusion/sqllogictest/test_files/spark/datetime/convert_timezone.slt | 1 -
datafusion/sqllogictest/test_files/spark/datetime/curdate.slt | 1 -
datafusion/sqllogictest/test_files/spark/datetime/current_date.slt | 1 -
datafusion/sqllogictest/test_files/spark/datetime/current_timestamp.slt | 1 -
datafusion/sqllogictest/test_files/spark/datetime/current_timezone.slt | 1 -
datafusion/sqllogictest/test_files/spark/datetime/date_add.slt | 1 -
datafusion/sqllogictest/test_files/spark/datetime/date_diff.slt | 1 -
datafusion/sqllogictest/test_files/spark/datetime/date_format.slt | 1 -
datafusion/sqllogictest/test_files/spark/datetime/date_part.slt | 1 -
datafusion/sqllogictest/test_files/spark/datetime/date_sub.slt | 1 -
datafusion/sqllogictest/test_files/spark/datetime/date_trunc.slt | 1 -
datafusion/sqllogictest/test_files/spark/datetime/dateadd.slt | 1 -
datafusion/sqllogictest/test_files/spark/datetime/datediff.slt | 1 -
datafusion/sqllogictest/test_files/spark/datetime/datepart.slt | 1 -
datafusion/sqllogictest/test_files/spark/datetime/day.slt | 1 -
datafusion/sqllogictest/test_files/spark/datetime/dayofmonth.slt | 1 -
datafusion/sqllogictest/test_files/spark/datetime/dayofweek.slt | 1 -
datafusion/sqllogictest/test_files/spark/datetime/dayofyear.slt | 1 -
datafusion/sqllogictest/test_files/spark/datetime/hour.slt | 1 -
datafusion/sqllogictest/test_files/spark/datetime/last_day.slt | 1 -
datafusion/sqllogictest/test_files/spark/datetime/localtimestamp.slt | 1 -
datafusion/sqllogictest/test_files/spark/datetime/make_date.slt | 1 -
datafusion/sqllogictest/test_files/spark/datetime/make_dt_interval.slt | 1 -
datafusion/sqllogictest/test_files/spark/datetime/make_timestamp.slt | 1 -
datafusion/sqllogictest/test_files/spark/datetime/make_timestamp_ltz.slt | 1 -
datafusion/sqllogictest/test_files/spark/datetime/make_timestamp_ntz.slt | 1 -
datafusion/sqllogictest/test_files/spark/datetime/make_ym_interval.slt | 1 -
datafusion/sqllogictest/test_files/spark/datetime/minute.slt | 1 -
datafusion/sqllogictest/test_files/spark/datetime/month.slt | 1 -
datafusion/sqllogictest/test_files/spark/datetime/months_between.slt | 1 -
datafusion/sqllogictest/test_files/spark/datetime/next_day.slt | 1 -
datafusion/sqllogictest/test_files/spark/datetime/now.slt | 1 -
datafusion/sqllogictest/test_files/spark/datetime/quarter.slt | 1 -
datafusion/sqllogictest/test_files/spark/datetime/second.slt | 1 -
datafusion/sqllogictest/test_files/spark/datetime/timestamp_micros.slt | 1 -
datafusion/sqllogictest/test_files/spark/datetime/timestamp_millis.slt | 1 -
datafusion/sqllogictest/test_files/spark/datetime/timestamp_seconds.slt | 1 -
datafusion/sqllogictest/test_files/spark/datetime/to_date.slt | 1 -
datafusion/sqllogictest/test_files/spark/datetime/to_timestamp.slt | 1 -
datafusion/sqllogictest/test_files/spark/datetime/to_timestamp_ltz.slt | 1 -
datafusion/sqllogictest/test_files/spark/datetime/to_timestamp_ntz.slt | 1 -
datafusion/sqllogictest/test_files/spark/datetime/to_unix_timestamp.slt | 1 -
datafusion/sqllogictest/test_files/spark/datetime/to_utc_timestamp.slt | 1 -
datafusion/sqllogictest/test_files/spark/datetime/trunc.slt | 1 -
datafusion/sqllogictest/test_files/spark/datetime/try_to_timestamp.slt | 1 -
datafusion/sqllogictest/test_files/spark/datetime/unix_timestamp.slt | 1 -
datafusion/sqllogictest/test_files/spark/datetime/weekday.slt | 1 -
datafusion/sqllogictest/test_files/spark/datetime/weekofyear.slt | 1 -
datafusion/sqllogictest/test_files/spark/datetime/year.slt | 1 -
datafusion/sqllogictest/test_files/spark/hash/crc32.slt | 1 -
datafusion/sqllogictest/test_files/spark/hash/md5.slt | 1 -
datafusion/sqllogictest/test_files/spark/hash/sha.slt | 1 -
datafusion/sqllogictest/test_files/spark/hash/sha1.slt | 1 -
datafusion/sqllogictest/test_files/spark/json/get_json_object.slt | 1 -
datafusion/sqllogictest/test_files/spark/json/json_object_keys.slt | 1 -
datafusion/sqllogictest/test_files/spark/math/abs.slt | 1 -
datafusion/sqllogictest/test_files/spark/math/acos.slt | 1 -
datafusion/sqllogictest/test_files/spark/math/acosh.slt | 1 -
datafusion/sqllogictest/test_files/spark/math/asin.slt | 1 -
datafusion/sqllogictest/test_files/spark/math/asinh.slt | 1 -
datafusion/sqllogictest/test_files/spark/math/atan.slt | 1 -
datafusion/sqllogictest/test_files/spark/math/atan2.slt | 1 -
datafusion/sqllogictest/test_files/spark/math/atanh.slt | 1 -
datafusion/sqllogictest/test_files/spark/math/bin.slt | 1 -
datafusion/sqllogictest/test_files/spark/math/bround.slt | 1 -
datafusion/sqllogictest/test_files/spark/math/cbrt.slt | 1 -
datafusion/sqllogictest/test_files/spark/math/ceil.slt | 1 -
datafusion/sqllogictest/test_files/spark/math/ceiling.slt | 1 -
datafusion/sqllogictest/test_files/spark/math/conv.slt | 1 -
datafusion/sqllogictest/test_files/spark/math/cos.slt | 1 -
datafusion/sqllogictest/test_files/spark/math/cosh.slt | 1 -
datafusion/sqllogictest/test_files/spark/math/cot.slt | 1 -
datafusion/sqllogictest/test_files/spark/math/csc.slt | 1 -
datafusion/sqllogictest/test_files/spark/math/degrees.slt | 1 -
datafusion/sqllogictest/test_files/spark/math/e.slt | 1 -
datafusion/sqllogictest/test_files/spark/math/exp.slt | 1 -
datafusion/sqllogictest/test_files/spark/math/floor.slt | 1 -
datafusion/sqllogictest/test_files/spark/math/greatest.slt | 1 -
datafusion/sqllogictest/test_files/spark/math/hypot.slt | 1 -
datafusion/sqllogictest/test_files/spark/math/least.slt | 1 -
datafusion/sqllogictest/test_files/spark/math/ln.slt | 1 -
datafusion/sqllogictest/test_files/spark/math/log.slt | 1 -
datafusion/sqllogictest/test_files/spark/math/log10.slt | 1 -
datafusion/sqllogictest/test_files/spark/math/log1p.slt | 1 -
datafusion/sqllogictest/test_files/spark/math/log2.slt | 1 -
datafusion/sqllogictest/test_files/spark/math/mod.slt | 1 -
datafusion/sqllogictest/test_files/spark/math/negative.slt | 1 -
datafusion/sqllogictest/test_files/spark/math/pi.slt | 1 -
datafusion/sqllogictest/test_files/spark/math/pmod.slt | 1 -
datafusion/sqllogictest/test_files/spark/math/positive.slt | 1 -
datafusion/sqllogictest/test_files/spark/math/pow.slt | 1 -
datafusion/sqllogictest/test_files/spark/math/power.slt | 1 -
datafusion/sqllogictest/test_files/spark/math/radians.slt | 1 -
datafusion/sqllogictest/test_files/spark/math/rand.slt | 1 -
datafusion/sqllogictest/test_files/spark/math/randn.slt | 1 -
datafusion/sqllogictest/test_files/spark/math/random.slt | 1 -
datafusion/sqllogictest/test_files/spark/math/rint.slt | 1 -
datafusion/sqllogictest/test_files/spark/math/round.slt | 1 -
datafusion/sqllogictest/test_files/spark/math/sec.slt | 1 -
datafusion/sqllogictest/test_files/spark/math/shiftleft.slt | 1 -
datafusion/sqllogictest/test_files/spark/math/sign.slt | 1 -
datafusion/sqllogictest/test_files/spark/math/signum.slt | 1 -
datafusion/sqllogictest/test_files/spark/math/sin.slt | 1 -
datafusion/sqllogictest/test_files/spark/math/sinh.slt | 1 -
datafusion/sqllogictest/test_files/spark/math/sqrt.slt | 1 -
datafusion/sqllogictest/test_files/spark/math/tan.slt | 1 -
datafusion/sqllogictest/test_files/spark/math/tanh.slt | 1 -
datafusion/sqllogictest/test_files/spark/math/try_add.slt | 1 -
datafusion/sqllogictest/test_files/spark/math/try_divide.slt | 1 -
datafusion/sqllogictest/test_files/spark/math/try_multiply.slt | 1 -
datafusion/sqllogictest/test_files/spark/math/try_subtract.slt | 1 -
datafusion/sqllogictest/test_files/spark/math/width_bucket.slt | 1 -
datafusion/sqllogictest/test_files/spark/misc/assert_true.slt | 1 -
datafusion/sqllogictest/test_files/spark/misc/current_catalog.slt | 1 -
datafusion/sqllogictest/test_files/spark/misc/current_database.slt | 1 -
datafusion/sqllogictest/test_files/spark/misc/current_schema.slt | 1 -
datafusion/sqllogictest/test_files/spark/misc/current_user.slt | 1 -
datafusion/sqllogictest/test_files/spark/misc/equal_null.slt | 1 -
.../sqllogictest/test_files/spark/misc/input_file_block_length.slt | 1 -
datafusion/sqllogictest/test_files/spark/misc/input_file_block_start.slt | 1 -
datafusion/sqllogictest/test_files/spark/misc/input_file_name.slt | 1 -
datafusion/sqllogictest/test_files/spark/misc/java_method.slt | 1 -
.../sqllogictest/test_files/spark/misc/monotonically_increasing_id.slt | 1 -
datafusion/sqllogictest/test_files/spark/misc/reflect.slt | 1 -
datafusion/sqllogictest/test_files/spark/misc/spark_partition_id.slt | 1 -
datafusion/sqllogictest/test_files/spark/misc/typeof.slt | 1 -
datafusion/sqllogictest/test_files/spark/misc/user.slt | 1 -
datafusion/sqllogictest/test_files/spark/misc/uuid.slt | 1 -
datafusion/sqllogictest/test_files/spark/misc/version.slt | 1 -
datafusion/sqllogictest/test_files/spark/predicate/ilike.slt | 1 -
datafusion/sqllogictest/test_files/spark/predicate/isnotnull.slt | 1 -
datafusion/sqllogictest/test_files/spark/predicate/isnull.slt | 1 -
datafusion/sqllogictest/test_files/spark/predicate/like.slt | 1 -
datafusion/sqllogictest/test_files/spark/string/base64.slt | 1 -
datafusion/sqllogictest/test_files/spark/string/bit_length.slt | 1 -
datafusion/sqllogictest/test_files/spark/string/btrim.slt | 1 -
datafusion/sqllogictest/test_files/spark/string/char_length.slt | 1 -
datafusion/sqllogictest/test_files/spark/string/character_length.slt | 1 -
datafusion/sqllogictest/test_files/spark/string/chr.slt | 1 -
datafusion/sqllogictest/test_files/spark/string/concat_ws.slt | 1 -
datafusion/sqllogictest/test_files/spark/string/contains.slt | 1 -
datafusion/sqllogictest/test_files/spark/string/decode.slt | 1 -
datafusion/sqllogictest/test_files/spark/string/elt.slt | 1 -
datafusion/sqllogictest/test_files/spark/string/encode.slt | 1 -
datafusion/sqllogictest/test_files/spark/string/endswith.slt | 1 -
datafusion/sqllogictest/test_files/spark/string/find_in_set.slt | 1 -
datafusion/sqllogictest/test_files/spark/string/format_number.slt | 1 -
datafusion/sqllogictest/test_files/spark/string/format_string.slt | 1 -
datafusion/sqllogictest/test_files/spark/string/initcap.slt | 1 -
datafusion/sqllogictest/test_files/spark/string/instr.slt | 1 -
datafusion/sqllogictest/test_files/spark/string/lcase.slt | 1 -
datafusion/sqllogictest/test_files/spark/string/left.slt | 1 -
datafusion/sqllogictest/test_files/spark/string/len.slt | 1 -
datafusion/sqllogictest/test_files/spark/string/length.slt | 1 -
datafusion/sqllogictest/test_files/spark/string/levenshtein.slt | 1 -
datafusion/sqllogictest/test_files/spark/string/locate.slt | 1 -
datafusion/sqllogictest/test_files/spark/string/lower.slt | 1 -
datafusion/sqllogictest/test_files/spark/string/lpad.slt | 1 -
datafusion/sqllogictest/test_files/spark/string/ltrim.slt | 1 -
datafusion/sqllogictest/test_files/spark/string/luhn_check.slt | 1 -
datafusion/sqllogictest/test_files/spark/string/mask.slt | 1 -
datafusion/sqllogictest/test_files/spark/string/octet_length.slt | 1 -
datafusion/sqllogictest/test_files/spark/string/position.slt | 1 -
datafusion/sqllogictest/test_files/spark/string/printf.slt | 1 -
datafusion/sqllogictest/test_files/spark/string/repeat.slt | 1 -
datafusion/sqllogictest/test_files/spark/string/replace.slt | 1 -
datafusion/sqllogictest/test_files/spark/string/right.slt | 1 -
datafusion/sqllogictest/test_files/spark/string/rpad.slt | 1 -
datafusion/sqllogictest/test_files/spark/string/rtrim.slt | 1 -
datafusion/sqllogictest/test_files/spark/string/sentences.slt | 1 -
datafusion/sqllogictest/test_files/spark/string/soundex.slt | 1 -
datafusion/sqllogictest/test_files/spark/string/split_part.slt | 1 -
datafusion/sqllogictest/test_files/spark/string/startswith.slt | 1 -
datafusion/sqllogictest/test_files/spark/string/substr.slt | 1 -
datafusion/sqllogictest/test_files/spark/string/substring.slt | 1 -
datafusion/sqllogictest/test_files/spark/string/substring_index.slt | 1 -
datafusion/sqllogictest/test_files/spark/string/to_binary.slt | 1 -
datafusion/sqllogictest/test_files/spark/string/to_char.slt | 1 -
datafusion/sqllogictest/test_files/spark/string/to_number.slt | 1 -
datafusion/sqllogictest/test_files/spark/string/to_varchar.slt | 1 -
datafusion/sqllogictest/test_files/spark/string/translate.slt | 1 -
datafusion/sqllogictest/test_files/spark/string/trim.slt | 1 -
datafusion/sqllogictest/test_files/spark/string/try_to_binary.slt | 1 -
datafusion/sqllogictest/test_files/spark/string/try_to_number.slt | 1 -
datafusion/sqllogictest/test_files/spark/string/ucase.slt | 1 -
datafusion/sqllogictest/test_files/spark/string/unbase64.slt | 1 -
datafusion/sqllogictest/test_files/spark/string/upper.slt | 1 -
datafusion/sqllogictest/test_files/spark/struct/named_struct.slt | 1 -
datafusion/sqllogictest/test_files/spark/struct/struct.slt | 1 -
datafusion/sqllogictest/test_files/spark/url/parse_url.slt | 1 -
datafusion/sqllogictest/test_files/spark/url/url_decode.slt | 1 -
datafusion/sqllogictest/test_files/spark/url/url_encode.slt | 1 -
datafusion/sqllogictest/test_files/spark/xml/xpath.slt | 1 -
datafusion/sqllogictest/test_files/spark/xml/xpath_boolean.slt | 1 -
datafusion/sqllogictest/test_files/spark/xml/xpath_string.slt | 1 -
208 files changed, 208 deletions(-)
diff --git a/datafusion/sqllogictest/test_files/spark/bitwise/bit_count.slt
b/datafusion/sqllogictest/test_files/spark/bitwise/bit_count.slt
index dfbf1f1ff5..d513888db9 100644
--- a/datafusion/sqllogictest/test_files/spark/bitwise/bit_count.slt
+++ b/datafusion/sqllogictest/test_files/spark/bitwise/bit_count.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'bit_count(0)': 0, 'typeof(bit_count(0))': 'int',
'typeof(0)': 'int'}
#query
#SELECT bit_count(0::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/bitwise/bit_get.slt
b/datafusion/sqllogictest/test_files/spark/bitwise/bit_get.slt
index 9086d5651e..8bf8851831 100644
--- a/datafusion/sqllogictest/test_files/spark/bitwise/bit_get.slt
+++ b/datafusion/sqllogictest/test_files/spark/bitwise/bit_get.slt
@@ -30,4 +30,3 @@
## PySpark 3.5.5 Result: {'bit_get(11, 2)': 0, 'typeof(bit_get(11, 2))':
'tinyint', 'typeof(11)': 'int', 'typeof(2)': 'int'}
#query
#SELECT bit_get(11::int, 2::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/bitwise/getbit.slt
b/datafusion/sqllogictest/test_files/spark/bitwise/getbit.slt
index 6f25603c5b..438f5cb427 100644
--- a/datafusion/sqllogictest/test_files/spark/bitwise/getbit.slt
+++ b/datafusion/sqllogictest/test_files/spark/bitwise/getbit.slt
@@ -30,4 +30,3 @@
## PySpark 3.5.5 Result: {'getbit(11, 2)': 0, 'typeof(getbit(11, 2))':
'tinyint', 'typeof(11)': 'int', 'typeof(2)': 'int'}
#query
#SELECT getbit(11::int, 2::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/bitwise/shiftright.slt
b/datafusion/sqllogictest/test_files/spark/bitwise/shiftright.slt
index 8c8cc366ff..2956fd5a63 100644
--- a/datafusion/sqllogictest/test_files/spark/bitwise/shiftright.slt
+++ b/datafusion/sqllogictest/test_files/spark/bitwise/shiftright.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'shiftright(4, 1)': 2, 'typeof(shiftright(4, 1))':
'int', 'typeof(4)': 'int', 'typeof(1)': 'int'}
#query
#SELECT shiftright(4::int, 1::int);
-
diff --git
a/datafusion/sqllogictest/test_files/spark/bitwise/shiftrightunsigned.slt
b/datafusion/sqllogictest/test_files/spark/bitwise/shiftrightunsigned.slt
index 34be404005..134246957e 100644
--- a/datafusion/sqllogictest/test_files/spark/bitwise/shiftrightunsigned.slt
+++ b/datafusion/sqllogictest/test_files/spark/bitwise/shiftrightunsigned.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'shiftrightunsigned(4, 1)': 2,
'typeof(shiftrightunsigned(4, 1))': 'int', 'typeof(4)': 'int', 'typeof(1)':
'int'}
#query
#SELECT shiftrightunsigned(4::int, 1::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/collection/concat.slt
b/datafusion/sqllogictest/test_files/spark/collection/concat.slt
index 8ac5a836c5..911975d9c7 100644
--- a/datafusion/sqllogictest/test_files/spark/collection/concat.slt
+++ b/datafusion/sqllogictest/test_files/spark/collection/concat.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'concat(Spark, SQL)': 'SparkSQL',
'typeof(concat(Spark, SQL))': 'string', 'typeof(Spark)': 'string',
'typeof(SQL)': 'string'}
#query
#SELECT concat('Spark'::string, 'SQL'::string);
-
diff --git a/datafusion/sqllogictest/test_files/spark/collection/reverse.slt
b/datafusion/sqllogictest/test_files/spark/collection/reverse.slt
index 961cbd3baa..f49c7c2a8c 100644
--- a/datafusion/sqllogictest/test_files/spark/collection/reverse.slt
+++ b/datafusion/sqllogictest/test_files/spark/collection/reverse.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'reverse(Spark SQL)': 'LQS krapS',
'typeof(reverse(Spark SQL))': 'string', 'typeof(Spark SQL)': 'string'}
#query
#SELECT reverse('Spark SQL'::string);
-
diff --git a/datafusion/sqllogictest/test_files/spark/conditional/coalesce.slt
b/datafusion/sqllogictest/test_files/spark/conditional/coalesce.slt
index 9c9f9796fc..3af8110ad6 100644
--- a/datafusion/sqllogictest/test_files/spark/conditional/coalesce.slt
+++ b/datafusion/sqllogictest/test_files/spark/conditional/coalesce.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'coalesce(NULL, 1, NULL)': 1, 'typeof(coalesce(NULL,
1, NULL))': 'int', 'typeof(NULL)': 'void', 'typeof(1)': 'int'}
#query
#SELECT coalesce(NULL::void, 1::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/conditional/if.slt
b/datafusion/sqllogictest/test_files/spark/conditional/if.slt
index e63bab6754..7baedad745 100644
--- a/datafusion/sqllogictest/test_files/spark/conditional/if.slt
+++ b/datafusion/sqllogictest/test_files/spark/conditional/if.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'(IF((1 < 2), a, b))': 'a', 'typeof((IF((1 < 2), a,
b)))': 'string', 'typeof((1 < 2))': 'boolean', 'typeof(a)': 'string',
'typeof(b)': 'string'}
#query
#SELECT if((1 < 2)::boolean, 'a'::string, 'b'::string);
-
diff --git a/datafusion/sqllogictest/test_files/spark/conditional/nullif.slt
b/datafusion/sqllogictest/test_files/spark/conditional/nullif.slt
index c13793ab07..1a4c80e3ba 100644
--- a/datafusion/sqllogictest/test_files/spark/conditional/nullif.slt
+++ b/datafusion/sqllogictest/test_files/spark/conditional/nullif.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'nullif(2, 2)': None, 'typeof(nullif(2, 2))': 'int',
'typeof(2)': 'int'}
#query
#SELECT nullif(2::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/conditional/nvl2.slt
b/datafusion/sqllogictest/test_files/spark/conditional/nvl2.slt
index e4507a8223..c5ea2f8f1f 100644
--- a/datafusion/sqllogictest/test_files/spark/conditional/nvl2.slt
+++ b/datafusion/sqllogictest/test_files/spark/conditional/nvl2.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'nvl2(NULL, 2, 1)': 1, 'typeof(nvl2(NULL, 2, 1))':
'int', 'typeof(NULL)': 'void', 'typeof(2)': 'int', 'typeof(1)': 'int'}
#query
#SELECT nvl2(NULL::void, 2::int, 1::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/csv/schema_of_csv.slt
b/datafusion/sqllogictest/test_files/spark/csv/schema_of_csv.slt
index 8f790748bf..eaa31c9d5c 100644
--- a/datafusion/sqllogictest/test_files/spark/csv/schema_of_csv.slt
+++ b/datafusion/sqllogictest/test_files/spark/csv/schema_of_csv.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'schema_of_csv(1,abc)': 'STRUCT<_c0: INT, _c1:
STRING>', 'typeof(schema_of_csv(1,abc))': 'string', 'typeof(1,abc)': 'string'}
#query
#SELECT schema_of_csv('1,abc'::string);
-
diff --git a/datafusion/sqllogictest/test_files/spark/datetime/add_months.slt
b/datafusion/sqllogictest/test_files/spark/datetime/add_months.slt
index df71582048..cae9b21dd4 100644
--- a/datafusion/sqllogictest/test_files/spark/datetime/add_months.slt
+++ b/datafusion/sqllogictest/test_files/spark/datetime/add_months.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'add_months(2016-08-31, 1)': datetime.date(2016, 9,
30), 'typeof(add_months(2016-08-31, 1))': 'date', 'typeof(2016-08-31)':
'string', 'typeof(1)': 'int'}
#query
#SELECT add_months('2016-08-31'::string, 1::int);
-
diff --git
a/datafusion/sqllogictest/test_files/spark/datetime/convert_timezone.slt
b/datafusion/sqllogictest/test_files/spark/datetime/convert_timezone.slt
index 303787a96b..54c9e616cf 100644
--- a/datafusion/sqllogictest/test_files/spark/datetime/convert_timezone.slt
+++ b/datafusion/sqllogictest/test_files/spark/datetime/convert_timezone.slt
@@ -30,4 +30,3 @@
## PySpark 3.5.5 Result: {"convert_timezone(current_timezone(),
Europe/Brussels, TIMESTAMP_NTZ '2021-12-05 15:00:00')": datetime.datetime(2021,
12, 6, 0, 0), "typeof(convert_timezone(current_timezone(), Europe/Brussels,
TIMESTAMP_NTZ '2021-12-05 15:00:00'))": 'timestamp_ntz',
'typeof(Europe/Brussels)': 'string', "typeof(TIMESTAMP_NTZ '2021-12-05
15:00:00')": 'timestamp_ntz'}
#query
#SELECT convert_timezone('Europe/Brussels'::string, TIMESTAMP_NTZ '2021-12-05
15:00:00'::timestamp_ntz);
-
diff --git a/datafusion/sqllogictest/test_files/spark/datetime/curdate.slt
b/datafusion/sqllogictest/test_files/spark/datetime/curdate.slt
index 5dd57084c5..21ec4c0305 100644
--- a/datafusion/sqllogictest/test_files/spark/datetime/curdate.slt
+++ b/datafusion/sqllogictest/test_files/spark/datetime/curdate.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'current_date()': datetime.date(2025, 6, 14),
'typeof(current_date())': 'date'}
#query
#SELECT curdate();
-
diff --git a/datafusion/sqllogictest/test_files/spark/datetime/current_date.slt
b/datafusion/sqllogictest/test_files/spark/datetime/current_date.slt
index 50e29f8f34..cd18790177 100644
--- a/datafusion/sqllogictest/test_files/spark/datetime/current_date.slt
+++ b/datafusion/sqllogictest/test_files/spark/datetime/current_date.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'current_date()': datetime.date(2025, 6, 14),
'typeof(current_date())': 'date'}
#query
#SELECT current_date();
-
diff --git
a/datafusion/sqllogictest/test_files/spark/datetime/current_timestamp.slt
b/datafusion/sqllogictest/test_files/spark/datetime/current_timestamp.slt
index b440e246ab..f3e4f5856a 100644
--- a/datafusion/sqllogictest/test_files/spark/datetime/current_timestamp.slt
+++ b/datafusion/sqllogictest/test_files/spark/datetime/current_timestamp.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'current_timestamp()': datetime.datetime(2025, 6,
14, 23, 57, 38, 948981), 'typeof(current_timestamp())': 'timestamp'}
#query
#SELECT current_timestamp();
-
diff --git
a/datafusion/sqllogictest/test_files/spark/datetime/current_timezone.slt
b/datafusion/sqllogictest/test_files/spark/datetime/current_timezone.slt
index c811bc9805..db3d8d4074 100644
--- a/datafusion/sqllogictest/test_files/spark/datetime/current_timezone.slt
+++ b/datafusion/sqllogictest/test_files/spark/datetime/current_timezone.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'current_timezone()': 'America/Los_Angeles',
'typeof(current_timezone())': 'string'}
#query
#SELECT current_timezone();
-
diff --git a/datafusion/sqllogictest/test_files/spark/datetime/date_add.slt
b/datafusion/sqllogictest/test_files/spark/datetime/date_add.slt
index 3a9fcd2c2e..be0b1c8524 100644
--- a/datafusion/sqllogictest/test_files/spark/datetime/date_add.slt
+++ b/datafusion/sqllogictest/test_files/spark/datetime/date_add.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'date_add(2016-07-30, 1)': datetime.date(2016, 7,
31), 'typeof(date_add(2016-07-30, 1))': 'date', 'typeof(2016-07-30)': 'string',
'typeof(1)': 'int'}
#query
#SELECT date_add('2016-07-30'::string, 1::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/datetime/date_diff.slt
b/datafusion/sqllogictest/test_files/spark/datetime/date_diff.slt
index 8b17bd74e2..c5871ab41e 100644
--- a/datafusion/sqllogictest/test_files/spark/datetime/date_diff.slt
+++ b/datafusion/sqllogictest/test_files/spark/datetime/date_diff.slt
@@ -30,4 +30,3 @@
## PySpark 3.5.5 Result: {'date_diff(2009-07-31, 2009-07-30)': 1,
'typeof(date_diff(2009-07-31, 2009-07-30))': 'int', 'typeof(2009-07-31)':
'string', 'typeof(2009-07-30)': 'string'}
#query
#SELECT date_diff('2009-07-31'::string, '2009-07-30'::string);
-
diff --git a/datafusion/sqllogictest/test_files/spark/datetime/date_format.slt
b/datafusion/sqllogictest/test_files/spark/datetime/date_format.slt
index 87dd581e01..1242518dee 100644
--- a/datafusion/sqllogictest/test_files/spark/datetime/date_format.slt
+++ b/datafusion/sqllogictest/test_files/spark/datetime/date_format.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'date_format(2016-04-08, y)': '2016',
'typeof(date_format(2016-04-08, y))': 'string', 'typeof(2016-04-08)': 'string',
'typeof(y)': 'string'}
#query
#SELECT date_format('2016-04-08'::string, 'y'::string);
-
diff --git a/datafusion/sqllogictest/test_files/spark/datetime/date_part.slt
b/datafusion/sqllogictest/test_files/spark/datetime/date_part.slt
index b2f00a0435..cd3271cdc7 100644
--- a/datafusion/sqllogictest/test_files/spark/datetime/date_part.slt
+++ b/datafusion/sqllogictest/test_files/spark/datetime/date_part.slt
@@ -60,4 +60,3 @@
## PySpark 3.5.5 Result: {"date_part(week, TIMESTAMP '2019-08-12
01:00:00.123456')": 33, "typeof(date_part(week, TIMESTAMP '2019-08-12
01:00:00.123456'))": 'int', 'typeof(week)': 'string', "typeof(TIMESTAMP
'2019-08-12 01:00:00.123456')": 'timestamp'}
#query
#SELECT date_part('week'::string, TIMESTAMP '2019-08-12
01:00:00.123456'::timestamp);
-
diff --git a/datafusion/sqllogictest/test_files/spark/datetime/date_sub.slt
b/datafusion/sqllogictest/test_files/spark/datetime/date_sub.slt
index 54faf2586c..4cc0a91550 100644
--- a/datafusion/sqllogictest/test_files/spark/datetime/date_sub.slt
+++ b/datafusion/sqllogictest/test_files/spark/datetime/date_sub.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'date_sub(2016-07-30, 1)': datetime.date(2016, 7,
29), 'typeof(date_sub(2016-07-30, 1))': 'date', 'typeof(2016-07-30)': 'string',
'typeof(1)': 'int'}
#query
#SELECT date_sub('2016-07-30'::string, 1::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/datetime/date_trunc.slt
b/datafusion/sqllogictest/test_files/spark/datetime/date_trunc.slt
index 4a8da2ceb1..8a15254e67 100644
--- a/datafusion/sqllogictest/test_files/spark/datetime/date_trunc.slt
+++ b/datafusion/sqllogictest/test_files/spark/datetime/date_trunc.slt
@@ -45,4 +45,3 @@
## PySpark 3.5.5 Result: {'date_trunc(YEAR, 2015-03-05T09:32:05.359)':
datetime.datetime(2015, 1, 1, 0, 0), 'typeof(date_trunc(YEAR,
2015-03-05T09:32:05.359))': 'timestamp', 'typeof(YEAR)': 'string',
'typeof(2015-03-05T09:32:05.359)': 'string'}
#query
#SELECT date_trunc('YEAR'::string, '2015-03-05T09:32:05.359'::string);
-
diff --git a/datafusion/sqllogictest/test_files/spark/datetime/dateadd.slt
b/datafusion/sqllogictest/test_files/spark/datetime/dateadd.slt
index 5c9e34fa12..dd2da11908 100644
--- a/datafusion/sqllogictest/test_files/spark/datetime/dateadd.slt
+++ b/datafusion/sqllogictest/test_files/spark/datetime/dateadd.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'date_add(2016-07-30, 1)': datetime.date(2016, 7,
31), 'typeof(date_add(2016-07-30, 1))': 'date', 'typeof(2016-07-30)': 'string',
'typeof(1)': 'int'}
#query
#SELECT dateadd('2016-07-30'::string, 1::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/datetime/datediff.slt
b/datafusion/sqllogictest/test_files/spark/datetime/datediff.slt
index a1f83ce01b..223e2c313a 100644
--- a/datafusion/sqllogictest/test_files/spark/datetime/datediff.slt
+++ b/datafusion/sqllogictest/test_files/spark/datetime/datediff.slt
@@ -30,4 +30,3 @@
## PySpark 3.5.5 Result: {'datediff(2009-07-31, 2009-07-30)': 1,
'typeof(datediff(2009-07-31, 2009-07-30))': 'int', 'typeof(2009-07-31)':
'string', 'typeof(2009-07-30)': 'string'}
#query
#SELECT datediff('2009-07-31'::string, '2009-07-30'::string);
-
diff --git a/datafusion/sqllogictest/test_files/spark/datetime/datepart.slt
b/datafusion/sqllogictest/test_files/spark/datetime/datepart.slt
index 731e26eebc..b2dd0089c2 100644
--- a/datafusion/sqllogictest/test_files/spark/datetime/datepart.slt
+++ b/datafusion/sqllogictest/test_files/spark/datetime/datepart.slt
@@ -60,4 +60,3 @@
## PySpark 3.5.5 Result: {"datepart(week FROM TIMESTAMP '2019-08-12
01:00:00.123456')": 33, "typeof(datepart(week FROM TIMESTAMP '2019-08-12
01:00:00.123456'))": 'int', 'typeof(week)': 'string', "typeof(TIMESTAMP
'2019-08-12 01:00:00.123456')": 'timestamp'}
#query
#SELECT datepart('week'::string, TIMESTAMP '2019-08-12
01:00:00.123456'::timestamp);
-
diff --git a/datafusion/sqllogictest/test_files/spark/datetime/day.slt
b/datafusion/sqllogictest/test_files/spark/datetime/day.slt
index e6426a20eb..35b73d67f5 100644
--- a/datafusion/sqllogictest/test_files/spark/datetime/day.slt
+++ b/datafusion/sqllogictest/test_files/spark/datetime/day.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'day(2009-07-30)': 30, 'typeof(day(2009-07-30))':
'int', 'typeof(2009-07-30)': 'string'}
#query
#SELECT day('2009-07-30'::string);
-
diff --git a/datafusion/sqllogictest/test_files/spark/datetime/dayofmonth.slt
b/datafusion/sqllogictest/test_files/spark/datetime/dayofmonth.slt
index d685c3d64c..4e4e9ff4a2 100644
--- a/datafusion/sqllogictest/test_files/spark/datetime/dayofmonth.slt
+++ b/datafusion/sqllogictest/test_files/spark/datetime/dayofmonth.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'dayofmonth(2009-07-30)': 30,
'typeof(dayofmonth(2009-07-30))': 'int', 'typeof(2009-07-30)': 'string'}
#query
#SELECT dayofmonth('2009-07-30'::string);
-
diff --git a/datafusion/sqllogictest/test_files/spark/datetime/dayofweek.slt
b/datafusion/sqllogictest/test_files/spark/datetime/dayofweek.slt
index c482b6d156..cc885818f6 100644
--- a/datafusion/sqllogictest/test_files/spark/datetime/dayofweek.slt
+++ b/datafusion/sqllogictest/test_files/spark/datetime/dayofweek.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'dayofweek(2009-07-30)': 5,
'typeof(dayofweek(2009-07-30))': 'int', 'typeof(2009-07-30)': 'string'}
#query
#SELECT dayofweek('2009-07-30'::string);
-
diff --git a/datafusion/sqllogictest/test_files/spark/datetime/dayofyear.slt
b/datafusion/sqllogictest/test_files/spark/datetime/dayofyear.slt
index 71b1afb9d8..7ffab98dac 100644
--- a/datafusion/sqllogictest/test_files/spark/datetime/dayofyear.slt
+++ b/datafusion/sqllogictest/test_files/spark/datetime/dayofyear.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'dayofyear(2016-04-09)': 100,
'typeof(dayofyear(2016-04-09))': 'int', 'typeof(2016-04-09)': 'string'}
#query
#SELECT dayofyear('2016-04-09'::string);
-
diff --git a/datafusion/sqllogictest/test_files/spark/datetime/hour.slt
b/datafusion/sqllogictest/test_files/spark/datetime/hour.slt
index 1dd6bcd466..e129b27165 100644
--- a/datafusion/sqllogictest/test_files/spark/datetime/hour.slt
+++ b/datafusion/sqllogictest/test_files/spark/datetime/hour.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'hour(2009-07-30 12:58:59)': 12,
'typeof(hour(2009-07-30 12:58:59))': 'int', 'typeof(2009-07-30 12:58:59)':
'string'}
#query
#SELECT hour('2009-07-30 12:58:59'::string);
-
diff --git a/datafusion/sqllogictest/test_files/spark/datetime/last_day.slt
b/datafusion/sqllogictest/test_files/spark/datetime/last_day.slt
index c298a2e69c..29fb9ca11b 100644
--- a/datafusion/sqllogictest/test_files/spark/datetime/last_day.slt
+++ b/datafusion/sqllogictest/test_files/spark/datetime/last_day.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'last_day(2009-01-12)': datetime.date(2009, 1, 31),
'typeof(last_day(2009-01-12))': 'date', 'typeof(2009-01-12)': 'string'}
#query
#SELECT last_day('2009-01-12'::string);
-
diff --git
a/datafusion/sqllogictest/test_files/spark/datetime/localtimestamp.slt
b/datafusion/sqllogictest/test_files/spark/datetime/localtimestamp.slt
index 3533c0c613..36fd451382 100644
--- a/datafusion/sqllogictest/test_files/spark/datetime/localtimestamp.slt
+++ b/datafusion/sqllogictest/test_files/spark/datetime/localtimestamp.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'localtimestamp()': datetime.datetime(2025, 6, 14,
23, 57, 39, 529742), 'typeof(localtimestamp())': 'timestamp_ntz'}
#query
#SELECT localtimestamp();
-
diff --git a/datafusion/sqllogictest/test_files/spark/datetime/make_date.slt
b/datafusion/sqllogictest/test_files/spark/datetime/make_date.slt
index adeeff7efb..b95347f976 100644
--- a/datafusion/sqllogictest/test_files/spark/datetime/make_date.slt
+++ b/datafusion/sqllogictest/test_files/spark/datetime/make_date.slt
@@ -30,4 +30,3 @@
## PySpark 3.5.5 Result: {'make_date(2019, 7, NULL)': None,
'typeof(make_date(2019, 7, NULL))': 'date', 'typeof(2019)': 'int', 'typeof(7)':
'int', 'typeof(NULL)': 'void'}
#query
#SELECT make_date(2019::int, 7::int, NULL::void);
-
diff --git
a/datafusion/sqllogictest/test_files/spark/datetime/make_dt_interval.slt
b/datafusion/sqllogictest/test_files/spark/datetime/make_dt_interval.slt
index cdde3d3c7b..e5c69cfbb8 100644
--- a/datafusion/sqllogictest/test_files/spark/datetime/make_dt_interval.slt
+++ b/datafusion/sqllogictest/test_files/spark/datetime/make_dt_interval.slt
@@ -35,4 +35,3 @@
## PySpark 3.5.5 Result: {'make_dt_interval(2, 0, 0, 0.000000)':
datetime.timedelta(days=2), 'typeof(make_dt_interval(2, 0, 0, 0.000000))':
'interval day to second', 'typeof(2)': 'int'}
#query
#SELECT make_dt_interval(2::int);
-
diff --git
a/datafusion/sqllogictest/test_files/spark/datetime/make_timestamp.slt
b/datafusion/sqllogictest/test_files/spark/datetime/make_timestamp.slt
index 89c6bf3215..262154186c 100644
--- a/datafusion/sqllogictest/test_files/spark/datetime/make_timestamp.slt
+++ b/datafusion/sqllogictest/test_files/spark/datetime/make_timestamp.slt
@@ -45,4 +45,3 @@
## PySpark 3.5.5 Result: {'make_timestamp(NULL, 7, 22, 15, 30, 0)': None,
'typeof(make_timestamp(NULL, 7, 22, 15, 30, 0))': 'timestamp', 'typeof(NULL)':
'void', 'typeof(7)': 'int', 'typeof(22)': 'int', 'typeof(15)': 'int',
'typeof(30)': 'int', 'typeof(0)': 'int'}
#query
#SELECT make_timestamp(NULL::void, 7::int, 22::int, 15::int, 30::int, 0::int);
-
diff --git
a/datafusion/sqllogictest/test_files/spark/datetime/make_timestamp_ltz.slt
b/datafusion/sqllogictest/test_files/spark/datetime/make_timestamp_ltz.slt
index 8bb93df3d2..ce5e07f663 100644
--- a/datafusion/sqllogictest/test_files/spark/datetime/make_timestamp_ltz.slt
+++ b/datafusion/sqllogictest/test_files/spark/datetime/make_timestamp_ltz.slt
@@ -40,4 +40,3 @@
## PySpark 3.5.5 Result: {'make_timestamp_ltz(NULL, 7, 22, 15, 30, 0)': None,
'typeof(make_timestamp_ltz(NULL, 7, 22, 15, 30, 0))': 'timestamp',
'typeof(NULL)': 'void', 'typeof(7)': 'int', 'typeof(22)': 'int', 'typeof(15)':
'int', 'typeof(30)': 'int', 'typeof(0)': 'int'}
#query
#SELECT make_timestamp_ltz(NULL::void, 7::int, 22::int, 15::int, 30::int,
0::int);
-
diff --git
a/datafusion/sqllogictest/test_files/spark/datetime/make_timestamp_ntz.slt
b/datafusion/sqllogictest/test_files/spark/datetime/make_timestamp_ntz.slt
index b65649d81a..fbbe37655e 100644
--- a/datafusion/sqllogictest/test_files/spark/datetime/make_timestamp_ntz.slt
+++ b/datafusion/sqllogictest/test_files/spark/datetime/make_timestamp_ntz.slt
@@ -35,4 +35,3 @@
## PySpark 3.5.5 Result: {'make_timestamp_ntz(NULL, 7, 22, 15, 30, 0)': None,
'typeof(make_timestamp_ntz(NULL, 7, 22, 15, 30, 0))': 'timestamp_ntz',
'typeof(NULL)': 'void', 'typeof(7)': 'int', 'typeof(22)': 'int', 'typeof(15)':
'int', 'typeof(30)': 'int', 'typeof(0)': 'int'}
#query
#SELECT make_timestamp_ntz(NULL::void, 7::int, 22::int, 15::int, 30::int,
0::int);
-
diff --git
a/datafusion/sqllogictest/test_files/spark/datetime/make_ym_interval.slt
b/datafusion/sqllogictest/test_files/spark/datetime/make_ym_interval.slt
index 2a5bc7b3d2..9429a3a530 100644
--- a/datafusion/sqllogictest/test_files/spark/datetime/make_ym_interval.slt
+++ b/datafusion/sqllogictest/test_files/spark/datetime/make_ym_interval.slt
@@ -40,4 +40,3 @@
## PySpark 3.5.5 Result: {'make_ym_interval(2, 0)': 24,
'typeof(make_ym_interval(2, 0))': 'interval year to month', 'typeof(2)': 'int'}
#query
#SELECT make_ym_interval(2::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/datetime/minute.slt
b/datafusion/sqllogictest/test_files/spark/datetime/minute.slt
index 451f5d2c40..dbe1e64be8 100644
--- a/datafusion/sqllogictest/test_files/spark/datetime/minute.slt
+++ b/datafusion/sqllogictest/test_files/spark/datetime/minute.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'minute(2009-07-30 12:58:59)': 58,
'typeof(minute(2009-07-30 12:58:59))': 'int', 'typeof(2009-07-30 12:58:59)':
'string'}
#query
#SELECT minute('2009-07-30 12:58:59'::string);
-
diff --git a/datafusion/sqllogictest/test_files/spark/datetime/month.slt
b/datafusion/sqllogictest/test_files/spark/datetime/month.slt
index fc182e157f..17a34352d1 100644
--- a/datafusion/sqllogictest/test_files/spark/datetime/month.slt
+++ b/datafusion/sqllogictest/test_files/spark/datetime/month.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'month(2016-07-30)': 7, 'typeof(month(2016-07-30))':
'int', 'typeof(2016-07-30)': 'string'}
#query
#SELECT month('2016-07-30'::string);
-
diff --git
a/datafusion/sqllogictest/test_files/spark/datetime/months_between.slt
b/datafusion/sqllogictest/test_files/spark/datetime/months_between.slt
index 252e364a48..c252676165 100644
--- a/datafusion/sqllogictest/test_files/spark/datetime/months_between.slt
+++ b/datafusion/sqllogictest/test_files/spark/datetime/months_between.slt
@@ -30,4 +30,3 @@
## PySpark 3.5.5 Result: {'months_between(1997-02-28 10:30:00, 1996-10-30,
false)': 3.9495967741935485, 'typeof(months_between(1997-02-28 10:30:00,
1996-10-30, false))': 'double', 'typeof(1997-02-28 10:30:00)': 'string',
'typeof(1996-10-30)': 'string', 'typeof(false)': 'boolean'}
#query
#SELECT months_between('1997-02-28 10:30:00'::string, '1996-10-30'::string,
false::boolean);
-
diff --git a/datafusion/sqllogictest/test_files/spark/datetime/next_day.slt
b/datafusion/sqllogictest/test_files/spark/datetime/next_day.slt
index 2c8f30b895..ffc7040f47 100644
--- a/datafusion/sqllogictest/test_files/spark/datetime/next_day.slt
+++ b/datafusion/sqllogictest/test_files/spark/datetime/next_day.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'next_day(2015-01-14, TU)': datetime.date(2015, 1,
20), 'typeof(next_day(2015-01-14, TU))': 'date', 'typeof(2015-01-14)':
'string', 'typeof(TU)': 'string'}
#query
#SELECT next_day('2015-01-14'::string, 'TU'::string);
-
diff --git a/datafusion/sqllogictest/test_files/spark/datetime/now.slt
b/datafusion/sqllogictest/test_files/spark/datetime/now.slt
index 36ae31ff5e..985140c1ac 100644
--- a/datafusion/sqllogictest/test_files/spark/datetime/now.slt
+++ b/datafusion/sqllogictest/test_files/spark/datetime/now.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'now()': datetime.datetime(2025, 6, 14, 23, 57, 39,
982956), 'typeof(now())': 'timestamp'}
#query
#SELECT now();
-
diff --git a/datafusion/sqllogictest/test_files/spark/datetime/quarter.slt
b/datafusion/sqllogictest/test_files/spark/datetime/quarter.slt
index e283d78d4f..27b6728b0b 100644
--- a/datafusion/sqllogictest/test_files/spark/datetime/quarter.slt
+++ b/datafusion/sqllogictest/test_files/spark/datetime/quarter.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'quarter(2016-08-31)': 3,
'typeof(quarter(2016-08-31))': 'int', 'typeof(2016-08-31)': 'string'}
#query
#SELECT quarter('2016-08-31'::string);
-
diff --git a/datafusion/sqllogictest/test_files/spark/datetime/second.slt
b/datafusion/sqllogictest/test_files/spark/datetime/second.slt
index 799d37101d..f69c9af4a6 100644
--- a/datafusion/sqllogictest/test_files/spark/datetime/second.slt
+++ b/datafusion/sqllogictest/test_files/spark/datetime/second.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'second(2009-07-30 12:58:59)': 59,
'typeof(second(2009-07-30 12:58:59))': 'int', 'typeof(2009-07-30 12:58:59)':
'string'}
#query
#SELECT second('2009-07-30 12:58:59'::string);
-
diff --git
a/datafusion/sqllogictest/test_files/spark/datetime/timestamp_micros.slt
b/datafusion/sqllogictest/test_files/spark/datetime/timestamp_micros.slt
index b739551123..19a52c9810 100644
--- a/datafusion/sqllogictest/test_files/spark/datetime/timestamp_micros.slt
+++ b/datafusion/sqllogictest/test_files/spark/datetime/timestamp_micros.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'timestamp_micros(1230219000123123)':
datetime.datetime(2008, 12, 25, 7, 30, 0, 123123),
'typeof(timestamp_micros(1230219000123123))': 'timestamp',
'typeof(1230219000123123)': 'bigint'}
#query
#SELECT timestamp_micros(1230219000123123::bigint);
-
diff --git
a/datafusion/sqllogictest/test_files/spark/datetime/timestamp_millis.slt
b/datafusion/sqllogictest/test_files/spark/datetime/timestamp_millis.slt
index a0b7c13772..7dc092549f 100644
--- a/datafusion/sqllogictest/test_files/spark/datetime/timestamp_millis.slt
+++ b/datafusion/sqllogictest/test_files/spark/datetime/timestamp_millis.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'timestamp_millis(1230219000123)':
datetime.datetime(2008, 12, 25, 7, 30, 0, 123000),
'typeof(timestamp_millis(1230219000123))': 'timestamp',
'typeof(1230219000123)': 'bigint'}
#query
#SELECT timestamp_millis(1230219000123::bigint);
-
diff --git
a/datafusion/sqllogictest/test_files/spark/datetime/timestamp_seconds.slt
b/datafusion/sqllogictest/test_files/spark/datetime/timestamp_seconds.slt
index a883ab7bd1..8e14c1dfe1 100644
--- a/datafusion/sqllogictest/test_files/spark/datetime/timestamp_seconds.slt
+++ b/datafusion/sqllogictest/test_files/spark/datetime/timestamp_seconds.slt
@@ -30,4 +30,3 @@
## PySpark 3.5.5 Result: {'timestamp_seconds(1230219000.123)':
datetime.datetime(2008, 12, 25, 7, 30, 0, 123000),
'typeof(timestamp_seconds(1230219000.123))': 'timestamp',
'typeof(1230219000.123)': 'decimal(13,3)'}
#query
#SELECT timestamp_seconds(1230219000.123::decimal(13,3));
-
diff --git a/datafusion/sqllogictest/test_files/spark/datetime/to_date.slt
b/datafusion/sqllogictest/test_files/spark/datetime/to_date.slt
index d7128942b9..3863cfb2ba 100644
--- a/datafusion/sqllogictest/test_files/spark/datetime/to_date.slt
+++ b/datafusion/sqllogictest/test_files/spark/datetime/to_date.slt
@@ -30,4 +30,3 @@
## PySpark 3.5.5 Result: {'to_date(2016-12-31, yyyy-MM-dd)':
datetime.date(2016, 12, 31), 'typeof(to_date(2016-12-31, yyyy-MM-dd))': 'date',
'typeof(2016-12-31)': 'string', 'typeof(yyyy-MM-dd)': 'string'}
#query
#SELECT to_date('2016-12-31'::string, 'yyyy-MM-dd'::string);
-
diff --git a/datafusion/sqllogictest/test_files/spark/datetime/to_timestamp.slt
b/datafusion/sqllogictest/test_files/spark/datetime/to_timestamp.slt
index 6511268b68..39f77620fa 100644
--- a/datafusion/sqllogictest/test_files/spark/datetime/to_timestamp.slt
+++ b/datafusion/sqllogictest/test_files/spark/datetime/to_timestamp.slt
@@ -30,4 +30,3 @@
## PySpark 3.5.5 Result: {'to_timestamp(2016-12-31, yyyy-MM-dd)':
datetime.datetime(2016, 12, 31, 0, 0), 'typeof(to_timestamp(2016-12-31,
yyyy-MM-dd))': 'timestamp', 'typeof(2016-12-31)': 'string',
'typeof(yyyy-MM-dd)': 'string'}
#query
#SELECT to_timestamp('2016-12-31'::string, 'yyyy-MM-dd'::string);
-
diff --git
a/datafusion/sqllogictest/test_files/spark/datetime/to_timestamp_ltz.slt
b/datafusion/sqllogictest/test_files/spark/datetime/to_timestamp_ltz.slt
index 9181fb5ea3..c7c43a2bcc 100644
--- a/datafusion/sqllogictest/test_files/spark/datetime/to_timestamp_ltz.slt
+++ b/datafusion/sqllogictest/test_files/spark/datetime/to_timestamp_ltz.slt
@@ -30,4 +30,3 @@
## PySpark 3.5.5 Result: {'to_timestamp_ltz(2016-12-31, yyyy-MM-dd)':
datetime.datetime(2016, 12, 31, 0, 0), 'typeof(to_timestamp_ltz(2016-12-31,
yyyy-MM-dd))': 'timestamp', 'typeof(2016-12-31)': 'string',
'typeof(yyyy-MM-dd)': 'string'}
#query
#SELECT to_timestamp_ltz('2016-12-31'::string, 'yyyy-MM-dd'::string);
-
diff --git
a/datafusion/sqllogictest/test_files/spark/datetime/to_timestamp_ntz.slt
b/datafusion/sqllogictest/test_files/spark/datetime/to_timestamp_ntz.slt
index 5e93fcd067..11c4e4cbe2 100644
--- a/datafusion/sqllogictest/test_files/spark/datetime/to_timestamp_ntz.slt
+++ b/datafusion/sqllogictest/test_files/spark/datetime/to_timestamp_ntz.slt
@@ -30,4 +30,3 @@
## PySpark 3.5.5 Result: {'to_timestamp_ntz(2016-12-31, yyyy-MM-dd)':
datetime.datetime(2016, 12, 31, 0, 0), 'typeof(to_timestamp_ntz(2016-12-31,
yyyy-MM-dd))': 'timestamp_ntz', 'typeof(2016-12-31)': 'string',
'typeof(yyyy-MM-dd)': 'string'}
#query
#SELECT to_timestamp_ntz('2016-12-31'::string, 'yyyy-MM-dd'::string);
-
diff --git
a/datafusion/sqllogictest/test_files/spark/datetime/to_unix_timestamp.slt
b/datafusion/sqllogictest/test_files/spark/datetime/to_unix_timestamp.slt
index 7b3589e4c8..53c1902094 100644
--- a/datafusion/sqllogictest/test_files/spark/datetime/to_unix_timestamp.slt
+++ b/datafusion/sqllogictest/test_files/spark/datetime/to_unix_timestamp.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'to_unix_timestamp(2016-04-08, yyyy-MM-dd)':
1460098800, 'typeof(to_unix_timestamp(2016-04-08, yyyy-MM-dd))': 'bigint',
'typeof(2016-04-08)': 'string', 'typeof(yyyy-MM-dd)': 'string'}
#query
#SELECT to_unix_timestamp('2016-04-08'::string, 'yyyy-MM-dd'::string);
-
diff --git
a/datafusion/sqllogictest/test_files/spark/datetime/to_utc_timestamp.slt
b/datafusion/sqllogictest/test_files/spark/datetime/to_utc_timestamp.slt
index e4c7b244ff..24693016be 100644
--- a/datafusion/sqllogictest/test_files/spark/datetime/to_utc_timestamp.slt
+++ b/datafusion/sqllogictest/test_files/spark/datetime/to_utc_timestamp.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'to_utc_timestamp(2016-08-31, Asia/Seoul)':
datetime.datetime(2016, 8, 30, 15, 0), 'typeof(to_utc_timestamp(2016-08-31,
Asia/Seoul))': 'timestamp', 'typeof(2016-08-31)': 'string',
'typeof(Asia/Seoul)': 'string'}
#query
#SELECT to_utc_timestamp('2016-08-31'::string, 'Asia/Seoul'::string);
-
diff --git a/datafusion/sqllogictest/test_files/spark/datetime/trunc.slt
b/datafusion/sqllogictest/test_files/spark/datetime/trunc.slt
index f716c8e950..a502e2f7f7 100644
--- a/datafusion/sqllogictest/test_files/spark/datetime/trunc.slt
+++ b/datafusion/sqllogictest/test_files/spark/datetime/trunc.slt
@@ -40,4 +40,3 @@
## PySpark 3.5.5 Result: {'trunc(2019-08-04, week)': datetime.date(2019, 7,
29), 'typeof(trunc(2019-08-04, week))': 'date', 'typeof(2019-08-04)': 'string',
'typeof(week)': 'string'}
#query
#SELECT trunc('2019-08-04'::string, 'week'::string);
-
diff --git
a/datafusion/sqllogictest/test_files/spark/datetime/try_to_timestamp.slt
b/datafusion/sqllogictest/test_files/spark/datetime/try_to_timestamp.slt
index 5e07b5a12e..23b788125e 100644
--- a/datafusion/sqllogictest/test_files/spark/datetime/try_to_timestamp.slt
+++ b/datafusion/sqllogictest/test_files/spark/datetime/try_to_timestamp.slt
@@ -35,4 +35,3 @@
## PySpark 3.5.5 Result: {'try_to_timestamp(foo, yyyy-MM-dd)': None,
'typeof(try_to_timestamp(foo, yyyy-MM-dd))': 'timestamp', 'typeof(foo)':
'string', 'typeof(yyyy-MM-dd)': 'string'}
#query
#SELECT try_to_timestamp('foo'::string, 'yyyy-MM-dd'::string);
-
diff --git
a/datafusion/sqllogictest/test_files/spark/datetime/unix_timestamp.slt
b/datafusion/sqllogictest/test_files/spark/datetime/unix_timestamp.slt
index 3a128981c6..bc597912bc 100644
--- a/datafusion/sqllogictest/test_files/spark/datetime/unix_timestamp.slt
+++ b/datafusion/sqllogictest/test_files/spark/datetime/unix_timestamp.slt
@@ -30,4 +30,3 @@
## PySpark 3.5.5 Result: {'unix_timestamp(current_timestamp(), yyyy-MM-dd
HH:mm:ss)': 1749970660, 'typeof(unix_timestamp(current_timestamp(), yyyy-MM-dd
HH:mm:ss))': 'bigint'}
#query
#SELECT unix_timestamp();
-
diff --git a/datafusion/sqllogictest/test_files/spark/datetime/weekday.slt
b/datafusion/sqllogictest/test_files/spark/datetime/weekday.slt
index 7e65d60026..b4f5444e8a 100644
--- a/datafusion/sqllogictest/test_files/spark/datetime/weekday.slt
+++ b/datafusion/sqllogictest/test_files/spark/datetime/weekday.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'weekday(2009-07-30)': 3,
'typeof(weekday(2009-07-30))': 'int', 'typeof(2009-07-30)': 'string'}
#query
#SELECT weekday('2009-07-30'::string);
-
diff --git a/datafusion/sqllogictest/test_files/spark/datetime/weekofyear.slt
b/datafusion/sqllogictest/test_files/spark/datetime/weekofyear.slt
index 185bc51ffa..30e69341d9 100644
--- a/datafusion/sqllogictest/test_files/spark/datetime/weekofyear.slt
+++ b/datafusion/sqllogictest/test_files/spark/datetime/weekofyear.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'weekofyear(2008-02-20)': 8,
'typeof(weekofyear(2008-02-20))': 'int', 'typeof(2008-02-20)': 'string'}
#query
#SELECT weekofyear('2008-02-20'::string);
-
diff --git a/datafusion/sqllogictest/test_files/spark/datetime/year.slt
b/datafusion/sqllogictest/test_files/spark/datetime/year.slt
index 9a19a618f7..6577522736 100644
--- a/datafusion/sqllogictest/test_files/spark/datetime/year.slt
+++ b/datafusion/sqllogictest/test_files/spark/datetime/year.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'year(2016-07-30)': 2016,
'typeof(year(2016-07-30))': 'int', 'typeof(2016-07-30)': 'string'}
#query
#SELECT year('2016-07-30'::string);
-
diff --git a/datafusion/sqllogictest/test_files/spark/hash/crc32.slt
b/datafusion/sqllogictest/test_files/spark/hash/crc32.slt
index 3fc442bbdd..b28a3fc13b 100644
--- a/datafusion/sqllogictest/test_files/spark/hash/crc32.slt
+++ b/datafusion/sqllogictest/test_files/spark/hash/crc32.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'crc32(Spark)': 1557323817, 'typeof(crc32(Spark))':
'bigint', 'typeof(Spark)': 'string'}
#query
#SELECT crc32('Spark'::string);
-
diff --git a/datafusion/sqllogictest/test_files/spark/hash/md5.slt
b/datafusion/sqllogictest/test_files/spark/hash/md5.slt
index 32aafcbc37..f1a4b82e29 100644
--- a/datafusion/sqllogictest/test_files/spark/hash/md5.slt
+++ b/datafusion/sqllogictest/test_files/spark/hash/md5.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'md5(Spark)': '8cde774d6f7333752ed72cacddb05126',
'typeof(md5(Spark))': 'string', 'typeof(Spark)': 'string'}
#query
#SELECT md5('Spark'::string);
-
diff --git a/datafusion/sqllogictest/test_files/spark/hash/sha.slt
b/datafusion/sqllogictest/test_files/spark/hash/sha.slt
index 30965f2684..bf205f7e0a 100644
--- a/datafusion/sqllogictest/test_files/spark/hash/sha.slt
+++ b/datafusion/sqllogictest/test_files/spark/hash/sha.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'sha(Spark)':
'85f5955f4b27a9a4c2aab6ffe5d7189fc298b92c', 'typeof(sha(Spark))': 'string',
'typeof(Spark)': 'string'}
#query
#SELECT sha('Spark'::string);
-
diff --git a/datafusion/sqllogictest/test_files/spark/hash/sha1.slt
b/datafusion/sqllogictest/test_files/spark/hash/sha1.slt
index e245cd5b3a..afaa862391 100644
--- a/datafusion/sqllogictest/test_files/spark/hash/sha1.slt
+++ b/datafusion/sqllogictest/test_files/spark/hash/sha1.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'sha1(Spark)':
'85f5955f4b27a9a4c2aab6ffe5d7189fc298b92c', 'typeof(sha1(Spark))': 'string',
'typeof(Spark)': 'string'}
#query
#SELECT sha1('Spark'::string);
-
diff --git a/datafusion/sqllogictest/test_files/spark/json/get_json_object.slt
b/datafusion/sqllogictest/test_files/spark/json/get_json_object.slt
index bd4f1c35f5..7917ee1168 100644
--- a/datafusion/sqllogictest/test_files/spark/json/get_json_object.slt
+++ b/datafusion/sqllogictest/test_files/spark/json/get_json_object.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'get_json_object({"a":"b"}, $.a)': 'b',
'typeof(get_json_object({"a":"b"}, $.a))': 'string', 'typeof({"a":"b"})':
'string', 'typeof($.a)': 'string'}
#query
#SELECT get_json_object('{"a":"b"}'::string, '$.a'::string);
-
diff --git a/datafusion/sqllogictest/test_files/spark/json/json_object_keys.slt
b/datafusion/sqllogictest/test_files/spark/json/json_object_keys.slt
index d890ac8d96..ce399c5820 100644
--- a/datafusion/sqllogictest/test_files/spark/json/json_object_keys.slt
+++ b/datafusion/sqllogictest/test_files/spark/json/json_object_keys.slt
@@ -35,4 +35,3 @@
## PySpark 3.5.5 Result: {'json_object_keys({})': [],
'typeof(json_object_keys({}))': 'array<string>', 'typeof({})': 'string'}
#query
#SELECT json_object_keys('{}'::string);
-
diff --git a/datafusion/sqllogictest/test_files/spark/math/abs.slt
b/datafusion/sqllogictest/test_files/spark/math/abs.slt
index bc29937267..4b9edf7e29 100644
--- a/datafusion/sqllogictest/test_files/spark/math/abs.slt
+++ b/datafusion/sqllogictest/test_files/spark/math/abs.slt
@@ -30,4 +30,3 @@
## PySpark 3.5.5 Result: {"abs(INTERVAL '-1-1' YEAR TO MONTH)": 13,
"typeof(abs(INTERVAL '-1-1' YEAR TO MONTH))": 'interval year to month',
"typeof(INTERVAL '-1-1' YEAR TO MONTH)": 'interval year to month'}
#query
#SELECT abs(INTERVAL '-1-1' YEAR TO MONTH::interval year to month);
-
diff --git a/datafusion/sqllogictest/test_files/spark/math/acos.slt
b/datafusion/sqllogictest/test_files/spark/math/acos.slt
index 1c16f395ca..76ee569425 100644
--- a/datafusion/sqllogictest/test_files/spark/math/acos.slt
+++ b/datafusion/sqllogictest/test_files/spark/math/acos.slt
@@ -30,4 +30,3 @@
## PySpark 3.5.5 Result: {'ACOS(2)': nan, 'typeof(ACOS(2))': 'double',
'typeof(2)': 'int'}
#query
#SELECT acos(2::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/math/acosh.slt
b/datafusion/sqllogictest/test_files/spark/math/acosh.slt
index 5ebfa190c4..45b4537419 100644
--- a/datafusion/sqllogictest/test_files/spark/math/acosh.slt
+++ b/datafusion/sqllogictest/test_files/spark/math/acosh.slt
@@ -30,4 +30,3 @@
## PySpark 3.5.5 Result: {'ACOSH(1)': 0.0, 'typeof(ACOSH(1))': 'double',
'typeof(1)': 'int'}
#query
#SELECT acosh(1::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/math/asin.slt
b/datafusion/sqllogictest/test_files/spark/math/asin.slt
index d782475a5f..5c6d265ff0 100644
--- a/datafusion/sqllogictest/test_files/spark/math/asin.slt
+++ b/datafusion/sqllogictest/test_files/spark/math/asin.slt
@@ -30,4 +30,3 @@
## PySpark 3.5.5 Result: {'ASIN(2)': nan, 'typeof(ASIN(2))': 'double',
'typeof(2)': 'int'}
#query
#SELECT asin(2::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/math/asinh.slt
b/datafusion/sqllogictest/test_files/spark/math/asinh.slt
index 1169fa7fbd..7d965dea2b 100644
--- a/datafusion/sqllogictest/test_files/spark/math/asinh.slt
+++ b/datafusion/sqllogictest/test_files/spark/math/asinh.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'ASINH(0)': 0.0, 'typeof(ASINH(0))': 'double',
'typeof(0)': 'int'}
#query
#SELECT asinh(0::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/math/atan.slt
b/datafusion/sqllogictest/test_files/spark/math/atan.slt
index c4b5baf1c7..b5817b0804 100644
--- a/datafusion/sqllogictest/test_files/spark/math/atan.slt
+++ b/datafusion/sqllogictest/test_files/spark/math/atan.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'ATAN(0)': 0.0, 'typeof(ATAN(0))': 'double',
'typeof(0)': 'int'}
#query
#SELECT atan(0::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/math/atan2.slt
b/datafusion/sqllogictest/test_files/spark/math/atan2.slt
index c4af082f7b..eb644854c4 100644
--- a/datafusion/sqllogictest/test_files/spark/math/atan2.slt
+++ b/datafusion/sqllogictest/test_files/spark/math/atan2.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'ATAN2(0, 0)': 0.0, 'typeof(ATAN2(0, 0))': 'double',
'typeof(0)': 'int'}
#query
#SELECT atan2(0::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/math/atanh.slt
b/datafusion/sqllogictest/test_files/spark/math/atanh.slt
index 00681b57d0..7e79f8c7be 100644
--- a/datafusion/sqllogictest/test_files/spark/math/atanh.slt
+++ b/datafusion/sqllogictest/test_files/spark/math/atanh.slt
@@ -30,4 +30,3 @@
## PySpark 3.5.5 Result: {'ATANH(2)': nan, 'typeof(ATANH(2))': 'double',
'typeof(2)': 'int'}
#query
#SELECT atanh(2::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/math/bin.slt
b/datafusion/sqllogictest/test_files/spark/math/bin.slt
index fab65eb837..1fa24e6cda 100644
--- a/datafusion/sqllogictest/test_files/spark/math/bin.slt
+++ b/datafusion/sqllogictest/test_files/spark/math/bin.slt
@@ -35,4 +35,3 @@
## PySpark 3.5.5 Result: {'bin(13.3)': '1101', 'typeof(bin(13.3))': 'string',
'typeof(13.3)': 'decimal(3,1)'}
#query
#SELECT bin(13.3::decimal(3,1));
-
diff --git a/datafusion/sqllogictest/test_files/spark/math/bround.slt
b/datafusion/sqllogictest/test_files/spark/math/bround.slt
index 3db3f1ebf1..afdc9c635c 100644
--- a/datafusion/sqllogictest/test_files/spark/math/bround.slt
+++ b/datafusion/sqllogictest/test_files/spark/math/bround.slt
@@ -30,4 +30,3 @@
## PySpark 3.5.5 Result: {'bround(25, -1)': 20, 'typeof(bround(25, -1))':
'int', 'typeof(25)': 'int', 'typeof(-1)': 'int'}
#query
#SELECT bround(25::int, -1::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/math/cbrt.slt
b/datafusion/sqllogictest/test_files/spark/math/cbrt.slt
index 7fee600d41..f0aea17ff0 100644
--- a/datafusion/sqllogictest/test_files/spark/math/cbrt.slt
+++ b/datafusion/sqllogictest/test_files/spark/math/cbrt.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'CBRT(27.0)': 3.0, 'typeof(CBRT(27.0))': 'double',
'typeof(27.0)': 'decimal(3,1)'}
#query
#SELECT cbrt(27.0::decimal(3,1));
-
diff --git a/datafusion/sqllogictest/test_files/spark/math/ceil.slt
b/datafusion/sqllogictest/test_files/spark/math/ceil.slt
index 1e6d86858f..c87a29b61f 100644
--- a/datafusion/sqllogictest/test_files/spark/math/ceil.slt
+++ b/datafusion/sqllogictest/test_files/spark/math/ceil.slt
@@ -40,4 +40,3 @@
## PySpark 3.5.5 Result: {'CEIL(5)': 5, 'typeof(CEIL(5))': 'bigint',
'typeof(5)': 'int'}
#query
#SELECT ceil(5::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/math/ceiling.slt
b/datafusion/sqllogictest/test_files/spark/math/ceiling.slt
index 3db7f4a192..2b761faef4 100644
--- a/datafusion/sqllogictest/test_files/spark/math/ceiling.slt
+++ b/datafusion/sqllogictest/test_files/spark/math/ceiling.slt
@@ -40,4 +40,3 @@
## PySpark 3.5.5 Result: {'ceiling(5)': 5, 'typeof(ceiling(5))': 'bigint',
'typeof(5)': 'int'}
#query
#SELECT ceiling(5::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/math/conv.slt
b/datafusion/sqllogictest/test_files/spark/math/conv.slt
index bc6033f4f4..371fd3e746 100644
--- a/datafusion/sqllogictest/test_files/spark/math/conv.slt
+++ b/datafusion/sqllogictest/test_files/spark/math/conv.slt
@@ -30,4 +30,3 @@
## PySpark 3.5.5 Result: {'conv(-10, 16, -10)': '-16', 'typeof(conv(-10, 16,
-10))': 'string', 'typeof(-10)': 'int', 'typeof(16)': 'int'}
#query
#SELECT conv(-10::int, 16::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/math/cos.slt
b/datafusion/sqllogictest/test_files/spark/math/cos.slt
index c122173805..a473c25755 100644
--- a/datafusion/sqllogictest/test_files/spark/math/cos.slt
+++ b/datafusion/sqllogictest/test_files/spark/math/cos.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'COS(0)': 1.0, 'typeof(COS(0))': 'double',
'typeof(0)': 'int'}
#query
#SELECT cos(0::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/math/cosh.slt
b/datafusion/sqllogictest/test_files/spark/math/cosh.slt
index 73313defc9..97b3a2eb01 100644
--- a/datafusion/sqllogictest/test_files/spark/math/cosh.slt
+++ b/datafusion/sqllogictest/test_files/spark/math/cosh.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'COSH(0)': 1.0, 'typeof(COSH(0))': 'double',
'typeof(0)': 'int'}
#query
#SELECT cosh(0::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/math/cot.slt
b/datafusion/sqllogictest/test_files/spark/math/cot.slt
index 77ecea3250..5bb010337a 100644
--- a/datafusion/sqllogictest/test_files/spark/math/cot.slt
+++ b/datafusion/sqllogictest/test_files/spark/math/cot.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'COT(1)': 0.6420926159343306, 'typeof(COT(1))':
'double', 'typeof(1)': 'int'}
#query
#SELECT cot(1::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/math/csc.slt
b/datafusion/sqllogictest/test_files/spark/math/csc.slt
index d64a7ffbf1..b11986c3e1 100644
--- a/datafusion/sqllogictest/test_files/spark/math/csc.slt
+++ b/datafusion/sqllogictest/test_files/spark/math/csc.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'CSC(1)': 1.1883951057781212, 'typeof(CSC(1))':
'double', 'typeof(1)': 'int'}
#query
#SELECT csc(1::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/math/degrees.slt
b/datafusion/sqllogictest/test_files/spark/math/degrees.slt
index 95d5541ca0..5ca7bacb8a 100644
--- a/datafusion/sqllogictest/test_files/spark/math/degrees.slt
+++ b/datafusion/sqllogictest/test_files/spark/math/degrees.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'DEGREES(3.141592653589793)': 180.0,
'typeof(DEGREES(3.141592653589793))': 'double', 'typeof(3.141592653589793)':
'decimal(16,15)'}
#query
#SELECT degrees(3.141592653589793::decimal(16,15));
-
diff --git a/datafusion/sqllogictest/test_files/spark/math/e.slt
b/datafusion/sqllogictest/test_files/spark/math/e.slt
index ad4ed0bd93..c8e23d3b09 100644
--- a/datafusion/sqllogictest/test_files/spark/math/e.slt
+++ b/datafusion/sqllogictest/test_files/spark/math/e.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'E()': 2.718281828459045, 'typeof(E())': 'double'}
#query
#SELECT e();
-
diff --git a/datafusion/sqllogictest/test_files/spark/math/exp.slt
b/datafusion/sqllogictest/test_files/spark/math/exp.slt
index 9ee28533ff..671684f985 100644
--- a/datafusion/sqllogictest/test_files/spark/math/exp.slt
+++ b/datafusion/sqllogictest/test_files/spark/math/exp.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'EXP(0)': 1.0, 'typeof(EXP(0))': 'double',
'typeof(0)': 'int'}
#query
#SELECT exp(0::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/math/floor.slt
b/datafusion/sqllogictest/test_files/spark/math/floor.slt
index 5e4a63a1a2..d39d47ab1f 100644
--- a/datafusion/sqllogictest/test_files/spark/math/floor.slt
+++ b/datafusion/sqllogictest/test_files/spark/math/floor.slt
@@ -40,4 +40,3 @@
## PySpark 3.5.5 Result: {'FLOOR(5)': 5, 'typeof(FLOOR(5))': 'bigint',
'typeof(5)': 'int'}
#query
#SELECT floor(5::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/math/greatest.slt
b/datafusion/sqllogictest/test_files/spark/math/greatest.slt
index 51cdb0d861..ff1143d5fc 100644
--- a/datafusion/sqllogictest/test_files/spark/math/greatest.slt
+++ b/datafusion/sqllogictest/test_files/spark/math/greatest.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'greatest(10, 9, 2, 4, 3)': 10, 'typeof(greatest(10,
9, 2, 4, 3))': 'int', 'typeof(10)': 'int', 'typeof(9)': 'int', 'typeof(2)':
'int', 'typeof(4)': 'int', 'typeof(3)': 'int'}
#query
#SELECT greatest(10::int, 9::int, 2::int, 4::int, 3::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/math/hypot.slt
b/datafusion/sqllogictest/test_files/spark/math/hypot.slt
index 3a087f5654..1349be0a95 100644
--- a/datafusion/sqllogictest/test_files/spark/math/hypot.slt
+++ b/datafusion/sqllogictest/test_files/spark/math/hypot.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'HYPOT(3, 4)': 5.0, 'typeof(HYPOT(3, 4))': 'double',
'typeof(3)': 'int', 'typeof(4)': 'int'}
#query
#SELECT hypot(3::int, 4::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/math/least.slt
b/datafusion/sqllogictest/test_files/spark/math/least.slt
index d0ef2e6699..f17bc2aed9 100644
--- a/datafusion/sqllogictest/test_files/spark/math/least.slt
+++ b/datafusion/sqllogictest/test_files/spark/math/least.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'least(10, 9, 2, 4, 3)': 2, 'typeof(least(10, 9, 2,
4, 3))': 'int', 'typeof(10)': 'int', 'typeof(9)': 'int', 'typeof(2)': 'int',
'typeof(4)': 'int', 'typeof(3)': 'int'}
#query
#SELECT least(10::int, 9::int, 2::int, 4::int, 3::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/math/ln.slt
b/datafusion/sqllogictest/test_files/spark/math/ln.slt
index ec8fbfeabb..d3245f7673 100644
--- a/datafusion/sqllogictest/test_files/spark/math/ln.slt
+++ b/datafusion/sqllogictest/test_files/spark/math/ln.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'ln(1)': 0.0, 'typeof(ln(1))': 'double',
'typeof(1)': 'int'}
#query
#SELECT ln(1::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/math/log.slt
b/datafusion/sqllogictest/test_files/spark/math/log.slt
index a439fd4f21..0ea3de7f1b 100644
--- a/datafusion/sqllogictest/test_files/spark/math/log.slt
+++ b/datafusion/sqllogictest/test_files/spark/math/log.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'LOG(10, 100)': 2.0, 'typeof(LOG(10, 100))':
'double', 'typeof(10)': 'int', 'typeof(100)': 'int'}
#query
#SELECT log(10::int, 100::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/math/log10.slt
b/datafusion/sqllogictest/test_files/spark/math/log10.slt
index d4867c388f..95e518f2eb 100644
--- a/datafusion/sqllogictest/test_files/spark/math/log10.slt
+++ b/datafusion/sqllogictest/test_files/spark/math/log10.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'LOG10(10)': 1.0, 'typeof(LOG10(10))': 'double',
'typeof(10)': 'int'}
#query
#SELECT log10(10::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/math/log1p.slt
b/datafusion/sqllogictest/test_files/spark/math/log1p.slt
index 1602263d85..359051c621 100644
--- a/datafusion/sqllogictest/test_files/spark/math/log1p.slt
+++ b/datafusion/sqllogictest/test_files/spark/math/log1p.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'LOG1P(0)': 0.0, 'typeof(LOG1P(0))': 'double',
'typeof(0)': 'int'}
#query
#SELECT log1p(0::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/math/log2.slt
b/datafusion/sqllogictest/test_files/spark/math/log2.slt
index e52f2c7a7e..2706c0fad4 100644
--- a/datafusion/sqllogictest/test_files/spark/math/log2.slt
+++ b/datafusion/sqllogictest/test_files/spark/math/log2.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'LOG2(2)': 1.0, 'typeof(LOG2(2))': 'double',
'typeof(2)': 'int'}
#query
#SELECT log2(2::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/math/mod.slt
b/datafusion/sqllogictest/test_files/spark/math/mod.slt
index b39db3aac4..19437c4dbd 100644
--- a/datafusion/sqllogictest/test_files/spark/math/mod.slt
+++ b/datafusion/sqllogictest/test_files/spark/math/mod.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'mod(2, 1.8)': Decimal('0.2'), 'typeof(mod(2,
1.8))': 'decimal(2,1)', 'typeof(2)': 'int', 'typeof(1.8)': 'decimal(2,1)'}
#query
#SELECT MOD(2::int, 1.8::decimal(2,1));
-
diff --git a/datafusion/sqllogictest/test_files/spark/math/negative.slt
b/datafusion/sqllogictest/test_files/spark/math/negative.slt
index 00688a98d7..aa8e558e98 100644
--- a/datafusion/sqllogictest/test_files/spark/math/negative.slt
+++ b/datafusion/sqllogictest/test_files/spark/math/negative.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'negative(1)': -1, 'typeof(negative(1))': 'int',
'typeof(1)': 'int'}
#query
#SELECT negative(1::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/math/pi.slt
b/datafusion/sqllogictest/test_files/spark/math/pi.slt
index 1479917802..4b94e09bc9 100644
--- a/datafusion/sqllogictest/test_files/spark/math/pi.slt
+++ b/datafusion/sqllogictest/test_files/spark/math/pi.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'PI()': 3.141592653589793, 'typeof(PI())': 'double'}
#query
#SELECT pi();
-
diff --git a/datafusion/sqllogictest/test_files/spark/math/pmod.slt
b/datafusion/sqllogictest/test_files/spark/math/pmod.slt
index 1b751fc8e0..aef251ec46 100644
--- a/datafusion/sqllogictest/test_files/spark/math/pmod.slt
+++ b/datafusion/sqllogictest/test_files/spark/math/pmod.slt
@@ -30,4 +30,3 @@
## PySpark 3.5.5 Result: {'pmod(10, 3)': 1, 'typeof(pmod(10, 3))': 'int',
'typeof(10)': 'int', 'typeof(3)': 'int'}
#query
#SELECT pmod(10::int, 3::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/math/positive.slt
b/datafusion/sqllogictest/test_files/spark/math/positive.slt
index c6a44bb561..5e1be0f4b4 100644
--- a/datafusion/sqllogictest/test_files/spark/math/positive.slt
+++ b/datafusion/sqllogictest/test_files/spark/math/positive.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'(+ 1)': 1, 'typeof((+ 1))': 'int', 'typeof(1)':
'int'}
#query
#SELECT positive(1::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/math/pow.slt
b/datafusion/sqllogictest/test_files/spark/math/pow.slt
index 83d85ce0e5..55b6f65b81 100644
--- a/datafusion/sqllogictest/test_files/spark/math/pow.slt
+++ b/datafusion/sqllogictest/test_files/spark/math/pow.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'pow(2, 3)': 8.0, 'typeof(pow(2, 3))': 'double',
'typeof(2)': 'int', 'typeof(3)': 'int'}
#query
#SELECT pow(2::int, 3::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/math/power.slt
b/datafusion/sqllogictest/test_files/spark/math/power.slt
index 3e56944d13..f82056c6d9 100644
--- a/datafusion/sqllogictest/test_files/spark/math/power.slt
+++ b/datafusion/sqllogictest/test_files/spark/math/power.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'POWER(2, 3)': 8.0, 'typeof(POWER(2, 3))': 'double',
'typeof(2)': 'int', 'typeof(3)': 'int'}
#query
#SELECT power(2::int, 3::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/math/radians.slt
b/datafusion/sqllogictest/test_files/spark/math/radians.slt
index e65177d6e2..bccda62c54 100644
--- a/datafusion/sqllogictest/test_files/spark/math/radians.slt
+++ b/datafusion/sqllogictest/test_files/spark/math/radians.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'RADIANS(180)': 3.141592653589793,
'typeof(RADIANS(180))': 'double', 'typeof(180)': 'int'}
#query
#SELECT radians(180::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/math/rand.slt
b/datafusion/sqllogictest/test_files/spark/math/rand.slt
index af24e99674..53b4c6f822 100644
--- a/datafusion/sqllogictest/test_files/spark/math/rand.slt
+++ b/datafusion/sqllogictest/test_files/spark/math/rand.slt
@@ -35,4 +35,3 @@
## PySpark 3.5.5 Result: {'rand(NULL)': 0.7604953758285915,
'typeof(rand(NULL))': 'double', 'typeof(NULL)': 'void'}
#query
#SELECT rand(NULL::void);
-
diff --git a/datafusion/sqllogictest/test_files/spark/math/randn.slt
b/datafusion/sqllogictest/test_files/spark/math/randn.slt
index 8e1a6ec798..daf81babd0 100644
--- a/datafusion/sqllogictest/test_files/spark/math/randn.slt
+++ b/datafusion/sqllogictest/test_files/spark/math/randn.slt
@@ -35,4 +35,3 @@
## PySpark 3.5.5 Result: {'randn(NULL)': 1.6034991609278433,
'typeof(randn(NULL))': 'double', 'typeof(NULL)': 'void'}
#query
#SELECT randn(NULL::void);
-
diff --git a/datafusion/sqllogictest/test_files/spark/math/random.slt
b/datafusion/sqllogictest/test_files/spark/math/random.slt
index 31e4a0e633..280a81b888 100644
--- a/datafusion/sqllogictest/test_files/spark/math/random.slt
+++ b/datafusion/sqllogictest/test_files/spark/math/random.slt
@@ -35,4 +35,3 @@
## PySpark 3.5.5 Result: {'rand(NULL)': 0.7604953758285915,
'typeof(rand(NULL))': 'double', 'typeof(NULL)': 'void'}
#query
#SELECT random(NULL::void);
-
diff --git a/datafusion/sqllogictest/test_files/spark/math/rint.slt
b/datafusion/sqllogictest/test_files/spark/math/rint.slt
index c62438faed..e0fe2d42d6 100644
--- a/datafusion/sqllogictest/test_files/spark/math/rint.slt
+++ b/datafusion/sqllogictest/test_files/spark/math/rint.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'rint(12.3456)': 12.0, 'typeof(rint(12.3456))':
'double', 'typeof(12.3456)': 'decimal(6,4)'}
#query
#SELECT rint(12.3456::decimal(6,4));
-
diff --git a/datafusion/sqllogictest/test_files/spark/math/round.slt
b/datafusion/sqllogictest/test_files/spark/math/round.slt
index 0b7ac371d5..bc1f6b7224 100644
--- a/datafusion/sqllogictest/test_files/spark/math/round.slt
+++ b/datafusion/sqllogictest/test_files/spark/math/round.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'round(2.5, 0)': Decimal('3'), 'typeof(round(2.5,
0))': 'decimal(2,0)', 'typeof(2.5)': 'decimal(2,1)', 'typeof(0)': 'int'}
#query
#SELECT round(2.5::decimal(2,1), 0::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/math/sec.slt
b/datafusion/sqllogictest/test_files/spark/math/sec.slt
index 5c5328e55c..6c49a34549 100644
--- a/datafusion/sqllogictest/test_files/spark/math/sec.slt
+++ b/datafusion/sqllogictest/test_files/spark/math/sec.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'SEC(0)': 1.0, 'typeof(SEC(0))': 'double',
'typeof(0)': 'int'}
#query
#SELECT sec(0::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/math/shiftleft.slt
b/datafusion/sqllogictest/test_files/spark/math/shiftleft.slt
index 92db7f6bc2..69a8e85565 100644
--- a/datafusion/sqllogictest/test_files/spark/math/shiftleft.slt
+++ b/datafusion/sqllogictest/test_files/spark/math/shiftleft.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'shiftleft(2, 1)': 4, 'typeof(shiftleft(2, 1))':
'int', 'typeof(2)': 'int', 'typeof(1)': 'int'}
#query
#SELECT shiftleft(2::int, 1::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/math/sign.slt
b/datafusion/sqllogictest/test_files/spark/math/sign.slt
index b0f5ce9631..e135f4b13d 100644
--- a/datafusion/sqllogictest/test_files/spark/math/sign.slt
+++ b/datafusion/sqllogictest/test_files/spark/math/sign.slt
@@ -30,4 +30,3 @@
## PySpark 3.5.5 Result: {"sign(INTERVAL '-100' YEAR)": -1.0,
"typeof(sign(INTERVAL '-100' YEAR))": 'double', "typeof(INTERVAL '-100' YEAR)":
'interval year'}
#query
#SELECT sign(INTERVAL '-100' YEAR::interval year);
-
diff --git a/datafusion/sqllogictest/test_files/spark/math/signum.slt
b/datafusion/sqllogictest/test_files/spark/math/signum.slt
index 3531196ad0..5557f5fe32 100644
--- a/datafusion/sqllogictest/test_files/spark/math/signum.slt
+++ b/datafusion/sqllogictest/test_files/spark/math/signum.slt
@@ -30,4 +30,3 @@
## PySpark 3.5.5 Result: {"SIGNUM(INTERVAL '-100' YEAR)": -1.0,
"typeof(SIGNUM(INTERVAL '-100' YEAR))": 'double', "typeof(INTERVAL '-100'
YEAR)": 'interval year'}
#query
#SELECT signum(INTERVAL '-100' YEAR::interval year);
-
diff --git a/datafusion/sqllogictest/test_files/spark/math/sin.slt
b/datafusion/sqllogictest/test_files/spark/math/sin.slt
index 994ff492f9..418a6fafdf 100644
--- a/datafusion/sqllogictest/test_files/spark/math/sin.slt
+++ b/datafusion/sqllogictest/test_files/spark/math/sin.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'SIN(0)': 0.0, 'typeof(SIN(0))': 'double',
'typeof(0)': 'int'}
#query
#SELECT sin(0::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/math/sinh.slt
b/datafusion/sqllogictest/test_files/spark/math/sinh.slt
index c743a81e23..6d24d387e2 100644
--- a/datafusion/sqllogictest/test_files/spark/math/sinh.slt
+++ b/datafusion/sqllogictest/test_files/spark/math/sinh.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'SINH(0)': 0.0, 'typeof(SINH(0))': 'double',
'typeof(0)': 'int'}
#query
#SELECT sinh(0::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/math/sqrt.slt
b/datafusion/sqllogictest/test_files/spark/math/sqrt.slt
index 7c2eaccabf..10b896eec9 100644
--- a/datafusion/sqllogictest/test_files/spark/math/sqrt.slt
+++ b/datafusion/sqllogictest/test_files/spark/math/sqrt.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'SQRT(4)': 2.0, 'typeof(SQRT(4))': 'double',
'typeof(4)': 'int'}
#query
#SELECT sqrt(4::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/math/tan.slt
b/datafusion/sqllogictest/test_files/spark/math/tan.slt
index 5880edea52..4699893d2b 100644
--- a/datafusion/sqllogictest/test_files/spark/math/tan.slt
+++ b/datafusion/sqllogictest/test_files/spark/math/tan.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'TAN(0)': 0.0, 'typeof(TAN(0))': 'double',
'typeof(0)': 'int'}
#query
#SELECT tan(0::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/math/tanh.slt
b/datafusion/sqllogictest/test_files/spark/math/tanh.slt
index 5db2e167a7..1511adb5b3 100644
--- a/datafusion/sqllogictest/test_files/spark/math/tanh.slt
+++ b/datafusion/sqllogictest/test_files/spark/math/tanh.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'TANH(0)': 0.0, 'typeof(TANH(0))': 'double',
'typeof(0)': 'int'}
#query
#SELECT tanh(0::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/math/try_add.slt
b/datafusion/sqllogictest/test_files/spark/math/try_add.slt
index fb8653ce37..f3f8315828 100644
--- a/datafusion/sqllogictest/test_files/spark/math/try_add.slt
+++ b/datafusion/sqllogictest/test_files/spark/math/try_add.slt
@@ -50,4 +50,3 @@
## PySpark 3.5.5 Result: {"try_add(TIMESTAMP '2021-01-01 00:00:00', INTERVAL
'1' DAY)": datetime.datetime(2021, 1, 2, 0, 0), "typeof(try_add(TIMESTAMP
'2021-01-01 00:00:00', INTERVAL '1' DAY))": 'timestamp', "typeof(TIMESTAMP
'2021-01-01 00:00:00')": 'timestamp', "typeof(INTERVAL '1' DAY)": 'interval
day'}
#query
#SELECT try_add(TIMESTAMP '2021-01-01 00:00:00'::timestamp, INTERVAL '1'
DAY::interval day);
-
diff --git a/datafusion/sqllogictest/test_files/spark/math/try_divide.slt
b/datafusion/sqllogictest/test_files/spark/math/try_divide.slt
index 1e2e6b555f..405872f9ca 100644
--- a/datafusion/sqllogictest/test_files/spark/math/try_divide.slt
+++ b/datafusion/sqllogictest/test_files/spark/math/try_divide.slt
@@ -45,4 +45,3 @@
## PySpark 3.5.5 Result: {"try_divide(INTERVAL '2' MONTH, 2)": 1,
"typeof(try_divide(INTERVAL '2' MONTH, 2))": 'interval year to month',
"typeof(INTERVAL '2' MONTH)": 'interval month', 'typeof(2)': 'int'}
#query
#SELECT try_divide(INTERVAL '2' MONTH::interval month, 2::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/math/try_multiply.slt
b/datafusion/sqllogictest/test_files/spark/math/try_multiply.slt
index f5eaad6841..c495a758e2 100644
--- a/datafusion/sqllogictest/test_files/spark/math/try_multiply.slt
+++ b/datafusion/sqllogictest/test_files/spark/math/try_multiply.slt
@@ -35,4 +35,3 @@
## PySpark 3.5.5 Result: {"try_multiply(INTERVAL '2' YEAR, 3)": 72,
"typeof(try_multiply(INTERVAL '2' YEAR, 3))": 'interval year to month',
"typeof(INTERVAL '2' YEAR)": 'interval year', 'typeof(3)': 'int'}
#query
#SELECT try_multiply(INTERVAL '2' YEAR::interval year, 3::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/math/try_subtract.slt
b/datafusion/sqllogictest/test_files/spark/math/try_subtract.slt
index 30af6877bf..4ce4c480b9 100644
--- a/datafusion/sqllogictest/test_files/spark/math/try_subtract.slt
+++ b/datafusion/sqllogictest/test_files/spark/math/try_subtract.slt
@@ -50,4 +50,3 @@
## PySpark 3.5.5 Result: {"try_subtract(TIMESTAMP '2021-01-02 00:00:00',
INTERVAL '1' DAY)": datetime.datetime(2021, 1, 1, 0, 0),
"typeof(try_subtract(TIMESTAMP '2021-01-02 00:00:00', INTERVAL '1' DAY))":
'timestamp', "typeof(TIMESTAMP '2021-01-02 00:00:00')": 'timestamp',
"typeof(INTERVAL '1' DAY)": 'interval day'}
#query
#SELECT try_subtract(TIMESTAMP '2021-01-02 00:00:00'::timestamp, INTERVAL '1'
DAY::interval day);
-
diff --git a/datafusion/sqllogictest/test_files/spark/math/width_bucket.slt
b/datafusion/sqllogictest/test_files/spark/math/width_bucket.slt
index b01ad9e587..a463f430a7 100644
--- a/datafusion/sqllogictest/test_files/spark/math/width_bucket.slt
+++ b/datafusion/sqllogictest/test_files/spark/math/width_bucket.slt
@@ -60,4 +60,3 @@
## PySpark 3.5.5 Result: {"width_bucket(INTERVAL '1' YEAR, INTERVAL '0' YEAR,
INTERVAL '10' YEAR, 10)": 2, "typeof(width_bucket(INTERVAL '1' YEAR, INTERVAL
'0' YEAR, INTERVAL '10' YEAR, 10))": 'bigint', "typeof(INTERVAL '1' YEAR)":
'interval year', "typeof(INTERVAL '0' YEAR)": 'interval year', "typeof(INTERVAL
'10' YEAR)": 'interval year', 'typeof(10)': 'int'}
#query
#SELECT width_bucket(INTERVAL '1' YEAR::interval year, INTERVAL '0'
YEAR::interval year, INTERVAL '10' YEAR::interval year, 10::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/misc/assert_true.slt
b/datafusion/sqllogictest/test_files/spark/misc/assert_true.slt
index c55ff71b05..99330233aa 100644
--- a/datafusion/sqllogictest/test_files/spark/misc/assert_true.slt
+++ b/datafusion/sqllogictest/test_files/spark/misc/assert_true.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {"assert_true((0 < 1), '(0 < 1)' is not true!)":
None, "typeof(assert_true((0 < 1), '(0 < 1)' is not true!))": 'void',
'typeof((0 < 1))': 'boolean'}
#query
#SELECT assert_true((0 < 1)::boolean);
-
diff --git a/datafusion/sqllogictest/test_files/spark/misc/current_catalog.slt
b/datafusion/sqllogictest/test_files/spark/misc/current_catalog.slt
index 3fd49775e4..b0cb488233 100644
--- a/datafusion/sqllogictest/test_files/spark/misc/current_catalog.slt
+++ b/datafusion/sqllogictest/test_files/spark/misc/current_catalog.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'current_catalog()': 'spark_catalog',
'typeof(current_catalog())': 'string'}
#query
#SELECT current_catalog();
-
diff --git a/datafusion/sqllogictest/test_files/spark/misc/current_database.slt
b/datafusion/sqllogictest/test_files/spark/misc/current_database.slt
index 917ee660d8..0883db29a0 100644
--- a/datafusion/sqllogictest/test_files/spark/misc/current_database.slt
+++ b/datafusion/sqllogictest/test_files/spark/misc/current_database.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'current_database()': 'default',
'typeof(current_database())': 'string'}
#query
#SELECT current_database();
-
diff --git a/datafusion/sqllogictest/test_files/spark/misc/current_schema.slt
b/datafusion/sqllogictest/test_files/spark/misc/current_schema.slt
index b96d1077b8..630734431d 100644
--- a/datafusion/sqllogictest/test_files/spark/misc/current_schema.slt
+++ b/datafusion/sqllogictest/test_files/spark/misc/current_schema.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'current_database()': 'default',
'typeof(current_database())': 'string'}
#query
#SELECT current_schema();
-
diff --git a/datafusion/sqllogictest/test_files/spark/misc/current_user.slt
b/datafusion/sqllogictest/test_files/spark/misc/current_user.slt
index 7e8ea20b32..17cfbd292e 100644
--- a/datafusion/sqllogictest/test_files/spark/misc/current_user.slt
+++ b/datafusion/sqllogictest/test_files/spark/misc/current_user.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'current_user()': 'r', 'typeof(current_user())':
'string'}
#query
#SELECT current_user();
-
diff --git a/datafusion/sqllogictest/test_files/spark/misc/equal_null.slt
b/datafusion/sqllogictest/test_files/spark/misc/equal_null.slt
index a5f9b1090e..88999d997d 100644
--- a/datafusion/sqllogictest/test_files/spark/misc/equal_null.slt
+++ b/datafusion/sqllogictest/test_files/spark/misc/equal_null.slt
@@ -45,4 +45,3 @@
## PySpark 3.5.5 Result: {'equal_null(true, NULL)': False,
'typeof(equal_null(true, NULL))': 'boolean', 'typeof(true)': 'boolean',
'typeof(NULL)': 'void'}
#query
#SELECT equal_null(true::boolean, NULL::void);
-
diff --git
a/datafusion/sqllogictest/test_files/spark/misc/input_file_block_length.slt
b/datafusion/sqllogictest/test_files/spark/misc/input_file_block_length.slt
index 7872ef4c28..4f227d7c4d 100644
--- a/datafusion/sqllogictest/test_files/spark/misc/input_file_block_length.slt
+++ b/datafusion/sqllogictest/test_files/spark/misc/input_file_block_length.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'input_file_block_length()': -1,
'typeof(input_file_block_length())': 'bigint'}
#query
#SELECT input_file_block_length();
-
diff --git
a/datafusion/sqllogictest/test_files/spark/misc/input_file_block_start.slt
b/datafusion/sqllogictest/test_files/spark/misc/input_file_block_start.slt
index 35e527eb5f..c60c616328 100644
--- a/datafusion/sqllogictest/test_files/spark/misc/input_file_block_start.slt
+++ b/datafusion/sqllogictest/test_files/spark/misc/input_file_block_start.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'input_file_block_start()': -1,
'typeof(input_file_block_start())': 'bigint'}
#query
#SELECT input_file_block_start();
-
diff --git a/datafusion/sqllogictest/test_files/spark/misc/input_file_name.slt
b/datafusion/sqllogictest/test_files/spark/misc/input_file_name.slt
index dbbfce7341..0379d6d0f5 100644
--- a/datafusion/sqllogictest/test_files/spark/misc/input_file_name.slt
+++ b/datafusion/sqllogictest/test_files/spark/misc/input_file_name.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'input_file_name()': '',
'typeof(input_file_name())': 'string'}
#query
#SELECT input_file_name();
-
diff --git a/datafusion/sqllogictest/test_files/spark/misc/java_method.slt
b/datafusion/sqllogictest/test_files/spark/misc/java_method.slt
index 30af81009f..bb6db98de7 100644
--- a/datafusion/sqllogictest/test_files/spark/misc/java_method.slt
+++ b/datafusion/sqllogictest/test_files/spark/misc/java_method.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'java_method(java.util.UUID, randomUUID)':
'e0d43859-1003-4f43-bfff-f2e3c34981e2', 'typeof(java_method(java.util.UUID,
randomUUID))': 'string', 'typeof(java.util.UUID)': 'string',
'typeof(randomUUID)': 'string'}
#query
#SELECT java_method('java.util.UUID'::string, 'randomUUID'::string);
-
diff --git
a/datafusion/sqllogictest/test_files/spark/misc/monotonically_increasing_id.slt
b/datafusion/sqllogictest/test_files/spark/misc/monotonically_increasing_id.slt
index d47f4da86a..00f6b4a119 100644
---
a/datafusion/sqllogictest/test_files/spark/misc/monotonically_increasing_id.slt
+++
b/datafusion/sqllogictest/test_files/spark/misc/monotonically_increasing_id.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'monotonically_increasing_id()': 0,
'typeof(monotonically_increasing_id())': 'bigint'}
#query
#SELECT monotonically_increasing_id();
-
diff --git a/datafusion/sqllogictest/test_files/spark/misc/reflect.slt
b/datafusion/sqllogictest/test_files/spark/misc/reflect.slt
index 464455d247..223f692f7a 100644
--- a/datafusion/sqllogictest/test_files/spark/misc/reflect.slt
+++ b/datafusion/sqllogictest/test_files/spark/misc/reflect.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'reflect(java.util.UUID, randomUUID)':
'bcf8f6e4-0d46-41a1-bc3c-9f793c8f8aa8', 'typeof(reflect(java.util.UUID,
randomUUID))': 'string', 'typeof(java.util.UUID)': 'string',
'typeof(randomUUID)': 'string'}
#query
#SELECT reflect('java.util.UUID'::string, 'randomUUID'::string);
-
diff --git
a/datafusion/sqllogictest/test_files/spark/misc/spark_partition_id.slt
b/datafusion/sqllogictest/test_files/spark/misc/spark_partition_id.slt
index 5407c7442c..57993103f8 100644
--- a/datafusion/sqllogictest/test_files/spark/misc/spark_partition_id.slt
+++ b/datafusion/sqllogictest/test_files/spark/misc/spark_partition_id.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'SPARK_PARTITION_ID()': 0,
'typeof(SPARK_PARTITION_ID())': 'int'}
#query
#SELECT spark_partition_id();
-
diff --git a/datafusion/sqllogictest/test_files/spark/misc/typeof.slt
b/datafusion/sqllogictest/test_files/spark/misc/typeof.slt
index 8ae58f29ce..e930b65baa 100644
--- a/datafusion/sqllogictest/test_files/spark/misc/typeof.slt
+++ b/datafusion/sqllogictest/test_files/spark/misc/typeof.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'typeof(1)': 'int', 'typeof(typeof(1))': 'string'}
#query
#SELECT typeof(1::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/misc/user.slt
b/datafusion/sqllogictest/test_files/spark/misc/user.slt
index 87c71e8ea7..fc63c61085 100644
--- a/datafusion/sqllogictest/test_files/spark/misc/user.slt
+++ b/datafusion/sqllogictest/test_files/spark/misc/user.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'current_user()': 'r', 'typeof(current_user())':
'string'}
#query
#SELECT user();
-
diff --git a/datafusion/sqllogictest/test_files/spark/misc/uuid.slt
b/datafusion/sqllogictest/test_files/spark/misc/uuid.slt
index f975adf990..223bd71447 100644
--- a/datafusion/sqllogictest/test_files/spark/misc/uuid.slt
+++ b/datafusion/sqllogictest/test_files/spark/misc/uuid.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'uuid()': '96981e67-62f6-49bc-a6f4-2f9bc676edda',
'typeof(uuid())': 'string'}
#query
#SELECT uuid();
-
diff --git a/datafusion/sqllogictest/test_files/spark/misc/version.slt
b/datafusion/sqllogictest/test_files/spark/misc/version.slt
index db495192a6..d01e0c9d96 100644
--- a/datafusion/sqllogictest/test_files/spark/misc/version.slt
+++ b/datafusion/sqllogictest/test_files/spark/misc/version.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'version()': '3.5.5
7c29c664cdc9321205a98a14858aaf8daaa19db2', 'typeof(version())': 'string'}
#query
#SELECT version();
-
diff --git a/datafusion/sqllogictest/test_files/spark/predicate/ilike.slt
b/datafusion/sqllogictest/test_files/spark/predicate/ilike.slt
index 6a147e6be5..aab57c95ba 100644
--- a/datafusion/sqllogictest/test_files/spark/predicate/ilike.slt
+++ b/datafusion/sqllogictest/test_files/spark/predicate/ilike.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'ilike(Spark, _Park)': True, 'typeof(ilike(Spark,
_Park))': 'boolean', 'typeof(Spark)': 'string', 'typeof(_Park)': 'string'}
#query
#SELECT ilike('Spark'::string, '_Park'::string);
-
diff --git a/datafusion/sqllogictest/test_files/spark/predicate/isnotnull.slt
b/datafusion/sqllogictest/test_files/spark/predicate/isnotnull.slt
index 59f3d6cafa..3fd5d6cea0 100644
--- a/datafusion/sqllogictest/test_files/spark/predicate/isnotnull.slt
+++ b/datafusion/sqllogictest/test_files/spark/predicate/isnotnull.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'(1 IS NOT NULL)': True, 'typeof((1 IS NOT NULL))':
'boolean', 'typeof(1)': 'int'}
#query
#SELECT isnotnull(1::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/predicate/isnull.slt
b/datafusion/sqllogictest/test_files/spark/predicate/isnull.slt
index b62492e5d1..7c2290fa3d 100644
--- a/datafusion/sqllogictest/test_files/spark/predicate/isnull.slt
+++ b/datafusion/sqllogictest/test_files/spark/predicate/isnull.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'(1 IS NULL)': False, 'typeof((1 IS NULL))':
'boolean', 'typeof(1)': 'int'}
#query
#SELECT isnull(1::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/predicate/like.slt
b/datafusion/sqllogictest/test_files/spark/predicate/like.slt
index 71aebbee2a..03852feb5f 100644
--- a/datafusion/sqllogictest/test_files/spark/predicate/like.slt
+++ b/datafusion/sqllogictest/test_files/spark/predicate/like.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'Spark LIKE _park': True, 'typeof(Spark LIKE
_park)': 'boolean', 'typeof(Spark)': 'string', 'typeof(_park)': 'string'}
#query
#SELECT like('Spark'::string, '_park'::string);
-
diff --git a/datafusion/sqllogictest/test_files/spark/string/base64.slt
b/datafusion/sqllogictest/test_files/spark/string/base64.slt
index ac0a8e4307..66edbe8442 100644
--- a/datafusion/sqllogictest/test_files/spark/string/base64.slt
+++ b/datafusion/sqllogictest/test_files/spark/string/base64.slt
@@ -30,4 +30,3 @@
## PySpark 3.5.5 Result: {"base64(X'537061726B2053514C')": 'U3BhcmsgU1FM',
"typeof(base64(X'537061726B2053514C'))": 'string',
"typeof(X'537061726B2053514C')": 'binary'}
#query
#SELECT base64(X'537061726B2053514C'::binary);
-
diff --git a/datafusion/sqllogictest/test_files/spark/string/bit_length.slt
b/datafusion/sqllogictest/test_files/spark/string/bit_length.slt
index 4c7703f36d..457d8cf034 100644
--- a/datafusion/sqllogictest/test_files/spark/string/bit_length.slt
+++ b/datafusion/sqllogictest/test_files/spark/string/bit_length.slt
@@ -30,4 +30,3 @@
## PySpark 3.5.5 Result: {"bit_length(X'537061726B2053514C')": 72,
"typeof(bit_length(X'537061726B2053514C'))": 'int',
"typeof(X'537061726B2053514C')": 'binary'}
#query
#SELECT bit_length(X'537061726B2053514C'::binary);
-
diff --git a/datafusion/sqllogictest/test_files/spark/string/btrim.slt
b/datafusion/sqllogictest/test_files/spark/string/btrim.slt
index 4cfbf4f14a..bf25bd652c 100644
--- a/datafusion/sqllogictest/test_files/spark/string/btrim.slt
+++ b/datafusion/sqllogictest/test_files/spark/string/btrim.slt
@@ -30,4 +30,3 @@
## PySpark 3.5.5 Result: {'btrim(SSparkSQLS, SL)': 'parkSQ',
'typeof(btrim(SSparkSQLS, SL))': 'string', 'typeof(SSparkSQLS)': 'string',
'typeof(SL)': 'string'}
#query
#SELECT btrim('SSparkSQLS'::string, 'SL'::string);
-
diff --git a/datafusion/sqllogictest/test_files/spark/string/char_length.slt
b/datafusion/sqllogictest/test_files/spark/string/char_length.slt
index 13d39a9ef2..e13c325b6f 100644
--- a/datafusion/sqllogictest/test_files/spark/string/char_length.slt
+++ b/datafusion/sqllogictest/test_files/spark/string/char_length.slt
@@ -35,4 +35,3 @@
## PySpark 3.5.5 Result: {"char_length(X'537061726B2053514C')": 9,
"typeof(char_length(X'537061726B2053514C'))": 'int',
"typeof(X'537061726B2053514C')": 'binary'}
#query
#SELECT char_length(X'537061726B2053514C'::binary);
-
diff --git
a/datafusion/sqllogictest/test_files/spark/string/character_length.slt
b/datafusion/sqllogictest/test_files/spark/string/character_length.slt
index 497d2a1327..24ca2830fb 100644
--- a/datafusion/sqllogictest/test_files/spark/string/character_length.slt
+++ b/datafusion/sqllogictest/test_files/spark/string/character_length.slt
@@ -35,4 +35,3 @@
## PySpark 3.5.5 Result: {"character_length(X'537061726B2053514C')": 9,
"typeof(character_length(X'537061726B2053514C'))": 'int',
"typeof(X'537061726B2053514C')": 'binary'}
#query
#SELECT character_length(X'537061726B2053514C'::binary);
-
diff --git a/datafusion/sqllogictest/test_files/spark/string/chr.slt
b/datafusion/sqllogictest/test_files/spark/string/chr.slt
index c3ea88e8e3..69ec4fca39 100644
--- a/datafusion/sqllogictest/test_files/spark/string/chr.slt
+++ b/datafusion/sqllogictest/test_files/spark/string/chr.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'chr(65)': 'A', 'typeof(chr(65))': 'string',
'typeof(65)': 'int'}
#query
#SELECT chr(65::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/string/concat_ws.slt
b/datafusion/sqllogictest/test_files/spark/string/concat_ws.slt
index 9172d204c3..62df636bba 100644
--- a/datafusion/sqllogictest/test_files/spark/string/concat_ws.slt
+++ b/datafusion/sqllogictest/test_files/spark/string/concat_ws.slt
@@ -40,4 +40,3 @@
## PySpark 3.5.5 Result: {'concat_ws(NULL, Spark, SQL)': None,
'typeof(concat_ws(NULL, Spark, SQL))': 'string', 'typeof(NULL)': 'void',
'typeof(Spark)': 'string', 'typeof(SQL)': 'string'}
#query
#SELECT concat_ws(NULL::void, 'Spark'::string, 'SQL'::string);
-
diff --git a/datafusion/sqllogictest/test_files/spark/string/contains.slt
b/datafusion/sqllogictest/test_files/spark/string/contains.slt
index 80b05b8f25..1bfb61fc00 100644
--- a/datafusion/sqllogictest/test_files/spark/string/contains.slt
+++ b/datafusion/sqllogictest/test_files/spark/string/contains.slt
@@ -40,4 +40,3 @@
## PySpark 3.5.5 Result: {"contains(X'537061726B2053514C', X'537061726B')":
True, "typeof(contains(X'537061726B2053514C', X'537061726B'))": 'boolean',
"typeof(X'537061726B2053514C')": 'binary', "typeof(X'537061726B')": 'binary'}
#query
#SELECT contains(X'537061726B2053514C'::binary, X'537061726B'::binary);
-
diff --git a/datafusion/sqllogictest/test_files/spark/string/decode.slt
b/datafusion/sqllogictest/test_files/spark/string/decode.slt
index c6848dccd4..a427fe4038 100644
--- a/datafusion/sqllogictest/test_files/spark/string/decode.slt
+++ b/datafusion/sqllogictest/test_files/spark/string/decode.slt
@@ -40,4 +40,3 @@
## PySpark 3.5.5 Result: {'decode(NULL, 6, Spark, NULL, SQL, 4, rocks)':
'SQL', 'typeof(decode(NULL, 6, Spark, NULL, SQL, 4, rocks))': 'string',
'typeof(NULL)': 'void', 'typeof(6)': 'int', 'typeof(Spark)': 'string',
'typeof(SQL)': 'string', 'typeof(4)': 'int', 'typeof(rocks)': 'string'}
#query
#SELECT decode(NULL::void, 6::int, 'Spark'::string, 'SQL'::string, 4::int,
'rocks'::string);
-
diff --git a/datafusion/sqllogictest/test_files/spark/string/elt.slt
b/datafusion/sqllogictest/test_files/spark/string/elt.slt
index 406be0d5e5..1c63c93aef 100644
--- a/datafusion/sqllogictest/test_files/spark/string/elt.slt
+++ b/datafusion/sqllogictest/test_files/spark/string/elt.slt
@@ -30,4 +30,3 @@
## PySpark 3.5.5 Result: {'elt(2, a, 1)': '1', 'typeof(elt(2, a, 1))':
'string', 'typeof(2)': 'int', 'typeof(a)': 'string', 'typeof(1)': 'int'}
#query
#SELECT elt(2::int, 'a'::string, 1::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/string/encode.slt
b/datafusion/sqllogictest/test_files/spark/string/encode.slt
index 627ed842c7..4ad02316f4 100644
--- a/datafusion/sqllogictest/test_files/spark/string/encode.slt
+++ b/datafusion/sqllogictest/test_files/spark/string/encode.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'encode(abc, utf-8)': bytearray(b'abc'),
'typeof(encode(abc, utf-8))': 'binary', 'typeof(abc)': 'string',
'typeof(utf-8)': 'string'}
#query
#SELECT encode('abc'::string, 'utf-8'::string);
-
diff --git a/datafusion/sqllogictest/test_files/spark/string/endswith.slt
b/datafusion/sqllogictest/test_files/spark/string/endswith.slt
index b933afe110..35ada546f8 100644
--- a/datafusion/sqllogictest/test_files/spark/string/endswith.slt
+++ b/datafusion/sqllogictest/test_files/spark/string/endswith.slt
@@ -45,4 +45,3 @@
## PySpark 3.5.5 Result: {"endswith(X'537061726B2053514C', X'537061726B')":
False, "typeof(endswith(X'537061726B2053514C', X'537061726B'))": 'boolean',
"typeof(X'537061726B2053514C')": 'binary', "typeof(X'537061726B')": 'binary'}
#query
#SELECT endswith(X'537061726B2053514C'::binary, X'537061726B'::binary);
-
diff --git a/datafusion/sqllogictest/test_files/spark/string/find_in_set.slt
b/datafusion/sqllogictest/test_files/spark/string/find_in_set.slt
index 9715879152..690d03ffa4 100644
--- a/datafusion/sqllogictest/test_files/spark/string/find_in_set.slt
+++ b/datafusion/sqllogictest/test_files/spark/string/find_in_set.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'find_in_set(ab, abc,b,ab,c,def)': 3,
'typeof(find_in_set(ab, abc,b,ab,c,def))': 'int', 'typeof(ab)': 'string',
'typeof(abc,b,ab,c,def)': 'string'}
#query
#SELECT find_in_set('ab'::string, 'abc,b,ab,c,def'::string);
-
diff --git a/datafusion/sqllogictest/test_files/spark/string/format_number.slt
b/datafusion/sqllogictest/test_files/spark/string/format_number.slt
index 01af282bcb..a56b8d004c 100644
--- a/datafusion/sqllogictest/test_files/spark/string/format_number.slt
+++ b/datafusion/sqllogictest/test_files/spark/string/format_number.slt
@@ -30,4 +30,3 @@
## PySpark 3.5.5 Result: {'format_number(12332.123456, 4)': '12,332.1235',
'typeof(format_number(12332.123456, 4))': 'string', 'typeof(12332.123456)':
'decimal(11,6)', 'typeof(4)': 'int'}
#query
#SELECT format_number(12332.123456::decimal(11,6), 4::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/string/format_string.slt
b/datafusion/sqllogictest/test_files/spark/string/format_string.slt
index 2505557a71..66b167a39a 100644
--- a/datafusion/sqllogictest/test_files/spark/string/format_string.slt
+++ b/datafusion/sqllogictest/test_files/spark/string/format_string.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'format_string(Hello World %d %s, 100, days)':
'Hello World 100 days', 'typeof(format_string(Hello World %d %s, 100, days))':
'string', 'typeof(Hello World %d %s)': 'string', 'typeof(100)': 'int',
'typeof(days)': 'string'}
#query
#SELECT format_string('Hello World %d %s'::string, 100::int, 'days'::string);
-
diff --git a/datafusion/sqllogictest/test_files/spark/string/initcap.slt
b/datafusion/sqllogictest/test_files/spark/string/initcap.slt
index b464cad471..eb4fe04632 100644
--- a/datafusion/sqllogictest/test_files/spark/string/initcap.slt
+++ b/datafusion/sqllogictest/test_files/spark/string/initcap.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'initcap(sPark sql)': 'Spark Sql',
'typeof(initcap(sPark sql))': 'string', 'typeof(sPark sql)': 'string'}
#query
#SELECT initcap('sPark sql'::string);
-
diff --git a/datafusion/sqllogictest/test_files/spark/string/instr.slt
b/datafusion/sqllogictest/test_files/spark/string/instr.slt
index 55ba2d7312..dd332ad4a4 100644
--- a/datafusion/sqllogictest/test_files/spark/string/instr.slt
+++ b/datafusion/sqllogictest/test_files/spark/string/instr.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'instr(SparkSQL, SQL)': 6, 'typeof(instr(SparkSQL,
SQL))': 'int', 'typeof(SparkSQL)': 'string', 'typeof(SQL)': 'string'}
#query
#SELECT instr('SparkSQL'::string, 'SQL'::string);
-
diff --git a/datafusion/sqllogictest/test_files/spark/string/lcase.slt
b/datafusion/sqllogictest/test_files/spark/string/lcase.slt
index 795cf620fd..45093aae64 100644
--- a/datafusion/sqllogictest/test_files/spark/string/lcase.slt
+++ b/datafusion/sqllogictest/test_files/spark/string/lcase.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'lcase(SparkSql)': 'sparksql',
'typeof(lcase(SparkSql))': 'string', 'typeof(SparkSql)': 'string'}
#query
#SELECT lcase('SparkSql'::string);
-
diff --git a/datafusion/sqllogictest/test_files/spark/string/left.slt
b/datafusion/sqllogictest/test_files/spark/string/left.slt
index 12effeb38f..a6413b7633 100644
--- a/datafusion/sqllogictest/test_files/spark/string/left.slt
+++ b/datafusion/sqllogictest/test_files/spark/string/left.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'left(Spark SQL, 3)': 'Spa', 'typeof(left(Spark SQL,
3))': 'string', 'typeof(Spark SQL)': 'string', 'typeof(3)': 'int'}
#query
#SELECT left('Spark SQL'::string, 3::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/string/len.slt
b/datafusion/sqllogictest/test_files/spark/string/len.slt
index ae469cdc35..8f0be80276 100644
--- a/datafusion/sqllogictest/test_files/spark/string/len.slt
+++ b/datafusion/sqllogictest/test_files/spark/string/len.slt
@@ -30,4 +30,3 @@
## PySpark 3.5.5 Result: {"len(X'537061726B2053514C')": 9,
"typeof(len(X'537061726B2053514C'))": 'int', "typeof(X'537061726B2053514C')":
'binary'}
#query
#SELECT len(X'537061726B2053514C'::binary);
-
diff --git a/datafusion/sqllogictest/test_files/spark/string/length.slt
b/datafusion/sqllogictest/test_files/spark/string/length.slt
index 94252a9977..57efc230f0 100644
--- a/datafusion/sqllogictest/test_files/spark/string/length.slt
+++ b/datafusion/sqllogictest/test_files/spark/string/length.slt
@@ -30,4 +30,3 @@
## PySpark 3.5.5 Result: {"length(X'537061726B2053514C')": 9,
"typeof(length(X'537061726B2053514C'))": 'int',
"typeof(X'537061726B2053514C')": 'binary'}
#query
#SELECT length(X'537061726B2053514C'::binary);
-
diff --git a/datafusion/sqllogictest/test_files/spark/string/levenshtein.slt
b/datafusion/sqllogictest/test_files/spark/string/levenshtein.slt
index 76d731da20..086f03642e 100644
--- a/datafusion/sqllogictest/test_files/spark/string/levenshtein.slt
+++ b/datafusion/sqllogictest/test_files/spark/string/levenshtein.slt
@@ -30,4 +30,3 @@
## PySpark 3.5.5 Result: {'levenshtein(kitten, sitting, 2)': -1,
'typeof(levenshtein(kitten, sitting, 2))': 'int', 'typeof(kitten)': 'string',
'typeof(sitting)': 'string', 'typeof(2)': 'int'}
#query
#SELECT levenshtein('kitten'::string, 'sitting'::string, 2::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/string/locate.slt
b/datafusion/sqllogictest/test_files/spark/string/locate.slt
index c5a6c625e9..369d505ac9 100644
--- a/datafusion/sqllogictest/test_files/spark/string/locate.slt
+++ b/datafusion/sqllogictest/test_files/spark/string/locate.slt
@@ -30,4 +30,3 @@
## PySpark 3.5.5 Result: {'locate(bar, foobarbar, 5)': 7, 'typeof(locate(bar,
foobarbar, 5))': 'int', 'typeof(bar)': 'string', 'typeof(foobarbar)': 'string',
'typeof(5)': 'int'}
#query
#SELECT locate('bar'::string, 'foobarbar'::string, 5::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/string/lower.slt
b/datafusion/sqllogictest/test_files/spark/string/lower.slt
index e221e62214..c59f380a99 100644
--- a/datafusion/sqllogictest/test_files/spark/string/lower.slt
+++ b/datafusion/sqllogictest/test_files/spark/string/lower.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'lower(SparkSql)': 'sparksql',
'typeof(lower(SparkSql))': 'string', 'typeof(SparkSql)': 'string'}
#query
#SELECT lower('SparkSql'::string);
-
diff --git a/datafusion/sqllogictest/test_files/spark/string/lpad.slt
b/datafusion/sqllogictest/test_files/spark/string/lpad.slt
index f9716d59cc..858ae8e221 100644
--- a/datafusion/sqllogictest/test_files/spark/string/lpad.slt
+++ b/datafusion/sqllogictest/test_files/spark/string/lpad.slt
@@ -35,4 +35,3 @@
## PySpark 3.5.5 Result: {'lpad(hi, 5, ??)': '???hi', 'typeof(lpad(hi, 5,
??))': 'string', 'typeof(hi)': 'string', 'typeof(5)': 'int', 'typeof(??)':
'string'}
#query
#SELECT lpad('hi'::string, 5::int, '??'::string);
-
diff --git a/datafusion/sqllogictest/test_files/spark/string/ltrim.slt
b/datafusion/sqllogictest/test_files/spark/string/ltrim.slt
index 8719dad4d4..a190eae914 100644
--- a/datafusion/sqllogictest/test_files/spark/string/ltrim.slt
+++ b/datafusion/sqllogictest/test_files/spark/string/ltrim.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'ltrim( SparkSQL )': 'SparkSQL ',
'typeof(ltrim( SparkSQL ))': 'string', 'typeof( SparkSQL )': 'string'}
#query
#SELECT ltrim(' SparkSQL '::string);
-
diff --git a/datafusion/sqllogictest/test_files/spark/string/luhn_check.slt
b/datafusion/sqllogictest/test_files/spark/string/luhn_check.slt
index a28c60e629..389c34ef68 100644
--- a/datafusion/sqllogictest/test_files/spark/string/luhn_check.slt
+++ b/datafusion/sqllogictest/test_files/spark/string/luhn_check.slt
@@ -35,4 +35,3 @@
## PySpark 3.5.5 Result: {'luhn_check(8112189876)': True,
'typeof(luhn_check(8112189876))': 'boolean', 'typeof(8112189876)': 'string'}
#query
#SELECT luhn_check('8112189876'::string);
-
diff --git a/datafusion/sqllogictest/test_files/spark/string/mask.slt
b/datafusion/sqllogictest/test_files/spark/string/mask.slt
index 6468af3cc4..45ea093d36 100644
--- a/datafusion/sqllogictest/test_files/spark/string/mask.slt
+++ b/datafusion/sqllogictest/test_files/spark/string/mask.slt
@@ -85,4 +85,3 @@
## PySpark 3.5.5 Result: {'mask(NULL, NULL, NULL, NULL, o)': None,
'typeof(mask(NULL, NULL, NULL, NULL, o))': 'string', 'typeof(NULL)': 'void',
'typeof(o)': 'string'}
#query
#SELECT mask(NULL::void, 'o'::string);
-
diff --git a/datafusion/sqllogictest/test_files/spark/string/octet_length.slt
b/datafusion/sqllogictest/test_files/spark/string/octet_length.slt
index 1efab79732..5042581aef 100644
--- a/datafusion/sqllogictest/test_files/spark/string/octet_length.slt
+++ b/datafusion/sqllogictest/test_files/spark/string/octet_length.slt
@@ -30,4 +30,3 @@
## PySpark 3.5.5 Result: {"octet_length(X'537061726B2053514C')": 9,
"typeof(octet_length(X'537061726B2053514C'))": 'int',
"typeof(X'537061726B2053514C')": 'binary'}
#query
#SELECT octet_length(X'537061726B2053514C'::binary);
-
diff --git a/datafusion/sqllogictest/test_files/spark/string/position.slt
b/datafusion/sqllogictest/test_files/spark/string/position.slt
index b79c24248c..76ce29e470 100644
--- a/datafusion/sqllogictest/test_files/spark/string/position.slt
+++ b/datafusion/sqllogictest/test_files/spark/string/position.slt
@@ -30,4 +30,3 @@
## PySpark 3.5.5 Result: {'position(bar, foobarbar, 5)': 7,
'typeof(position(bar, foobarbar, 5))': 'int', 'typeof(bar)': 'string',
'typeof(foobarbar)': 'string', 'typeof(5)': 'int'}
#query
#SELECT position('bar'::string, 'foobarbar'::string, 5::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/string/printf.slt
b/datafusion/sqllogictest/test_files/spark/string/printf.slt
index 7a19918019..dd25dbcbfe 100644
--- a/datafusion/sqllogictest/test_files/spark/string/printf.slt
+++ b/datafusion/sqllogictest/test_files/spark/string/printf.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'printf(Hello World %d %s, 100, days)': 'Hello World
100 days', 'typeof(printf(Hello World %d %s, 100, days))': 'string',
'typeof(Hello World %d %s)': 'string', 'typeof(100)': 'int', 'typeof(days)':
'string'}
#query
#SELECT printf('Hello World %d %s'::string, 100::int, 'days'::string);
-
diff --git a/datafusion/sqllogictest/test_files/spark/string/repeat.slt
b/datafusion/sqllogictest/test_files/spark/string/repeat.slt
index 3c1d097e59..5ca4166f9f 100644
--- a/datafusion/sqllogictest/test_files/spark/string/repeat.slt
+++ b/datafusion/sqllogictest/test_files/spark/string/repeat.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'repeat(123, 2)': '123123', 'typeof(repeat(123,
2))': 'string', 'typeof(123)': 'string', 'typeof(2)': 'int'}
#query
#SELECT repeat('123'::string, 2::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/string/replace.slt
b/datafusion/sqllogictest/test_files/spark/string/replace.slt
index ee74c8e91a..a5430febb7 100644
--- a/datafusion/sqllogictest/test_files/spark/string/replace.slt
+++ b/datafusion/sqllogictest/test_files/spark/string/replace.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'replace(ABCabc, abc, DEF)': 'ABCDEF',
'typeof(replace(ABCabc, abc, DEF))': 'string', 'typeof(ABCabc)': 'string',
'typeof(abc)': 'string', 'typeof(DEF)': 'string'}
#query
#SELECT replace('ABCabc'::string, 'abc'::string, 'DEF'::string);
-
diff --git a/datafusion/sqllogictest/test_files/spark/string/right.slt
b/datafusion/sqllogictest/test_files/spark/string/right.slt
index 239705eab8..a65a18b490 100644
--- a/datafusion/sqllogictest/test_files/spark/string/right.slt
+++ b/datafusion/sqllogictest/test_files/spark/string/right.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'right(Spark SQL, 3)': 'SQL', 'typeof(right(Spark
SQL, 3))': 'string', 'typeof(Spark SQL)': 'string', 'typeof(3)': 'int'}
#query
#SELECT right('Spark SQL'::string, 3::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/string/rpad.slt
b/datafusion/sqllogictest/test_files/spark/string/rpad.slt
index 98ebd1f810..f0451ade90 100644
--- a/datafusion/sqllogictest/test_files/spark/string/rpad.slt
+++ b/datafusion/sqllogictest/test_files/spark/string/rpad.slt
@@ -35,4 +35,3 @@
## PySpark 3.5.5 Result: {'rpad(hi, 5, ??)': 'hi???', 'typeof(rpad(hi, 5,
??))': 'string', 'typeof(hi)': 'string', 'typeof(5)': 'int', 'typeof(??)':
'string'}
#query
#SELECT rpad('hi'::string, 5::int, '??'::string);
-
diff --git a/datafusion/sqllogictest/test_files/spark/string/rtrim.slt
b/datafusion/sqllogictest/test_files/spark/string/rtrim.slt
index c86264b6e7..b6d3b10abd 100644
--- a/datafusion/sqllogictest/test_files/spark/string/rtrim.slt
+++ b/datafusion/sqllogictest/test_files/spark/string/rtrim.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'rtrim( SparkSQL )': ' SparkSQL',
'typeof(rtrim( SparkSQL ))': 'string', 'typeof( SparkSQL )': 'string'}
#query
#SELECT rtrim(' SparkSQL '::string);
-
diff --git a/datafusion/sqllogictest/test_files/spark/string/sentences.slt
b/datafusion/sqllogictest/test_files/spark/string/sentences.slt
index f6c69a64ce..317dca0e47 100644
--- a/datafusion/sqllogictest/test_files/spark/string/sentences.slt
+++ b/datafusion/sqllogictest/test_files/spark/string/sentences.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'sentences(Hi there! Good morning., , )': [['Hi',
'there'], ['Good', 'morning']], 'typeof(sentences(Hi there! Good morning., ,
))': 'array<array<string>>', 'typeof(Hi there! Good morning.)': 'string'}
#query
#SELECT sentences('Hi there! Good morning.'::string);
-
diff --git a/datafusion/sqllogictest/test_files/spark/string/soundex.slt
b/datafusion/sqllogictest/test_files/spark/string/soundex.slt
index 1222f02c0d..f0c46e10fd 100644
--- a/datafusion/sqllogictest/test_files/spark/string/soundex.slt
+++ b/datafusion/sqllogictest/test_files/spark/string/soundex.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'soundex(Miller)': 'M460',
'typeof(soundex(Miller))': 'string', 'typeof(Miller)': 'string'}
#query
#SELECT soundex('Miller'::string);
-
diff --git a/datafusion/sqllogictest/test_files/spark/string/split_part.slt
b/datafusion/sqllogictest/test_files/spark/string/split_part.slt
index 89c752183f..0561a03ecf 100644
--- a/datafusion/sqllogictest/test_files/spark/string/split_part.slt
+++ b/datafusion/sqllogictest/test_files/spark/string/split_part.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'split_part(11.12.13, ., 3)': '13',
'typeof(split_part(11.12.13, ., 3))': 'string', 'typeof(11.12.13)': 'string',
'typeof(.)': 'string', 'typeof(3)': 'int'}
#query
#SELECT split_part('11.12.13'::string, '.'::string, 3::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/string/startswith.slt
b/datafusion/sqllogictest/test_files/spark/string/startswith.slt
index 296ec4beb0..f75f9d080d 100644
--- a/datafusion/sqllogictest/test_files/spark/string/startswith.slt
+++ b/datafusion/sqllogictest/test_files/spark/string/startswith.slt
@@ -45,4 +45,3 @@
## PySpark 3.5.5 Result: {"startswith(X'537061726B2053514C', X'537061726B')":
True, "typeof(startswith(X'537061726B2053514C', X'537061726B'))": 'boolean',
"typeof(X'537061726B2053514C')": 'binary', "typeof(X'537061726B')": 'binary'}
#query
#SELECT startswith(X'537061726B2053514C'::binary, X'537061726B'::binary);
-
diff --git a/datafusion/sqllogictest/test_files/spark/string/substr.slt
b/datafusion/sqllogictest/test_files/spark/string/substr.slt
index 79bdee0213..0942bdd86a 100644
--- a/datafusion/sqllogictest/test_files/spark/string/substr.slt
+++ b/datafusion/sqllogictest/test_files/spark/string/substr.slt
@@ -35,4 +35,3 @@
## PySpark 3.5.5 Result: {'substr(Spark SQL, 5, 1)': 'k', 'typeof(substr(Spark
SQL, 5, 1))': 'string', 'typeof(Spark SQL)': 'string', 'typeof(5)': 'int',
'typeof(1)': 'int'}
#query
#SELECT substr('Spark SQL'::string, 5::int, 1::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/string/substring.slt
b/datafusion/sqllogictest/test_files/spark/string/substring.slt
index be37a02529..847ce4b6d4 100644
--- a/datafusion/sqllogictest/test_files/spark/string/substring.slt
+++ b/datafusion/sqllogictest/test_files/spark/string/substring.slt
@@ -35,4 +35,3 @@
## PySpark 3.5.5 Result: {'substring(Spark SQL, 5, 1)': 'k',
'typeof(substring(Spark SQL, 5, 1))': 'string', 'typeof(Spark SQL)': 'string',
'typeof(5)': 'int', 'typeof(1)': 'int'}
#query
#SELECT substring('Spark SQL'::string, 5::int, 1::int);
-
diff --git
a/datafusion/sqllogictest/test_files/spark/string/substring_index.slt
b/datafusion/sqllogictest/test_files/spark/string/substring_index.slt
index 99b6fae28b..b434d9fa5e 100644
--- a/datafusion/sqllogictest/test_files/spark/string/substring_index.slt
+++ b/datafusion/sqllogictest/test_files/spark/string/substring_index.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'substring_index(www.apache.org, ., 2)':
'www.apache', 'typeof(substring_index(www.apache.org, ., 2))': 'string',
'typeof(www.apache.org)': 'string', 'typeof(.)': 'string', 'typeof(2)': 'int'}
#query
#SELECT substring_index('www.apache.org'::string, '.'::string, 2::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/string/to_binary.slt
b/datafusion/sqllogictest/test_files/spark/string/to_binary.slt
index 2cfe2f9c3f..d8efa323f2 100644
--- a/datafusion/sqllogictest/test_files/spark/string/to_binary.slt
+++ b/datafusion/sqllogictest/test_files/spark/string/to_binary.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'to_binary(abc, utf-8)': bytearray(b'abc'),
'typeof(to_binary(abc, utf-8))': 'binary', 'typeof(abc)': 'string',
'typeof(utf-8)': 'string'}
#query
#SELECT to_binary('abc'::string, 'utf-8'::string);
-
diff --git a/datafusion/sqllogictest/test_files/spark/string/to_char.slt
b/datafusion/sqllogictest/test_files/spark/string/to_char.slt
index ca9d843fb3..88d88bbb8a 100644
--- a/datafusion/sqllogictest/test_files/spark/string/to_char.slt
+++ b/datafusion/sqllogictest/test_files/spark/string/to_char.slt
@@ -45,4 +45,3 @@
## PySpark 3.5.5 Result: {'to_char(78.12, $99.99)': '$78.12',
'typeof(to_char(78.12, $99.99))': 'string', 'typeof(78.12)': 'decimal(4,2)',
'typeof($99.99)': 'string'}
#query
#SELECT to_char(78.12::decimal(4,2), '$99.99'::string);
-
diff --git a/datafusion/sqllogictest/test_files/spark/string/to_number.slt
b/datafusion/sqllogictest/test_files/spark/string/to_number.slt
index 6c10f6afc9..ffbee15aca 100644
--- a/datafusion/sqllogictest/test_files/spark/string/to_number.slt
+++ b/datafusion/sqllogictest/test_files/spark/string/to_number.slt
@@ -45,4 +45,3 @@
## PySpark 3.5.5 Result: {'to_number(454.00, 000.00)': Decimal('454.00'),
'typeof(to_number(454.00, 000.00))': 'decimal(5,2)', 'typeof(454.00)':
'string', 'typeof(000.00)': 'string'}
#query
#SELECT to_number('454.00'::string, '000.00'::string);
-
diff --git a/datafusion/sqllogictest/test_files/spark/string/to_varchar.slt
b/datafusion/sqllogictest/test_files/spark/string/to_varchar.slt
index f1303324be..51662b89e5 100644
--- a/datafusion/sqllogictest/test_files/spark/string/to_varchar.slt
+++ b/datafusion/sqllogictest/test_files/spark/string/to_varchar.slt
@@ -45,4 +45,3 @@
## PySpark 3.5.5 Result: {'to_char(78.12, $99.99)': '$78.12',
'typeof(to_char(78.12, $99.99))': 'string', 'typeof(78.12)': 'decimal(4,2)',
'typeof($99.99)': 'string'}
#query
#SELECT to_varchar(78.12::decimal(4,2), '$99.99'::string);
-
diff --git a/datafusion/sqllogictest/test_files/spark/string/translate.slt
b/datafusion/sqllogictest/test_files/spark/string/translate.slt
index 179ac93427..53ea41a7ac 100644
--- a/datafusion/sqllogictest/test_files/spark/string/translate.slt
+++ b/datafusion/sqllogictest/test_files/spark/string/translate.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'translate(AaBbCc, abc, 123)': 'A1B2C3',
'typeof(translate(AaBbCc, abc, 123))': 'string', 'typeof(AaBbCc)': 'string',
'typeof(abc)': 'string', 'typeof(123)': 'string'}
#query
#SELECT translate('AaBbCc'::string, 'abc'::string, '123'::string);
-
diff --git a/datafusion/sqllogictest/test_files/spark/string/trim.slt
b/datafusion/sqllogictest/test_files/spark/string/trim.slt
index ebd637b71f..725bab5e69 100644
--- a/datafusion/sqllogictest/test_files/spark/string/trim.slt
+++ b/datafusion/sqllogictest/test_files/spark/string/trim.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'trim( SparkSQL )': 'SparkSQL', 'typeof(trim(
SparkSQL ))': 'string', 'typeof( SparkSQL )': 'string'}
#query
#SELECT trim(' SparkSQL '::string);
-
diff --git a/datafusion/sqllogictest/test_files/spark/string/try_to_binary.slt
b/datafusion/sqllogictest/test_files/spark/string/try_to_binary.slt
index 3f6935327f..211520be1e 100644
--- a/datafusion/sqllogictest/test_files/spark/string/try_to_binary.slt
+++ b/datafusion/sqllogictest/test_files/spark/string/try_to_binary.slt
@@ -35,4 +35,3 @@
## PySpark 3.5.5 Result: {'try_to_binary(abc, invalidFormat)': None,
'typeof(try_to_binary(abc, invalidFormat))': 'binary', 'typeof(abc)': 'string',
'typeof(invalidFormat)': 'string'}
#query
#SELECT try_to_binary('abc'::string, 'invalidFormat'::string);
-
diff --git a/datafusion/sqllogictest/test_files/spark/string/try_to_number.slt
b/datafusion/sqllogictest/test_files/spark/string/try_to_number.slt
index 77e8f5a4cb..10be9e2180 100644
--- a/datafusion/sqllogictest/test_files/spark/string/try_to_number.slt
+++ b/datafusion/sqllogictest/test_files/spark/string/try_to_number.slt
@@ -45,4 +45,3 @@
## PySpark 3.5.5 Result: {'try_to_number(454.00, 000.00)': Decimal('454.00'),
'typeof(try_to_number(454.00, 000.00))': 'decimal(5,2)', 'typeof(454.00)':
'string', 'typeof(000.00)': 'string'}
#query
#SELECT try_to_number('454.00'::string, '000.00'::string);
-
diff --git a/datafusion/sqllogictest/test_files/spark/string/ucase.slt
b/datafusion/sqllogictest/test_files/spark/string/ucase.slt
index ff0d2a3674..00860c6973 100644
--- a/datafusion/sqllogictest/test_files/spark/string/ucase.slt
+++ b/datafusion/sqllogictest/test_files/spark/string/ucase.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'ucase(SparkSql)': 'SPARKSQL',
'typeof(ucase(SparkSql))': 'string', 'typeof(SparkSql)': 'string'}
#query
#SELECT ucase('SparkSql'::string);
-
diff --git a/datafusion/sqllogictest/test_files/spark/string/unbase64.slt
b/datafusion/sqllogictest/test_files/spark/string/unbase64.slt
index f9afde4390..5cf3fbee04 100644
--- a/datafusion/sqllogictest/test_files/spark/string/unbase64.slt
+++ b/datafusion/sqllogictest/test_files/spark/string/unbase64.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'unbase64(U3BhcmsgU1FM)': bytearray(b'Spark SQL'),
'typeof(unbase64(U3BhcmsgU1FM))': 'binary', 'typeof(U3BhcmsgU1FM)': 'string'}
#query
#SELECT unbase64('U3BhcmsgU1FM'::string);
-
diff --git a/datafusion/sqllogictest/test_files/spark/string/upper.slt
b/datafusion/sqllogictest/test_files/spark/string/upper.slt
index 62124c315d..91c9294033 100644
--- a/datafusion/sqllogictest/test_files/spark/string/upper.slt
+++ b/datafusion/sqllogictest/test_files/spark/string/upper.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'upper(SparkSql)': 'SPARKSQL',
'typeof(upper(SparkSql))': 'string', 'typeof(SparkSql)': 'string'}
#query
#SELECT upper('SparkSql'::string);
-
diff --git a/datafusion/sqllogictest/test_files/spark/struct/named_struct.slt
b/datafusion/sqllogictest/test_files/spark/struct/named_struct.slt
index ae08770e8b..83b24f6d04 100644
--- a/datafusion/sqllogictest/test_files/spark/struct/named_struct.slt
+++ b/datafusion/sqllogictest/test_files/spark/struct/named_struct.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'named_struct(a, 1, b, 2, c, 3)': Row(a=1, b=2,
c=3), 'typeof(named_struct(a, 1, b, 2, c, 3))': 'struct<a:int,b:int,c:int>',
'typeof(a)': 'string', 'typeof(1)': 'int', 'typeof(b)': 'string', 'typeof(2)':
'int', 'typeof(c)': 'string', 'typeof(3)': 'int'}
#query
#SELECT named_struct('a'::string, 1::int, 'b'::string, 2::int, 'c'::string,
3::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/struct/struct.slt
b/datafusion/sqllogictest/test_files/spark/struct/struct.slt
index abfd654624..fe23e24970 100644
--- a/datafusion/sqllogictest/test_files/spark/struct/struct.slt
+++ b/datafusion/sqllogictest/test_files/spark/struct/struct.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'struct(1, 2, 3)': Row(col1=1, col2=2, col3=3),
'typeof(struct(1, 2, 3))': 'struct<col1:int,col2:int,col3:int>', 'typeof(1)':
'int', 'typeof(2)': 'int', 'typeof(3)': 'int'}
#query
#SELECT struct(1::int, 2::int, 3::int);
-
diff --git a/datafusion/sqllogictest/test_files/spark/url/parse_url.slt
b/datafusion/sqllogictest/test_files/spark/url/parse_url.slt
index eeeb154d7f..dc4e0b3ac7 100644
--- a/datafusion/sqllogictest/test_files/spark/url/parse_url.slt
+++ b/datafusion/sqllogictest/test_files/spark/url/parse_url.slt
@@ -35,4 +35,3 @@
## PySpark 3.5.5 Result: {'parse_url(http://spark.apache.org/path?query=1,
QUERY, query)': '1', 'typeof(parse_url(http://spark.apache.org/path?query=1,
QUERY, query))': 'string', 'typeof(http://spark.apache.org/path?query=1)':
'string', 'typeof(QUERY)': 'string', 'typeof(query)': 'string'}
#query
#SELECT parse_url('http://spark.apache.org/path?query=1'::string,
'QUERY'::string, 'query'::string);
-
diff --git a/datafusion/sqllogictest/test_files/spark/url/url_decode.slt
b/datafusion/sqllogictest/test_files/spark/url/url_decode.slt
index cbb89b2998..fa5028b647 100644
--- a/datafusion/sqllogictest/test_files/spark/url/url_decode.slt
+++ b/datafusion/sqllogictest/test_files/spark/url/url_decode.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'url_decode(https%3A%2F%2Fspark.apache.org)':
'https://spark.apache.org',
'typeof(url_decode(https%3A%2F%2Fspark.apache.org))': 'string',
'typeof(https%3A%2F%2Fspark.apache.org)': 'string'}
#query
#SELECT url_decode('https%3A%2F%2Fspark.apache.org'::string);
-
diff --git a/datafusion/sqllogictest/test_files/spark/url/url_encode.slt
b/datafusion/sqllogictest/test_files/spark/url/url_encode.slt
index c66e113193..6aef87dcb4 100644
--- a/datafusion/sqllogictest/test_files/spark/url/url_encode.slt
+++ b/datafusion/sqllogictest/test_files/spark/url/url_encode.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'url_encode(https://spark.apache.org)':
'https%3A%2F%2Fspark.apache.org',
'typeof(url_encode(https://spark.apache.org))': 'string',
'typeof(https://spark.apache.org)': 'string'}
#query
#SELECT url_encode('https://spark.apache.org'::string);
-
diff --git a/datafusion/sqllogictest/test_files/spark/xml/xpath.slt
b/datafusion/sqllogictest/test_files/spark/xml/xpath.slt
index a1aa1b85c3..d1ff923921 100644
--- a/datafusion/sqllogictest/test_files/spark/xml/xpath.slt
+++ b/datafusion/sqllogictest/test_files/spark/xml/xpath.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result:
{'xpath(<a><b>b1</b><b>b2</b><b>b3</b><c>c1</c><c>c2</c></a>, a/b)': [None,
None, None],
'typeof(xpath(<a><b>b1</b><b>b2</b><b>b3</b><c>c1</c><c>c2</c></a>, a/b))':
'array<string>',
'typeof(<a><b>b1</b><b>b2</b><b>b3</b><c>c1</c><c>c2</c></a>)': 'string',
'typeof(a/b)': 'string'}
#query
#SELECT xpath('<a><b>b1</b><b>b2</b><b>b3</b><c>c1</c><c>c2</c></a>'::string,
'a/b'::string);
-
diff --git a/datafusion/sqllogictest/test_files/spark/xml/xpath_boolean.slt
b/datafusion/sqllogictest/test_files/spark/xml/xpath_boolean.slt
index 6d4a2c6db7..8a5dc693eb 100644
--- a/datafusion/sqllogictest/test_files/spark/xml/xpath_boolean.slt
+++ b/datafusion/sqllogictest/test_files/spark/xml/xpath_boolean.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'xpath_boolean(<a><b>1</b></a>, a/b)': True,
'typeof(xpath_boolean(<a><b>1</b></a>, a/b))': 'boolean',
'typeof(<a><b>1</b></a>)': 'string', 'typeof(a/b)': 'string'}
#query
#SELECT xpath_boolean('<a><b>1</b></a>'::string, 'a/b'::string);
-
diff --git a/datafusion/sqllogictest/test_files/spark/xml/xpath_string.slt
b/datafusion/sqllogictest/test_files/spark/xml/xpath_string.slt
index 4b725ced11..cfabf467ed 100644
--- a/datafusion/sqllogictest/test_files/spark/xml/xpath_string.slt
+++ b/datafusion/sqllogictest/test_files/spark/xml/xpath_string.slt
@@ -25,4 +25,3 @@
## PySpark 3.5.5 Result: {'xpath_string(<a><b>b</b><c>cc</c></a>, a/c)': 'cc',
'typeof(xpath_string(<a><b>b</b><c>cc</c></a>, a/c))': 'string',
'typeof(<a><b>b</b><c>cc</c></a>)': 'string', 'typeof(a/c)': 'string'}
#query
#SELECT xpath_string('<a><b>b</b><c>cc</c></a>'::string, 'a/c'::string);
-
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@datafusion.apache.org
For additional commands, e-mail: commits-h...@datafusion.apache.org
