[ https://issues.apache.org/jira/browse/CALCITE-1951?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16445102#comment-16445102 ]
Kevin Risden commented on CALCITE-1951: --------------------------------------- [~elserj] and [~francischuang] - FYI I was able to create a test case in Avatica with the RemoteDriverTest. The PR has the failing test case. I haven't looked closely yet at fixing but sharing in case it helps. The failure seems as described where the fractional seconds are being stripped. {noformat} org.junit.ComparisonFailure: Expected :20:08:08.034900 Actual :20:08:08{noformat} > 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)