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

SHOW CREATE USER generates invalid SQL (password expiry/ account lock)

Details

    Description

      MariaDB [(none)]> show create user 'mariadb.sys'@'localhost';
      +--------------------------------------------------------------------+
      | CREATE USER for mariadb.sys@localhost                              |
      +--------------------------------------------------------------------+
      | CREATE USER `mariadb.sys`@`localhost` PASSWORD EXPIRE ACCOUNT LOCK |
      +--------------------------------------------------------------------+
      1 row in set (0.000 sec)
       
      MariaDB [(none)]> CREATE USER `mariadb.sys`@`localhost` PASSWORD EXPIRE ACCOUNT LOCK;
      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 'ACCOUNT LOCK' at line 1
      

      Attachments

        Activity

          danblack Daniel Black added a comment - - edited

          pushed.

          TODO: documentation update

          create user / alter user now accept both options in either order.

          previously accepted "LOCKED" ... "PASSWORD EXPIRE" order only.

          danblack Daniel Black added a comment - - edited pushed. TODO: documentation update create user / alter user now accept both options in either order. previously accepted "LOCKED" ... "PASSWORD EXPIRE" order only.
          danblack Daniel Black added a comment -

          kb documents updated

          danblack Daniel Black added a comment - kb documents updated
          robertbindar Robert Bindar added a comment -

          Hi danblack, is the patch for this MDEV pushed? Looked over the patch here and if that's the final version, please note that the yacc_ora parser wasn't updated with the new options. Also please update the naming of the options so that they are consistent with each other, i.e. opt_, option, opt.._option

          robertbindar Robert Bindar added a comment - Hi danblack , is the patch for this MDEV pushed? Looked over the patch here and if that's the final version, please note that the yacc_ora parser wasn't updated with the new options. Also please update the naming of the options so that they are consistent with each other, i.e. opt_, option, opt .._option
          danblack Daniel Black added a comment -

          Yes it was pushed. I did miss yacc_ora so bb-MDEV-24098-show-create-user-oracle-syntax submitted and I'll look at merging next week. Thanks for noticing.

          Convention of opt_* is can be blank and *_option is an option of a syntax has been applied.

          danblack Daniel Black added a comment - Yes it was pushed. I did miss yacc_ora so bb- MDEV-24098 -show-create-user-oracle-syntax submitted and I'll look at merging next week. Thanks for noticing. Convention of opt_* is can be blank and *_option is an option of a syntax has been applied.
          danblack Daniel Black added a comment -

          Pushed oracle mode fix. f5d2d455a6fa9f55f65238f27a625efe1d8ba5d9

          danblack Daniel Black added a comment - Pushed oracle mode fix. f5d2d455a6fa9f55f65238f27a625efe1d8ba5d9

          People

            danblack Daniel Black
            danblack Daniel Black
            Votes:
            0 Vote for this issue
            Watchers:
            5 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.