最近在测试平迁starrocks的sql,发现array_remove表现和sr不一样,有无其他办法剔除null值?
sr 3.1.9:
mysql> select array_remove([1,2,3,null,3], null);
+----------------------------------------+
| array_remove([1, 2, 3, NULL, 3], NULL) |
+----------------------------------------+
| [1,2,3,3] |
+----------------------------------------+
selectdb 2.1.1:
mysql> select array_remove([1,2,3,null,3], null);
+----------------------------------------+
| array_remove([1, 2, 3, NULL, 3], NULL) |
+----------------------------------------+
| NULL |
+----------------------------------------+