Uploaded image for project: 'Tajo'
  1. Tajo
  2. TAJO-1238

Add SET SESSION and RESET statement

    Details

    • Type: New Feature
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.10.0
    • Labels:
      None

      Description

      So far, there have been no session statements which enable users to set or reset session variables. We have only meta command in tsql. Here is my proposal for session statement.

      SET CATALOG and SET TIME ZONE are based on ANSI SQL 2003 standards, and others are based on PostgreSQL. Vertica and Teradata have the same syntax.

      BNF
      : SET CATALOG dbname = identifier
        | SET TIME ZONE (Character_String_Literal | signed_numerical_literal | DEFAULT)
        | SET (SESSION)? name=identifier (TO | EQUAL)?
          (Character_String_Literal | signed_numerical_literal | boolean_literal | DEFAULT)
        | RESET name=identifier
      

        Attachments

        1. TAJO-1238.patch
          57 kB
          Hyunsik Choi
        2. TAJO-1238_4.patch
          55 kB
          Hyunsik Choi
        3. TAJO-1238_3.patch
          56 kB
          Hyunsik Choi
        4. TAJO-1238_2.patch
          71 kB
          Hyunsik Choi

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: