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:
   
   
![image](https://github.com/apache/doris/assets/1573662/f956a439-ad20-4582-bf38-a336acc3af7a)
   
   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

Reply via email to