Details

    Description

      The servers table table is already stored per catalog.

      • Test that "servers" table works per catalog.
      • Ensure that we create the 'servers' table in each catalog mysql's datadir.
      • Ensure one can connect to from a server compiled with and without catalogs:
        (Same requirement as with catalogs and the connect engine)
      • A table in another catalog.
      • A table in a non catalog server.
      • Add 'catalog' name to mysql.servers
      • Remember to fix this in mysql_fix_privileges

      Things to look at:
      sql_servers.cc
      bool servers_init(bool dont_read_servers_table)

      Attachments

        Issue Links

          Activity

            monty Michael Widenius created issue -
            monty Michael Widenius made changes -
            Field Original Value New Value
            monty Michael Widenius made changes -
            Description The servers table table is already stored per catalog.
            - Test that severs works per catalog
            - Add 'catalog' name to mysql.servers
              - Remember to fix this in mysql_fix_privileges

            Things to look at:
            sql_servers.cc
            bool servers_init(bool dont_read_servers_table)
            The servers table table is already stored per catalog.
            - Test that "servers" table works per catalog.
              - Ensure that we create the 'servers' table in each catalog mysql's datadir.
            - Ensure one can connect to from a server compiled with and without catalogs:
            (Same requirement as with catalogs and the connect engine)
              - A table in another catalog.
              - A table in a non catalog server.
            - Add 'catalog' name to mysql.servers
              - Remember to fix this in mysql_fix_privileges

            Things to look at:
            sql_servers.cc
            bool servers_init(bool dont_read_servers_table)
            monty Michael Widenius made changes -
            TheLinuxJedi Andrew Hutchings (Inactive) made changes -
            Assignee Andrew Hutchings [ JIRAUSER52179 ]
            TheLinuxJedi Andrew Hutchings (Inactive) made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            TheLinuxJedi Andrew Hutchings (Inactive) made changes -
            Status In Progress [ 3 ] Stalled [ 10000 ]
            TheLinuxJedi Andrew Hutchings (Inactive) made changes -
            Status Stalled [ 10000 ] In Progress [ 3 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 11.4 [ 29301 ]
            Fix Version/s 11.3 [ 28565 ]
            TheLinuxJedi Andrew Hutchings (Inactive) made changes -
            Status In Progress [ 3 ] Stalled [ 10000 ]
            TheLinuxJedi Andrew Hutchings (Inactive) made changes -
            Status Stalled [ 10000 ] In Progress [ 3 ]
            TheLinuxJedi Andrew Hutchings (Inactive) made changes -
            Assignee Andrew Hutchings [ JIRAUSER52179 ] Michael Widenius [ monty ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            monty Michael Widenius made changes -
            issue.field.resolutiondate 2023-11-20 13:58:46.0 2023-11-20 13:58:46.41
            monty Michael Widenius made changes -
            Fix Version/s N/A [ 14700 ]
            Fix Version/s 11.4 [ 29301 ]
            Resolution Fixed [ 1 ]
            Status In Review [ 10002 ] Closed [ 6 ]
            TheLinuxJedi Andrew Hutchings (Inactive) made changes -
            ralf.gebhardt Ralf Gebhardt made changes -
            Parent MDEV-31542 [ 123006 ]
            Issue Type Task [ 3 ] Technical task [ 7 ]
            ralf.gebhardt Ralf Gebhardt made changes -

            People

              monty Michael Widenius
              monty Michael Widenius
              Votes:
              0 Vote for this issue
              Watchers:
              5 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.