Details

    • Type: Sub-task
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.11.0
    • Component/s: SQL Parser
    • Labels:
      None

      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.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                hyunsik Hyunsik Choi
                Reporter:
                hyunsik Hyunsik Choi
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: