"Not found column [..] in block" with clusterAllReplicas

[al13n321]

This doesn't work:

:) select serverUUID() as s, sum(dummy) from clusterAllReplicas(both, system.one) group by s

[...]
Received exception from server (version 24.4.1):
Code: 10. DB::Exception: Received from localhost:9000. DB::Exception: Not found column serverUUID() in block. There are only columns: sum(__table1.dummy): While executing Remote. (NOT_FOUND_COLUMN_IN_BLOCK)

But this works:

:) select cityHash64(serverUUID()) + dummy as s, sum(dummy) from clusterAllReplicas(both, system.one) group by s

[...]
   ┌───────────────────s─┬─sum(dummy)─┐
1. │ 6220104575184213473 │          0 │
2. │ 7064952209212228648 │          0 │
   └─────────────────────┴────────────┘

2 rows in set. Elapsed: 0.006 sec. 

The cluster is just 2 servers running on localhost:

remote_servers:                                                                                                                                                                                                                        
  both:                                                                                                                                                                                                                                
    shard:                                                                                                                                                                                                                             
      replica:                                                                                                                                                                                                                         
        host: 127.0.0.1                                                                                                                                                                                                                
        port: 9000                                                                                                                                                                                                                     
      replica:                                                                                                                                                                                                                         
        host: 127.0.0.3                                                                                                                                                                                                                
        port: 9010                                                                                                                                                                                                                     

[SaltTan]

Workaround: set allow_experimental_analyzer=0

[SaltTan]

https://fiddle.clickhouse.com/d239fb78-2ceb-4474-8efc-0bd702d248fd

[den-crane]

select identity(serverUUID()) as s, count() 
from remote('127.0.0.{1,2}', system.one)
group by s;

https://fiddle.clickhouse.com/d293f1db-cfb2-47a0-adcf-d803b88a347c

SELECT
    identity(serverUUID()) AS s,
    count()
FROM clusterAllReplicas('replicated', system.one)
GROUP BY s

Query id: a01e4225-f595-43c0-887a-a3ab50901aa1

   ┌─s────────────────────────────────────┬─count()─┐
1. │ 64551af3-6e7a-42d5-88fe-dff568a09455 │       1 │
2. │ a4eb955b-b2b4-4754-9d8c-d6ad667339eb │       1 │
   └──────────────────────────────────────┴─────────┘

[den-crane]

select getMacro('replica') as s, count() from clusterAllReplicas('replicated', system.one) group by s;

Received exception from server (version 24.3.2):
Code: 10. DB::Exception: Received from localhost:9000. DB::Exception: 
Not found column getMacro('replica'_String) in block.
 There are only columns: count(): While executing Remote. (NOT_FOUND_COLUMN_IN_BLOCK)

[den-crane]

select uptime() as s, count() from clusterAllReplicas('replicated', system.one)  group by s;

Received exception from server (version 24.3.2):
Code: 10. DB::Exception: Received from localhost:9000. DB::Exception:
 Not found column uptime() in block. There are only columns: count(): 
While executing Remote. (NOT_FOUND_COLUMN_IN_BLOCK)

uptime: https://fiddle.clickhouse.com/cf68fb33-988d-453e-9659-2c8a41f34069

timezone: https://fiddle.clickhouse.com/e60a7fca-6fb4-4d14-8f0f-8d261f6415d0

serverTimeZone: https://fiddle.clickhouse.com/1b03f4b1-0c52-477e-a85a-534b5423a1f8

[Algunenano]

Fix had to be reverted

[KochetovNicolai]

Revert was reverted.