gojumprope commented on issue #23466:
URL: https://github.com/apache/doris/issues/23466#issuecomment-1698734394

   simple query also can't works (union with same table cannot filter multiple 
values)
   example as below:
   `SELECT * FROM (
            with temptable as (
                        SELECT 1 id
            )
        SELECT id FROM (
                SELECT * FROM temptable
                UNION
                SELECT * FROM temptable
            ) tab
        GROUP BY id
       ) AS tab2
       WHERE id IN ('1', '2')`


-- 
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

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