tsql
tsql copied to clipboard
AnyhowStep
Document MySQL limitation regarding temporary tables being referenced twice in same query
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
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