Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.3.32, 10.4.25, 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL)
-
None
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
- duplicates
-
MDEV-27673 Warning after "select progress from information_schema.processlist"
- Closed