MySQL Bugs: #60940: Implement Common Table Expressions as defined by the ANSI SQL 99 standard

Bug #60940	Implement Common Table Expressions as defined by the ANSI SQL 99 standard
Submitted:	21 Apr 2011 3:56	Modified:	21 Apr 2011 7:28
Reporter:	Behrang Saeedzadeh	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server: General	Severity:	S4 (Feature request)
Version:		OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	common table expressions, cte, with

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
From Wikipedia:

A Common Table Expression, or CTE, (in SQL) is a temporary named result set, derived from a simple query and defined within the execution scope of a SELECT, INSERT, UPDATE, or DELETE statement.

[At the moment,] common table expressions are supported by DB2, Firebird, Microsoft SQL Server, Oracle, PostgreSQL and H2.

How to repeat:
Feature request. N/A.+

This is a duplicate of Bug #16244.