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

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

          relates to

          Task - A task that needs to be done. MDEV-7978 CREATE/ALTER USER as in 5.7

          • Major - Major loss of function.
          • Closed

          Activity

            People

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

              Dates

                Created:
                Updated:

                Git Integration

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