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

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

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

On Mon, Jan 15, 2018 at 6:09 PM, Mike Bayer wrote: > On Mon, Jan 15, 2018 at 5:32 PM, Mike Bayer wrote: > > that's not quite right, because I'm not selecting from Test. Adding > the JOIN back in, I've tried aliasing Test everywhere and it

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

On Mon, Jan 15, 2018 at 5:32 PM, Mike Bayer wrote: > On Mon, Jan 15, 2018 at 4:47 PM, Lukas Barth wrote: >> 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

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

On Mon, Jan 15, 2018 at 4:47 PM, Lukas Barth wrote: > 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

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

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