cjj2010 commented on code in PR #4774:
URL: https://github.com/apache/calcite/pull/4774#discussion_r2744410656


##########
mongodb/src/test/java/org/apache/calcite/adapter/mongodb/MongoAdapterTest.java:
##########
@@ -1001,4 +1001,18 @@ private static Consumer<List> mongoChecker(final 
String... expected) {
                 "{$sort: {CITY: 1}}"))
         .returnsOrdered("");
   }
+
+  /** Test case for
+   * <a 
href="https://issues.apache.org/jira/browse/CALCITE-7404";>[CALCITE-7404]
+   * Incorrect Field Alias in MongoDB project Stage</a>. */
+  @Test void testAggFunctionMinFilter() {
+    assertModel(MODEL)
+        .query("select min(pop>5000) as pop_result from zips")

Review Comment:
   > is case meet expectations?
   
   Errors will occur during the syntax parsing phase of SQL,
   but: was "java.sql.SQLException: Error while executing SQL "select (pop as 
pop_a) as pop_result from zips": parse failed: Encountered "as" at line 1, 
column 13.
   Was expecting one of:
   "EXCEPT" ...
   "FETCH" ...



-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to