Uploaded image for project: 'Ignite'
  1. Ignite
  2. IGNITE-4172

SQL: Add support for Java 8 Time API classes in date\time functions

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 2.0
    • 2.4
    • sql

    Description

      We have is issue with querying LocalDateTime objects with our SQL engine.

      Next query can fails with error, if one of row localDateTimeField value has zero-time:
      select DATEDIFF('DAY', localDateTimeField, CURRENT_DATE ()) from t;

      Startpoint is IgniteH2Indexing.wrap() method.
      We need add support to these classes: LocalDate, LocalTime, LocalDateTime.

      Attachments

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            asfedotov Alexandr Fedotov
            amashenkov Andrey Mashenkov
            Votes:
            2 Vote for this issue
            Watchers:
            7 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment