[TAJO-2128] Add validator of Date/Time

• Type: New Feature
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 0.12.0
• Component/s: Query Validation
• Assignee: Unassigned
• Reporter: Jinho Kim
• Created: 21/Apr/16 03:14
• Updated: 21/Apr/16 03:15

Description

Currently, tajo are not check the syntax of datetime type.
We should add validator

• Tajo

  default> select '00:10:10'::timestamp;
  ?cast
  -------------------------------
  0002-11-30 00:10:10 BC
  
  default> select '00:10:10'::date;
  ?cast
  -------------------------------
  0002-11-30
  (1 rows, 0.003 sec, 0 B selected)
  
  default> select '1992-01-01'::time;
  ?cast
  -------------------------------
  1992:01:01
  (1 rows, 0.003 sec, 0 B selected)
  

• Postgres

  postgres=# select '00:10:10'::timestamp;
  ERROR:  invalid input syntax for type timestamp: "00:10:10"
  LINE 1: select '00:10:10'::timestamp;
                 ^
  postgres=# select '00:10:10'::date;
  ERROR:  invalid input syntax for type date: "00:10:10"
  LINE 1: select '00:10:10'::date;
                 ^
  postgres=# select '1992-01-01'::time;
  ERROR:  invalid input syntax for type time: "1992-01-01"
  LINE 1: select '1992-01-01'::time;
  

Issue Links

• relates to: TAJO-2110 Fix incorrect DateTime and remove hard coded tests