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

Command-line client keeps showing database in prompt after changing user

Details

    Description

      MariaDB [test]> set session authorization foo@localhost;
      Query OK, 0 rows affected (0.001 sec)
       
      MariaDB [test]> select database();
      +------------+
      | database() |
      +------------+
      | NULL       |
      +------------+
      1 row in set (0.001 sec)
       
      MariaDB [test]> 
      

      It is a bit misleading if a user doesn't expect it and then hits "No database selected".

      Attachments

        Issue Links

          Activity

            elenst Elena Stepanova created issue -
            elenst Elena Stepanova made changes -
            Field Original Value New Value
            elenst Elena Stepanova made changes -
            Description {code:sql:title=d4c600f804af677ac3177497b3770dbd67c448f7}
            MariaDB [test]> set session authorization foo@localhost;
            Query OK, 0 rows affected (0.001 sec)

            MariaDB [test]> select database();
            +------------+
            | database() |
            +------------+
            | NULL |
            +------------+
            1 row in set (0.001 sec)

            MariaDB [test]>
            {code}

            It is a bit misleading if a user doesn't expect it and then hits "No database selected".
            elenst Elena Stepanova made changes -
            Assignee Sergei Golubchik [ serg ]
            serg Sergei Golubchik made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            serg Sergei Golubchik made changes -
            Status In Progress [ 3 ] In Testing [ 10301 ]

            People

              serg Sergei Golubchik
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.