Makarov-AA commented on issue #25659: URL: https://github.com/apache/superset/issues/25659#issuecomment-3248343017
Same here, superset version 3.0.0, postgresql 16.8 I don't know why this issue is considered duplicate of https://github.com/apache/superset/issues/22704, can't see relation. I use UNION in SQL Lab in request - everything is fine. As long as I use it in WITH AS statement - it breaks. `SELECT * FROM a UNION SELECT * FROM b;` -- works fine. ``` WITH c AS ( SELECT * FROM a UNION SELECT * FROM b ) SELECT * FROM c; ``` breaks immediately with an error: ``` DB engine Error Only SELECT statements are allowed against this database. This may be triggered by: Issue 1022 - Database does not allow data manipulation. ``` If I enable DML in dataset settings, everything works, but this is not an option. Since UNION is not supported I have to come up with some weird ideas like OUTER JOIN ON FALSE to replace UNION -- 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: notifications-unsubscr...@superset.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org For additional commands, e-mail: notifications-h...@superset.apache.org
