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

START SLAVE ,,,,,, is accepted as valid syntax

Details

    • Bug
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 10.11.4
    • 10.5, 10.6, 10.11
    • Parser
    • None

    Description

      MariaDB [test]> START SLAVE ,,,,,,;
      Query OK, 0 rows affected, 1 warning (0.000 sec)
      

      The same also seems to apply to STOP SLAVE.

      Looking at the code, we see that the syntax for it is defined as follows:

      slave_thread_opt_list:
                slave_thread_opt
      	| slave_thread_opt_list ',' slave_thread_opt
      	;
       
      slave_thread_opt:
                /*empty*/ {}
              | SQL_THREAD   { Lex->slave_thd_opt|=SLAVE_SQL; }
              | RELAY_THREAD { Lex->slave_thd_opt|=SLAVE_IO; }
              ;
      

      I believe the empty value should be in slave_thread_opt_list and not in slave_thread_opt; this way an empty value or a list of SQL or IO thread variables is accepted.

      Attachments

        Activity

          Agree that this was probably not intended. But I'd suggest to not change it. It doesn't seem to hurt anything, and it only risks breaking some odd script out there that accidentally ended up with an extra comma.

          knielsen Kristian Nielsen added a comment - Agree that this was probably not intended. But I'd suggest to not change it. It doesn't seem to hurt anything, and it only risks breaking some odd script out there that accidentally ended up with an extra comma.
          markus makela markus makela added a comment -

          Yes, this is the definition of a cosmetic issue. Perhaps mentioning it in the documentation for the START SLAVE command is enough as a fix.

          markus makela markus makela added a comment - Yes, this is the definition of a cosmetic issue. Perhaps mentioning it in the documentation for the START SLAVE command is enough as a fix.

          People

            Unassigned Unassigned
            markus makela markus makela
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.