Hi Mike and thanks for taking the time to look into that.
The query itself works fine. As mentioned it updates perfectly in mysql CLI
or using a sql client like DBeaver.
I followed your suggestion and tried using mysql.connector and the query
works fine.
In the meantime I also tried to use the
looks like you are matching on timestamps. is there a timezone or date
truncation issue occurring ? check the timestamps etc. and make sure they
match up. Create small test scripts using SQLAlchemy with echo='debug' to
see that the rows you expect are matching.your SQL query does not
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