This is an automated email from the ASF dual-hosted git repository.
agrove pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/datafusion-comet.git
The following commit(s) were added to refs/heads/main by this push:
new 012d5b46c test: add SQL file test for casting double to string (#3854)
012d5b46c is described below
commit 012d5b46cced8cc1abb0e06fada7adbe96c8f639
Author: Andy Grove <[email protected]>
AuthorDate: Wed Apr 1 04:25:10 2026 -0600
test: add SQL file test for casting double to string (#3854)
Add test coverage for casting double to string values including
negative zero, positive zero, NaN, Infinity, -Infinity, NULL,
scientific notation, and regular decimal values.
---
.../expressions/cast/cast_double_to_string.sql | 44 ++++++++++++++++++++++
1 file changed, 44 insertions(+)
diff --git
a/spark/src/test/resources/sql-tests/expressions/cast/cast_double_to_string.sql
b/spark/src/test/resources/sql-tests/expressions/cast/cast_double_to_string.sql
new file mode 100644
index 000000000..876bfd0b5
--- /dev/null
+++
b/spark/src/test/resources/sql-tests/expressions/cast/cast_double_to_string.sql
@@ -0,0 +1,44 @@
+-- Licensed to the Apache Software Foundation (ASF) under one
+-- or more contributor license agreements. See the NOTICE file
+-- distributed with this work for additional information
+-- regarding copyright ownership. The ASF licenses this file
+-- to you under the Apache License, Version 2.0 (the
+-- "License"); you may not use this file except in compliance
+-- with the License. You may obtain a copy of the License at
+--
+-- http://www.apache.org/licenses/LICENSE-2.0
+--
+-- Unless required by applicable law or agreed to in writing,
+-- software distributed under the License is distributed on an
+-- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+-- KIND, either express or implied. See the License for the
+-- specific language governing permissions and limitations
+-- under the License.
+
+-- ConfigMatrix: parquet.enable.dictionary=false,true
+
+statement
+CREATE TABLE test_double_to_string(d double, id int) USING parquet
+
+statement
+INSERT INTO test_double_to_string VALUES
+ (-0.0, 1),
+ (0.0, 2),
+ (1.5, 3),
+ (-1.5, 4),
+ (cast('NaN' as double), 5),
+ (cast('Infinity' as double), 6),
+ (cast('-Infinity' as double), 7),
+ (NULL, 8),
+ (1.0E20, 9),
+ (1.0E-20, 10),
+ (-1.0E20, 11),
+ (0.001, 12),
+ (123456789.0, 13),
+ (1.23456789E10, 14)
+
+query
+SELECT cast(d as string), id FROM test_double_to_string ORDER BY id
+
+query
+SELECT cast(-0.0 as string), cast(0.0 as string)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
