"Ann W. Harrison" <aharrison@...> wrote:

>
> A problem is that the SQL-03 standard makes temporary tables
> nearly incompatible with the <as subquery> clause in table
> definitions. Adding temporary tables won't solve the migration
> from MSSQL problems.

I do hope this entire thread is not about the migration of MSSQL users ;-)

> Adding a non-standard temporary table
> implementation will make future standards a choice between
> doing the right thing - maintaining backward compatibility
> and doing the right thing - following the standard.

Sigh, we may offer created and declared SESSION TEMPORARY TABLE instead. It
will have the semantics of LTTs being discussed here. It will make the
sponsor (and, expectedly, other guys as well) happy. Later we may either
change this syntax to {SESSION | LOCAL} or implement yet another
[standard-compliant] LOCAL TEMPORARY TABLE or forget about standard LTTs for
ever. But please don't stop a feature discussion just because we don't
understand the SQL-99 LTTs.


Dmitry