[jira] [Created] (IGNITE-24367) Jdbc. Unable to read interval value

[Maksim Zhuravkov (Jira)]

Maksim Zhuravkov created IGNITE-24367:
-----------------------------------------

             Summary: Jdbc. Unable to read interval value 
                 Key: IGNITE-24367
                 URL: https://issues.apache.org/jira/browse/IGNITE-24367
             Project: Ignite
          Issue Type: Improvement
          Components: sql
            Reporter: Maksim Zhuravkov


Reading a value of an interval type via JDBC results in an error, meanwhile, 
SQL APIs (both thin client and embedded) read them correctly.

{noformat}
@Test
public void test() throws SQLException {
    ResultSet r = stmt.executeQuery("SELECT INTERVAL 1 YEARS");
    while (r.next()) {
        System.err.println(r.getObject(1));
    }
}
{noformat}

Error:
{noformat}

org.apache.ignite.internal.binarytuple.BinaryTupleFormatException: 
IGN-CMN-65535 TraceId:20d3f4fe-9bfb-4baf-b191-8ea8481c084d Invalid length for a 
tuple element: 1

        at 
org.apache.ignite.internal.binarytuple.BinaryTupleParser.periodValue(BinaryTupleParser.java:495)
        at 
org.apache.ignite.internal.binarytuple.BinaryTupleReader.periodValue(BinaryTupleReader.java:361)
        at 
org.apache.ignite.internal.jdbc.JdbcConverterUtils.deriveValueFromBinaryTuple(JdbcConverterUtils.java:103)
        at 
org.apache.ignite.internal.jdbc.JdbcResultSet.lambda$createTransformer$0(JdbcResultSet.java:2293)
        at 
org.apache.ignite.internal.util.TransformingIterator.next(TransformingIterator.java:42)
        at 
org.apache.ignite.internal.jdbc.JdbcResultSet.next(JdbcResultSet.java:303)
        at 
org.apache.ignite.jdbc.ItJdbcSchemaTest.test(ItJdbcSchemaTest.java:62)
        at java.base/java.lang.reflect.Method.invoke(Method.java:566)
        at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
        at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
{noformat}






--
This message was sent by Atlassian Jira
(v8.20.10#820010)