Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-490

Change the data range of TINYINT, SMALLINT, INTEGER/INT and BIGINT

    XMLWordPrintable

Details

    • New Feature
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • None
    • Icebox
    • writeengine
    • 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

          Activity

            People

              LinuxJedi Andrew Hutchings (Inactive)
              zengchun Zeng Chun
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.