[ https://issues.apache.org/jira/browse/DRILL-4457?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15237711#comment-15237711 ]
Khurram Faraaz commented on DRILL-4457: --------------------------------------- Test added here Functional/window_functions/frameclause/RBCRACR/RBCRACR_bgint_6.q > Difference in results returned by window function over BIGINT data > ------------------------------------------------------------------ > > Key: DRILL-4457 > URL: https://issues.apache.org/jira/browse/DRILL-4457 > Project: Apache Drill > Issue Type: Bug > Components: Execution - Flow > Affects Versions: 1.6.0 > Environment: 4 node cluster > Reporter: Khurram Faraaz > Assignee: Deneche A. Hakim > Labels: window_function > Fix For: 1.6.0 > > > Difference in results returned by window function query over same data on > Drill vs on Postgres. > Drill 1.6.0 commit ID 6d5f4983 > {noformat} > Verification Failures: > /root/public_framework/drill-test-framework/framework/resources/Functional/window_functions/frameclause/RBCRACR/RBCRACR_bgint_6.q > Query: > SELECT FIRST_VALUE(c3) OVER(PARTITION BY c8 ORDER BY c1 RANGE BETWEEN CURRENT > ROW AND CURRENT ROW) FROM `t_alltype.parquet` > Expected number of rows: 145 > Actual number of rows from Drill: 145 > Number of matching rows: 143 > Number of rows missing: 2 > Number of rows unexpected: 2 > These rows are not expected (first 10): > 36022570792 > 21011901540311080 > These rows are missing (first 10): > null (2 time(s)) > {noformat} > Here is the difference in results, Drill 1.6.0 returns 36022570792 whereas > Postgres returns null, and another difference is that Drill returns > 21011901540311080 whereas Postgres returns null. > {noformat} > [root@centos-01 drill-output]# diff -cb > RBCRACR_RBCRACR_bgint_6.output_Tue_Mar_01_10\:36\:42_UTC_2016 > ../resources/Functional/window_functions/frameclause/RBCRACR/RBCRACR_bgint_6.e > *** RBCRACR_RBCRACR_bgint_6.output_Tue_Mar_01_10:36:42_UTC_2016 > 2016-03-01 10:36:43.012382649 +0000 > --- > ../resources/Functional/window_functions/frameclause/RBCRACR/RBCRACR_bgint_6.e > 2016-03-01 10:32:56.605677914 +0000 > *************** > *** 55,61 **** > 5424751352 > 3734160392 > 36022570792 > ! 36022570792 > 584831936 > 37102817894137256 > 61958708627376736 > --- 55,61 ---- > 5424751352 > 3734160392 > 36022570792 > ! null > 584831936 > 37102817894137256 > 61958708627376736 > *************** > *** 64,70 **** > 29537626363643852 > 52598911986023288 > 21011901540311080 > ! 21011901540311080 > 17990322900862228 > 616080519999272 > 3136812789494 > --- 64,70 ---- > 29537626363643852 > 52598911986023288 > 21011901540311080 > ! null > 17990322900862228 > 616080519999272 > 3136812789494 > {noformat} -- This message was sent by Atlassian JIRA (v6.3.4#6332)