I need to send some TypedValues to the avatica server (phoenix query
server) when executing a statement.
According to
https://calcite.apache.org/docs/avatica_protobuf_reference.html#typedvalue,
I need to set a Type for each value. I noticed that the list of Reps
here
(https://calcite.apache.org/docs/avatica_protobuf_reference.html#rep)
support things like JAVA_SQL_TIME, JAVA_SQL_TIMESTAMP etc, however it's
unclear which ones are valid values for a TypedValue.
In my case, the golang sql interface provides data for parameter binding
that might be a time.time (which is essentially a datetime). In this
case, what should my TypedValue look like?
Also, I noticed the Rep enum has a few things that looked similar, but
might mean different things. It would be nice to have documentation to
clarify. For example:
- What's the difference between PRIMITIVE_BOOLEAN and BOOLEAN?
- Is there any difference between LONG and BIG_INTEGER?
- Are the JAVA_SQL_* and JAVA_UTIL_* types currently being used?
Thanks!
