You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@calcite.apache.org by "Zhengqiang Duan (Jira)" <ji...@apache.org> on 2025/05/31 00:15:00 UTC

[jira] [Comment Edited] (CALCITE-1466) Support for UNSIGNED types of TINYINT, SMALLINT, MEDIUMINT, INT, BIGINT in type system

    [ 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)