arrayMap(x -> x + 1, [1, 2, 3]) returns wrong result

[l1t1]

it should return [2,3,4], rather than [1,4,9], others also wrong

D SELECT arrayMap(x -> x + 1, [1, 2, 3]); 
┌────────────────────────────────────────────────────┐
│ arraymap((x -> (x + 1)), main.list_value(1, 2, 3)) │
│                      int32[]                       │
├────────────────────────────────────────────────────┤
│ [1, 4, 9]                                          │
└────────────────────────────────────────────────────┘
D SELECT arrayMap(x -> x -1, [1, 2, 3]); --also wrong
┌────────────────────────────────────────────────────┐
│ arraymap((x -> (x - 1)), main.list_value(1, 2, 3)) │
│                      int32[]                       │
├────────────────────────────────────────────────────┤
│ [1, 4, 9]                                          │
└────────────────────────────────────────────────────┘
D SELECT arrayMap(x -> x, [1, 2, 3]); --also wrong
┌──────────────────────────────────────────────┐
│ arraymap((x -> x), main.list_value(1, 2, 3)) │
│                   int32[]                    │
├──────────────────────────────────────────────┤
│ [1, 4, 9]                                    │
└──────────────────────────────────────────────┘

[lmangani]

Thanks for the report! The macro indeed requires a patch to correctly accept and execute the lambda function.
In order to correctly register macros with lamba expressions we need to use a custom loader to retain the type.

[lmangani]

Big has been fixed in master and will be part of next release tonight. Thanks for the report @l1t1

D SELECT arrayMap(x -> x + 1, [1, 2, 3]);
┌────────────────────────────────────────────────────┐
│ arraymap((x -> (x + 1)), main.list_value(1, 2, 3)) │
│                      int32[]                       │
├────────────────────────────────────────────────────┤
│ [2, 3, 4]                                          │
└────────────────────────────────────────────────────┘
D SELECT arrayMap(x -> x + 10, [1, 2, 3]);
┌─────────────────────────────────────────────────────┐
│ arraymap((x -> (x + 10)), main.list_value(1, 2, 3)) │
│                       int32[]                       │
├─────────────────────────────────────────────────────┤
│ [11, 12, 13]                                        │
└─────────────────────────────────────────────────────┘

Note: the lambda expression syntax requires using x

[lmangani]

Fixed in chsql v1.0.6 for DuckDB v1.1.3