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

EXAMINED_ROWS is not populated in information_schema.processlist upon SELECT

    XMLWordPrintable

Details

    Description

      The test case is not suitable for the regression suite, don't push it as is, create a deterministic one instead!

      --source include/have_sequence.inc
       
      --connect(con1,localhost,root,,)
      --send
        select * from seq_1_to_10000000 where seq%1000000 = 0;
       
      --connection default
      --let $run= 10
      while ($run)
      {
        --sleep 1
        query_vertical select * from information_schema.processlist where id != connection_id();
        --dec $run
      }
       
      --connection con1
      --reap
      

      10.4 9b5275b8

      select * from information_schema.processlist where id != connection_id();
      ID	5
      USER	root
      HOST	localhost
      DB	test
      COMMAND	Query
      TIME	10
      STATE	Sending data
      INFO	select * from seq_1_to_10000000 where seq%1000000 = 0
      TIME_MS	10031.634
      STAGE	0
      MAX_STAGE	0
      PROGRESS	0.000
      MEMORY_USED	106424
      MAX_MEMORY_USED	106424
      EXAMINED_ROWS	0
      QUERY_ID	23
      INFO_BINARY	select * from seq_1_to_10000000 where seq%1000000 = 0
      TID	2218428
      connection con1;
      seq
      1000000
      2000000
      3000000
      4000000
      5000000
      6000000
      7000000
      8000000
      9000000
      10000000
      

      Reproducible on all existing versions.

      Attachments

        Issue Links

          Activity

            People

              monty Michael Widenius
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.