rusackas commented on issue #26162: URL: https://github.com/apache/superset/issues/26162#issuecomment-4043491924
Thanks for the validation @FurcyPin — great to have a clear reproduction case. The underlying challenge seems to be that splitting SQL on `;` doesn't work correctly for multi-statement routines, and the right place to fix this is likely in the SQL splitting logic now that Superset has moved to `sqlglot`. @betodealmeida opened a related `sqlglot` issue at https://github.com/tobymao/sqlglot/issues/5178 — it might be worth checking the status of that upstream issue, as a fix there could unblock this. Alternatively, a workaround in Superset's SQL splitting logic to handle Trino routines more gracefully could also be worth exploring. It would be great if someone with Trino access could keep an eye on that upstream issue and open a PR here once there's a path forward. Last activity on this issue was approximately 9 months ago. -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
