[CALCITE-267] Improve support for ARRAY data type

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Labels: github-import
• Assignee: Unassigned
• Reporter: GitHub Import
• Created: 18/Jun/14 08:55
• Updated: 18/Jun/14 08:55
• Resolved: 18/Jun/14 08:55

Description

Improve support for SQL ARRAY data type.

Move class AbstractCursor.ArrayImpl to Avatica.

Richer representation of column type, including element type of arrays, and key and value type of maps, in ColumnMetaData, and passed via ArrayAccessor to ArrayImpl. Should be able to distinguish `INTEGER ARRAY` from `INTEGER NOT NULL ARRAY` and `INTEGER ARRAY ARRAY`.

If values in an array can be null, use a boxed type, for example Integer rather than int.

In ArrayImpl, implement the remaining java.sql.Array methods.

---------------- Imported from GitHub ----------------
Url: https://github.com/julianhyde/optiq/issues/267
Created by: julianhyde
Labels:
Created at: Tue Apr 29 02:14:52 CEST 2014
State: closed