Bug #49943 Temporary views
Submitted: 27 Dec 2009 2:03 Modified: 29 May 2012 13:34
Reporter: Federico Razzoli (OCA) Email Updates:
Status: Won't fix Impact on me:
Category:MySQL Server: Views Severity:S4 (Feature request)
Version: OS:Any
Assigned to: CPU Architecture:Any

[27 Dec 2009 2:03] Federico Razzoli
Temporary views would be useful. They should be per-connection and only visible for the user who created them. Temporary views should be able to involve existing temporary tables.
I hope that this is not difficult and that you will implement this feature.

How to repeat:
[4 Jan 2010 12:44] Susanne Ebrecht
Sorry, but what would be the advantage from Temp Views against Temp Tables or Views?
[5 Jan 2010 21:25] Federico Razzoli
Thank you for your interest about my request.
I have 2 Perl scripts which regularly generate some reports about sales, etc. One does it every sunday and one does it montly. To generate these reports and keep queries reasonibly simple, they use 16 views. These views are not needed by any other task. So, if I could use temporary views, the scripts could create the temp views on connection and the views would automatically disappear when they disconnect.
This feature is supported by PostgreSQL and SQL Server 2005 - don't know if it's supported by some other dbms, but I beilive it is.
[5 Jan 2010 21:49] Peter Gulutzan
There is no CREATE TEMPORARY VIEW statement in
SQL Server 2008, nor in Oracle 11g, nor in DB2 v9.
[19 Feb 2010 13:04] Susanne Ebrecht
Also SQL Standard don't supports temporary view.