houqp opened a new issue #1057: URL: https://github.com/apache/arrow-datafusion/issues/1057
**Describe the bug** Test defined at https://github.com/apache/arrow-datafusion/blob/91a450fcc3a08a65a521b555707a3a2893a85697/datafusion/tests/sql.rs#L1019-L1031 This test is passing in master, but failing in arrow2 branch. The expected result asserted in the test is: ``` "+-----------+---------+------------+------+---------+---------+---------+---------+------------------------ ---+", "| c9 | SUM(CAS | AVG(CAST(a | COUN | MAX(CAS | MIN(CAS | FIRST_V | LAST_VA | NTH_VALUE(.c4 AS Int32) 2) |", "+-----------+---------+------------+------+---------+---------+---------+---------+------------------------ ---+", "| 28774375 | -16110 | -16110 | 1 | -16110 | -16110 | -16110 | -16110 | |", "| 63044568 | 3917 | 3917 | 1 | 3917 | 3917 | 3917 | 3917 | |", "| 141047417 | -38455 | -19227.5 | 2 | -16974 | -21481 | -16974 | -21481 | |", "| 141680161 | -1114 | -1114 | 1 | -1114 | -1114 | -1114 | -1114 | |", "| 145294611 | 15673 | 15673 | 1 | 15673 | 15673 | 15673 | 15673 | |", "+-----------+---------+------------+------+---------+---------+---------+---------+------------------------ ---+", ``` Result from postgres: ``` c9 sum avg count max min first last nth 28774375 -16110 -16110 1 -16110 -16110 -16110 -16110 NULL 63044568 3917 3917 1 3917 3917 3917 3917 NULL 141047417 -38455 -19227.5 2 -16974 -21481 -21481 -16974 -16974 141680161 -1114 -1114 1 -1114 -1114 -1114 -1114 NULL 145294611 15673 15673 1 15673 15673 15673 15673 NULL ``` Row in question is `c9=141047417` -- 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]
