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
[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.