[
https://issues.apache.org/jira/browse/CALCITE-1466?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17955348#comment-17955348
]
Zhengqiang Duan edited comment on CALCITE-1466 at 5/31/25 12:14 AM:
--------------------------------------------------------------------
Hi [~mbudiu], I looked at the [https://github.com/jOOQ/jOOU] library, it
provides UByte, UShort, UInteger, and ULong, which are consistent with the
UNSIGNED type range in MySQL. I think we can integrate it into calcite avatica.
In addition, MySQL also provides the MEDIUMINT [UNSIGNED] type -
[https://dev.mysql.com/doc/refman/5.7/en/integer-types.html], which has no
corresponding type in JDK and Joou. Do you think MediumInteger and
UMediumInteger should be added to handle this type?
was (Author: duanzhengqiang):
Hi [~mbudiu], I looked at the https://github.com/jOOQ/jOOU library, it provides
UByte, UShort, UInteger, and ULong, which are consistent with the UNSIGNED type
range in MySQL. I think we can integrate it into calcite avatica.
In addition, MySQL also provides the MEDIUMINT [UNSIGNED] type -
https://dev.mysql.com/doc/refman/5.7/en/integer-types.html, which has no
complete corresponding type in JDK and Joou. Do you think MediumInteger and
UMediumInteger should be added to handle this type?
> 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)
