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

Connect Engine: long SRCDEF leads to broken table

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.1.13, 10.0, 10.1, 10.2
    • Fix Version/s: 10.1.14
    • Labels:
      None
    • Environment:
      3.2.0-4-amd64 #1 SMP Debian 3.2.35-2 x86_64 GNU/Linux
    • Sprint:
      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

            Assignee:
            serg Sergei Golubchik
            Reporter:
            Sergey.Antonyuk Sergey Antonyuk
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration