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

[21 Apr 2011 3:56] Behrang Saeedzadeh 
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.+
[21 Apr 2011 7:28] Valeriy Kravchuk 
This is a duplicate of Bug #16244.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.049 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.