devregression.mcs7136_regression_bug4027 MTR test failure with 11.4

MariaDB [tpch1]> create table product_tag (product_id bigint)engine=columnstore;

Query OK, 0 rows affected (0.454 sec)

MariaDB [tpch1]> CREATE TABLE `product` (

    -> `product_id` bigint(20) DEFAULT NULL,

    -> `price` bigint(20) DEFAULT NULL,

    -> `short_description` varchar(7998) DEFAULT NULL,

    -> `brand` varchar(254) DEFAULT NULL,

    -> `modified_dtm` datetime DEFAULT NULL,

    -> `created_dtm` datetime DEFAULT NULL,

    -> `modified_by` int(11) DEFAULT NULL

    -> ) engine=columnstore DEFAULT CHARSET=latin1 ;

Query OK, 0 rows affected (0.229 sec)

MariaDB [tpch1]> insert into product_tag values (1),(2),(3),(4);

Query OK, 4 rows affected (0.286 sec)

Records: 4  Duplicates: 0  Warnings: 0

MariaDB [tpch1]> insert into product values (1,22,'fes','rets','2011-12-12 12:12:12','2011-12-13 1:1:10',343);

Query OK, 1 row affected (0.201 sec)

MariaDB [tpch1]> insert into product values (3,22,'fes','rets','2011-12-12 12:12:12','2011-12-13 1:1:10',343);

Query OK, 1 row affected (0.134 sec)

MariaDB [tpch1]> select * from product;

+------------+-------+-------------------+-------+--------------+-------------+-------------+

| product_id | price | short_description | brand | modified_dtm | created_dtm | modified_by |

+------------+-------+-------------------+-------+--------------+-------------+-------------+

|          1 |    22 | fes               | rets  | 2011-12-12 12:12:12 | 2011-12-13 01:01:10 |         343 |

|          3 |    22 | fes               | rets  | 2011-12-12 12:12:12 | 2011-12-13 01:01:10 |         343 |

+------------+-------+-------------------+-------+--------------+-------------+-------------+

2 rows in set (0.131 sec)

MariaDB [tpch1]> update

    -> product p join

    -> (select product_id from product_tag limit 1000) t using (product_id)

    -> set brand=p.product_id, price=555, modified_dtm='2011-12-15 15:15:30',

    -> short_description=concat(short_description,modified_by);

Query OK, 0 rows affected (0.029 sec)

Rows matched: 0  Changed: 0  Warnings: 0

MariaDB [tpch1]> select * from product;

+------------+-------+-------------------+-------+--------------+-------------+-------------+

| product_id | price | short_description | brand | modified_dtm | created_dtm | modified_by |

+------------+-------+-------------------+-------+--------------+-------------+-------------+

|          1 |    22 | fes               | rets  | 2011-12-12 12:12:12 | 2011-12-13 01:01:10 |         343 |

|          3 |    22 | fes               | rets  | 2011-12-12 12:12:12 | 2011-12-13 01:01:10 |         343 |

+------------+-------+-------------------+-------+--------------+-------------+-------------+

2 rows in set (0.007 sec)

MariaDB [test]> create table product_tag (product_id bigint)engine=columnstore;

Query OK, 0 rows affected (0,351 sec)

MariaDB [test]> CREATE TABLE `product` (

    -> `product_id` bigint(20) DEFAULT NULL,

    -> `price` bigint(20) DEFAULT NULL,

    -> `short_description` varchar(7998) DEFAULT NULL,

    -> `brand` varchar(254) DEFAULT NULL,

    -> `modified_dtm` datetime DEFAULT NULL,

    -> `created_dtm` datetime DEFAULT NULL,

    -> `modified_by` int(11) DEFAULT NULL

    -> ) engine=columnstore DEFAULT CHARSET=latin1 ;

Query OK, 0 rows affected (0,395 sec)

MariaDB [test]> insert into product_tag values (1),(2),(3),(4);

Query OK, 4 rows affected (0,189 sec)

Records: 4  Duplicates: 0  Warnings: 0

MariaDB [test]> insert into product values (1,22,'fes','rets','2011-12-12 12:12:12','2011-12-13 1:1:10',343);

Query OK, 1 row affected (0,428 sec)

MariaDB [test]> insert into product values (3,22,'fes','rets','2011-12-12 12:12:12','2011-12-13 1:1:10',343);

Query OK, 1 row affected (1,275 sec)

MariaDB [test]> select * from product;

+------------+-------+-------------------+-------+---------------------+---------------------+-------------+

| product_id | price | short_description | brand | modified_dtm        | created_dtm         | modified_by |

+------------+-------+-------------------+-------+---------------------+---------------------+-------------+

|          1 |    22 | fes               | rets  | 2011-12-12 12:12:12 | 2011-12-13 01:01:10 |         343 |

|          3 |    22 | fes               | rets  | 2011-12-12 12:12:12 | 2011-12-13 01:01:10 |         343 |

+------------+-------+-------------------+-------+---------------------+---------------------+-------------+

2 rows in set (0,088 sec)

MariaDB [test]> update

    -> product p join

    -> (select product_id from product_tag limit 1000) t using (product_id)

    -> set brand=p.product_id, price=555, modified_dtm='2011-12-15 15:15:30',

    -> short_description=concat(short_description,modified_by);

Query OK, 0 rows affected (1,334 sec)

Rows matched: 0  Changed: 0  Warnings: 0

MariaDB [test]> select * from product;

+------------+-------+-------------------+-------+---------------------+---------------------+-------------+

| product_id | price | short_description | brand | modified_dtm        | created_dtm         | modified_by |

+------------+-------+-------------------+-------+---------------------+---------------------+-------------+

|          1 |   555 | fes343            | 1     | 2011-12-15 15:15:30 | 2011-12-13 01:01:10 |         343 |

|          3 |   555 | fes343            | 3     | 2011-12-15 15:15:30 | 2011-12-13 01:01:10 |         343 |

+------------+-------+-------------------+-------+---------------------+---------------------+-------------+

2 rows in set (0,020 sec)