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

Resource option MAX_USER_CONNECTIONS in CREATE USER is limited by 2**32

    XMLWordPrintable

    Details

      Description

      In MariaDB 10.2 MAX_USER_CONNECTIONS cannot be set to a value greater than 2147483647. In MySQL 5.7 bigger values work.
      I don't think it makes a practical difference, but better check if it's intentional, because the produced error code is strange – it fails with a syntax error, not with an overflow or anything like that.

      10.2

      MariaDB [test]> CREATE USER foo IDENTIFIED BY 'Aabcd1$ee' WITH MAX_USER_CONNECTIONS 2147483648;
      ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '2147483648' at line 1
      MariaDB [test]> CREATE USER foo IDENTIFIED BY 'Aabcd1$ee' WITH MAX_USER_CONNECTIONS 2147483647;
      Query OK, 0 rows affected (0.00 sec)
       
      MariaDB [test]> select @@version;
      +----------------------+
      | @@version            |
      +----------------------+
      | 10.2.3-MariaDB-debug |
      +----------------------+
      1 row in set (0.00 sec)
      

      MySQL 5.7

      MySQL [test]> CREATE USER foo IDENTIFIED BY 'Aabcd1$ee' WITH MAX_USER_CONNECTIONS 2147483648;
      Query OK, 0 rows affected (0.01 sec)
       
      MySQL [test]> select @@version;
      +--------------+
      | @@version    |
      +--------------+
      | 5.7.16-debug |
      +--------------+
      1 row in set (0.00 sec)
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              cvicentiu Vicențiu Ciorbaru
              Reporter:
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:

                  Git Integration