[MCOL-490] Change the data range of TINYINT, SMALLINT, INTEGER/INT and BIGINT Created: 2016-12-29  Updated: 2017-12-01  Resolved: 2016-12-29

Status: Closed
Project: MariaDB ColumnStore
Component/s: writeengine
Affects Version/s: None
Fix Version/s: Icebox

Type: New Feature Priority: Major
Reporter: Zeng Chun Assignee: Andrew Hutchings (Inactive)
Resolution: Duplicate Votes: 0
Labels: None

Issue Links:
Duplicate
duplicates MCOL-92 Support full numeric ranges for all d... Closed

 Description   

Keep the same definition for numeric types between MariaDB ColumnStore and MariaDB. Thanks for your great support.

MariaDB ColumnStore:

  • TINYINT: Signed: -126 to +127. Unsigned: 0 to 253.
  • SMALLINT: Signed: -32,766 to 32,767. Unsigned: 0 to 65,533.
  • INTEGER/INT: Signed: -2,147,483,646 to 2,147,483,647. Unsigned: 0 to 4,294,967,293
  • BIGINT: Signed: -9,223,372,036,854,775,806 to+9,223,372,036,854,775,807 Unsigned: 0 to +18,446,744,073,709,551,613

MariaDB:

  • TINYINT: signed range is -128 to 127. The unsigned range is 0 to 255.
  • SMALLINT: signed range is -32768 to 32767. The unsigned range is 0 to 65535.
  • INTEGER/INT: signed range is -2147483648 to 2147483647. The unsigned range is 0 to 4294967295.
  • BIGINT: signed range is -9223372036854775808 to 9223372036854775807. The unsigned range is 0 to 18446744073709551615.


 Comments   
Comment by Andrew Hutchings (Inactive) [ 2016-12-29 ]

Many thanks for your report. This is a duplicate of MCOL-92 and I have marked it as such. Please feel free to watch that issue for any updates and vote for it there.

Generated at Thu Feb 08 02:21:29 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.