Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-6448

Unsigned numbers as default

        Details

        • Type: Task
        • Status: Closed
        • Priority: Major
        • Resolution: Won't Fix
        • Fix Version/s: N/A
        • Component/s: None
        • Labels:
          None

          Description

          Add the ability to set numbers to be unsigned by default.

            Gliffy Diagrams

              Attachments

                Activity

                Ascending order - Click to sort in descending order
                Hide
                Permalink
                serg Sergei Golubchik added a comment -

                What do you mean?

                Show
                serg Sergei Golubchik added a comment - What do you mean?
                Hide
                Permalink
                oskude Andre Schmidt added a comment -

                Couldn't find the mariadb docs for this, so i assume it's still the same as in mysql:

                "Numeric data types that permit the UNSIGNED attribute also permit SIGNED. However, these data types are signed by default, so the SIGNED attribute has no effect."
                http://dev.mysql.com/doc/refman/5.0/en/numeric-type-overview.html

                So the ability to change this default to UNSIGNED by adding an option in runtime config would be nice.

                ps. would also be interesting to know why is SIGNED the upstream default.

                Show
                oskude Andre Schmidt added a comment - Couldn't find the mariadb docs for this, so i assume it's still the same as in mysql: "Numeric data types that permit the UNSIGNED attribute also permit SIGNED. However, these data types are signed by default, so the SIGNED attribute has no effect." http://dev.mysql.com/doc/refman/5.0/en/numeric-type-overview.html So the ability to change this default to UNSIGNED by adding an option in runtime config would be nice. ps. would also be interesting to know why is SIGNED the upstream default.
                Hide
                Permalink
                serg Sergei Golubchik added a comment -

                SIGNED is the default, because it's what the SQL standard dictates. While the standard does not explicitly use "SIGNED" or "UNSIGNED" keywords, it does specify that

                For every numeric type, the least value is less than zero and the greatest value is greater than zero.

                which means, all numeric types must be signed. "UNSIGNED" keyword is MySQL/MariaDB extension.

                Show
                serg Sergei Golubchik added a comment - SIGNED is the default, because it's what the SQL standard dictates. While the standard does not explicitly use "SIGNED" or "UNSIGNED" keywords, it does specify that For every numeric type, the least value is less than zero and the greatest value is greater than zero. which means, all numeric types must be signed. "UNSIGNED" keyword is MySQL/MariaDB extension.

                  People

                  • Assignee:
                    Unassigned
                    Reporter:
                    oskude Andre Schmidt
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    2 Start watching this issue

                    Dates

                    • Due:
                      Created:
                      Updated:
                      Resolved: