Details

    Description

      In the MariaDB catalog tree all mtr test works.
      However the test only checks that we can connect to another server with the same catalog name.

      This task is to ensure that catalogs are fully supported by connect.
      In particular one should be able to create a MariaDB linked catalog table that can:

      • Connect from a server with catalogs to another server with a different catalog
      • Connect from a server with catalogs to a server without catalogs.
      • Connect from a server without catalogs to a server with catalogs.
      • For this to work, there may be some changes needed in sql-common/client.c

      The following already works:

      • Connecting from a server without catalogs to a server without catalogs (default setup).
      • Connecting from a server with catalogs to the same catalog on another server.

      Things to do:

      • Add a catalog option to the connect CREATE TABLE (similar to the way that databases are specified). If no catalog option is used, then the current catalog is used.
      • If catalogs are used, add catalog to the database with a '.' between catalog and database.
      • Fix sql-common/client.cc to support connecting from a non catalog server to a catalog server.
      • Add mtr test to cover all the connect options.

      Attachments

        Issue Links

          Activity

            monty Michael Widenius created issue -
            monty Michael Widenius made changes -
            Field Original Value New Value
            monty Michael Widenius made changes -
            TheLinuxJedi Andrew Hutchings (Inactive) made changes -
            Fix Version/s 11.3 [ 28565 ]
            Fix Version/s 10.3 [ 22126 ]
            monty Michael Widenius made changes -
            Issue Type Bug [ 1 ] Task [ 3 ]
            TheLinuxJedi Andrew Hutchings (Inactive) made changes -
            Status Open [ 1 ] In Progress [ 3 ]

            Implemented in my branch. Only thing not working is the mysql_index test when catalogs are enabled. It looks like the index does not get created. Looking into that.

            TheLinuxJedi Andrew Hutchings (Inactive) added a comment - Implemented in my branch. Only thing not working is the mysql_index test when catalogs are enabled. It looks like the index does not get created. Looking into that.

            All done, in the linuxjedi-cat branch. One commit for the catalogs support, one commit to fix one of the tests that was not generic enough for catalogs support.

            TheLinuxJedi Andrew Hutchings (Inactive) added a comment - All done, in the linuxjedi-cat branch. One commit for the catalogs support, one commit to fix one of the tests that was not generic enough for catalogs support.
            TheLinuxJedi Andrew Hutchings (Inactive) made changes -
            Status In Progress [ 3 ] In Testing [ 10301 ]
            TheLinuxJedi Andrew Hutchings (Inactive) made changes -
            Assignee Andrew Hutchings [ JIRAUSER52179 ] Michael Widenius [ monty ]
            TheLinuxJedi Andrew Hutchings (Inactive) made changes -
            Status In Testing [ 10301 ] Stalled [ 10000 ]
            TheLinuxJedi Andrew Hutchings (Inactive) made changes -
            Status Stalled [ 10000 ] Open [ 1 ]
            TheLinuxJedi Andrew Hutchings (Inactive) made changes -
            Status Open [ 1 ] Needs Feedback [ 10501 ]
            TheLinuxJedi Andrew Hutchings (Inactive) made changes -
            Status Needs Feedback [ 10501 ] Open [ 1 ]
            TheLinuxJedi Andrew Hutchings (Inactive) made changes -
            Status Open [ 1 ] Needs Feedback [ 10501 ]
            TheLinuxJedi Andrew Hutchings (Inactive) made changes -
            Status Needs Feedback [ 10501 ] Open [ 1 ]
            greenman Ian Gilfillan made changes -
            Assignee Michael Widenius [ monty ] Ian Gilfillan [ greenman ]
            serg Sergei Golubchik made changes -
            Fix Version/s 11.4 [ 29301 ]
            Fix Version/s 11.3 [ 28565 ]
            cvicentiu Vicențiu Ciorbaru made changes -
            Assignee Ian Gilfillan [ greenman ] Michael Widenius [ monty ]
            cvicentiu Vicențiu Ciorbaru made changes -
            Assignee Michael Widenius [ monty ] Vicențiu Ciorbaru [ cvicentiu ]
            cvicentiu Vicențiu Ciorbaru made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            cvicentiu Vicențiu Ciorbaru made changes -
            Assignee Vicențiu Ciorbaru [ cvicentiu ] Michael Widenius [ monty ]
            Status In Progress [ 3 ] In Review [ 10002 ]

            Review, adapted and merged to Catalog ttree

            monty Michael Widenius added a comment - Review, adapted and merged to Catalog ttree
            monty Michael Widenius made changes -
            issue.field.resolutiondate 2023-11-20 13:59:34.0 2023-11-20 13:59:33.997
            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 ]
            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:
              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.