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 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 made changes -
            Assignee Roel Van de Paar [ roel ] Yuchen Pei [ JIRAUSER52627 ]
            Status In Testing [ 10301 ] Stalled [ 10000 ]
            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.