[TAJO-1238] Add SET SESSION and RESET statement

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.10.0
• Component/s: Planner/Optimizer, QueryMaster
• Assignee: Hyunsik Choi
• Reporter: Hyunsik Choi
• Created: 09/Dec/14 09:03
• Updated: 17/Dec/14 12:19
• Resolved: 17/Dec/14 12:19

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