Re: [sqlalchemy] select x for update is still snapshot read in sqlalchemy.

ying zhang wrote: > > > I'm confused with how Query.with_lockmode('update') works in sqlalchemy. > My code is in attachment. > For testing, I start test.py in 1st terminal, then start test.py in 2nd > terminal. > so the 2nd termial will read the data modified by 1st test.py. > But the 2nd te

[sqlalchemy] select x for update is still snapshot read in sqlalchemy.

I'm confused with how Query.with_lockmode('update') works in sqlalchemy. My code is in attachment. For testing, I start test.py in 1st terminal, then start test.py in 2nd terminal. so the 2nd termial will read the data modified by 1st test.py. But the 2nd terminal's output contains L42 in test.p