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

the CONNECT plugin fails to transfer table column defaults

Details

    Description

      suppose you map a table with a column: varchar(100) not null default ''; then the CONNECT engine will not show the default ''.
      You only have to do a describe table or a show create table on the remote server to see the issue

      Attachments

        Activity

          philip_38 Philip orleans added a comment -

          The connect engine ahs more problems:
          I create the source table at server (a) like
          CREATE TABLE obviousfraud (
          keyword varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
          PRIMARY KEY (keyword)
          )
          there is no error
          But when I create the same table a the remote server, I get
          CREATE TABLE obviousfraud (
          keyword varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
          PRIMARY KEY (keyword)
          )
          ENGINE = CONNECT,
          TABLE_TYPE = MYSQL,
          DBNAME = 'api',
          TABNAME = 'obviousfraud',
          CHARACTER SET utf8mb4,
          COLLATE utf8mb4_unicode_ci,
          CONNECTION = 'mysql://XXXX',
          ROW_FORMAT = DYNAMIC;
          Error (24,1): Specified key was too long; max key length is 255 bytes

          philip_38 Philip orleans added a comment - The connect engine ahs more problems: I create the source table at server (a) like CREATE TABLE obviousfraud ( keyword varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (keyword) ) there is no error But when I create the same table a the remote server, I get CREATE TABLE obviousfraud ( keyword varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (keyword) ) ENGINE = CONNECT, TABLE_TYPE = MYSQL, DBNAME = 'api', TABNAME = 'obviousfraud', CHARACTER SET utf8mb4, COLLATE utf8mb4_unicode_ci, CONNECTION = 'mysql://XXXX', ROW_FORMAT = DYNAMIC; Error (24,1): Specified key was too long; max key length is 255 bytes

          People

            Unassigned Unassigned
            philip_38 Philip orleans
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.