[BUG] CalcitePPLAggregationTest in windows failed

```
CalcitePPLAggregationTest > testSimpleCount FAILED
    java.lang.AssertionError: 
    Expected: is "SELECT COUNT(*) `c`\nFROM `scott`.`EMP`"
         but: was "SELECT COUNT(*) `c`\r\nFROM `scott`.`EMP`"
        at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18)
        at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6)
        at org.opensearch.sql.ppl.calcite.CalcitePPLAbstractTest.verifyPPLToSparkSQL(CalcitePPLAbstractTest.java:126)
        at org.opensearch.sql.ppl.calcite.CalcitePPLAggregationTest.testSimpleCount(CalcitePPLAggregationTest.java:39)
    java.lang.AssertionError: 
    Expected: is "SELECT *\nFROM `scott`.`EMP`\nWHERE (((SELECT COUNT(*) `COUNT()`\nFROM `scott`.`SALGRADE`\nWHERE `EMP`.`SAL` = `HISAL` OR `HISAL` > 1.0000E3))) > 0"
         but: was "SELECT *\r\nFROM `scott`.`EMP`\r\nWHERE (((SELECT COUNT(*) `COUNT()`\r\nFROM `scott`.`SALGRADE`\r\nWHERE `EMP`.`SAL` = `HISAL` OR `HISAL` > 1.0000E3))) > 0"
        at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18)
        at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6)
        at org.opensearch.sql.ppl.calcite.CalcitePPLAbstractTest.verifyPPLToSparkSQL(CalcitePPLAbstractTest.java:126)
        at org.opensearch.sql.ppl.calcite.CalcitePPLScalarSubqueryTest.testDisjunctiveCorrelatedScalarSubqueryInWhere(CalcitePPLScalarSubqueryTest.java:205)

CalcitePPLScalarSubqueryTest > testCorrelatedScalarSubqueryInSelect FAILED
    java.lang.AssertionError: 
    Expected: is "SELECT (((SELECT MIN(`EMP`.`EMPNO`) `min(EMPNO)`\nFROM `scott`.`SALGRADE`\nWHERE `EMP`.`SAL` = `HISAL`))) `min_empno`, `SAL`\nFROM `scott`.`EMP`"
         but: was "SELECT (((SELECT MIN(`EMP`.`EMPNO`) `min(EMPNO)`\r\nFROM `scott`.`SALGRADE`\r\nWHERE `EMP`.`SAL` = `HISAL`))) `min_empno`, `SAL`\r\nFROM `scott`.`EMP`"
        at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18)
        at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6)
        at org.opensearch.sql.ppl.calcite.CalcitePPLAbstractTest.verifyPPLToSparkSQL(CalcitePPLAbstractTest.java:126)
        at org.opensearch.sql.ppl.calcite.CalcitePPLScalarSubqueryTest.testCorrelatedScalarSubqueryInSelect(CalcitePPLScalarSubqueryTest.java:175)

CalcitePPLScalarSubqueryTest > testCorrelatedScalarSubqueryInWhere FAILED
    java.lang.AssertionError: 
    Expected: is "SELECT *\nFROM `scott`.`EMP`\nWHERE `SAL` > (((SELECT AVG(`EMP`.`SAL`) `AVG(SAL)`\nFROM `scott`.`SALGRADE`\nWHERE `EMP`.`SAL` = `HISAL`)))"
         but: was "SELECT *\r\nFROM `scott`.`EMP`\r\nWHERE `SAL` > (((SELECT AVG(`EMP`.`SAL`) `AVG(SAL)`\r\nFROM `scott`.`SALGRADE`\r\nWHERE `EMP`.`SAL` = `HISAL`)))"
        at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18)
        at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6)
        at org.opensearch.sql.ppl.calcite.CalcitePPLAbstractTest.verifyPPLToSparkSQL(CalcitePPLAbstractTest.java:126)
        at org.opensearch.sql.ppl.calcite.CalcitePPLScalarSubqueryTest.testCorrelatedScalarSubqueryInWhere(CalcitePPLScalarSubqueryTest.java:144)

CalcitePPLScalarSubqueryTest > testTwoScalarSubqueriesInOr FAILED
    java.lang.AssertionError: 
    Expected: is "SELECT *\nFROM `scott`.`EMP`\nWHERE `SAL` = (((SELECT MAX(`HISAL`) `max(HISAL)`\nFROM (SELECT `GRADE`, `LOSAL`, `HISAL`\nFROM `scott`.`SALGRADE`\nORDER BY `LOSAL` NULLS LAST) `t`))) OR `SAL` = (((SELECT MIN(`HISAL`) `min(HISAL)`\nFROM (SELECT `GRADE`, `LOSAL`, `HISAL`\nFROM `scott`.`SALGRADE`\nWHERE `LOSAL` > 1.0000E3\nORDER BY `HISAL` DESC NULLS FIRST) `t2`)))"
         but: was "SELECT *\r\nFROM `scott`.`EMP`\r\nWHERE `SAL` = (((SELECT MAX(`HISAL`) `max(HISAL)`\r\nFROM (SELECT `GRADE`, `LOSAL`, `HISAL`\r\nFROM `scott`.`SALGRADE`\r\nORDER BY `LOSAL` NULLS LAST) `t`))) OR `SAL` = (((SELECT MIN(`HISAL`) `min(HISAL)`\r\nFROM (SELECT `GRADE`, `LOSAL`, `HISAL`\r\nFROM `scott`.`SALGRADE`\r\nWHERE `LOSAL` > 1.0000E3\r\nORDER BY `HISAL` DESC NULLS FIRST) `t2`)))"
        at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18)
        at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6)
        at org.opensearch.sql.ppl.calcite.CalcitePPLAbstractTest.verifyPPLToSparkSQL(CalcitePPLAbstractTest.java:126)
        at org.opensearch.sql.ppl.calcite.CalcitePPLScalarSubqueryTest.testTwoScalarSubqueriesInOr(CalcitePPLScalarSubqueryTest.java:277)

CalcitePPLScalarSubqueryTest > testUncorrelatedScalarSubqueryInWhereAndSelect FAILED
    java.lang.AssertionError: 
    Expected: is "SELECT `min_empno`, `SAL`\nFROM (SELECT `EMPNO`, `ENAME`, `JOB`, `MGR`, `HIREDATE`, `SAL`, `COMM`, `DEPTNO`, (((SELECT MIN(`EMPNO`) `min(EMPNO)`\nFROM `scott`.`EMP`))) `min_empno`\nFROM `scott`.`EMP`) `t0`\nWHERE `SAL` > (((SELECT AVG(`SAL`) `AVG(SAL)`\nFROM `scott`.`EMP`)))"
         but: was "SELECT `min_empno`, `SAL`\r\nFROM (SELECT `EMPNO`, `ENAME`, `JOB`, `MGR`, `HIREDATE`, `SAL`, `COMM`, `DEPTNO`, (((SELECT MIN(`EMPNO`) `min(EMPNO)`\r\nFROM `scott`.`EMP`))) `min_empno`\r\nFROM `scott`.`EMP`) `t0`\r\nWHERE `SAL` > (((SELECT AVG(`SAL`) `AVG(SAL)`\r\nFROM `scott`.`EMP`)))"
        at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18)
        at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6)
        at org.opensearch.sql.ppl.calcite.CalcitePPLAbstractTest.verifyPPLToSparkSQL(CalcitePPLAbstractTest.java:126)
        at org.opensearch.sql.ppl.calcite.CalcitePPLScalarSubqueryTest.testUncorrelatedScalarSubqueryInWhereAndSelect(CalcitePPLScalarSubqueryTest.java:113)

CalcitePPLScalarSubqueryTest > testUncorrelatedScalarSubqueryInSelect FAILED
    java.lang.AssertionError: 
    Expected: is "SELECT (((SELECT MIN(`EMPNO`) `min(EMPNO)`\nFROM `scott`.`EMP`))) `min_empno`, `SAL`\nFROM `scott`.`EMP`"
         but: was "SELECT (((SELECT MIN(`EMPNO`) `min(EMPNO)`\r\nFROM `scott`.`EMP`))) `min_empno`, `SAL`\r\nFROM `scott`.`EMP`"
        at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18)
        at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6)
        at org.opensearch.sql.ppl.calcite.CalcitePPLAbstractTest.verifyPPLToSparkSQL(CalcitePPLAbstractTest.java:126)
        at org.opensearch.sql.ppl.calcite.CalcitePPLScalarSubqueryTest.testUncorrelatedScalarSubqueryInSelect(CalcitePPLScalarSubqueryTest.java:72)

CalcitePPLScalarSubqueryTest > testDisjunctiveCorrelatedScalarSubqueryInWhere2 FAILED
    java.lang.AssertionError: 
    Expected: is "SELECT *\nFROM `scott`.`EMP`\nWHERE (((SELECT COUNT(*) `COUNT()`\nFROM `scott`.`SALGRADE`\nWHERE `EMP`.`SAL` = `HISAL` AND `HISAL` > 1.0000E3 OR `EMP`.`SAL` = `HISAL` AND `LOSAL` > 1.0000E3))) > 0"
         but: was "SELECT *\r\nFROM `scott`.`EMP`\r\nWHERE (((SELECT COUNT(*) `COUNT()`\r\nFROM `scott`.`SALGRADE`\r\nWHERE `EMP`.`SAL` = `HISAL` AND `HISAL` > 1.0000E3 OR `EMP`.`SAL` = `HISAL` AND `LOSAL` > 1.0000E3))) > 0"
        at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18)
        at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6)
        at org.opensearch.sql.ppl.calcite.CalcitePPLAbstractTest.verifyPPLToSparkSQL(CalcitePPLAbstractTest.java:126)
        at org.opensearch.sql.ppl.calcite.CalcitePPLScalarSubqueryTest.testDisjunctiveCorrelatedScalarSubqueryInWhere2(CalcitePPLScalarSubqueryTest.java:235)

CalcitePPLScalarSubqueryTest > testUncorrelatedScalarSubqueryInWhere FAILED
    java.lang.AssertionError: 
    Expected: is "SELECT *\nFROM `scott`.`EMP`\nWHERE `SAL` > (((SELECT AVG(`SAL`) `AVG(SAL)`\nFROM `scott`.`EMP`)))"
         but: was "SELECT *\r\nFROM `scott`.`EMP`\r\nWHERE `SAL` > (((SELECT AVG(`SAL`) `AVG(SAL)`\r\nFROM `scott`.`EMP`)))"
        at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18)
        at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6)
        at org.opensearch.sql.ppl.calcite.CalcitePPLAbstractTest.verifyPPLToSparkSQL(CalcitePPLAbstractTest.java:126)
        at org.opensearch.sql.ppl.calcite.CalcitePPLScalarSubqueryTest.testUncorrelatedScalarSubqueryInWhere(CalcitePPLScalarSubqueryTest.java:44)

CalcitePPLStringFunctionTest > testLower FAILED
    java.lang.AssertionError: 
    Expected: is "SELECT LOWER(`ENAME`) `lower_name`\nFROM `scott`.`EMP`"
         but: was "SELECT LOWER(`ENAME`) `lower_name`\r\nFROM `scott`.`EMP`"
        at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18)
        at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6)
        at org.opensearch.sql.ppl.calcite.CalcitePPLAbstractTest.verifyPPLToSparkSQL(CalcitePPLAbstractTest.java:126)
        at org.opensearch.sql.ppl.calcite.CalcitePPLStringFunctionTest.testLower(CalcitePPLStringFunctionTest.java:46)

CalcitePPLStringFunctionTest > testLike FAILED
    java.lang.AssertionError: 
    Expected: is "SELECT COUNT(*) `cnt`\nFROM `scott`.`EMP`\nWHERE `JOB` ILIKE 'SALE%'"
         but: was "SELECT COUNT(*) `cnt`\r\nFROM `scott`.`EMP`\r\nWHERE `JOB` ILIKE 'SALE%'"
        at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18)
        at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6)
        at org.opensearch.sql.ppl.calcite.CalcitePPLAbstractTest.verifyPPLToSparkSQL(CalcitePPLAbstractTest.java:126)
        at org.opensearch.sql.ppl.calcite.CalcitePPLStringFunctionTest.testLike(CalcitePPLStringFunctionTest.java:64)

```

https://github.com/opensearch-project/sql/actions/runs/13848270281/job/38750884112?pr=3423


Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Uh oh!

[BUG] CalcitePPLAggregationTest in windows failed #3425

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Uh oh!

[BUG] CalcitePPLAggregationTest in windows failed #3425

Description

Metadata

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Issue actions