ephraimbuddy commented on PR #42928:
URL: https://github.com/apache/airflow/pull/42928#issuecomment-2408945422

   > Rather than two commits you can also do `session.flush()` which makes SQLA 
issue the commands to the DB such that a future select on the same session sees 
the same rows, but it keeps it in the same session, such that the total 
operation is atomic still
   
   If I read this correctly, we would still have the issue: 
https://docs.sqlalchemy.org/en/20/orm/session_basics.html#flushing. Does this 
mean there was a flush in the update statement when we called `write` before 
the delete statement? 


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

Reply via email to