xavierzhao opened a new issue, #21117: URL: https://github.com/apache/doris/issues/21117
Recently I upgraded version to Doris from version 1.2.1 to version 1.2.4-1. The problem is when I execute unit test it dosen't working, it's look like there is a change in the version that cause this problem. Here is exception message:  and SQL like this: ` SELECT totalNum - lag ( totalNum, 1, 0 ) over ( ORDER BY sortNum ) AS totalNum FROM ( SELECT sortNum, BITMAP_UNION_COUNT (pv) over ( ORDER BY sortNum ) totalNum FROM ( SELECT ifnull( a.sortNum, b.sortNum ) sortNum, BITMAP_UNION ( ifnull( a.pv, b.pv ) ) pv FROM ( SELECT 1 sortNum, BITMAP_UNION (DEVICE_ID) AS pv FROM APP_LOG WHERE LOG_DATE >= '2023-06-01' AND LOG_DATE <= '2023-06-30' ORDER BY sortNum ) a FULL JOIN ( SELECT '2' sortNum, BITMAP_UNION (DEVICE_ID) AS pv FROM APP_LOG WHERE LOG_DATE < '2023-06-01' ORDER BY sortNum ) b ON a.sortNum = b.sortNum GROUP BY sortNum ORDER BY sortNum ) c ) final LIMIT 1 ` Any idea.? _Originally posted by @xavierzhao in https://github.com/apache/doris/discussions/21017_ -- 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: commits-unsubscr...@doris.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org