Uploaded image for project: 'InsightEdge Platform'
  1. GS-13625

SQL query with Java date/time WHERE clause fails when date/time format property is configured

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Medium
    • Resolution: Fixed
    • Affects versions: None
    • Fix versions: 14.0, 12.3.1-patch1
    • Labels:
      None
    • Platform:
      All
    • SalesForce Case ID:
      12019
    • Acceptance Test:
      Added new sgtest: test.query.DateAndTimeFormattedQueryTest
    • Sprint:
    • Edition:
      Enterprise

      Description


      In 12.3.1-ga-patch1 (b19302),
      With the new 12.3.1 below sql query with java data time where conditions are failing, these queries work in 12.1
      select * from com.gigaspaces.MyPojo where rownum<10 and endDateTime='2018-08-25T00:00:00'

      MyPojo is defined to have a field endDateTime which is java.time.LocalDateTime.

      This does not work in webui or gs-ui.

      In the pu.xml, The formatter has been configured with:
      <os-core:embedded-space...
      <os-core:properties>
          <props>
              <prop key="space-config.QueryProcessor.datetime_format">yyyy-MM-dd'T'HH:mm:ss</prop>

        Attachments

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: