This happens because H2 does not work with these classes directly and we do some conversions to SQL types, then from H2 JDBC API we get what H2 gives us. The resulting types can be different. I guess you have to just write tests for all these types and cover all these cases in C++ code.
Sergi 2017-03-16 18:14 GMT+03:00 Igor Sapego <[email protected]>: > Hi guys, > > I'm working on java.sql.Time type support for ODBC [1], and I'm facing > following behaviour: > > Lets suppose I perform an SQL query from C++ on field of java.sql.Time > type: > > SELECT dateField from SomeType > > Nothing special here. The problem is in C++ I get value of type Date > instead of Time. The similar behaviour can be observed for the > java.sql.Date type (returned as Timestamp in binary protocol). I have not > investigated issue yet but I suppose it has to do something with > java.sql.Time and java.sql.Timestamp both being a subclasses of the > java.util.Date. > > So the question is, is this an expected behaviour or is it a bug? > > [1] - https://issues.apache.org/jira/browse/IGNITE-4691 >
