Details
-
New Feature
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
None
-
None
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.
Attachments
Issue Links
- duplicates
-
MCOL-92 Support full numeric ranges for all data types
- Closed