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

Allow arbitrary options in CREATE SERVER

Details

    • New Feature
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 11.7.1
    • Server
    • None

    Description

      The existing syntax for CREATE SERVER:

      CREATE [OR REPLACE] SERVER [IF NOT EXISTS] server_name
      		 
          FOREIGN DATA WRAPPER wrapper_name
      		 
          OPTIONS (option [, option] ...)


      option:
      		 
        { HOST character-literal
      		 
        | DATABASE character-literal
      		 
        | USER character-literal
      		 
        | PASSWORD character-literal
      		 
        | SOCKET character-literal
      		 
        | OWNER character-literal
      		 
        | PORT numeric-literal }

      With this change we will have:

      option:
      		 
        { HOST character-literal
      		 
        | DATABASE character-literal
      		 
        | USER character-literal
      		 
        | PASSWORD character-literal
      		 
        | SOCKET character-literal
      		 
        | OWNER character-literal
      		 
        | PORT numeric-literal
      		 
        | PORT quoted-numerical-literal
      		 
        | identifier character-literal}

      Attachments

        Issue Links

          blocks

          New Feature - A new feature of the product, which has yet to be developed. MDEV-33925 Add TLS-related options for CREATE SERVER

          • Major - Major loss of function.
          • Open
          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35136 Sporadic hang on shutdown after using [SHOW] CREATE SERVER syntax

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35557 SIGSEGV in get_server_from_table_to_cache | servers_load, UBSAN null pointer passed as argument 1, which is declared to never be null

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-36087 MariDB 11.7.2 - /usr/sbin/mariadbd got signal 11

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed
          is blocked by

          New Feature - A new feature of the product, which has yet to be developed. MDEV-15696 Implement SHOW CREATE SERVER

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-34872 Inconsistency of json fields character sets

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          is part of

          New Feature - A new feature of the product, which has yet to be developed. MDEV-15696 Implement SHOW CREATE SERVER

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35153 backport the MDEV-34716 fix of socket length in mysql.servers

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          split from

          Task - A task that needs to be done. MDEV-34272 Implement ODBC Connection Keywords (aka parameters) as OPTIONS for CREATE SERVER

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            ycp Yuchen Pei created issue -
            ycp Yuchen Pei made changes -
            Field Original Value New Value
            ycp Yuchen Pei made changes -
            ycp Yuchen Pei made changes -
            ycp Yuchen Pei made changes -
            ycp Yuchen Pei made changes -
            ycp Yuchen Pei made changes -
            ycp Yuchen Pei made changes -
            Fix Version/s 11.7 [ 29815 ]
            ycp Yuchen Pei made changes -
            ycp Yuchen Pei added a comment -

            Currently under review as a part of MDEV-15696

            ycp Yuchen Pei added a comment - Currently under review as a part of MDEV-15696
            ycp Yuchen Pei made changes -
            serg Sergei Golubchik made changes -
            Fix Version/s 11.8 [ 29921 ]
            Fix Version/s 11.7 [ 29815 ]
            ycp Yuchen Pei made changes -
            Fix Version/s 11.7 [ 29815 ]
            Fix Version/s 11.8 [ 29921 ]
            ycp Yuchen Pei made changes -
            serg Sergei Golubchik made changes -
            ralf.gebhardt Ralf Gebhardt made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Status In Progress [ 3 ] In Testing [ 10301 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Assignee Yuchen Pei [ JIRAUSER52627 ] Roel Van de Paar [ roel ]
            Roel Roel Van de Paar made changes -
            Description The existing syntax for CREATE SERVER:

            CREATE [OR REPLACE] SERVER [IF NOT EXISTS] server_name
                FOREIGN DATA WRAPPER wrapper_name
                OPTIONS (option [, option] ...)

            option:
              { HOST character-literal
              | DATABASE character-literal
              | USER character-literal
              | PASSWORD character-literal
              | SOCKET character-literal
              | OWNER character-literal
              | PORT numeric-literal }

            With this change we will have:

            option:
              { HOST character-literal
              | DATABASE character-literal
              | USER character-literal
              | PASSWORD character-literal
              | SOCKET character-literal
              | OWNER character-literal
              | PORT numeric-literal
            * | PORT quoted-numerical-literal
              | identifier character-literal*}
            Roel Roel Van de Paar made changes -
            Description The existing syntax for CREATE SERVER:

            CREATE [OR REPLACE] SERVER [IF NOT EXISTS] server_name
                FOREIGN DATA WRAPPER wrapper_name
                OPTIONS (option [, option] ...)

            option:
              { HOST character-literal
              | DATABASE character-literal
              | USER character-literal
              | PASSWORD character-literal
              | SOCKET character-literal
              | OWNER character-literal
              | PORT numeric-literal }

            With this change we will have:

            option:
              { HOST character-literal
              | DATABASE character-literal
              | USER character-literal
              | PASSWORD character-literal
              | SOCKET character-literal
              | OWNER character-literal
              | PORT numeric-literal
            * | PORT quoted-numerical-literal
              | identifier character-literal*}
            		The existing syntax for CREATE SERVER:
            {noformat}
            CREATE [OR REPLACE] SERVER [IF NOT EXISTS] server_name
                FOREIGN DATA WRAPPER wrapper_name
                OPTIONS (option [, option] ...)

            option:
              { HOST character-literal
              | DATABASE character-literal
              | USER character-literal
              | PASSWORD character-literal
              | SOCKET character-literal
              | OWNER character-literal
              | PORT numeric-literal }

            With this change we will have:

            option:
              { HOST character-literal
              | DATABASE character-literal
              | USER character-literal
              | PASSWORD character-literal
              | SOCKET character-literal
              | OWNER character-literal
              | PORT numeric-literal
            * | PORT quoted-numerical-literal
              | identifier character-literal*}
            {noformat}
            Roel Roel Van de Paar made changes -
            Description The existing syntax for CREATE SERVER:
            {noformat}
            CREATE [OR REPLACE] SERVER [IF NOT EXISTS] server_name
                FOREIGN DATA WRAPPER wrapper_name
                OPTIONS (option [, option] ...)

            option:
              { HOST character-literal
              | DATABASE character-literal
              | USER character-literal
              | PASSWORD character-literal
              | SOCKET character-literal
              | OWNER character-literal
              | PORT numeric-literal }

            With this change we will have:

            option:
              { HOST character-literal
              | DATABASE character-literal
              | USER character-literal
              | PASSWORD character-literal
              | SOCKET character-literal
              | OWNER character-literal
              | PORT numeric-literal
            * | PORT quoted-numerical-literal
              | identifier character-literal*}
            {noformat}             		The existing syntax for CREATE SERVER:
            {noformat}
            CREATE [OR REPLACE] SERVER [IF NOT EXISTS] server_name
                FOREIGN DATA WRAPPER wrapper_name
                OPTIONS (option [, option] ...)
            {noformat}
            {noformat}
            option:
              { HOST character-literal
              | DATABASE character-literal
              | USER character-literal
              | PASSWORD character-literal
              | SOCKET character-literal
              | OWNER character-literal
              | PORT numeric-literal }
            {noformat}
            With this change we will have:
            {noformat}
            option:
              { HOST character-literal
              | DATABASE character-literal
              | USER character-literal
              | PASSWORD character-literal
              | SOCKET character-literal
              | OWNER character-literal
              | PORT numeric-literal
            * | PORT quoted-numerical-literal
              | identifier character-literal*}
            {noformat}
            Roel Roel Van de Paar made changes -
            Description The existing syntax for CREATE SERVER:
            {noformat}
            CREATE [OR REPLACE] SERVER [IF NOT EXISTS] server_name
                FOREIGN DATA WRAPPER wrapper_name
                OPTIONS (option [, option] ...)
            {noformat}
            {noformat}
            option:
              { HOST character-literal
              | DATABASE character-literal
              | USER character-literal
              | PASSWORD character-literal
              | SOCKET character-literal
              | OWNER character-literal
              | PORT numeric-literal }
            {noformat}
            With this change we will have:
            {noformat}
            option:
              { HOST character-literal
              | DATABASE character-literal
              | USER character-literal
              | PASSWORD character-literal
              | SOCKET character-literal
              | OWNER character-literal
              | PORT numeric-literal
            * | PORT quoted-numerical-literal
              | identifier character-literal*}
            {noformat}             		The existing syntax for CREATE SERVER:
            {noformat}
            CREATE [OR REPLACE] SERVER [IF NOT EXISTS] server_name
                FOREIGN DATA WRAPPER wrapper_name
                OPTIONS (option [, option] ...)
            {noformat}
            {noformat}
            option:
              { HOST character-literal
              | DATABASE character-literal
              | USER character-literal
              | PASSWORD character-literal
              | SOCKET character-literal
              | OWNER character-literal
              | PORT numeric-literal }
            {noformat}
            With this change we will have:
            {noformat}
            option:
              { HOST character-literal
              | DATABASE character-literal
              | USER character-literal
              | PASSWORD character-literal
              | SOCKET character-literal
              | OWNER character-literal
              | PORT numeric-literal
              | PORT quoted-numerical-literal
              | identifier character-literal}
            {noformat}
            Roel Roel Van de Paar made changes -
            Roel Roel Van de Paar added a comment -

            Testing was included with MDEV-15696

            OK to push

            Roel Roel Van de Paar added a comment - Testing was included with MDEV-15696 OK to push
            Roel Roel Van de Paar made changes -
            Assignee Roel Van de Paar [ roel ] Yuchen Pei [ JIRAUSER52627 ]
            Status In Testing [ 10301 ] Stalled [ 10000 ]
            ycp Yuchen Pei added a comment -

            thanks for the testing Roel. Pushed as part of MDEV-15696.

            As mentioned in https://jira.mariadb.org/browse/MDEV-15696?focusedCommentId=289669&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-289669, the two cleanup and bugfix commits (see below) will also be pushed to the earliest version applicable

            2345407b8c2 MDEV-34716 Fix mysql.servers socket max length too short
            		 
            84df8d72751 MDEV-34716 spider: some trivial cleanups and documentation

            ycp Yuchen Pei added a comment - thanks for the testing Roel . Pushed as part of MDEV-15696 . As mentioned in https://jira.mariadb.org/browse/MDEV-15696?focusedCommentId=289669&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-289669 , the two cleanup and bugfix commits (see below) will also be pushed to the earliest version applicable 2345407b8c2 MDEV-34716 Fix mysql.servers socket max length too short 84df8d72751 MDEV-34716 spider: some trivial cleanups and documentation
            ycp Yuchen Pei made changes -
            Fix Version/s 11.7.1 [ 29913 ]
            Fix Version/s 11.7 [ 29815 ]
            Resolution Fixed [ 1 ]
            Status Stalled [ 10000 ] Closed [ 6 ]
            ycp Yuchen Pei made changes -
            serg Sergei Golubchik made changes -
            Issue Type Task [ 3 ] New Feature [ 2 ]
            ycp Yuchen Pei made changes -
            elenst Elena Stepanova made changes -

            People

              ycp Yuchen Pei
              ycp Yuchen Pei
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.