This is an automated email from the ASF dual-hosted git repository.

jackie pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/pinot.git


The following commit(s) were added to refs/heads/master by this push:
     new 5bee13a68a sql between function should be inclusive (#11467)
5bee13a68a is described below

commit 5bee13a68a15cea0acf445dd4f04ae0fd33b9734
Author: Haitao Zhang <[email protected]>
AuthorDate: Wed Aug 30 22:56:17 2023 -0700

    sql between function should be inclusive (#11467)
---
 .../org/apache/pinot/common/function/scalar/ComparisonFunctions.java    | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git 
a/pinot-common/src/main/java/org/apache/pinot/common/function/scalar/ComparisonFunctions.java
 
b/pinot-common/src/main/java/org/apache/pinot/common/function/scalar/ComparisonFunctions.java
index c94d8c3fdb..e12cb7d8de 100644
--- 
a/pinot-common/src/main/java/org/apache/pinot/common/function/scalar/ComparisonFunctions.java
+++ 
b/pinot-common/src/main/java/org/apache/pinot/common/function/scalar/ComparisonFunctions.java
@@ -61,6 +61,6 @@ public class ComparisonFunctions {
 
   @ScalarFunction
   public static boolean between(double val, double a, double b) {
-    return val > a && val < b;
+    return val >= a && val <= b;
   }
 }


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to