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

Unexpected warning while selecting from information_schema.processlist

    XMLWordPrintable

    Details

      Description

      Run this in one session:

      MariaDB [test]> select sleep(100);
      

      and while it runs check the following simple SELECT:

      MariaDB [test]> select id, user, host, progress from information_schema.processlist where info not like '%information%';
      +----+---------+-----------+----------+
      | id | user    | host      | progress |
      +----+---------+-----------+----------+
      |  9 | Valerii | localhost |        0 |
      +----+---------+-----------+----------+
      1 row in set, 1 warning (0.006 sec)
       
      MariaDB [test]> show warnings\G
      *************************** 1. row ***************************
        Level: Warning
         Code: 1918
      Message: Encountered illegal value '' when converting to DECIMAL
      1 row in set (0.000 sec)
       
      MariaDB [test]> select version();
      +-----------------+
      | version()       |
      +-----------------+
      | 10.4.25-MariaDB |
      +-----------------+
      1 row in set (0.002 sec)
       
      MariaDB [test]> select @@sql_mode\G
      *************************** 1. row ***************************
      @@sql_mode: STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
      1 row in set (0.000 sec)
      

      Note the warning that is unexpected and I am not sure how to explain it.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              bar Alexander Barkov
              Reporter:
              valerii Valerii Kravchuk
              Votes:
              0 Vote for this issue
              Watchers:
              5 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.