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

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-coreroperties>
<props>
<prop key="space-config.QueryProcessor.datetime_format">yyyy-MM-dd'T'HH:mm:ss</prop>

Workaround

None

Acceptance Test

Added new sgtest: test.query.DateAndTimeFormattedQueryTest

Assignee

Niv Ingberg

Reporter

Dixson Huie

Labels

None

Priority

Medium

SalesForce Case ID

12019

Fix versions

Commitment Version/s

None

Due date

None

Product

None

Edition

Enterprise

Platform

All
Configure