[TAJO-497] Rearrange reserved and non-reserved keywords

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 0.8.0
• Assignee: Keuntae Park
• Reporter: Keuntae Park
• Created: 13/Jan/14 02:15
• Updated: 29/Jan/14 05:05
• Resolved: 29/Jan/14 04:59

Description

Keywords of Tajo are classified as reserved and non-reserved,
and reserved keywords cannot be used as table name or column name.

Because reserved keywords of Tajo are different from other DBs like PostgreSQL and MySQL, migrating tables from those DBs to Tajo induces table creation error sometimes.

So, we need to rearrange reserved and non-researved keywords.

Following shows keywords which are allowed in PostgreSQL but not allowed in Tajo.

mydb=# \d
          List of relations
 Schema |   Name    | Type  | Owner  
--------+-----------+-------+--------
 public | filter    | table | ktpark
 public | first     | table | ktpark
 public | format    | table | ktpark
 public | grouping  | table | ktpark
 public | hash      | table | ktpark
 public | index     | table | ktpark
 public | insert    | table | ktpark
 public | last      | table | ktpark
 public | location  | table | ktpark
 public | max       | table | ktpark
 public | min       | table | ktpark
 public | national  | table | ktpark
 public | nullif    | table | ktpark
 public | overwrite | table | ktpark
 public | precision | table | ktpark
 public | range     | table | ktpark
 public | regexp    | table | ktpark
 public | rlike     | table | ktpark
 public | set       | table | ktpark
 public | unknown   | table | ktpark
 public | var_pop   | table | ktpark
 public | var_samp  | table | ktpark
 public | varying   | table | ktpark
 public | zone      | table | ktpark
 public | bigint      | table | ktpark
 public | bit         | table | ktpark
 public | blob        | table | ktpark
 public | bool        | table | ktpark
 public | boolean     | table | ktpark
 public | bytea       | table | ktpark
 public | char        | table | ktpark
 public | date        | table | ktpark
 public | decimal     | table | ktpark
 public | double      | table | ktpark
 public | float       | table | ktpark
 public | float4      | table | ktpark
 public | float8      | table | ktpark
 public | inet4       | table | ktpark
 public | int         | table | ktpark
 public | int1        | table | ktpark
 public | int2        | table | ktpark
 public | int4        | table | ktpark
 public | int8        | table | ktpark
 public | integer     | table | ktpark
 public | nchar       | table | ktpark
 public | numeric     | table | ktpark
 public | nvarchar    | table | ktpark
 public | real        | table | ktpark
 public | smallint    | table | ktpark
 public | text        | table | ktpark
 public | time        | table | ktpark
 public | timestamp   | table | ktpark
 public | timestamptz | table | ktpark
 public | timetz      | table | ktpark
 public | tinyint     | table | ktpark
 public | varbinary   | table | ktpark
 public | varbit      | table | ktpark
 public | varchar     | table | ktpark