Details
-
Bug
-
Status: Open (View Workflow)
-
Trivial
-
Resolution: Unresolved
-
10.2
-
None
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
-
MDEV-7978 CREATE/ALTER USER as in 5.7
-
- Closed
-