Re: [sqlalchemy] SQLAlchemy does not properly create temporary table for subqueries in MariaDB

2018-01-17 Thread Lukas Barth
Thanks a lot! So, if I get this correctly, the difference is that you assigned a label to the timestamp, and that you're doing "~exists()" instead of "~in()" in the delete clause, right? I'll have to adapt this a bit to get it into my (obviously a bit more complicated) actual code, but thanks f

[sqlalchemy] SQLAlchemy does not properly create temporary table for subqueries in MariaDB

2018-01-15 Thread Lukas Barth
Hi, first things first: I put a complete notebook showing the problem at [0], I'll only post the excerpts I deem useful below. The exact same code, this time working, with an sqlite in-memory database is at [1]. I'm using SQLAlchemy version 1.2.1, python 3.5, mysqlclient version 1.3.12 and Mar