pawankukreja01 commented on issue #24737: URL: https://github.com/apache/doris/issues/24737#issuecomment-1763506944
The first code block creates a table named example_tbl with columns such as `user_id`, `username`, `city, age`, `sex`, `phone`, `address`, and `register_time`. The second code block is a SQL query that selects all records from the table where the username is ‘a’ and there exists a record in the same table with the same user_id as the selected record and username ‘b’, and there exists a record in the same table with the same user_id as the ‘b’ record and username ‘c’, or there exists a record in the same table with the same user_id as the ‘b’ record and username ‘d’. However, this code will result in an error: “Disjunctions with correlated predicates are not supported: b.user_id = a.user_id AND b.username = ‘b’ AND $a$1.$c$1 OR $a$2.$c$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
