temporary table reflection
Issue #3204
resolved
all the way back in 5320a47a, SQLite gained the ability to reflect temp tables. But it seems like at least PG and MySQL don't at all. this is totally inconsistent.
Comments (6)
-
reporter -
reporter so.... I'm going to support reflection of the table, but yank it out of the list for sqlite. its inconsistent
-
reporter we'll move the list-based methods into new inspector methods for temp tables and temp views.
-
reporter - changed status to resolved
- Added :meth:
.Inspector.get_temp_table_names
and :meth:.Inspector.get_temp_view_names
; currently, only the SQLite dialect supports these methods. The return of temporary table and view names has been removed from SQLite's version of :meth:.Inspector.get_table_names
and :meth:.Inspector.get_view_names
; other database backends cannot support this information (such as MySQL), and the scope of operation is different in that the tables can be local to a session and typically aren't supported in remote schemas. fixes#3204
→ <<cset cb23fa243f51>>
-
reporter Oracle too.
-
reporter - Added support for the Oracle table option ON COMMIT. This is being kept separate from Postgresql's ON COMMIT for now even though ON COMMIT is in the SQL standard; the option is still very specific to temp tables and we eventually would provide a more first class temporary table feature.
- oracle can apparently do get_temp_table_names() too, so implement that,
fix its get_table_names(), and add it to
#3204. fixes#3204again.
→ <<cset e3f07f7206cf>>
- Log in to comment
well, MySQL has no feature whatsoever to do this: http://dev.mysql.com/doc/refman/5.5/en/tables-table.html http://stackoverflow.com/a/16296395/34549