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

last_query_cost is 0.00 for some queries

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.4(EOL), 10.5(EOL)
    • 10.6
    • Optimizer
    • None

    Description

      CREATE TABLE t1 (a INT, b INT, KEY (a), KEY (a,b));
      CREATE TABLE t2 (c INT, KEY (c));
       
      SELECT * FROM t1 t1a JOIN t1 t1b;
       
      INSERT INTO t2 VALUES (1),(2);
      INSERT INTO t1 VALUES (1,2),(3,4),(5,6),(7,8),(9,10),(11,12);
      

      SELECT *
      FROM
        t1 JOIN
        (SELECT t1.a, t1.b FROM t1, t2 WHERE t1.b = t2.c GROUP BY t1.a, t1.b) as dt
      WHERE
        t1.a = dt.a;
      

      show status like "last_query_cost";
      DROP TABLE t1, t2;
      

      This will output:

      Variable_name   Value
      Last_query_cost 0.000000
      

      Attachments

        Activity

          People

            psergei Sergei Petrunia
            monty Michael Widenius
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.