UPDATE..SET using another table is not updating

CREATE TABLE t1 (a INT NOT NULL, b INT NOT NULL) ENGINE=Columnstore;

INSERT INTO t1 VALUES (1,1),(1,2),(1,3),(2,1),(2,2),(2,3);

CREATE TABLE t2 (a INT NOT NULL, b INT NOT NULL) ENGINE=Columnstore;

INSERT INTO t2 VALUES (1,1),(1,2),(1,3);

UPDATE t1 SET b=(SELECT b FROM t2 ORDER BY b LIMIT 1);

SELECT * FROM t1 ORDER BY a, b;

+---+---+

| a | b |

+---+---+

| 1 | 1 |

| 1 | 2 |

| 1 | 3 |

| 2 | 1 |

| 2 | 2 |

| 2 | 3 |

+---+---+

6 rows in set (0.024 sec)

SELECT * FROM t1 ORDER BY a, b;

+---+---+

| a | b |

+---+---+

| 1 | 1 |

| 1 | 1 |

| 1 | 1 |

| 2 | 1 |

| 2 | 1 |

| 2 | 1 |

+---+---+

6 rows in set (0.000 sec)