Details

    • Sub-task
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • 0.11.0
    • SQL Parser
    • 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

        1. TAJO-1353.patch
          24 kB
          Hyunsik Choi

        Issue Links

          Activity

            People

              hyunsik Hyunsik Choi
              hyunsik Hyunsik Choi
              Votes:
              0 Vote for this issue
              Watchers:
              3 Stop watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Slack

                  Issue deployment