Bug #13830 Support for ROW, ARRAY, and MULTISET type constructors
Submitted: 7 Oct 2005 8:13 Modified: 21 May 2011 16:06
Reporter: Sebastian Bergmann Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Data Types Severity:S4 (Feature request)
Version:Irrelevant OS:Any (Irrelevant)
Assigned to: CPU Architecture:Any

[7 Oct 2005 8:13] Sebastian Bergmann 
Description:
While preparing for an exam on Relational Databases I noticed that MySQL 5 does not support the ROW (new in SQL:1999, example below), ARRAY, and MULTISET (both new in SQL:2003) type constructors.

  CREATE TABLE customer (id INTEGER,
                                      address ROW (
                                        street VARCHAR (30), ...
                                      )
  );

  SELECT address.street FROM customer WHERE id = 42;

While I personally do not need these type constructors (at least not at the moment), I would still like to see MySQL support, especially since MySQL strives for full SQL:1999 support.

How to repeat:
Not applicable.

Suggested fix:
Not applicable.
[21 May 2011 16:06] Valeriy Kravchuk 
Thank you for the feature request. See http://forge.mysql.com/worklog/task.php?id=2081 (and related worklogs).