This is an automated email from the ASF dual-hosted git repository.
gengliang pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/spark.git
The following commit(s) were added to refs/heads/master by this push:
new 4f567f49cb1 [SPARK-39272][SQL] Increase the start position of query
context by 1
4f567f49cb1 is described below
commit 4f567f49cb19007b9adcce850f5f309c02375ac3
Author: Gengliang Wang <gengli...@apache.org>
AuthorDate: Wed May 25 17:32:45 2022 +0800
[SPARK-39272][SQL] Increase the start position of query context by 1
### What changes were proposed in this pull request?
Increase the start position of query context by 1
### Why are the changes needed?
Currently, the line number starts from 1, while the start position starts
from 0.
Thus it's better to increase the start position by 1 for consistency.
### Does this PR introduce _any_ user-facing change?
No
### How was this patch tested?
UT
Closes #36651 from gengliangwang/increase1.
Authored-by: Gengliang Wang <gengli...@apache.org>
Signed-off-by: Gengliang Wang <gengli...@apache.org>
---
.../apache/spark/sql/catalyst/trees/TreeNode.scala | 4 +-
.../spark/sql/catalyst/trees/TreeNodeSuite.scala | 2 +-
.../resources/sql-tests/results/ansi/cast.sql.out | 70 +++++++++++-----------
.../resources/sql-tests/results/ansi/date.sql.out | 6 +-
.../results/ansi/datetime-parsing-invalid.sql.out | 4 +-
.../ansi/decimalArithmeticOperations.sql.out | 20 +++----
.../sql-tests/results/ansi/interval.sql.out | 34 +++++------
.../resources/sql-tests/results/ansi/map.sql.out | 8 +--
.../results/ansi/string-functions.sql.out | 8 +--
.../resources/sql-tests/results/interval.sql.out | 12 ++--
.../sql-tests/results/postgreSQL/boolean.sql.out | 32 +++++-----
.../sql-tests/results/postgreSQL/float4.sql.out | 8 +--
.../sql-tests/results/postgreSQL/float8.sql.out | 8 +--
.../sql-tests/results/postgreSQL/int4.sql.out | 12 ++--
.../sql-tests/results/postgreSQL/int8.sql.out | 14 ++---
.../results/postgreSQL/select_having.sql.out | 2 +-
.../sql-tests/results/postgreSQL/text.sql.out | 4 +-
.../results/postgreSQL/window_part2.sql.out | 2 +-
.../results/postgreSQL/window_part3.sql.out | 2 +-
.../results/postgreSQL/window_part4.sql.out | 2 +-
.../udf/postgreSQL/udf-select_having.sql.out | 2 +-
.../sql/errors/QueryExecutionAnsiErrorsSuite.scala | 8 +--
22 files changed, 133 insertions(+), 131 deletions(-)
diff --git
a/sql/catalyst/src/main/scala/org/apache/spark/sql/catalyst/trees/TreeNode.scala
b/sql/catalyst/src/main/scala/org/apache/spark/sql/catalyst/trees/TreeNode.scala
index 54c64515ee4..fcbebf3ac7a 100644
---
a/sql/catalyst/src/main/scala/org/apache/spark/sql/catalyst/trees/TreeNode.scala
+++
b/sql/catalyst/src/main/scala/org/apache/spark/sql/catalyst/trees/TreeNode.scala
@@ -79,7 +79,9 @@ case class Origin(
""
} else {
val positionContext = if (line.isDefined && startPosition.isDefined) {
- s"(line ${line.get}, position ${startPosition.get})"
+ // Note that the line number starts from 1, while the start position
starts from 0.
+ // Here we increase the start position by 1 for consistency.
+ s"(line ${line.get}, position ${startPosition.get + 1})"
} else {
""
}
diff --git
a/sql/catalyst/src/test/scala/org/apache/spark/sql/catalyst/trees/TreeNodeSuite.scala
b/sql/catalyst/src/test/scala/org/apache/spark/sql/catalyst/trees/TreeNodeSuite.scala
index 899a740bdae..1e1206c0e1e 100644
---
a/sql/catalyst/src/test/scala/org/apache/spark/sql/catalyst/trees/TreeNodeSuite.scala
+++
b/sql/catalyst/src/test/scala/org/apache/spark/sql/catalyst/trees/TreeNodeSuite.scala
@@ -876,7 +876,7 @@ class TreeNodeSuite extends SparkFunSuite with SQLHelper {
objectType = Some("VIEW"),
objectName = Some("some_view"))
val expected =
- """== SQL of VIEW some_view(line 3, position 38) ==
+ """== SQL of VIEW some_view(line 3, position 39) ==
|...7890 + 1234567890 + 1234567890, cast('a'
| ^^^^^^^^
|as /* comment */
diff --git a/sql/core/src/test/resources/sql-tests/results/ansi/cast.sql.out
b/sql/core/src/test/resources/sql-tests/results/ansi/cast.sql.out
index 891cd34b7c5..45024dcffa7 100644
--- a/sql/core/src/test/resources/sql-tests/results/ansi/cast.sql.out
+++ b/sql/core/src/test/resources/sql-tests/results/ansi/cast.sql.out
@@ -9,7 +9,7 @@ struct<>
-- !query output
org.apache.spark.SparkNumberFormatException
[CAST_INVALID_INPUT] The value '1.23' of the type "STRING" cannot be cast to
"INT" because it is malformed. Correct the value as per the syntax, or change
its target type. To return NULL instead, use `try_cast`. If necessary set
"spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
SELECT CAST('1.23' AS int)
^^^^^^^^^^^^^^^^^^^
@@ -21,7 +21,7 @@ struct<>
-- !query output
org.apache.spark.SparkNumberFormatException
[CAST_INVALID_INPUT] The value '1.23' of the type "STRING" cannot be cast to
"BIGINT" because it is malformed. Correct the value as per the syntax, or
change its target type. To return NULL instead, use `try_cast`. If necessary
set "spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
SELECT CAST('1.23' AS long)
^^^^^^^^^^^^^^^^^^^^
@@ -33,7 +33,7 @@ struct<>
-- !query output
org.apache.spark.SparkNumberFormatException
[CAST_INVALID_INPUT] The value '-4.56' of the type "STRING" cannot be cast to
"INT" because it is malformed. Correct the value as per the syntax, or change
its target type. To return NULL instead, use `try_cast`. If necessary set
"spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
SELECT CAST('-4.56' AS int)
^^^^^^^^^^^^^^^^^^^^
@@ -45,7 +45,7 @@ struct<>
-- !query output
org.apache.spark.SparkNumberFormatException
[CAST_INVALID_INPUT] The value '-4.56' of the type "STRING" cannot be cast to
"BIGINT" because it is malformed. Correct the value as per the syntax, or
change its target type. To return NULL instead, use `try_cast`. If necessary
set "spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
SELECT CAST('-4.56' AS long)
^^^^^^^^^^^^^^^^^^^^^
@@ -57,7 +57,7 @@ struct<>
-- !query output
org.apache.spark.SparkNumberFormatException
[CAST_INVALID_INPUT] The value 'abc' of the type "STRING" cannot be cast to
"INT" because it is malformed. Correct the value as per the syntax, or change
its target type. To return NULL instead, use `try_cast`. If necessary set
"spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
SELECT CAST('abc' AS int)
^^^^^^^^^^^^^^^^^^
@@ -69,7 +69,7 @@ struct<>
-- !query output
org.apache.spark.SparkNumberFormatException
[CAST_INVALID_INPUT] The value 'abc' of the type "STRING" cannot be cast to
"BIGINT" because it is malformed. Correct the value as per the syntax, or
change its target type. To return NULL instead, use `try_cast`. If necessary
set "spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
SELECT CAST('abc' AS long)
^^^^^^^^^^^^^^^^^^^
@@ -81,7 +81,7 @@ struct<>
-- !query output
org.apache.spark.SparkNumberFormatException
[CAST_INVALID_INPUT] The value 'abc' of the type "STRING" cannot be cast to
"FLOAT" because it is malformed. Correct the value as per the syntax, or change
its target type. To return NULL instead, use `try_cast`. If necessary set
"spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
SELECT CAST('abc' AS float)
^^^^^^^^^^^^^^^^^^^^
@@ -93,7 +93,7 @@ struct<>
-- !query output
org.apache.spark.SparkNumberFormatException
[CAST_INVALID_INPUT] The value 'abc' of the type "STRING" cannot be cast to
"DOUBLE" because it is malformed. Correct the value as per the syntax, or
change its target type. To return NULL instead, use `try_cast`. If necessary
set "spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
SELECT CAST('abc' AS double)
^^^^^^^^^^^^^^^^^^^^^
@@ -105,7 +105,7 @@ struct<>
-- !query output
org.apache.spark.SparkNumberFormatException
[CAST_INVALID_INPUT] The value '1234567890123' of the type "STRING" cannot be
cast to "INT" because it is malformed. Correct the value as per the syntax, or
change its target type. To return NULL instead, use `try_cast`. If necessary
set "spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
SELECT CAST('1234567890123' AS int)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
@@ -117,7 +117,7 @@ struct<>
-- !query output
org.apache.spark.SparkNumberFormatException
[CAST_INVALID_INPUT] The value '12345678901234567890123' of the type "STRING"
cannot be cast to "BIGINT" because it is malformed. Correct the value as per
the syntax, or change its target type. To return NULL instead, use `try_cast`.
If necessary set "spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
SELECT CAST('12345678901234567890123' AS long)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
@@ -129,7 +129,7 @@ struct<>
-- !query output
org.apache.spark.SparkNumberFormatException
[CAST_INVALID_INPUT] The value '' of the type "STRING" cannot be cast to "INT"
because it is malformed. Correct the value as per the syntax, or change its
target type. To return NULL instead, use `try_cast`. If necessary set
"spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
SELECT CAST('' AS int)
^^^^^^^^^^^^^^^
@@ -141,7 +141,7 @@ struct<>
-- !query output
org.apache.spark.SparkNumberFormatException
[CAST_INVALID_INPUT] The value '' of the type "STRING" cannot be cast to
"BIGINT" because it is malformed. Correct the value as per the syntax, or
change its target type. To return NULL instead, use `try_cast`. If necessary
set "spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
SELECT CAST('' AS long)
^^^^^^^^^^^^^^^^
@@ -153,7 +153,7 @@ struct<>
-- !query output
org.apache.spark.SparkNumberFormatException
[CAST_INVALID_INPUT] The value '' of the type "STRING" cannot be cast to
"FLOAT" because it is malformed. Correct the value as per the syntax, or change
its target type. To return NULL instead, use `try_cast`. If necessary set
"spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
SELECT CAST('' AS float)
^^^^^^^^^^^^^^^^^
@@ -165,7 +165,7 @@ struct<>
-- !query output
org.apache.spark.SparkNumberFormatException
[CAST_INVALID_INPUT] The value '' of the type "STRING" cannot be cast to
"DOUBLE" because it is malformed. Correct the value as per the syntax, or
change its target type. To return NULL instead, use `try_cast`. If necessary
set "spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
SELECT CAST('' AS double)
^^^^^^^^^^^^^^^^^^
@@ -193,7 +193,7 @@ struct<>
-- !query output
org.apache.spark.SparkNumberFormatException
[CAST_INVALID_INPUT] The value '123.a' of the type "STRING" cannot be cast to
"INT" because it is malformed. Correct the value as per the syntax, or change
its target type. To return NULL instead, use `try_cast`. If necessary set
"spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
SELECT CAST('123.a' AS int)
^^^^^^^^^^^^^^^^^^^^
@@ -205,7 +205,7 @@ struct<>
-- !query output
org.apache.spark.SparkNumberFormatException
[CAST_INVALID_INPUT] The value '123.a' of the type "STRING" cannot be cast to
"BIGINT" because it is malformed. Correct the value as per the syntax, or
change its target type. To return NULL instead, use `try_cast`. If necessary
set "spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
SELECT CAST('123.a' AS long)
^^^^^^^^^^^^^^^^^^^^^
@@ -217,7 +217,7 @@ struct<>
-- !query output
org.apache.spark.SparkNumberFormatException
[CAST_INVALID_INPUT] The value '123.a' of the type "STRING" cannot be cast to
"FLOAT" because it is malformed. Correct the value as per the syntax, or change
its target type. To return NULL instead, use `try_cast`. If necessary set
"spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
SELECT CAST('123.a' AS float)
^^^^^^^^^^^^^^^^^^^^^^
@@ -229,7 +229,7 @@ struct<>
-- !query output
org.apache.spark.SparkNumberFormatException
[CAST_INVALID_INPUT] The value '123.a' of the type "STRING" cannot be cast to
"DOUBLE" because it is malformed. Correct the value as per the syntax, or
change its target type. To return NULL instead, use `try_cast`. If necessary
set "spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
SELECT CAST('123.a' AS double)
^^^^^^^^^^^^^^^^^^^^^^^
@@ -249,7 +249,7 @@ struct<>
-- !query output
org.apache.spark.SparkNumberFormatException
[CAST_INVALID_INPUT] The value '-2147483649' of the type "STRING" cannot be
cast to "INT" because it is malformed. Correct the value as per the syntax, or
change its target type. To return NULL instead, use `try_cast`. If necessary
set "spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
SELECT CAST('-2147483649' AS int)
^^^^^^^^^^^^^^^^^^^^^^^^^^
@@ -269,7 +269,7 @@ struct<>
-- !query output
org.apache.spark.SparkNumberFormatException
[CAST_INVALID_INPUT] The value '2147483648' of the type "STRING" cannot be
cast to "INT" because it is malformed. Correct the value as per the syntax, or
change its target type. To return NULL instead, use `try_cast`. If necessary
set "spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
SELECT CAST('2147483648' AS int)
^^^^^^^^^^^^^^^^^^^^^^^^^
@@ -289,7 +289,7 @@ struct<>
-- !query output
org.apache.spark.SparkNumberFormatException
[CAST_INVALID_INPUT] The value '-9223372036854775809' of the type "STRING"
cannot be cast to "BIGINT" because it is malformed. Correct the value as per
the syntax, or change its target type. To return NULL instead, use `try_cast`.
If necessary set "spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
SELECT CAST('-9223372036854775809' AS long)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
@@ -309,7 +309,7 @@ struct<>
-- !query output
org.apache.spark.SparkNumberFormatException
[CAST_INVALID_INPUT] The value '9223372036854775808' of the type "STRING"
cannot be cast to "BIGINT" because it is malformed. Correct the value as per
the syntax, or change its target type. To return NULL instead, use `try_cast`.
If necessary set "spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
SELECT CAST('9223372036854775808' AS long)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
@@ -568,7 +568,7 @@ struct<>
-- !query output
org.apache.spark.SparkNumberFormatException
[CAST_INVALID_INPUT] The value '1中文' of the type "STRING" cannot be cast to
"TINYINT" because it is malformed. Correct the value as per the syntax, or
change its target type. To return NULL instead, use `try_cast`. If necessary
set "spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
select cast('1中文' as tinyint)
^^^^^^^^^^^^^^^^^^^^^^
@@ -580,7 +580,7 @@ struct<>
-- !query output
org.apache.spark.SparkNumberFormatException
[CAST_INVALID_INPUT] The value '1中文' of the type "STRING" cannot be cast to
"SMALLINT" because it is malformed. Correct the value as per the syntax, or
change its target type. To return NULL instead, use `try_cast`. If necessary
set "spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
select cast('1中文' as smallint)
^^^^^^^^^^^^^^^^^^^^^^^
@@ -592,7 +592,7 @@ struct<>
-- !query output
org.apache.spark.SparkNumberFormatException
[CAST_INVALID_INPUT] The value '1中文' of the type "STRING" cannot be cast to
"INT" because it is malformed. Correct the value as per the syntax, or change
its target type. To return NULL instead, use `try_cast`. If necessary set
"spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
select cast('1中文' as INT)
^^^^^^^^^^^^^^^^^^
@@ -604,7 +604,7 @@ struct<>
-- !query output
org.apache.spark.SparkNumberFormatException
[CAST_INVALID_INPUT] The value '中文1' of the type "STRING" cannot be cast to
"BIGINT" because it is malformed. Correct the value as per the syntax, or
change its target type. To return NULL instead, use `try_cast`. If necessary
set "spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
select cast('中文1' as bigint)
^^^^^^^^^^^^^^^^^^^^^
@@ -616,7 +616,7 @@ struct<>
-- !query output
org.apache.spark.SparkNumberFormatException
[CAST_INVALID_INPUT] The value '1中文' of the type "STRING" cannot be cast to
"BIGINT" because it is malformed. Correct the value as per the syntax, or
change its target type. To return NULL instead, use `try_cast`. If necessary
set "spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
select cast('1中文' as bigint)
^^^^^^^^^^^^^^^^^^^^^
@@ -647,7 +647,7 @@ struct<>
org.apache.spark.SparkRuntimeException
[CAST_INVALID_INPUT] The value '
xyz
' of the type "STRING" cannot be cast to "BOOLEAN" because it is malformed.
Correct the value as per the syntax, or change its target type. To return NULL
instead, use `try_cast`. If necessary set "spark.sql.ansi.enabled" to "false"
to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
select cast('\t\n xyz \t\r' as boolean)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
@@ -667,7 +667,7 @@ struct<>
-- !query output
org.apache.spark.SparkArithmeticException
[CANNOT_CHANGE_DECIMAL_PRECISION] Decimal(expanded, 123.45, 5, 2) cannot be
represented as Decimal(4, 2). If necessary set "spark.sql.ansi.enabled" to
"false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
select cast('123.45' as decimal(4, 2))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
@@ -679,7 +679,7 @@ struct<>
-- !query output
org.apache.spark.SparkNumberFormatException
[CAST_INVALID_INPUT] The value 'xyz' of the type "STRING" cannot be cast to
"DECIMAL(4,2)" because it is malformed. Correct the value as per the syntax, or
change its target type. To return NULL instead, use `try_cast`. If necessary
set "spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
select cast('xyz' as decimal(4, 2))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
@@ -699,7 +699,7 @@ struct<>
-- !query output
org.apache.spark.SparkDateTimeException
[CAST_INVALID_INPUT] The value 'a' of the type "STRING" cannot be cast to
"DATE" because it is malformed. Correct the value as per the syntax, or change
its target type. To return NULL instead, use `try_cast`. If necessary set
"spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
select cast('a' as date)
^^^^^^^^^^^^^^^^^
@@ -719,7 +719,7 @@ struct<>
-- !query output
org.apache.spark.SparkDateTimeException
[CAST_INVALID_INPUT] The value 'a' of the type "STRING" cannot be cast to
"TIMESTAMP" because it is malformed. Correct the value as per the syntax, or
change its target type. To return NULL instead, use `try_cast`. If necessary
set "spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
select cast('a' as timestamp)
^^^^^^^^^^^^^^^^^^^^^^
@@ -739,7 +739,7 @@ struct<>
-- !query output
org.apache.spark.SparkDateTimeException
[CAST_INVALID_INPUT] The value 'a' of the type "STRING" cannot be cast to
"TIMESTAMP_NTZ" because it is malformed. Correct the value as per the syntax,
or change its target type. To return NULL instead, use `try_cast`. If necessary
set "spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
select cast('a' as timestamp_ntz)
^^^^^^^^^^^^^^^^^^^^^^^^^^
@@ -751,7 +751,7 @@ struct<>
-- !query output
org.apache.spark.SparkDateTimeException
[CAST_INVALID_INPUT] The value Infinity of the type "DOUBLE" cannot be cast to
"TIMESTAMP" because it is malformed. Correct the value as per the syntax, or
change its target type. To return NULL instead, use `try_cast`. If necessary
set "spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
select cast(cast('inf' as double) as timestamp)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
@@ -763,6 +763,6 @@ struct<>
-- !query output
org.apache.spark.SparkDateTimeException
[CAST_INVALID_INPUT] The value Infinity of the type "DOUBLE" cannot be cast to
"TIMESTAMP" because it is malformed. Correct the value as per the syntax, or
change its target type. To return NULL instead, use `try_cast`. If necessary
set "spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
select cast(cast('inf' as float) as timestamp)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
diff --git a/sql/core/src/test/resources/sql-tests/results/ansi/date.sql.out
b/sql/core/src/test/resources/sql-tests/results/ansi/date.sql.out
index dea228b3652..cea75f6dc46 100644
--- a/sql/core/src/test/resources/sql-tests/results/ansi/date.sql.out
+++ b/sql/core/src/test/resources/sql-tests/results/ansi/date.sql.out
@@ -233,7 +233,7 @@ struct<>
-- !query output
org.apache.spark.SparkDateTimeException
[CAST_INVALID_INPUT] The value 'xx' of the type "STRING" cannot be cast to
"DATE" because it is malformed. Correct the value as per the syntax, or change
its target type. To return NULL instead, use `try_cast`. If necessary set
"spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
select next_day("xx", "Mon")
^^^^^^^^^^^^^^^^^^^^^
@@ -328,7 +328,7 @@ struct<>
-- !query output
org.apache.spark.SparkNumberFormatException
[CAST_INVALID_INPUT] The value '1.2' of the type "STRING" cannot be cast to
"INT" because it is malformed. Correct the value as per the syntax, or change
its target type. To return NULL instead, use `try_cast`. If necessary set
"spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
select date_add('2011-11-11', '1.2')
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
@@ -439,7 +439,7 @@ struct<>
-- !query output
org.apache.spark.SparkNumberFormatException
[CAST_INVALID_INPUT] The value '1.2' of the type "STRING" cannot be cast to
"INT" because it is malformed. Correct the value as per the syntax, or change
its target type. To return NULL instead, use `try_cast`. If necessary set
"spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
select date_sub(date'2011-11-11', '1.2')
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
diff --git
a/sql/core/src/test/resources/sql-tests/results/ansi/datetime-parsing-invalid.sql.out
b/sql/core/src/test/resources/sql-tests/results/ansi/datetime-parsing-invalid.sql.out
index 7b9ad7ac4a9..aa6a6835a6b 100644
---
a/sql/core/src/test/resources/sql-tests/results/ansi/datetime-parsing-invalid.sql.out
+++
b/sql/core/src/test/resources/sql-tests/results/ansi/datetime-parsing-invalid.sql.out
@@ -251,7 +251,7 @@ struct<>
-- !query output
org.apache.spark.SparkDateTimeException
[CAST_INVALID_INPUT] The value 'Unparseable' of the type "STRING" cannot be
cast to "TIMESTAMP" because it is malformed. Correct the value as per the
syntax, or change its target type. To return NULL instead, use `try_cast`. If
necessary set "spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
select cast("Unparseable" as timestamp)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
@@ -263,6 +263,6 @@ struct<>
-- !query output
org.apache.spark.SparkDateTimeException
[CAST_INVALID_INPUT] The value 'Unparseable' of the type "STRING" cannot be
cast to "DATE" because it is malformed. Correct the value as per the syntax, or
change its target type. To return NULL instead, use `try_cast`. If necessary
set "spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
select cast("Unparseable" as date)
^^^^^^^^^^^^^^^^^^^^^^^^^^^
diff --git
a/sql/core/src/test/resources/sql-tests/results/ansi/decimalArithmeticOperations.sql.out
b/sql/core/src/test/resources/sql-tests/results/ansi/decimalArithmeticOperations.sql.out
index 219b1e621e1..ec4174c212e 100644
---
a/sql/core/src/test/resources/sql-tests/results/ansi/decimalArithmeticOperations.sql.out
+++
b/sql/core/src/test/resources/sql-tests/results/ansi/decimalArithmeticOperations.sql.out
@@ -77,7 +77,7 @@ struct<>
-- !query output
org.apache.spark.SparkArithmeticException
[CANNOT_CHANGE_DECIMAL_PRECISION] Decimal(expanded,
10000000000000000000000000000000000000.1, 39, 1) cannot be represented as
Decimal(38, 1). If necessary set "spark.sql.ansi.enabled" to "false" to bypass
this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
select (5e36BD + 0.1) + 5e36BD
^^^^^^^^^^^^^^^^^^^^^^^
@@ -89,7 +89,7 @@ struct<>
-- !query output
org.apache.spark.SparkArithmeticException
[CANNOT_CHANGE_DECIMAL_PRECISION] Decimal(expanded,
-11000000000000000000000000000000000000.1, 39, 1) cannot be represented as
Decimal(38, 1). If necessary set "spark.sql.ansi.enabled" to "false" to bypass
this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
select (-4e36BD - 0.1) - 7e36BD
^^^^^^^^^^^^^^^^^^^^^^^^
@@ -101,7 +101,7 @@ struct<>
-- !query output
org.apache.spark.SparkArithmeticException
[CANNOT_CHANGE_DECIMAL_PRECISION] Decimal(expanded,
152415787532388367501905199875019052100, 39, 0) cannot be represented as
Decimal(38, 2). If necessary set "spark.sql.ansi.enabled" to "false" to bypass
this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
select 12345678901234567890.0 * 12345678901234567890.0
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
@@ -113,7 +113,7 @@ struct<>
-- !query output
org.apache.spark.SparkArithmeticException
[CANNOT_CHANGE_DECIMAL_PRECISION] Decimal(expanded,
1000000000000000000000000000000000000.00000000000000000000000000000000000000,
75, 38) cannot be represented as Decimal(38, 6). If necessary set
"spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
select 1e35BD / 0.1
^^^^^^^^^^^^
@@ -149,7 +149,7 @@ struct<>
-- !query output
org.apache.spark.SparkArithmeticException
[CANNOT_CHANGE_DECIMAL_PRECISION] Decimal(expanded,
10123456789012345678901234567890123456.00000000000000000000000000000000000000,
76, 38) cannot be represented as Decimal(38, 6). If necessary set
"spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
select 1.0123456789012345678901234567890123456e36BD / 0.1
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
@@ -161,7 +161,7 @@ struct<>
-- !query output
org.apache.spark.SparkArithmeticException
[CANNOT_CHANGE_DECIMAL_PRECISION] Decimal(expanded,
101234567890123456789012345678901234.56000000000000000000000000000000000000,
74, 38) cannot be represented as Decimal(38, 6). If necessary set
"spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
select 1.0123456789012345678901234567890123456e35BD / 1.0
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
@@ -173,7 +173,7 @@ struct<>
-- !query output
org.apache.spark.SparkArithmeticException
[CANNOT_CHANGE_DECIMAL_PRECISION] Decimal(expanded,
10123456789012345678901234567890123.45600000000000000000000000000000000000, 73,
38) cannot be represented as Decimal(38, 6). If necessary set
"spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
select 1.0123456789012345678901234567890123456e34BD / 1.0
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
@@ -185,7 +185,7 @@ struct<>
-- !query output
org.apache.spark.SparkArithmeticException
[CANNOT_CHANGE_DECIMAL_PRECISION] Decimal(expanded,
1012345678901234567890123456789012.34560000000000000000000000000000000000, 72,
38) cannot be represented as Decimal(38, 6). If necessary set
"spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
select 1.0123456789012345678901234567890123456e33BD / 1.0
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
@@ -197,7 +197,7 @@ struct<>
-- !query output
org.apache.spark.SparkArithmeticException
[CANNOT_CHANGE_DECIMAL_PRECISION] Decimal(expanded,
101234567890123456789012345678901.23456000000000000000000000000000000000, 71,
38) cannot be represented as Decimal(38, 6). If necessary set
"spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
select 1.0123456789012345678901234567890123456e32BD / 1.0
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
@@ -217,7 +217,7 @@ struct<>
-- !query output
org.apache.spark.SparkArithmeticException
[CANNOT_CHANGE_DECIMAL_PRECISION] Decimal(expanded,
101234567890123456789012345678901.23456000000000000000000000000000000000, 71,
38) cannot be represented as Decimal(38, 6). If necessary set
"spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
select 1.0123456789012345678901234567890123456e31BD / 0.1
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
diff --git
a/sql/core/src/test/resources/sql-tests/results/ansi/interval.sql.out
b/sql/core/src/test/resources/sql-tests/results/ansi/interval.sql.out
index 6a61369a63e..7eaa5cc9a78 100644
--- a/sql/core/src/test/resources/sql-tests/results/ansi/interval.sql.out
+++ b/sql/core/src/test/resources/sql-tests/results/ansi/interval.sql.out
@@ -123,7 +123,7 @@ struct<>
-- !query output
org.apache.spark.SparkNumberFormatException
[CAST_INVALID_INPUT] The value 'a' of the type "STRING" cannot be cast to
"DOUBLE" because it is malformed. Correct the value as per the syntax, or
change its target type. To return NULL instead, use `try_cast`. If necessary
set "spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
select interval 2 second * 'a'
^^^^^^^^^^^^^^^^^^^^^^^
@@ -135,7 +135,7 @@ struct<>
-- !query output
org.apache.spark.SparkNumberFormatException
[CAST_INVALID_INPUT] The value 'a' of the type "STRING" cannot be cast to
"DOUBLE" because it is malformed. Correct the value as per the syntax, or
change its target type. To return NULL instead, use `try_cast`. If necessary
set "spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
select interval 2 second / 'a'
^^^^^^^^^^^^^^^^^^^^^^^
@@ -147,7 +147,7 @@ struct<>
-- !query output
org.apache.spark.SparkNumberFormatException
[CAST_INVALID_INPUT] The value 'a' of the type "STRING" cannot be cast to
"DOUBLE" because it is malformed. Correct the value as per the syntax, or
change its target type. To return NULL instead, use `try_cast`. If necessary
set "spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
select interval 2 year * 'a'
^^^^^^^^^^^^^^^^^^^^^
@@ -159,7 +159,7 @@ struct<>
-- !query output
org.apache.spark.SparkNumberFormatException
[CAST_INVALID_INPUT] The value 'a' of the type "STRING" cannot be cast to
"DOUBLE" because it is malformed. Correct the value as per the syntax, or
change its target type. To return NULL instead, use `try_cast`. If necessary
set "spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
select interval 2 year / 'a'
^^^^^^^^^^^^^^^^^^^^^
@@ -187,7 +187,7 @@ struct<>
-- !query output
org.apache.spark.SparkNumberFormatException
[CAST_INVALID_INPUT] The value 'a' of the type "STRING" cannot be cast to
"DOUBLE" because it is malformed. Correct the value as per the syntax, or
change its target type. To return NULL instead, use `try_cast`. If necessary
set "spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
select 'a' * interval 2 second
^^^^^^^^^^^^^^^^^^^^^^^
@@ -199,7 +199,7 @@ struct<>
-- !query output
org.apache.spark.SparkNumberFormatException
[CAST_INVALID_INPUT] The value 'a' of the type "STRING" cannot be cast to
"DOUBLE" because it is malformed. Correct the value as per the syntax, or
change its target type. To return NULL instead, use `try_cast`. If necessary
set "spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
select 'a' * interval 2 year
^^^^^^^^^^^^^^^^^^^^^
@@ -229,7 +229,7 @@ struct<>
-- !query output
org.apache.spark.SparkArithmeticException
[DIVIDE_BY_ZERO] Division by zero. To return NULL instead, use `try_divide`.
If necessary set "spark.sql.ansi.enabled" to "false" (except for ANSI interval
type) to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
select interval '2 seconds' / 0
^^^^^^^^^^^^^^^^^^^^^^^^
@@ -265,7 +265,7 @@ struct<>
-- !query output
org.apache.spark.SparkArithmeticException
[DIVIDE_BY_ZERO] Division by zero. To return NULL instead, use `try_divide`.
If necessary set "spark.sql.ansi.enabled" to "false" (except for ANSI interval
type) to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
select interval '2' year / 0
^^^^^^^^^^^^^^^^^^^^^
@@ -665,7 +665,7 @@ struct<>
-- !query output
org.apache.spark.SparkArithmeticException
[CANNOT_CHANGE_DECIMAL_PRECISION] Decimal(expanded, 1234567890123456789, 20,
0) cannot be represented as Decimal(18, 6). If necessary set
"spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
select make_interval(0, 0, 0, 0, 0, 0, 1234567890123456789)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
@@ -1517,7 +1517,7 @@ struct<>
-- !query output
org.apache.spark.SparkDateTimeException
[CAST_INVALID_INPUT] The value '4 11:11' of the type "STRING" cannot be cast
to "TIMESTAMP" because it is malformed. Correct the value as per the syntax, or
change its target type. To return NULL instead, use `try_cast`. If necessary
set "spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
select '4 11:11' - interval '4 22:12' day to minute
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
@@ -1529,7 +1529,7 @@ struct<>
-- !query output
org.apache.spark.SparkDateTimeException
[CAST_INVALID_INPUT] The value '4 12:12:12' of the type "STRING" cannot be
cast to "TIMESTAMP" because it is malformed. Correct the value as per the
syntax, or change its target type. To return NULL instead, use `try_cast`. If
necessary set "spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
select '4 12:12:12' + interval '4 22:12' day to minute
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
@@ -1567,7 +1567,7 @@ struct<>
-- !query output
org.apache.spark.SparkDateTimeException
[CAST_INVALID_INPUT] The value '1' of the type "STRING" cannot be cast to
"TIMESTAMP" because it is malformed. Correct the value as per the syntax, or
change its target type. To return NULL instead, use `try_cast`. If necessary
set "spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
select str - interval '4 22:12' day to minute from interval_view
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
@@ -1579,7 +1579,7 @@ struct<>
-- !query output
org.apache.spark.SparkDateTimeException
[CAST_INVALID_INPUT] The value '1' of the type "STRING" cannot be cast to
"TIMESTAMP" because it is malformed. Correct the value as per the syntax, or
change its target type. To return NULL instead, use `try_cast`. If necessary
set "spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
select str + interval '4 22:12' day to minute from interval_view
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
@@ -2037,7 +2037,7 @@ struct<>
-- !query output
org.apache.spark.SparkArithmeticException
[ARITHMETIC_OVERFLOW] Overflow in integral divide. To return NULL instead, use
'try_divide'. If necessary set spark.sql.ansi.enabled to "false" (except for
ANSI interval type) to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
SELECT (INTERVAL '-178956970-8' YEAR TO MONTH) / -1
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
@@ -2049,7 +2049,7 @@ struct<>
-- !query output
org.apache.spark.SparkArithmeticException
[ARITHMETIC_OVERFLOW] Overflow in integral divide. To return NULL instead, use
'try_divide'. If necessary set spark.sql.ansi.enabled to "false" (except for
ANSI interval type) to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
SELECT (INTERVAL '-178956970-8' YEAR TO MONTH) / -1L
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
@@ -2095,7 +2095,7 @@ struct<>
-- !query output
org.apache.spark.SparkArithmeticException
[ARITHMETIC_OVERFLOW] Overflow in integral divide. To return NULL instead, use
'try_divide'. If necessary set spark.sql.ansi.enabled to "false" (except for
ANSI interval type) to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
SELECT (INTERVAL '-106751991 04:00:54.775808' DAY TO SECOND) / -1
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
@@ -2107,7 +2107,7 @@ struct<>
-- !query output
org.apache.spark.SparkArithmeticException
[ARITHMETIC_OVERFLOW] Overflow in integral divide. To return NULL instead, use
'try_divide'. If necessary set spark.sql.ansi.enabled to "false" (except for
ANSI interval type) to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
SELECT (INTERVAL '-106751991 04:00:54.775808' DAY TO SECOND) / -1L
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
diff --git a/sql/core/src/test/resources/sql-tests/results/ansi/map.sql.out
b/sql/core/src/test/resources/sql-tests/results/ansi/map.sql.out
index fec9c42f5dc..8a4d9978274 100644
--- a/sql/core/src/test/resources/sql-tests/results/ansi/map.sql.out
+++ b/sql/core/src/test/resources/sql-tests/results/ansi/map.sql.out
@@ -9,7 +9,7 @@ struct<>
-- !query output
org.apache.spark.SparkNoSuchElementException
[MAP_KEY_DOES_NOT_EXIST] Key 5 does not exist. To return NULL instead, use
`try_element_at`. If necessary set "spark.sql.ansi.enabled" to "false" to
bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
select element_at(map(1, 'a', 2, 'b'), 5)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
@@ -21,7 +21,7 @@ struct<>
-- !query output
org.apache.spark.SparkNoSuchElementException
[MAP_KEY_DOES_NOT_EXIST] Key 5 does not exist. To return NULL instead, use
`try_element_at`. If necessary set "spark.sql.ansi.enabled" to "false" to
bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
select map(1, 'a', 2, 'b')[5]
^^^^^^^^^^^^^^^^^^^^^^
@@ -115,7 +115,7 @@ struct<>
-- !query output
org.apache.spark.SparkNoSuchElementException
[MAP_KEY_DOES_NOT_EXIST] Key 5 does not exist. To return NULL instead, use
`try_element_at`. If necessary set "spark.sql.ansi.enabled" to "false" to
bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
select element_at(map(1, 'a', 2, 'b'), 5)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
@@ -127,6 +127,6 @@ struct<>
-- !query output
org.apache.spark.SparkNoSuchElementException
[MAP_KEY_DOES_NOT_EXIST] Key 'c' does not exist. To return NULL instead, use
`try_element_at`. If necessary set "spark.sql.ansi.enabled" to "false" to
bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
select element_at(map('a', 1, 'b', 2), 'c')
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
diff --git
a/sql/core/src/test/resources/sql-tests/results/ansi/string-functions.sql.out
b/sql/core/src/test/resources/sql-tests/results/ansi/string-functions.sql.out
index b4991a5b683..23dea32dc9d 100644
---
a/sql/core/src/test/resources/sql-tests/results/ansi/string-functions.sql.out
+++
b/sql/core/src/test/resources/sql-tests/results/ansi/string-functions.sql.out
@@ -83,7 +83,7 @@ struct<>
-- !query output
org.apache.spark.SparkNumberFormatException
[CAST_INVALID_INPUT] The value 'a' of the type "STRING" cannot be cast to
"INT" because it is malformed. Correct the value as per the syntax, or change
its target type. To return NULL instead, use `try_cast`. If necessary set
"spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 42) ==
+== SQL(line 1, position 43) ==
...t("abcd", -2), left("abcd", 0), left("abcd", 'a')
^^^^^^^^^^^^^^^^^
@@ -111,7 +111,7 @@ struct<>
-- !query output
org.apache.spark.SparkNumberFormatException
[CAST_INVALID_INPUT] The value 'a' of the type "STRING" cannot be cast to
"INT" because it is malformed. Correct the value as per the syntax, or change
its target type. To return NULL instead, use `try_cast`. If necessary set
"spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 44) ==
+== SQL(line 1, position 45) ==
...("abcd", -2), right("abcd", 0), right("abcd", 'a')
^^^^^^^^^^^^^^^^^^
@@ -420,7 +420,7 @@ struct<>
-- !query output
org.apache.spark.SparkNumberFormatException
[CAST_INVALID_INPUT] The value 'invalid_length' of the type "STRING" cannot be
cast to "INT" because it is malformed. Correct the value as per the syntax, or
change its target type. To return NULL instead, use `try_cast`. If necessary
set "spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
SELECT lpad('hi', 'invalid_length')
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
@@ -432,7 +432,7 @@ struct<>
-- !query output
org.apache.spark.SparkNumberFormatException
[CAST_INVALID_INPUT] The value 'invalid_length' of the type "STRING" cannot be
cast to "INT" because it is malformed. Correct the value as per the syntax, or
change its target type. To return NULL instead, use `try_cast`. If necessary
set "spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
SELECT rpad('hi', 'invalid_length')
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
diff --git a/sql/core/src/test/resources/sql-tests/results/interval.sql.out
b/sql/core/src/test/resources/sql-tests/results/interval.sql.out
index f095ea5360b..aa07876e1ca 100644
--- a/sql/core/src/test/resources/sql-tests/results/interval.sql.out
+++ b/sql/core/src/test/resources/sql-tests/results/interval.sql.out
@@ -205,7 +205,7 @@ struct<>
-- !query output
org.apache.spark.SparkArithmeticException
[DIVIDE_BY_ZERO] Division by zero. To return NULL instead, use `try_divide`.
If necessary set "spark.sql.ansi.enabled" to "false" (except for ANSI interval
type) to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
select interval '2 seconds' / 0
^^^^^^^^^^^^^^^^^^^^^^^^
@@ -241,7 +241,7 @@ struct<>
-- !query output
org.apache.spark.SparkArithmeticException
[DIVIDE_BY_ZERO] Division by zero. To return NULL instead, use `try_divide`.
If necessary set "spark.sql.ansi.enabled" to "false" (except for ANSI interval
type) to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
select interval '2' year / 0
^^^^^^^^^^^^^^^^^^^^^
@@ -1993,7 +1993,7 @@ struct<>
-- !query output
org.apache.spark.SparkArithmeticException
[ARITHMETIC_OVERFLOW] Overflow in integral divide. To return NULL instead, use
'try_divide'. If necessary set spark.sql.ansi.enabled to "false" (except for
ANSI interval type) to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
SELECT (INTERVAL '-178956970-8' YEAR TO MONTH) / -1
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
@@ -2005,7 +2005,7 @@ struct<>
-- !query output
org.apache.spark.SparkArithmeticException
[ARITHMETIC_OVERFLOW] Overflow in integral divide. To return NULL instead, use
'try_divide'. If necessary set spark.sql.ansi.enabled to "false" (except for
ANSI interval type) to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
SELECT (INTERVAL '-178956970-8' YEAR TO MONTH) / -1L
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
@@ -2051,7 +2051,7 @@ struct<>
-- !query output
org.apache.spark.SparkArithmeticException
[ARITHMETIC_OVERFLOW] Overflow in integral divide. To return NULL instead, use
'try_divide'. If necessary set spark.sql.ansi.enabled to "false" (except for
ANSI interval type) to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
SELECT (INTERVAL '-106751991 04:00:54.775808' DAY TO SECOND) / -1
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
@@ -2063,7 +2063,7 @@ struct<>
-- !query output
org.apache.spark.SparkArithmeticException
[ARITHMETIC_OVERFLOW] Overflow in integral divide. To return NULL instead, use
'try_divide'. If necessary set spark.sql.ansi.enabled to "false" (except for
ANSI interval type) to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
SELECT (INTERVAL '-106751991 04:00:54.775808' DAY TO SECOND) / -1L
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
diff --git
a/sql/core/src/test/resources/sql-tests/results/postgreSQL/boolean.sql.out
b/sql/core/src/test/resources/sql-tests/results/postgreSQL/boolean.sql.out
index 6f17a0cd760..6b8d31b917a 100644
--- a/sql/core/src/test/resources/sql-tests/results/postgreSQL/boolean.sql.out
+++ b/sql/core/src/test/resources/sql-tests/results/postgreSQL/boolean.sql.out
@@ -57,7 +57,7 @@ struct<>
-- !query output
org.apache.spark.SparkRuntimeException
[CAST_INVALID_INPUT] The value 'test' of the type "STRING" cannot be cast to
"BOOLEAN" because it is malformed. Correct the value as per the syntax, or
change its target type. To return NULL instead, use `try_cast`. If necessary
set "spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
SELECT boolean('test') AS error
^^^^^^^^^^^^^^^
@@ -77,7 +77,7 @@ struct<>
-- !query output
org.apache.spark.SparkRuntimeException
[CAST_INVALID_INPUT] The value 'foo' of the type "STRING" cannot be cast to
"BOOLEAN" because it is malformed. Correct the value as per the syntax, or
change its target type. To return NULL instead, use `try_cast`. If necessary
set "spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
SELECT boolean('foo') AS error
^^^^^^^^^^^^^^
@@ -105,7 +105,7 @@ struct<>
-- !query output
org.apache.spark.SparkRuntimeException
[CAST_INVALID_INPUT] The value 'yeah' of the type "STRING" cannot be cast to
"BOOLEAN" because it is malformed. Correct the value as per the syntax, or
change its target type. To return NULL instead, use `try_cast`. If necessary
set "spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
SELECT boolean('yeah') AS error
^^^^^^^^^^^^^^^
@@ -133,7 +133,7 @@ struct<>
-- !query output
org.apache.spark.SparkRuntimeException
[CAST_INVALID_INPUT] The value 'nay' of the type "STRING" cannot be cast to
"BOOLEAN" because it is malformed. Correct the value as per the syntax, or
change its target type. To return NULL instead, use `try_cast`. If necessary
set "spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
SELECT boolean('nay') AS error
^^^^^^^^^^^^^^
@@ -145,7 +145,7 @@ struct<>
-- !query output
org.apache.spark.SparkRuntimeException
[CAST_INVALID_INPUT] The value 'on' of the type "STRING" cannot be cast to
"BOOLEAN" because it is malformed. Correct the value as per the syntax, or
change its target type. To return NULL instead, use `try_cast`. If necessary
set "spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
SELECT boolean('on') AS true
^^^^^^^^^^^^^
@@ -157,7 +157,7 @@ struct<>
-- !query output
org.apache.spark.SparkRuntimeException
[CAST_INVALID_INPUT] The value 'off' of the type "STRING" cannot be cast to
"BOOLEAN" because it is malformed. Correct the value as per the syntax, or
change its target type. To return NULL instead, use `try_cast`. If necessary
set "spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
SELECT boolean('off') AS `false`
^^^^^^^^^^^^^^
@@ -169,7 +169,7 @@ struct<>
-- !query output
org.apache.spark.SparkRuntimeException
[CAST_INVALID_INPUT] The value 'of' of the type "STRING" cannot be cast to
"BOOLEAN" because it is malformed. Correct the value as per the syntax, or
change its target type. To return NULL instead, use `try_cast`. If necessary
set "spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
SELECT boolean('of') AS `false`
^^^^^^^^^^^^^
@@ -181,7 +181,7 @@ struct<>
-- !query output
org.apache.spark.SparkRuntimeException
[CAST_INVALID_INPUT] The value 'o' of the type "STRING" cannot be cast to
"BOOLEAN" because it is malformed. Correct the value as per the syntax, or
change its target type. To return NULL instead, use `try_cast`. If necessary
set "spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
SELECT boolean('o') AS error
^^^^^^^^^^^^
@@ -193,7 +193,7 @@ struct<>
-- !query output
org.apache.spark.SparkRuntimeException
[CAST_INVALID_INPUT] The value 'on_' of the type "STRING" cannot be cast to
"BOOLEAN" because it is malformed. Correct the value as per the syntax, or
change its target type. To return NULL instead, use `try_cast`. If necessary
set "spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
SELECT boolean('on_') AS error
^^^^^^^^^^^^^^
@@ -205,7 +205,7 @@ struct<>
-- !query output
org.apache.spark.SparkRuntimeException
[CAST_INVALID_INPUT] The value 'off_' of the type "STRING" cannot be cast to
"BOOLEAN" because it is malformed. Correct the value as per the syntax, or
change its target type. To return NULL instead, use `try_cast`. If necessary
set "spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
SELECT boolean('off_') AS error
^^^^^^^^^^^^^^^
@@ -225,7 +225,7 @@ struct<>
-- !query output
org.apache.spark.SparkRuntimeException
[CAST_INVALID_INPUT] The value '11' of the type "STRING" cannot be cast to
"BOOLEAN" because it is malformed. Correct the value as per the syntax, or
change its target type. To return NULL instead, use `try_cast`. If necessary
set "spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
SELECT boolean('11') AS error
^^^^^^^^^^^^^
@@ -245,7 +245,7 @@ struct<>
-- !query output
org.apache.spark.SparkRuntimeException
[CAST_INVALID_INPUT] The value '000' of the type "STRING" cannot be cast to
"BOOLEAN" because it is malformed. Correct the value as per the syntax, or
change its target type. To return NULL instead, use `try_cast`. If necessary
set "spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
SELECT boolean('000') AS error
^^^^^^^^^^^^^^
@@ -257,7 +257,7 @@ struct<>
-- !query output
org.apache.spark.SparkRuntimeException
[CAST_INVALID_INPUT] The value '' of the type "STRING" cannot be cast to
"BOOLEAN" because it is malformed. Correct the value as per the syntax, or
change its target type. To return NULL instead, use `try_cast`. If necessary
set "spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
SELECT boolean('') AS error
^^^^^^^^^^^
@@ -366,7 +366,7 @@ struct<>
-- !query output
org.apache.spark.SparkRuntimeException
[CAST_INVALID_INPUT] The value ' tru e ' of the type "STRING" cannot be cast
to "BOOLEAN" because it is malformed. Correct the value as per the syntax, or
change its target type. To return NULL instead, use `try_cast`. If necessary
set "spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
SELECT boolean(string(' tru e ')) AS invalid
^^^^^^^^^^^^^^^^^^^^^^^^^^^
@@ -378,7 +378,7 @@ struct<>
-- !query output
org.apache.spark.SparkRuntimeException
[CAST_INVALID_INPUT] The value '' of the type "STRING" cannot be cast to
"BOOLEAN" because it is malformed. Correct the value as per the syntax, or
change its target type. To return NULL instead, use `try_cast`. If necessary
set "spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
SELECT boolean(string('')) AS invalid
^^^^^^^^^^^^^^^^^^^
@@ -525,7 +525,7 @@ struct<>
-- !query output
org.apache.spark.sql.AnalysisException
failed to evaluate expression CAST('XXX' AS BOOLEAN): [CAST_INVALID_INPUT] The
value 'XXX' of the type "STRING" cannot be cast to "BOOLEAN" because it is
malformed. Correct the value as per the syntax, or change its target type. To
return NULL instead, use `try_cast`. If necessary set "spark.sql.ansi.enabled"
to "false" to bypass this error.
-== SQL(line 2, position 11) ==
+== SQL(line 2, position 12) ==
VALUES (boolean('XXX'))
^^^^^^^^^^^^^^
; line 2 pos 3
diff --git
a/sql/core/src/test/resources/sql-tests/results/postgreSQL/float4.sql.out
b/sql/core/src/test/resources/sql-tests/results/postgreSQL/float4.sql.out
index d172e2ace04..58d5e9b86bb 100644
--- a/sql/core/src/test/resources/sql-tests/results/postgreSQL/float4.sql.out
+++ b/sql/core/src/test/resources/sql-tests/results/postgreSQL/float4.sql.out
@@ -97,7 +97,7 @@ struct<>
-- !query output
org.apache.spark.SparkNumberFormatException
[CAST_INVALID_INPUT] The value 'N A N' of the type "STRING" cannot be cast to
"FLOAT" because it is malformed. Correct the value as per the syntax, or change
its target type. To return NULL instead, use `try_cast`. If necessary set
"spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
SELECT float('N A N')
^^^^^^^^^^^^^^
@@ -109,7 +109,7 @@ struct<>
-- !query output
org.apache.spark.SparkNumberFormatException
[CAST_INVALID_INPUT] The value 'NaN x' of the type "STRING" cannot be cast to
"FLOAT" because it is malformed. Correct the value as per the syntax, or change
its target type. To return NULL instead, use `try_cast`. If necessary set
"spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
SELECT float('NaN x')
^^^^^^^^^^^^^^
@@ -121,7 +121,7 @@ struct<>
-- !query output
org.apache.spark.SparkNumberFormatException
[CAST_INVALID_INPUT] The value ' INFINITY x' of the type "STRING" cannot be
cast to "FLOAT" because it is malformed. Correct the value as per the syntax,
or change its target type. To return NULL instead, use `try_cast`. If necessary
set "spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
SELECT float(' INFINITY x')
^^^^^^^^^^^^^^^^^^^^^^^
@@ -157,7 +157,7 @@ struct<>
-- !query output
org.apache.spark.SparkNumberFormatException
[CAST_INVALID_INPUT] The value 'nan' of the type "STRING" cannot be cast to
"DECIMAL(10,0)" because it is malformed. Correct the value as per the syntax,
or change its target type. To return NULL instead, use `try_cast`. If necessary
set "spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 13) ==
+== SQL(line 1, position 14) ==
SELECT float(decimal('nan'))
^^^^^^^^^^^^^^
diff --git
a/sql/core/src/test/resources/sql-tests/results/postgreSQL/float8.sql.out
b/sql/core/src/test/resources/sql-tests/results/postgreSQL/float8.sql.out
index 8259856ed7e..4df6d37ef2a 100644
--- a/sql/core/src/test/resources/sql-tests/results/postgreSQL/float8.sql.out
+++ b/sql/core/src/test/resources/sql-tests/results/postgreSQL/float8.sql.out
@@ -129,7 +129,7 @@ struct<>
-- !query output
org.apache.spark.SparkNumberFormatException
[CAST_INVALID_INPUT] The value 'N A N' of the type "STRING" cannot be cast to
"DOUBLE" because it is malformed. Correct the value as per the syntax, or
change its target type. To return NULL instead, use `try_cast`. If necessary
set "spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
SELECT double('N A N')
^^^^^^^^^^^^^^^
@@ -141,7 +141,7 @@ struct<>
-- !query output
org.apache.spark.SparkNumberFormatException
[CAST_INVALID_INPUT] The value 'NaN x' of the type "STRING" cannot be cast to
"DOUBLE" because it is malformed. Correct the value as per the syntax, or
change its target type. To return NULL instead, use `try_cast`. If necessary
set "spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
SELECT double('NaN x')
^^^^^^^^^^^^^^^
@@ -153,7 +153,7 @@ struct<>
-- !query output
org.apache.spark.SparkNumberFormatException
[CAST_INVALID_INPUT] The value ' INFINITY x' of the type "STRING" cannot be
cast to "DOUBLE" because it is malformed. Correct the value as per the syntax,
or change its target type. To return NULL instead, use `try_cast`. If necessary
set "spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
SELECT double(' INFINITY x')
^^^^^^^^^^^^^^^^^^^^^^^^
@@ -189,7 +189,7 @@ struct<>
-- !query output
org.apache.spark.SparkNumberFormatException
[CAST_INVALID_INPUT] The value 'nan' of the type "STRING" cannot be cast to
"DECIMAL(10,0)" because it is malformed. Correct the value as per the syntax,
or change its target type. To return NULL instead, use `try_cast`. If necessary
set "spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 14) ==
+== SQL(line 1, position 15) ==
SELECT double(decimal('nan'))
^^^^^^^^^^^^^^
diff --git
a/sql/core/src/test/resources/sql-tests/results/postgreSQL/int4.sql.out
b/sql/core/src/test/resources/sql-tests/results/postgreSQL/int4.sql.out
index 7e9fe0357c5..f84feac720e 100755
--- a/sql/core/src/test/resources/sql-tests/results/postgreSQL/int4.sql.out
+++ b/sql/core/src/test/resources/sql-tests/results/postgreSQL/int4.sql.out
@@ -201,7 +201,7 @@ struct<>
-- !query output
org.apache.spark.SparkArithmeticException
[ARITHMETIC_OVERFLOW] integer overflow. To return NULL instead, use
'try_multiply'. If necessary set spark.sql.ansi.enabled to "false" (except for
ANSI interval type) to bypass this error.
-== SQL(line 1, position 25) ==
+== SQL(line 1, position 26) ==
SELECT '' AS five, i.f1, i.f1 * smallint('2') AS x FROM INT4_TBL i
^^^^^^^^^^^^^^^^^^^^
@@ -224,7 +224,7 @@ struct<>
-- !query output
org.apache.spark.SparkArithmeticException
[ARITHMETIC_OVERFLOW] integer overflow. To return NULL instead, use
'try_multiply'. If necessary set spark.sql.ansi.enabled to "false" (except for
ANSI interval type) to bypass this error.
-== SQL(line 1, position 25) ==
+== SQL(line 1, position 26) ==
SELECT '' AS five, i.f1, i.f1 * int('2') AS x FROM INT4_TBL i
^^^^^^^^^^^^^^^
@@ -247,7 +247,7 @@ struct<>
-- !query output
org.apache.spark.SparkArithmeticException
[ARITHMETIC_OVERFLOW] integer overflow. To return NULL instead, use 'try_add'.
If necessary set spark.sql.ansi.enabled to "false" (except for ANSI interval
type) to bypass this error.
-== SQL(line 1, position 25) ==
+== SQL(line 1, position 26) ==
SELECT '' AS five, i.f1, i.f1 + smallint('2') AS x FROM INT4_TBL i
^^^^^^^^^^^^^^^^^^^^
@@ -271,7 +271,7 @@ struct<>
-- !query output
org.apache.spark.SparkArithmeticException
[ARITHMETIC_OVERFLOW] integer overflow. To return NULL instead, use 'try_add'.
If necessary set spark.sql.ansi.enabled to "false" (except for ANSI interval
type) to bypass this error.
-== SQL(line 1, position 25) ==
+== SQL(line 1, position 26) ==
SELECT '' AS five, i.f1, i.f1 + int('2') AS x FROM INT4_TBL i
^^^^^^^^^^^^^^^
@@ -295,7 +295,7 @@ struct<>
-- !query output
org.apache.spark.SparkArithmeticException
[ARITHMETIC_OVERFLOW] integer overflow. To return NULL instead, use
'try_subtract'. If necessary set spark.sql.ansi.enabled to "false" (except for
ANSI interval type) to bypass this error.
-== SQL(line 1, position 25) ==
+== SQL(line 1, position 26) ==
SELECT '' AS five, i.f1, i.f1 - smallint('2') AS x FROM INT4_TBL i
^^^^^^^^^^^^^^^^^^^^
@@ -319,7 +319,7 @@ struct<>
-- !query output
org.apache.spark.SparkArithmeticException
[ARITHMETIC_OVERFLOW] integer overflow. To return NULL instead, use
'try_subtract'. If necessary set spark.sql.ansi.enabled to "false" (except for
ANSI interval type) to bypass this error.
-== SQL(line 1, position 25) ==
+== SQL(line 1, position 26) ==
SELECT '' AS five, i.f1, i.f1 - int('2') AS x FROM INT4_TBL i
^^^^^^^^^^^^^^^
diff --git
a/sql/core/src/test/resources/sql-tests/results/postgreSQL/int8.sql.out
b/sql/core/src/test/resources/sql-tests/results/postgreSQL/int8.sql.out
index 93614221ff8..2d68cbb4481 100755
--- a/sql/core/src/test/resources/sql-tests/results/postgreSQL/int8.sql.out
+++ b/sql/core/src/test/resources/sql-tests/results/postgreSQL/int8.sql.out
@@ -393,7 +393,7 @@ struct<>
-- !query output
org.apache.spark.SparkArithmeticException
[ARITHMETIC_OVERFLOW] long overflow. To return NULL instead, use
'try_multiply'. If necessary set spark.sql.ansi.enabled to "false" (except for
ANSI interval type) to bypass this error.
-== SQL(line 1, position 28) ==
+== SQL(line 1, position 29) ==
SELECT '' AS three, q1, q2, q1 * q2 AS multiply FROM INT8_TBL
^^^^^^^
@@ -651,7 +651,7 @@ struct<>
-- !query output
org.apache.spark.SparkArithmeticException
[DIVIDE_BY_ZERO] Division by zero. To return NULL instead, use `try_divide`.
If necessary set "spark.sql.ansi.enabled" to "false" (except for ANSI interval
type) to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
select bigint('9223372036854775800') / bigint('0')
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
@@ -663,7 +663,7 @@ struct<>
-- !query output
org.apache.spark.SparkArithmeticException
[DIVIDE_BY_ZERO] Division by zero. To return NULL instead, use `try_divide`.
If necessary set "spark.sql.ansi.enabled" to "false" (except for ANSI interval
type) to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
select bigint('-9223372036854775808') / smallint('0')
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
@@ -675,7 +675,7 @@ struct<>
-- !query output
org.apache.spark.SparkArithmeticException
[DIVIDE_BY_ZERO] Division by zero. To return NULL instead, use `try_divide`.
If necessary set "spark.sql.ansi.enabled" to "false" (except for ANSI interval
type) to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
select smallint('100') / bigint('0')
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
@@ -830,7 +830,7 @@ struct<>
-- !query output
org.apache.spark.SparkArithmeticException
[ARITHMETIC_OVERFLOW] long overflow. To return NULL instead, use
'try_multiply'. If necessary set spark.sql.ansi.enabled to "false" (except for
ANSI interval type) to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
SELECT bigint((-9223372036854775808)) * bigint((-1))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
@@ -858,7 +858,7 @@ struct<>
-- !query output
org.apache.spark.SparkArithmeticException
[ARITHMETIC_OVERFLOW] long overflow. To return NULL instead, use
'try_multiply'. If necessary set spark.sql.ansi.enabled to "false" (except for
ANSI interval type) to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
SELECT bigint((-9223372036854775808)) * int((-1))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
@@ -886,7 +886,7 @@ struct<>
-- !query output
org.apache.spark.SparkArithmeticException
[ARITHMETIC_OVERFLOW] long overflow. To return NULL instead, use
'try_multiply'. If necessary set spark.sql.ansi.enabled to "false" (except for
ANSI interval type) to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
SELECT bigint((-9223372036854775808)) * smallint((-1))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
diff --git
a/sql/core/src/test/resources/sql-tests/results/postgreSQL/select_having.sql.out
b/sql/core/src/test/resources/sql-tests/results/postgreSQL/select_having.sql.out
index c7e7cd361fb..0bbd00c2d3b 100644
---
a/sql/core/src/test/resources/sql-tests/results/postgreSQL/select_having.sql.out
+++
b/sql/core/src/test/resources/sql-tests/results/postgreSQL/select_having.sql.out
@@ -178,7 +178,7 @@ struct<>
-- !query output
org.apache.spark.SparkArithmeticException
[DIVIDE_BY_ZERO] Division by zero. To return NULL instead, use `try_divide`.
If necessary set "spark.sql.ansi.enabled" to "false" (except for ANSI interval
type) to bypass this error.
-== SQL(line 1, position 39) ==
+== SQL(line 1, position 40) ==
...1 AS one FROM test_having WHERE 1/a = 1 HAVING 1 < 2
^^^
diff --git
a/sql/core/src/test/resources/sql-tests/results/postgreSQL/text.sql.out
b/sql/core/src/test/resources/sql-tests/results/postgreSQL/text.sql.out
index 50c714b7f36..17aece8592a 100755
--- a/sql/core/src/test/resources/sql-tests/results/postgreSQL/text.sql.out
+++ b/sql/core/src/test/resources/sql-tests/results/postgreSQL/text.sql.out
@@ -66,7 +66,7 @@ struct<>
-- !query output
org.apache.spark.SparkNumberFormatException
[CAST_INVALID_INPUT] The value 'four: 2' of the type "STRING" cannot be cast
to "BIGINT" because it is malformed. Correct the value as per the syntax, or
change its target type. To return NULL instead, use `try_cast`. If necessary
set "spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
select string('four: ') || 2+2
^^^^^^^^^^^^^^^^^^^^^^^
@@ -78,7 +78,7 @@ struct<>
-- !query output
org.apache.spark.SparkNumberFormatException
[CAST_INVALID_INPUT] The value 'four: 2' of the type "STRING" cannot be cast
to "BIGINT" because it is malformed. Correct the value as per the syntax, or
change its target type. To return NULL instead, use `try_cast`. If necessary
set "spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 1, position 7) ==
+== SQL(line 1, position 8) ==
select 'four: ' || 2+2
^^^^^^^^^^^^^^^
diff --git
a/sql/core/src/test/resources/sql-tests/results/postgreSQL/window_part2.sql.out
b/sql/core/src/test/resources/sql-tests/results/postgreSQL/window_part2.sql.out
index 9aeab7f957b..ff5bf1c2e21 100644
---
a/sql/core/src/test/resources/sql-tests/results/postgreSQL/window_part2.sql.out
+++
b/sql/core/src/test/resources/sql-tests/results/postgreSQL/window_part2.sql.out
@@ -463,7 +463,7 @@ struct<>
-- !query output
org.apache.spark.SparkNumberFormatException
[CAST_INVALID_INPUT] The value 'NaN' of the type "STRING" cannot be cast to
"INT" because it is malformed. Correct the value as per the syntax, or change
its target type. To return NULL instead, use `try_cast`. If necessary set
"spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 3, position 12) ==
+== SQL(line 3, position 13) ==
window w as (order by f_numeric range between
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
1.1 preceding and 'NaN' following)
diff --git
a/sql/core/src/test/resources/sql-tests/results/postgreSQL/window_part3.sql.out
b/sql/core/src/test/resources/sql-tests/results/postgreSQL/window_part3.sql.out
index cad5e7d77dd..4b75b81fe85 100644
---
a/sql/core/src/test/resources/sql-tests/results/postgreSQL/window_part3.sql.out
+++
b/sql/core/src/test/resources/sql-tests/results/postgreSQL/window_part3.sql.out
@@ -73,7 +73,7 @@ struct<>
-- !query output
org.apache.spark.sql.AnalysisException
failed to evaluate expression CAST('11:00 BST' AS TIMESTAMP):
[CAST_INVALID_INPUT] The value '11:00 BST' of the type "STRING" cannot be cast
to "TIMESTAMP" because it is malformed. Correct the value as per the syntax, or
change its target type. To return NULL instead, use `try_cast`. If necessary
set "spark.sql.ansi.enabled" to "false" to bypass this error.
-== SQL(line 2, position 23) ==
+== SQL(line 2, position 24) ==
(1, timestamp '11:00', cast ('11:00 BST' as timestamp), cast ('1 year' as
timestamp), ...
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
; line 1 pos 22
diff --git
a/sql/core/src/test/resources/sql-tests/results/postgreSQL/window_part4.sql.out
b/sql/core/src/test/resources/sql-tests/results/postgreSQL/window_part4.sql.out
index 5020e328a7e..5113200a058 100644
---
a/sql/core/src/test/resources/sql-tests/results/postgreSQL/window_part4.sql.out
+++
b/sql/core/src/test/resources/sql-tests/results/postgreSQL/window_part4.sql.out
@@ -502,7 +502,7 @@ struct<>
-- !query output
org.apache.spark.sql.AnalysisException
failed to evaluate expression CAST('nan' AS INT): [CAST_INVALID_INPUT] The
value 'nan' of the type "STRING" cannot be cast to "INT" because it is
malformed. Correct the value as per the syntax, or change its target type. To
return NULL instead, use `try_cast`. If necessary set "spark.sql.ansi.enabled"
to "false" to bypass this error.
-== SQL(line 3, position 28) ==
+== SQL(line 3, position 29) ==
FROM (VALUES(1,1),(2,2),(3,(cast('nan' as int))),(4,3),(5,4)) t(a,b)
^^^^^^^^^^^^^^^^^^
; line 3 pos 6
diff --git
a/sql/core/src/test/resources/sql-tests/results/udf/postgreSQL/udf-select_having.sql.out
b/sql/core/src/test/resources/sql-tests/results/udf/postgreSQL/udf-select_having.sql.out
index 4631979adf8..59be18dad7f 100644
---
a/sql/core/src/test/resources/sql-tests/results/udf/postgreSQL/udf-select_having.sql.out
+++
b/sql/core/src/test/resources/sql-tests/results/udf/postgreSQL/udf-select_having.sql.out
@@ -178,7 +178,7 @@ struct<>
-- !query output
org.apache.spark.SparkArithmeticException
[DIVIDE_BY_ZERO] Division by zero. To return NULL instead, use `try_divide`.
If necessary set "spark.sql.ansi.enabled" to "false" (except for ANSI interval
type) to bypass this error.
-== SQL(line 1, position 39) ==
+== SQL(line 1, position 40) ==
...1 AS one FROM test_having WHERE 1/udf(a) = 1 HAVING 1 < 2
^^^^^^^^
diff --git
a/sql/core/src/test/scala/org/apache/spark/sql/errors/QueryExecutionAnsiErrorsSuite.scala
b/sql/core/src/test/scala/org/apache/spark/sql/errors/QueryExecutionAnsiErrorsSuite.scala
index 1a39ecc190e..e7e3c0df814 100644
---
a/sql/core/src/test/scala/org/apache/spark/sql/errors/QueryExecutionAnsiErrorsSuite.scala
+++
b/sql/core/src/test/scala/org/apache/spark/sql/errors/QueryExecutionAnsiErrorsSuite.scala
@@ -49,7 +49,7 @@ class QueryExecutionAnsiErrorsSuite extends QueryTest with
QueryErrorsSuiteBase
"Division by zero. To return NULL instead, use `try_divide`. If
necessary set " +
s"""$ansiConf to "false" (except for ANSI interval type) to bypass
this error.""" +
"""
- |== SQL(line 1, position 7) ==
+ |== SQL(line 1, position 8) ==
|select 6/0
| ^^^
|""".stripMargin,
@@ -77,7 +77,7 @@ class QueryExecutionAnsiErrorsSuite extends QueryTest with
QueryErrorsSuiteBase
"Decimal(expanded, 66666666666666.666, 17, 3) cannot be represented as
Decimal(8, 1). " +
s"""If necessary set $ansiConf to "false" to bypass this error.""" +
"""
- |== SQL(line 1, position 7) ==
+ |== SQL(line 1, position 8) ==
|select CAST('66666666666666.666' AS DECIMAL(8, 1))
| ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
|""".stripMargin,
@@ -117,7 +117,7 @@ class QueryExecutionAnsiErrorsSuite extends QueryTest with
QueryErrorsSuiteBase
msg = "Key 3 does not exist. To return NULL instead, use
`try_element_at`. " +
s"""If necessary set $ansiConf to "false" to bypass this error.""" +
"""
- |== SQL(line 1, position 7) ==
+ |== SQL(line 1, position 8) ==
|select element_at(map(1, 'a', 2, 'b'), 3)
| ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
|""".stripMargin
@@ -134,7 +134,7 @@ class QueryExecutionAnsiErrorsSuite extends QueryTest with
QueryErrorsSuiteBase
"because it is malformed. Correct the value as per the syntax, " +
"or change its target type. To return NULL instead, use `try_cast`. If
necessary set " +
s"""$ansiConf to \"false\" to bypass this error.
- |== SQL(line 1, position 7) ==
+ |== SQL(line 1, position 8) ==
|select CAST('111111111111xe23' AS DOUBLE)
| ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
|""".stripMargin)
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@spark.apache.org
For additional commands, e-mail: commits-h...@spark.apache.org
