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

When to_date() parses some date without day, the result will be wrong.

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.9.0
    • Component/s: Function/UDF
    • Labels:
      None

      Description

      The reproduction code is as follows:

      SELECT to_date('201404', 'yyyymm');
      > 2014-03-31
      

      The correct result should be 2014-04-01.

        Activity

        Hide
        githubbot ASF GitHub Bot added a comment -

        GitHub user hyunsik opened a pull request:

        https://github.com/apache/tajo/pull/57

        TAJO-905: When to_date() parses some date without day, the result will b...

        ...e wrong.

        You can merge this pull request into a Git repository by running:

        $ git pull https://github.com/hyunsik/tajo TAJO-905

        Alternatively you can review and apply these changes as the patch at:

        https://github.com/apache/tajo/pull/57.patch

        To close this pull request, make a commit to your master/trunk branch
        with (at least) the following in the commit message:

        This closes #57


        commit 48b339af48b40c0dcbb687a2cf609e4f14db91ae
        Author: Hyunsik Choi <hyunsik@apache.org>
        Date: 2014-07-04T00:46:13Z

        TAJO-905: When to_date() parses some date without day, the result will be wrong.


        Show
        githubbot ASF GitHub Bot added a comment - GitHub user hyunsik opened a pull request: https://github.com/apache/tajo/pull/57 TAJO-905 : When to_date() parses some date without day, the result will b... ...e wrong. You can merge this pull request into a Git repository by running: $ git pull https://github.com/hyunsik/tajo TAJO-905 Alternatively you can review and apply these changes as the patch at: https://github.com/apache/tajo/pull/57.patch To close this pull request, make a commit to your master/trunk branch with (at least) the following in the commit message: This closes #57 commit 48b339af48b40c0dcbb687a2cf609e4f14db91ae Author: Hyunsik Choi <hyunsik@apache.org> Date: 2014-07-04T00:46:13Z TAJO-905 : When to_date() parses some date without day, the result will be wrong.
        Hide
        blrunner Jaehwa Jung added a comment -

        +1

        Thank you for your contribution.
        But before you push it, you need to update change node against master branch.

        Show
        blrunner Jaehwa Jung added a comment - +1 Thank you for your contribution. But before you push it, you need to update change node against master branch.
        Hide
        hyunsik Hyunsik Choi added a comment -

        just committed it to master branch. Thank you for the review.

        Show
        hyunsik Hyunsik Choi added a comment - just committed it to master branch. Thank you for the review.
        Hide
        githubbot ASF GitHub Bot added a comment -

        Github user asfgit closed the pull request at:

        https://github.com/apache/tajo/pull/57

        Show
        githubbot ASF GitHub Bot added a comment - Github user asfgit closed the pull request at: https://github.com/apache/tajo/pull/57
        Hide
        hudson Hudson added a comment -

        SUCCESS: Integrated in Tajo-master-build #277 (See https://builds.apache.org/job/Tajo-master-build/277/)
        TAJO-905: When to_date() parses some date without day, the result will be wrong. (hyunsik) (hyunsik: rev d84d5ca59dc0cd3ad86cad6b9ec31681b8249e9f)

        • tajo-common/src/main/java/org/apache/tajo/util/datetime/DateTimeFormat.java
        • CHANGES
        • tajo-core/src/test/java/org/apache/tajo/engine/function/TestDateTimeFunctions.java
        Show
        hudson Hudson added a comment - SUCCESS: Integrated in Tajo-master-build #277 (See https://builds.apache.org/job/Tajo-master-build/277/ ) TAJO-905 : When to_date() parses some date without day, the result will be wrong. (hyunsik) (hyunsik: rev d84d5ca59dc0cd3ad86cad6b9ec31681b8249e9f) tajo-common/src/main/java/org/apache/tajo/util/datetime/DateTimeFormat.java CHANGES tajo-core/src/test/java/org/apache/tajo/engine/function/TestDateTimeFunctions.java

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development