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

API for running SQL from inside the server

Details

    Description

      There's a set of classes in the server:

      class Protocol_local;
      		 
      class Ed_connection;
      		 
      class Server_runnable;
      		 
      class Execute_sql_statement;

      created to simplify executing SQL statements from inside the server.

      They are not used, and probably cannot be used anymore.

      This task is to fix them, cleanup/simplify perhaps, and use them everywhere in the server where it needs to execute SQL.

      This API should also be usable by plugins.

      Note: often the server does not need to execute SQL, only to parse it, so these classes should allow that too.

      Attachments

        Issue Links

          is part of

          Task - A task that needs to be done. MDEV-19275 Provide SQL service to plugins.

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed
          relates to

          Task - A task that needs to be done. MDEV-4679 PARSER - SANDBOX - parse queries without executing and report what happened

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            serg Sergei Golubchik created issue -
            serg Sergei Golubchik made changes -
            Field Original Value New Value
            Labels plugins
            serg Sergei Golubchik made changes -
            Description There's a set of classes in the server:
            {noformat}
            class Protocol_local;
            class Ed_connection;
            class Server_runnable;
            class Execute_sql_statement;
            {noformat}
            created to simplify executing SQL statements from inside the server.

            They are not used, and probably cannot be used anymore.

            This task is to fix them, cleanup/simplify perhaps, and use them everywhere in the server where it needs to execute SQL.

            *Note*: often the server does not need to _execute_ SQL, only to _parse_ it, so these classes should allow that too.             		There's a set of classes in the server:
            {noformat}
            class Protocol_local;
            class Ed_connection;
            class Server_runnable;
            class Execute_sql_statement;
            {noformat}
            created to simplify executing SQL statements from inside the server.

            They are not used, and probably cannot be used anymore.

            This task is to fix them, cleanup/simplify perhaps, and use them everywhere in the server where it needs to execute SQL.

            This API should also be usable by plugins.

            *Note*: often the server does not need to _execute_ SQL, only to _parse_ it, so these classes should allow that too.
            rspadim roberto spadim made changes -
            serg Sergei Golubchik made changes -
            Priority Minor [ 4 ] Major [ 3 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.1.0 [ 12200 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.1.0 [ 12200 ]
            serg Sergei Golubchik made changes -
            Assignee Alexander Barkov [ bar ]
            serg Sergei Golubchik made changes -
            Priority Major [ 3 ] Minor [ 4 ]
            serg Sergei Golubchik made changes -
            Workflow defaullt [ 27669 ] MariaDB v2 [ 46604 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.1 [ 16100 ]
            Fix Version/s 10.1.0 [ 12200 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Workflow MariaDB v2 [ 46604 ] MariaDB v3 [ 67317 ]
            GeoffMontee Geoff Montee (Inactive) added a comment - - edited

            Justin Swanhart thinks CTE support can be implemented easily once this is finished:

            https://lists.launchpad.net/maria-discuss/msg02662.html

            Should that issue be dependent on MDEV-8308?

            GeoffMontee Geoff Montee (Inactive) added a comment - - edited Justin Swanhart thinks CTE support can be implemented easily once this is finished: https://lists.launchpad.net/maria-discuss/msg02662.html Should that issue be dependent on MDEV-8308 ?
            serg Sergei Golubchik made changes -
            Fix Version/s 10.1 [ 16100 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 67317 ] MariaDB v4 [ 130120 ]
            serg Sergei Golubchik made changes -
            serg Sergei Golubchik made changes -
            Component/s Plugins [ 10118 ]
            Fix Version/s N/A [ 14700 ]
            Resolution Fixed [ 1 ]
            Status Open [ 1 ] Closed [ 6 ]

            People

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