Iceberg ALTER ADD COLUMN does not support Bool/Decimal

[alsugiliazova]

Problem

ClickHouse rejects adding a Bool column to an Iceberg table through DataLakeCatalog, although boolean is a valid Iceberg primitive type.

Same issue with Decimal.

Tested with https://altinity-build-artifacts.s3.amazonaws.com/PRs/1841/78d272e18d7641866ac4f4ded573708cf005a3f9/build_arm_release/clickhouse-common-static_26.3.13.20001.altinityantalya_arm64.deb

Reproduction

Create an Iceberg table through a DataLakeCatalog database, then run:

SET allow_insert_into_iceberg = 1;

ALTER TABLE datalake_db.`namespace.table`
ADD COLUMN boolean_col Nullable(Bool);

Actual behavior

Code: 36. DB::Exception: Unsupported type for iceberg Bool.
(BAD_ARGUMENTS)

Expected behavior

The alteration should succeed and add an optional Iceberg boolean field. Existing rows should contain NULL for the new column.

Maybe related to #2029

[subkanthi]

#2157

ALTER TABLE ice.`flowers.sample`
ADD COLUMN boolean_col Nullable(Bool);

ALTER TABLE ice.`flowers.sample`
    (ADD COLUMN `boolean_col` Nullable(Bool))

Query id: e8b550c2-9c45-4ad4-a942-607d0c6e6ab9

Ok.

0 rows in set. Elapsed: 0.163 sec. 

Ubuntu-2404-noble-amd64-base :) show create table ice.`flowers.sample`;

SHOW CREATE TABLE ice.`flowers.sample`

Query id: 15ec4c55-0fb7-4e37-a209-bc211814e243

   ┌─statement─────────────────────────────────────────────────────────┐
1. │ CREATE TABLE ice.`flowers.sample`                                ↴│
   │↳(                                                                ↴│
   │↳    `value` Nullable(Int64),                                     ↴│
   │↳    `boolean_col` Nullable(Bool)                                 ↴│
   │↳)                                                                ↴│
   │↳ENGINE = Iceberg('http://localhost:9000/bucket1/flowers/sample/') │
   └───────────────────────────────────────────────────────────────────┘

[subkanthi]

ALTER TABLE ice.`flowers.sample`
ADD COLUMN dec_col Nullable(Decimal(10,2));

ALTER TABLE ice.`flowers.sample`
    (ADD COLUMN `dec_col` Nullable(Decimal(10, 2)))

Query id: 83a0ae12-2b00-40de-85ba-654daa0d7dc0

Ok.

0 rows in set. Elapsed: 0.203 sec. 

Ubuntu-2404-noble-amd64-base :) show create table ice.`flowers.sample`;

SHOW CREATE TABLE ice.`flowers.sample`

Query id: bb3b8676-9b7e-4000-9b08-2fcb30b65079

   ┌─statement─────────────────────────────────────────────────────────┐
1. │ CREATE TABLE ice.`flowers.sample`                                ↴│
   │↳(                                                                ↴│
   │↳    `value` Nullable(Int64),                                     ↴│
   │↳    `boolean_col` Nullable(Bool),                                ↴│
   │↳    `dec_col` Nullable(Decimal(10, 2))                           ↴│
   │↳)                                                                ↴│
   │↳ENGINE = Iceberg('http://localhost:9000/bucket1/flowers/sample/') │
   └───────────────────────────────────────────────────────────────────┘

1 row in set. Elapsed: 0.009 sec.

[DimensionWieldr]

Fixed by #2157 , version 26.6, no need to backport to older versions.