Document MySQL limitation regarding temporary tables being referenced twice in same query - Githubissues

AnyhowStep / tsql

A SQL query-builder/ORM

37 stars 3 forks source link

Document MySQL limitation regarding temporary tables being referenced twice in same query #146

Open AnyhowStep opened 4 years ago

AnyhowStep commented 4 years ago

https://bugs.mysql.com/bug.php?id=10327

This library does not make a distinction between temporary and non-temporary tables. (Maybe it should?)

This library also does not (yet?) provide a unified way of creating temporary tables (and non-temporary tables).

So, any temporary tables created would be done with .rawQuery(), at the moment.

So, we can't yet detect when a temporary table is being used twice in the same query. Gdi MySQL.

Just let people use temporary tables the way it should intuitively work

AnyhowStep commented 4 years ago

I'm somewhat against trying to unify DDL with this library. There are a lot of differences between the different databases.

Some examples,

Storage engines
Collations
Partitions
Indexing
Generated columns (not supported in SQLite as of this writing, but should be out soon)
Column formats
Data type sizes

Most people might not use all the available options, for small applications, I suppose. But anything I attempt to unify will probably support a very small subset of DDLs...

Also, trying to unify DML alone is already such a pain