[jira] [Commented] (CALCITE-1951) Avatica HSQLDB docker image time loses fractional seconds

["Josh Elser (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CALCITE-1951?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16463106#comment-16463106 ] 

Josh Elser commented on CALCITE-1951:
-------------------------------------

Sick. Good stuff, [~risdenk]. Will put it on my list to come back to.

> Avatica HSQLDB docker image time loses fractional seconds
> ---------------------------------------------------------
>
>                 Key: CALCITE-1951
>                 URL: https://issues.apache.org/jira/browse/CALCITE-1951
>             Project: Calcite
>          Issue Type: Bug
>          Components: avatica
>            Reporter: Francis Chuang
>            Priority: Major
>
> I create a table like so in HSQLDB using the avatica-hsqldb image:
> {code}
> CREATE TABLE some_table (
> 	tm TIME(6) PRIMARY KEY,
> )
> {code}
> I then use calculate the milliseconds since 00:00:00.000 and send this value along with my insert statement: 76881222
> However, when I select the row to read the value back, I get 76881000.
> In this case, 222 milliseconds was lost.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)