Re: [sqlalchemy] SQLAlchemy update on mysql updates less row than directly from IDE or command line

2021-02-14 Thread Vincent T
are matching.your SQL query does not > seem to use any Python values nor anything really specific to SQLAlchemy so > try writing a simple mysqlclient script also. > > > > > > On Sun, Feb 14, 2021, at 8:36 AM, Vincent T wrote: > > Mysql v8.0.23 on ubuntu 20.04 >

[sqlalchemy] SQLAlchemy update on mysql updates less row than directly from IDE or command line

2021-02-14 Thread Vincent T
Mysql v8.0.23 on ubuntu 20.04 SQLAlchemy 1.3.22 Python 3.8.5 I have an SQL query as shown below that updates row in database. When run by command line or using DBeaver SQL editor, I get 583k lines updated. When using SQLAlchemy I get only 450k lines updated. i.e. some rows get updated but not