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

        1. mdev9949.sql
          34 kB
          Elena Stepanova

          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