commit 31d66e797d3ca66d154262b15ee35876804df963
author caicancai <2356672992@qq.com> Sun Feb 18 23:28:52 2024 +0800
committer Jiajun <jiajunbernoulli@foxmail.com> Tue Feb 20 10:00:01 2024 +0800
tree 47af8a07e92e6a46c43fd7f79227b6ba9a3c405a
parent a19a954738e3405f621843a9df71e51002e1609b

[CALCITE-6273] Add sqrt negative test in SqlOperatorTest

testkit/src/main/java/org/apache/calcite/test/SqlOperatorTest.java

diff --git a/testkit/src/main/java/org/apache/calcite/test/SqlOperatorTest.java b/testkit/src/main/java/org/apache/calcite/test/SqlOperatorTest.java
index 2ff72a1..12052c9 100644
--- a/testkit/src/main/java/org/apache/calcite/test/SqlOperatorTest.java
+++ b/testkit/src/main/java/org/apache/calcite/test/SqlOperatorTest.java
@@ -6110,6 +6110,18 @@
         isWithin(1.4142d, 0.0001d));
     f.checkScalarApprox("sqrt(cast(2 as decimal(2, 0)))", "DOUBLE NOT NULL",
         isWithin(1.4142d, 0.0001d));
+    f.checkScalarApprox("sqrt(0)", "DOUBLE NOT NULL",
+        isWithin(0, 0.0001d));
+    f.checkScalarApprox("sqrt(0.1)", "DOUBLE NOT NULL",
+        isWithin(0.31622776601683794, 0.0001d));
+    f.checkScalarApprox("sqrt(2.0/3)", "DOUBLE NOT NULL",
+        isWithin(0.816496580927726, 0.0001d));
+    f.checkScalarApprox("sqrt(cast(10e8 as integer))", "DOUBLE NOT NULL",
+        isWithin(31622.776601683792, 0.0001d));
+    f.checkScalarApprox("sqrt(cast(10e8 as double))", "DOUBLE NOT NULL",
+        isWithin(31622.776601683792, 0.0001d));
+    f.checkScalarApprox("sqrt(-1)", "DOUBLE NOT NULL",
+        "NaN");
     f.checkNull("sqrt(cast(null as integer))");
     f.checkNull("sqrt(cast(null as double))");
   }