[BUG] JDBC Driver doesn't return TIMESTAMP fractional seconds

[kylepbit]

What is the bug?
Timestamps with fractional seconds have the fractions stripped through the JDBC driver.

How can one reproduce the bug?
Steps to reproduce the behavior:

1. Load data into a timestamp index with fractional seconds
2. Connect using the JDBC driver
3. Issue a SELECT * query on the table
4. Notice no fractional seconds for any values

What is the expected behavior?
Fractional seconds match the inserted values

What is your host/environment?

• OS: macOS
• Version JDBC 1.1.0.1
• Plugins

[Yury-Fridlyand]

Test data:
test_data.zip

[MaxKsyunz]

The problem is here.

This is the definition of DATE_TIME_FORMATTER

The correct solution should use the formatter specified in the mapping for the field or whatever is set as the default formatter in OpenSearch[*].

Here are the docs for date field formatters.

[*] I thought I read somewhere it's a setting, but I can't find it. Default formatters used by OpenSearch are here.

[MaxKsyunz]

constructTimestamp should be able to use DateFormatters.forPattern to get date formatter for one of the pre-defined formats.

[kylepbit]

I believe this was actually a red herring - it appears to have invoked the v1 SQLEngine which doesn't have timestamp, and thus couldn't return the precision. It's now working correctly after some other changes.