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

Connect Engine: long SRCDEF leads to broken table

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.1.13, 10.0(EOL), 10.1(EOL), 10.2(EOL)
    • 10.1.14
    • None
    • 3.2.0-4-amd64 #1 SMP Debian 3.2.35-2 x86_64 GNU/Linux
    • 10.1.14

    Description

      I've found a problem with connect engine using SRCDEF notation when creating a table. The problem is a broken table created when SRCDEF parameter contains an sql query more than 32 kb long. For example, sql query with long list of ids in "where x IN ( ... )" conditional statement.

      The following error appears on create table: "Engine CONNECT failed to discover table `db`.`connect_1` with 'CREATE TABLE whatever .... skip

      The table can't be dropped due to the error: "Incorrect information in file './db/connect_1.frm'".

      The desired behaviour is to get the ability to use long queries in SRCDEF parameter with the length limited by some configuration parameter.

      Attachments

        Activity

          People

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