[pinot] branch master updated: adding inequality join condition test and specifically exclude unsupported syntax (#10242)

[siddteotia]

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

siddteotia 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 5e0a8dbaa1 adding inequality join condition test and specifically 
exclude unsupported syntax (#10242)
5e0a8dbaa1 is described below

commit 5e0a8dbaa11986079c8801b9f423fc49b5681205
Author: Rong Rong <ro...@apache.org>
AuthorDate: Tue Feb 7 18:20:25 2023 -0800

    adding inequality join condition test and specifically exclude unsupported 
syntax (#10242)
    
    Co-authored-by: Rong Rong <ro...@startree.ai>
---
 .../src/test/resources/queries/TableExpressions.json     | 16 ++++++++++++++++
 1 file changed, 16 insertions(+)

diff --git 
a/pinot-query-runtime/src/test/resources/queries/TableExpressions.json 
b/pinot-query-runtime/src/test/resources/queries/TableExpressions.json
index 765cd687e0..d5e8085bad 100644
--- a/pinot-query-runtime/src/test/resources/queries/TableExpressions.json
+++ b/pinot-query-runtime/src/test/resources/queries/TableExpressions.json
@@ -101,6 +101,12 @@
       { "sql": "SELECT strCol FROM {tbl1} GROUP BY strCol, intCol" },
       { "sql": "SELECT strCol, intCol FROM {tbl1} GROUP BY strCol, intCol" },
       { "sql": "SELECT strCol, SUM(intCol) FROM {tbl1} GROUP BY strCol" },
+      { "sql": "SELECT b.intCol, a.intCol FROM {tbl1} a INNER JOIN {tbl2} b ON 
a.strCol > b.strCol1" },
+      { "sql": "SELECT b.intCol, a.intCol FROM {tbl1} a INNER JOIN {tbl2} b ON 
a.intCol = b.intCol WHERE a.strCol > b.strCol1" },
+      { "sql": "SELECT b.intCol, a.intCol FROM {tbl1} a INNER JOIN {tbl2} b ON 
a.intCol = b.intCol AND a.strCol > b.strCol1" },
+      { "sql": "SELECT b.intCol, a.intCol FROM {tbl1} a INNER JOIN {tbl2} b ON 
a.strCol BETWEEN b.strCol1 AND b.strCol2" },
+      { "sql": "SELECT b.intCol, a.intCol FROM {tbl1} a INNER JOIN {tbl2} b ON 
a.intCol = b.intCol WHERE a.strCol BETWEEN b.strCol1 AND b.strCol2" },
+      { "sql": "SELECT b.intCol, a.intCol FROM {tbl1} a INNER JOIN {tbl2} b ON 
a.intCol = b.intCol AND a.strCol BETWEEN b.strCol1 AND b.strCol2" },
       { "sql": "SELECT strCol, b.strCol2, (sum(a.intCol) * b.intCol) AS 
colAlias FROM {tbl1} a INNER JOIN {tbl2} b ON a.strCol = b.strCol1 GROUP BY 
strCol, b.strCol2, b.intCol" },
       { "sql": "SELECT MOD(b.intCol, 2), sum(a.intCol) AS colAlias FROM {tbl1} 
a INNER JOIN {tbl2} b ON a.strCol = b.strCol1 GROUP BY MOD(b.intCol, 2)" },
       { "sql": "SELECT strCol, SUM(intCol) FROM {tbl1} GROUP BY strCol HAVING 
SUM(intCol) > 3" },
@@ -115,6 +121,16 @@
         "ignored": true,
         "comment": "correlation is not supported. SOME is only supported if 
expand = false",
         "sql": "SELECT strCol, SUM(intCol) FROM {tbl1} GROUP BY strCol HAVING 
AVG(intCol) >= ANY (SELECT AVG(intCol) FROM {tbl1} GROUP BY strCol)"
+      },
+      {
+        "ignored": true,
+        "comments": "where clause inequality join condition is not supported",
+        "sql": "SELECT b.intCol, a.intCol FROM {tbl1} a INNER JOIN {tbl2} b 
WHERE a.intCol > b.intCol"
+      },
+      {
+        "ignored": true,
+        "comments": "where clause inequality join condition is not supported 
yet",
+        "sql": "SELECT b.intCol, a.intCol FROM {tbl1} a INNER JOIN {tbl2} b 
WHERE a.strCol BETWEEN b.strCol1 AND b.strCol2"
       }
     ]
   }


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org
For additional commands, e-mail: commits-h...@pinot.apache.org