Details

    • Type: New Feature
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 0.12.0
    • Fix Version/s: None
    • Component/s: Query Validation
    • Labels:
      None

      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;
        

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                jhkim Jinho Kim
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated: