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

incorrect row estimates in Connect

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Won't Fix
    • Affects Version/s: 10.0.11
    • Fix Version/s: 10.0.12
    • Component/s: None
    • Labels:

      Description

      Copy the following test case into a file under storage/connect/mysql-test/connect/t:

      CREATE TABLE t1 (c INT PRIMARY KEY) ENGINE=CONNECT TABLE_TYPE=CSV;
      INSERT INTO t1 VALUES (1),(2);
      --query_vertical EXPLAIN SELECT AVG(c) FROM t1
      drop table t1;

      Observe that the result contains

      rows    4

      even though the table has only two rows. This becomes important when the number of rows in the table grows large.

        Attachments

          Activity

            People

            Assignee:
            bertrandop Olivier Bertrand
            Reporter:
            serg Sergei Golubchik
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: