Bug #120525 Append-Only Growth Breaks Subset Monotonicity for Implicit VARCHAR-to-DECIMAL IN-Subquery Comparison
Submitted: 22 May 9:41 Modified: 26 May 6:49
Reporter: Y F Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Optimizer Severity:S2 (Serious)
Version:8.0.45 OS:Ubuntu (Ubuntu 20.04.4 LTS)
Assigned to: CPU Architecture:x86 (Intel(R) Xeon(R) Platinum 8358P @ 2.60GHz (64 Cores, 96MB L3 Cache))

[22 May 9:41] Y F 
Description:
This issue can be described using two execution states over the same tables.

In the baseline execution state S1, after creating the tables, inserting a
small initial seed, and evaluating the query, the following row is returned:

------------------------------------
mysql> SELECT /*implicit_conversion_in*/
    ->        COALESCE(sub1.c5, '2023-01-01'),
    ->        sub1.c2,
    ->        CASE WHEN sub1.c1 >= -12 THEN sub1.c1 ELSE -12 END
    -> FROM subset3_c45fceaa sub1
    -> WHERE sub1.c2 = 'hv_369'
    ->   AND sub1.c3 IN (
    ->       SELECT sq2.c3
    ->       FROM subset3_ref_c45fceaa_t2 sq2
    ->   )
    -> ORDER BY sub1.c3 DESC;
+-------------------------------------+--------+--------------------------------------------------------------+
| COALESCE(`sub1`.`c5`, '2023-01-01') | c2     | (CASE WHEN `sub1`.`c1` >= -12 THEN `sub1`.`c1` ELSE -12 END) |
+-------------------------------------+--------+--------------------------------------------------------------+
| 0000-00-00                          | hv_369 | 3621650                                                      |
+-------------------------------------+--------+--------------------------------------------------------------+
1 row in set
------------------------------------

Then additional rows are appended to `subset3_c45fceaa`, `ANALYZE TABLE` is
run, and the same query is executed again over the enlarged table state S2.
At that point the query returns 21 rows, but the original S1 witness row
`3621650` disappears completely:

------------------------------------
mysql> SELECT /*implicit_conversion_in*/
    ->        COALESCE(sub1.c5, '2023-01-01'),
    ->        sub1.c2,
    ->        CASE WHEN sub1.c1 >= -12 THEN sub1.c1 ELSE -12 END
    -> FROM subset3_c45fceaa sub1
    -> WHERE sub1.c2 = 'hv_369'
    ->   AND sub1.c3 IN (
    ->       SELECT sq2.c3
    ->       FROM subset3_ref_c45fceaa_t2 sq2
    ->   )
    -> ORDER BY sub1.c3 DESC;
+-------------------------------------+--------+--------------------------------------------------------------+
| COALESCE(`sub1`.`c5`, '2023-01-01') | c2     | (CASE WHEN `sub1`.`c1` >= -12 THEN `sub1`.`c1` ELSE -12 END) |
+-------------------------------------+--------+--------------------------------------------------------------+
| 0000-00-00                          | hv_369 | 9788549                                                      |
| 2023-01-01                          | hv_369 | 9700493                                                      |
| 0000-00-00                          | hv_369 | 2049379                                                      |
| 0000-00-00                          | hv_369 | 2966327                                                      |
| 0000-00-00                          | hv_369 | 3182257                                                      |
| 0000-00-00                          | hv_369 | 4265701                                                      |
| 2023-01-01                          | hv_369 | 8937410                                                      |
| 0000-00-00                          | hv_369 | 6190018                                                      |
| 2007-05-09                          | hv_369 | 8228006                                                      |
| 2023-01-01                          | hv_369 | 9219784                                                      |
| 0000-00-00                          | hv_369 | 729206                                                       |
| 0000-00-00                          | hv_369 | 9220168                                                      |
| 0000-00-00                          | hv_369 | 9124480                                                      |
| 0000-00-00                          | hv_369 | 8965887                                                      |
| 2023-01-01                          | hv_369 | 8409405                                                      |
| 0000-00-00                          | hv_369 | 7787779                                                      |
| 0000-00-00                          | hv_369 | 6831517                                                      |
| 2012-03-15                          | hv_369 | 4515233                                                      |
| 2023-01-01                          | hv_369 | 3575338                                                      |
| 2023-01-01                          | hv_369 | 2887479                                                      |
| 0000-00-00                          | hv_369 | 7789219                                                      |
+-------------------------------------+--------+--------------------------------------------------------------+
21 rows in set
------------------------------------

This is an append-only monotonicity violation. S2 is produced from S1 only by
inserting more rows into the outer table. No rows from S1 are deleted or
updated, and the query predicate is unchanged. Therefore every row returned in
S1 must still be returned in S2. Instead, the observed relationship is:

------------------------------------
ROWS(S1) = { 3621650 }
ROWS(S2) = {
  9788549, 9700493, 2049379, 2966327, 3182257, 4265701, 8937410,
  6190018, 8228006, 9219784, 729206, 9220168, 9124480, 8965887,
  8409405, 7787779, 6831517, 4515233, 3575338, 2887479, 7789219
}

3621650 ∈ ROWS(S1)
3621650 ∉ ROWS(S2)
------------------------------------

So the expected subset relationship `ROWS(S1) ⊆ ROWS(S2)` is broken.

The predicate depends on an implicit cross-type membership test:

------------------------------------
sub1.c3 IN (SELECT sq2.c3 FROM subset3_ref_c45fceaa_t2 sq2)
------------------------------------

where `sub1.c3` is `VARCHAR(255)` and `sq2.c3` is `DECIMAL(10,2)`. The issue
therefore appears to be a wrong-result bug in MySQL's handling of implicit
`VARCHAR`-to-`DECIMAL` conversion for `IN (subquery)` evaluation. The result
set changes incorrectly after append-only growth and statistics refresh, even
though the original matching row remains present and unchanged.

One unrelated statement in the minimized script fails:

------------------------------------
mysql> CREATE INDEX i_s3_c45fceaa_c6 ON subset3_c45fceaa (c6(64));
ERROR 1089 (HY000): Incorrect prefix key ...
------------------------------------

This error is not the cause of the wrong result. The bug still reproduces
after the failed index creation because the final query returns the incorrect
S2 result set shown above.

How to repeat:
CREATE TABLE subset3_c45fceaa (
    c1 INT NOT NULL AUTO_INCREMENT,
    c2 VARCHAR(255) NOT NULL,
    c3 VARCHAR(255) NULL,
    c4 INT NULL,
    c5 DATE NOT NULL,
    c6 VARCHAR(10) NOT NULL,
    PRIMARY KEY (c1)
);

CREATE TABLE subset3_ref_c45fceaa_t2 (
    c1 INT NOT NULL AUTO_INCREMENT,
    c2 INT NOT NULL,
    c3 DECIMAL(10,2) NOT NULL,
    c4 VARCHAR(50) NOT NULL,
    c5 DATE NOT NULL,
    c6 MEDIUMTEXT NULL,
    c7 LONGTEXT NULL,
    c8 MEDIUMBLOB NULL,
    c9 LONGBLOB NULL,
    c10 ENUM('value1','value2','value3') NULL,
    c11 SET('a','b','c','d') NULL,
    c12 BIT(8) NULL,
    c13 DATETIME NULL,
    c14 FLOAT(8,2) NULL,
    c15 DOUBLE(12,4) NULL,
    PRIMARY KEY (c1)
);

CREATE INDEX i_s3_c45fceaa ON subset3_c45fceaa (`c2`(64));
CREATE INDEX i_s3_c45fceaa_c6 ON subset3_c45fceaa (`c6`(64));
CREATE INDEX i_s3_c45fceaa_c3 ON subset3_c45fceaa (`c3`(64));

INSERT IGNORE INTO subset3_c45fceaa (`c1`, `c2`, `c3`, `c4`, `c5`, `c6`) VALUES
(3621650, 'hv_369', '0/pkb81nfifrl3p7b8i6', -9, 'not-a-date', '2023-01-01');

INSERT IGNORE INTO subset3_ref_c45fceaa_t2
(`c1`, `c2`, `c3`, `c4`, `c5`, `c6`, `c7`, `c8`, `c9`, `c10`, `c11`, `c12`, `c13`, `c14`, `c15`) VALUES
(9000003, 0, 1.00, '2023-01-01', '1991-02-24', 'm949pu36sf-2wpiefor:evri:h:3nckbvax2-bp5zne:59wk', ' 1', NULL, NULL, 'value3', 'a,b', NULL, '2031-09-06 08:56:58.689231', 0.0, 0.0),
(9000005, -1, 0.00, '2023-01-01', NULL, '01e0', 'r:/nbrk/ygueq3a2gmhy6 3wexkov:py53k11bsb_k-g', NULL, NULL, 'value2', 'b,c,d', NULL, '2005-08-11 09:01:13', -1.0, -1.0);

SELECT /*implicit_conversion_in*/
       COALESCE(`sub1`.`c5`, '2023-01-01'),
       `sub1`.`c2`,
       (CASE WHEN `sub1`.`c1` >= -12 THEN `sub1`.`c1` ELSE -12 END)
FROM `subset3_c45fceaa` sub1
WHERE `sub1`.`c2` = 'hv_369'
  AND `sub1`.`c3` IN (
      SELECT `sq2`.`c3`
      FROM `subset3_ref_c45fceaa_t2` sq2
  )
ORDER BY `sub1`.`c3` DESC;

START TRANSACTION;
INSERT IGNORE INTO subset3_c45fceaa (`c1`, `c2`, `c3`, `c4`, `c5`, `c6`) VALUES
(2197075, 'not-a-date', 'not-a-date', -7, '0000-00-00', 'not-a-date'),
(9337970, '4 lkai/vjdp7r', 'not-a-date', -7, '0000-00-00', 'not-a-date'),
(360471, '2023-01-01', '2023-01-01', -9, 'not-a-date', '2023-01-01'),
(2873070, '01e0', 'not-a-date', -7, 'not-a-date', 'not-a-date'),
(5167747, '01e0', 'not-a-date', -12, '2023-01-01', 'l41an0zljt7c1n'),
(24752, 'not-a-date', 'not-a-date', -9, 'not-a-date', 'hv_630'),
(679607, 'hv_369', '2023-01-01', -7, '2023-01-01', 'hv_630'),
(2497123, 'not-a-date', 'not-a-date', -12, '0000-00-00', 'hv_630'),
(2966327, 'hv_369', 'not-a-date', -7, 'not-a-date', 'hv_630'),
(9670048, '01e0', 'hv_8536', -12, '2023-01-01', 'not-a-date'),
(3533978, '01e0', 'not-a-date', -7, 'not-a-date', 'hv_630'),
(1647186, '01e0', '2023-01-01', -12, '2023-01-01', 'not-a-date'),
(7476158, '01e0', 'not-a-date', -795, 'not-a-date', 'hv_630'),
(8965887, 'hv_369', 'hv_8536', 559, 'not-a-date', '2023-01-01'),
(8409405, 'hv_369', 'hv_8536', -7, '2023-01-01', 'not-a-date'),
(6169395, '01e0', 'not-a-date', -9, '2025-10-27', '2023-01-01'),
(7942163, 'not-a-date', '2023-01-01', -9, '2023-01-01', 'hv_630'),
(9566913, '2023-01-01', 'hv_8536', -9, 'not-a-date', 'not-a-date'),
(5134535, '01e0', 'hv_8536', -7, 'not-a-date', '2023-01-01'),
(5689499, '01e0', '2023-01-01', -12, '0000-00-00', 'not-a-date'),
(5594823, 'hv_369', '2023-01-01', -7, 'not-a-date', 'hv_630'),
(3609812, '2023-01-01', 'hv_8536', -9, '2023-01-01', 'hv_630'),
(950564, '01e0', '2023-01-01', -12, '0000-00-00', 'hv_630'),
(7789359, 'hv_369', '2023-01-01', -9, '0000-00-00', 'hv_630'),
(8928787, '01e0', 'not-a-date', -12, '1994-08-18', 'not-a-date'),
(7896646, '2023-01-01', 'hv_8536', -9, 'not-a-date', 'not-a-date'),
(7618873, '2023-01-01', 'hv_8536', -12, '2023-01-01', 'hv_630'),
(8858603, 'not-a-date', 'hv_8536', -12, '0000-00-00', '2023-01-01'),
(2558855, 'not-a-date', '-1', -7, '0000-00-00', '2023-01-01'),
(3146843, '2023-01-01', '2023-01-01', -9, 'not-a-date', 'not-a-date'),
(4903704, 'hv_369', '2023-01-01', -9, '0000-00-00', 'hv_630'),
(6614684, '01e0', '2023-01-01', -7, '2036-08-02', 'not-a-date'),
(2456607, 'not-a-date', '2023-01-01', -7, '0000-00-00', '2023-01-01'),
(3182257, 'hv_369', 'not-a-date', -12, 'not-a-date', 'hv_630'),
(1469390, '1', 'yvl2r7l3x/_fpg/d', -7, '', 'hv_630'),
(214874, '01e0', 'not-a-date', -9, 'not-a-date', 'hv_630'),
(4181965, 'zaxzs9w6_b', 'hv_8536', -7, '2023-01-01', '2023-01-01'),
(9852808, '01e0', 'not-a-date', 573, 'not-a-date', '2023-01-01'),
(7787779, 'hv_369', 'hv_8536', -12, '0000-00-00', '2023-01-01'),
(5386477, '01e0', 'not-a-date', 946, 'not-a-date', 'hv_630'),
(7362800, '01e0', '2023-01-01', -12, '0000-00-00', '2023-01-01'),
(9220168, 'hv_369', 'hv_8536', -7, 'not-a-date', '2023-01-01'),
(6648541, '2023-01-01', 'hv_8536', -7, '2016-06-14', 'not-a-date'),
(1247625, '2023-01-01', 'not-a-date', -7, '0000-00-00', 'hv_630'),
(858351, '01e0', '', -9, '2023-01-01', 'hv_630'),
(4592967, '01e0', 'hv_8536', -12, '2023-01-01', 'hv_630'),
(6975137, 'not-a-date', 'hv_8536', -328, 'not-a-date', 'not-a-date'),
(357074, 'not-a-date', 'not-a-date', -12, '2023-01-01', 'hv_630'),
(5745739, '01e0', 'not-a-date', -7, '0000-00-00', 'not-a-date'),
(7964279, 'not-a-date', '2023-01-01', -7, 'not-a-date', 'hv_630'),
(8228006, 'hv_369', 'not-a-date', -7, '2007-05-09', '2023-01-01'),
(3827543, '2023-01-01', 'not-a-date', -12, '0000-00-00', '2023-01-01'),
(8301429, '01e0', 'hv_8536', -9, '2023-01-01', '2023-01-01'),
(9700493, 'hv_369', 'not-a-date', -9, '2023-01-01', 'hv_630'),
(1218406, 'otb:n6/-_599t2kfx', 'not-a-date', -12, '0000-00-00', '2023-01-01'),
(5457024, 'not-a-date', '2023-01-01', -9, '2023-01-01', '2023-01-01'),
(3613088, 'not-a-date', '2023-01-01', -12, '0000-00-00', 'hv_630'),
(6604595, '2023-01-01', 'hv_8536', -12, '2023-01-01', 'hv_630'),
(4880032, 'not-a-date', 'hv_8536', -7, 'not-a-date', '2023-01-01'),
(5488729, 'not-a-date', '2023-01-01', -12, '2023-01-01', 'hv_630'),
(372170, '01e0', ' 1', -9, 'not-a-date', 'hv_630'),
(3575338, 'hv_369', 'hv_8536', -12, '2023-01-01', 'hv_630'),
(6335065, 'hv_369', '2023-01-01', -7, '2023-01-01', '2023-01-01'),
(4847163, '2023-01-01', 'not-a-date', -12, '0000-00-00', 'y24i68x/4ii e8egvgz'),
(9672296, 'hd3c dfxqbie:x', 'not-a-date', -9, 'not-a-date', 'hv_630'),
(1614013, '2023-01-01', '2023-01-01', -7, '2023-01-01', 'hv_630'),
(3943197, '01e0', 'not-a-date', 232, 'not-a-date', 'hv_630'),
(3301860, '2023-01-01', 'not-a-date', -12, '0000-00-00', 'k3dbhq1h58u/n1nd2'),
(8415229, '2023-01-01', 'not-a-date', -7, '2023-01-01', 'not-a-date'),
(1666694, '01e0', 'not-a-date', -9, 'not-a-date', 'not-a-date'),
(1880722, '01e0', '2023-01-01', -12, 'not-a-date', '2023-01-01'),
(466255, 'ht_md4dewtr432ww x', 'not-a-date', -9, '2023-01-01', 'hv_630'),
(1569419, 'amjzgv18b', 'hv_8536', -9, '0000-00-00', 'not-a-date'),
(256575, 'not-a-date', '2023-01-01', -12, '2023-01-01', 'not-a-date'),
(5013675, '01e0', '2023-01-01', -7, '0000-00-00', 'not-a-date'),
(5389777, '2023-01-01', 'hv_8536', -9, '0000-00-00', '0'),
(2599794, '01e0', '2023-01-01', -12, '0000-00-00', '01e0'),
(1308942, '01e0', 'hv_8536', -7, 'not-a-date', 'hv_630'),
(7617815, '01e0', 'hv_8536', -12, 'not-a-date', '2023-01-01'),
(1335081, '01e0', 'not-a-date', -12, '0000-00-00', '2023-01-01'),
(5531681, '01e0', 'hv_8536', -9, '0000-00-00', '2023-01-01'),
(2392826, '01e0', 'hv_8536', -12, 'not-a-date', 'hv_630'),
(9057243, '-1', 'hv_8536', -12, '2023-01-01', 'not-a-date'),
(2635226, '01e0', '2023-01-01', -9, '0000-00-00', '0'),
(6190018, 'hv_369', 'not-a-date', -9, '0000-00-00', 'not-a-date'),
(824292, '01e0', 'not-a-date', -12, '0000-00-00', 'not-a-date'),
(6130607, '2023-01-01', 'not-a-date', -9, '0000-00-00', '2023-01-01'),
(5605075, 'not-a-date', '2023-01-01', -7, '2023-01-01', '2023-01-01'),
(532518, 'not-a-date', '2023-01-01', -12, '0000-00-00', '2023-01-01'),
(2053622, '2023-01-01', '2023-01-01', -9, '0000-00-00', 'not-a-date'),
(4515233, 'hv_369', 'hv_8536', -9, '2012-03-15', 'hv_630'),
(4326305, '01e0', 'hv_8536', -9, '2023-01-01', 'not-a-date'),
(4654744, '2023-01-01', '2023-01-01', -7, '0000-00-00', 'not-a-date'),
(4265701, 'hv_369', 'not-a-date', -12, '0000-00-00', '2023-01-01'),
(1786357, '2023-01-01', 'hv_8536', -12, '2023-01-01', 'hv_630'),
(7097701, '2023-01-01', 'hv_8536', -9, '2023-01-01', 'not-a-date'),
(1779905, 'not-a-date', 'not-a-date', -9, '2023-01-01', '2023-01-01'),
(1338984, 'not-a-date', '2023-01-01', -12, '2015-01-06', 'not-a-date'),
(130609, '01e0', 'hv_8536', -706, 'not-a-date', '2023-01-01'),
(6831517, 'hv_369', 'hv_8536', -12, 'not-a-date', 'not-a-date'),
(705329, '2023-01-01', 'hv_8536', -12, '2023-01-01', '2023-01-01'),
(7048545, 'not-a-date', 'not-a-date', -9, '2023-01-01', 'hv_630'),
(2049379, 'hv_369', 'not-a-date', -9, '0000-00-00', 'hv_630'),
(6757535, '01e0', '2023-01-01', -12, 'not-a-date', 'j4rop g57/w-mfvjgyms'),
(3318648, '2023-01-01', 'not-a-date', -9, '2023-01-01', 'hv_630'),
(729206, 'hv_369', 'hv_8536', -12, 'not-a-date', 'not-a-date'),
(2977219, '01e0', 'hv_8536', -12, '2023-01-01', 'not-a-date'),
(2114708, '2023-01-01', 'not-a-date', -12, 'not-a-date', 'hv_630'),
(8328498, '01e0', 'not-a-date', -9, '2023-01-01', 'not-a-date'),
(9788549, 'hv_369', 'not-a-date', -12, 'not-a-date', 'not-a-date'),
(6220810, '01e0', 'not-a-date', -12, '2024-05-26', ': fkkim:jty8'),
(3831867, 'not-a-date', 'hv_8536', -9, '0000-00-00', '2023-01-01'),
(864204, '01e0', '2023-01-01', -12, '1998-10-20', 'hv_630'),
(3610853, '01e0', 'not-a-date', 782, '0000-00-00', 'not-a-date'),
(9912841, '01e0', 'hv_8536', -9, 'not-a-date', 'not-a-date'),
(1234407, '01e0', 'hv_8536', -12, 'not-a-date', '01e0'),
(8026260, '01e0', 'not-a-date', -9, '0000-00-00', 'not-a-date'),
(243728, 'not-a-date', '2023-01-01', -12, '0000-00-00', 'not-a-date'),
(7789219, 'hv_369', '1', -12, 'not-a-date', '2023-01-01'),
(345276, '01e0', '2023-01-01', -7, 'not-a-date', 'hv_630'),
(6888846, 'a3im6-at', '2023-01-01', -7, '', 'hv_630'),
(7803439, '01e0', 'not-a-date', -9, 'not-a-date', 'not-a-date'),
(6369197, 'hv_369', '2023-01-01', 68, '0000-00-00', '2023-01-01'),
(8251144, '2023-01-01', '2023-01-01', -12, '2023-01-01', 'not-a-date'),
(5095281, '2023-01-01', 'not-a-date', -7, 'not-a-date', 'not-a-date'),
(866367, 'hv_369', '2023-01-01', -12, '0000-00-00', '2023-01-01'),
(8195643, 'hv_369', '2023-01-01', -12, '2023-01-01', 'hv_630'),
(1424418, '01e0', 'hv_8536', -9, 'not-a-date', 'not-a-date'),
(7665144, 'not-a-date', '2023-01-01', 69, '0000-00-00', 'hv_630'),
(9124480, 'hv_369', 'hv_8536', -7, '0000-00-00', '2023-01-01'),
(9219784, 'hv_369', 'iygwo3zd6kb', -12, '2023-01-01', '2023-01-01'),
(9706400, '01e0', '2023-01-01', -12, '2017-02-17', 'not-a-date'),
(7448504, 'not-a-date', 'not-a-date', -7, '0000-00-00', 'not-a-date'),
(9186136, '01e0', 'not-a-date', -7, 'not-a-date', '0ey63ne/ik9elnn2z8'),
(6358061, '01e0', '0dhk/b:5o-:v a-', -7, '2023-01-01', 'not-a-date'),
(8925783, 'hn7/g0e21j', '2023-01-01', -9, 'not-a-date', 'hv_630'),
(8937410, 'hv_369', 'not-a-date', 267, '2023-01-01', 'hv_630'),
(3121967, '01e0', 'not-a-date', -12, '2035-12-12', '2023-01-01'),
(207063, '2023-01-01', 'not-a-date', -12, '2023-01-01', 'hv_630'),
(508895, '01e0', 'hv_8536', -12, '0000-00-00', 'hv_630'),
(9117790, '01e0', '2023-01-01', -12, 'not-a-date', 'hv_630'),
(2429627, '01e0', 'not-a-date', -12, 'not-a-date', 'not-a-date'),
(9455326, 'not-a-date', 'hv_8536', 793, 'not-a-date', 'not-a-date'),
(6141375, '2023-01-01', '4s/wzbl1oog:6', -12, 'not-a-date', 'not-a-date'),
(2887479, 'hv_369', 'hv_8536', -9, '2023-01-01', '2023-01-01'),
(9962710, '0000-00-00', '2023-01-01', 93, '0000-00-00', 'not-a-date'),
(8345834, '2023-01-01', 'not-a-date', -12, 'not-a-date', 'hv_630'),
(7676502, '01e0', 'hv_8536', -9, '2023-01-01', '2023-01-01'),
(8955966, 'not-a-date', '2023-01-01', -7, 'not-a-date', 'hv_630');
COMMIT;

ANALYZE TABLE subset3_c45fceaa;

SELECT /*implicit_conversion_in*/
       COALESCE(`sub1`.`c5`, '2023-01-01'),
       `sub1`.`c2`,
       (CASE WHEN `sub1`.`c1` >= -12 THEN `sub1`.`c1` ELSE -12 END)
FROM `subset3_c45fceaa` sub1
WHERE `sub1`.`c2` = 'hv_369'
  AND `sub1`.`c3` IN (
      SELECT `sq2`.`c3`
      FROM `subset3_ref_c45fceaa_t2` sq2
  )
ORDER BY `sub1`.`c3` DESC;
[26 May 6:49] Roy Lyseng 
Thank you for the bug report.
Verified as described.