[TAJO-1353] Nested record support in CREATE TABLE statement

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.11.0
• Component/s: SQL Parser
• Assignee: Hyunsik Choi
• Reporter: Hyunsik Choi
• Created: 21/Feb/15 01:55
• Updated: 21/Feb/15 12:12
• Resolved: 21/Feb/15 11:46

Description

This patch adds the nested record definition to CREATE TABLE BNF. The changed BNF is as follows:

predefined_type
  : character_string_type
  | national_character_string_type
  | binary_large_object_string_type
  | numeric_type
  | boolean_type
  | datetime_type
  | bit_type
  | binary_type
  | network_type
  | record_type
  ;

record_type
  : RECORD table_elements
  ;

table_elements
  : LEFT_PAREN field_element (COMMA field_element)* RIGHT_PAREN
  ;

Example statements as follows:

CREATE TABLE T1 (
  A TEXT, 
  B INT4, 
  C RECORD (
    D TEXT, 
    E INT8, 
    F RECORD (
      G INT1, H FLOAT4
    )
  ), 
  Z FLOAT8
);

Updates

• I changed the type name 'struct' to 'record' according to TAJO-809.

Issue Links

• is part of: TAJO-809 Language extension for non-scalar types
• is required by: TAJO-721 Add support for nested tuple or struct type