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

Optimizer trace: table_scan.rows is traced as integer, change to double

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Cannot Reproduce
    • 10.4, 10.5, 10.6, 10.8, 10.9, 10.10, 10.11, 11.0
    • N/A
    • Optimizer
    • None

    Description

      I am looking at 10.6 but earlier versions are likely affected, too.

      Looking at outputs like this

                    {
                      "table": "ix",
                      "table_scan": {
                        "rows": 1289434,
                        "cost": 23103
                      }
      

      "cost" is always integer?
      Debugging the code in add_table_scan_values_to_trace() (one of the TWO places which log "table_scan" objects). I see that the cost is double but is written as integer.

      Please make sure it is written as double in BOTH places, starting from the earliest applicable version.

      Attachments

        Activity

          People

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