temporary table reflection

[Mike Bayer]

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.

[Mike Bayer]

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

[Mike Bayer]

so.... I'm going to support reflection of the table, but yank it out of the list for sqlite. its inconsistent

[Mike Bayer]

we'll move the list-based methods into new inspector methods for temp tables and temp views.

[Mike Bayer]

• 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>>

[Mike Bayer]

Oracle too.

[Mike Bayer]

• 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 #3204 again.

→ <<cset e3f07f7206cf>>