[
https://issues.apache.org/jira/browse/CALCITE-717?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14636181#comment-14636181
]
Julian Hyde commented on CALCITE-717:
-------------------------------------
Should be straightforward to fix. You'e right - it's just the compare function.
Probably ByteString.compareTo. Some code in SqlFunctions.java might need
changing too - I'm not sure. You should add a line or two to each of
SqlFunctionsTest.testByteString, SqlOperatorBaseTest.testLessThanOperator,
testGreaterThanOperator, testBetween, etc.
> Order By varbinary column use signed value instead of unsigned value
> --------------------------------------------------------------------
>
> Key: CALCITE-717
> URL: https://issues.apache.org/jira/browse/CALCITE-717
> Project: Calcite
> Issue Type: Bug
> Reporter: Low Chin Wei
> Assignee: Julian Hyde
>
> I am storing IP address as varbinary and the order by on that column will not
> yield correct order. Because, it use signed value instead of unsigned value
> to sort the column.
> Is there anyway I can sort it by unsigned value?
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
