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

Mihai Budiu commented on CALCITE-1466:
--------------------------------------

I am doing this inside Calcite, and the number of operators one needs to 
implement is quadratic in the number of types. For example, there are 
conversions (casts) between any pair of numeric types; this is where my time is 
spent now, one has to carefully consider what happens for each such conversion 
when the two types do not have the same range. So let's start with having the 
core functionality, and then extend this to more types if there is demand in 
subsequent PRs. One can also consider 128 and 256 types, which exist in 
ClickHouse, for example.

> Support for UNSIGNED types of TINYINT, SMALLINT, MEDIUMINT, INT, BIGINT in 
> type system
> --------------------------------------------------------------------------------------
>
>                 Key: CALCITE-1466
>                 URL: https://issues.apache.org/jira/browse/CALCITE-1466
>             Project: Calcite
>          Issue Type: Improvement
>          Components: avatica
>            Reporter: Rajeshbabu Chintaguntla
>            Assignee: Mihai Budiu
>            Priority: Major
>              Labels: pull-request-available
>
> There are some data bases like MySQL supporting unsigned data types.  Apache 
> Phoenix also supports them. Would be great to add them to calcite as well.
> http://dev.mysql.com/doc/refman/5.7/en/integer-types.html



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to