Where condition on boolean column returns 0 rows on 25.8.12.20747.altinityantalya

[alsugiliazova]

Describe the bug

SELECT *
FROM icebergS3('http://minio:9000/warehouse/data', 'admin', 'password')

Query id: 38d6561b-bf56-4ce3-a8e9-8d0c2bca2d4b

    ┌─string─┬─boolean─┬─integer─┬───────date─┬───────────────────datetime─┐
 1. │ 0      │ true    │       0 │ 2024-01-01 │ 2024-01-01 01:00:00.000000 │
 2. │ 1      │ false   │       1 │ 2024-01-02 │ 2024-01-02 01:00:00.000000 │
 3. │ 2      │ true    │       2 │ 2024-01-03 │ 2024-01-03 01:00:00.000000 │
 4. │ 3      │ false   │       3 │ 2024-01-04 │ 2024-01-04 01:00:00.000000 │
 5. │ 4      │ true    │       4 │ 2024-01-05 │ 2024-01-05 01:00:00.000000 │
 6. │ 5      │ false   │       5 │ 2024-01-06 │ 2024-01-06 01:00:00.000000 │
 7. │ 6      │ true    │       6 │ 2024-01-07 │ 2024-01-07 01:00:00.000000 │
 8. │ 7      │ false   │       7 │ 2024-01-08 │ 2024-01-08 01:00:00.000000 │
 9. │ 8      │ true    │       8 │ 2024-01-09 │ 2024-01-09 01:00:00.000000 │
10. │ 9      │ false   │       9 │ 2024-01-10 │ 2024-01-10 01:00:00.000000 │
11. │ 10     │ true    │      10 │ 2024-01-11 │ 2024-01-11 01:00:00.000000 │
12. │ 11     │ false   │      11 │ 2024-01-12 │ 2024-01-12 01:00:00.000000 │
13. │ 12     │ true    │      12 │ 2024-01-13 │ 2024-01-13 01:00:00.000000 │
14. │ 13     │ false   │      13 │ 2024-01-14 │ 2024-01-14 01:00:00.000000 │
15. │ 14     │ true    │      14 │ 2024-01-15 │ 2024-01-15 01:00:00.000000 │
16. │ 15     │ false   │      15 │ 2024-01-16 │ 2024-01-16 01:00:00.000000 │
17. │ 16     │ true    │      16 │ 2024-01-17 │ 2024-01-17 01:00:00.000000 │
18. │ 17     │ false   │      17 │ 2024-01-18 │ 2024-01-18 01:00:00.000000 │
19. │ 18     │ true    │      18 │ 2024-01-19 │ 2024-01-19 01:00:00.000000 │
20. │ 19     │ false   │      19 │ 2024-01-20 │ 2024-01-20 01:00:00.000000 │
    └────────┴─────────┴─────────┴────────────┴────────────────────────────┘
20 rows in set. Elapsed: 0.009 sec. 

SELECT *
FROM icebergS3('http://minio:9000/warehouse/data', 'admin', 'password')
WHERE boolean = true

Query id: 582d0bdb-f3e6-4216-b4c2-de70d653f4b8

Ok.

0 rows in set. Elapsed: 0.007 sec. 

[alsugiliazova]

Issue only with true:

clickhouse1 :) SELECT * FROM icebergS3('http://minio:9000/warehouse/data', 'admin', 'password')

SELECT *
FROM icebergS3('http://minio:9000/warehouse/data', 'admin', 'password')

Query id: d33bf9a3-655c-4c2e-8bda-419a38297eea

    ┌─string─┬─boolean─┬─integer─┬───────date─┬───────────────────datetime─┐
 1. │ 0      │ true    │       0 │ 2024-01-01 │ 2024-01-01 01:00:00.000000 │
 2. │ 1      │ false   │       1 │ 2024-01-02 │ 2024-01-02 01:00:00.000000 │
 3. │ 2      │ true    │       2 │ 2024-01-03 │ 2024-01-03 01:00:00.000000 │
 4. │ 3      │ false   │       3 │ 2024-01-04 │ 2024-01-04 01:00:00.000000 │
 5. │ 4      │ true    │       4 │ 2024-01-05 │ 2024-01-05 01:00:00.000000 │
 6. │ 5      │ false   │       5 │ 2024-01-06 │ 2024-01-06 01:00:00.000000 │
 7. │ 6      │ true    │       6 │ 2024-01-07 │ 2024-01-07 01:00:00.000000 │
 8. │ 7      │ false   │       7 │ 2024-01-08 │ 2024-01-08 01:00:00.000000 │
 9. │ 8      │ true    │       8 │ 2024-01-09 │ 2024-01-09 01:00:00.000000 │
10. │ 9      │ false   │       9 │ 2024-01-10 │ 2024-01-10 01:00:00.000000 │
11. │ 10     │ true    │      10 │ 2024-01-11 │ 2024-01-11 01:00:00.000000 │
12. │ 11     │ false   │      11 │ 2024-01-12 │ 2024-01-12 01:00:00.000000 │
13. │ 12     │ true    │      12 │ 2024-01-13 │ 2024-01-13 01:00:00.000000 │
14. │ 13     │ false   │      13 │ 2024-01-14 │ 2024-01-14 01:00:00.000000 │
15. │ 14     │ true    │      14 │ 2024-01-15 │ 2024-01-15 01:00:00.000000 │
16. │ 15     │ false   │      15 │ 2024-01-16 │ 2024-01-16 01:00:00.000000 │
17. │ 16     │ true    │      16 │ 2024-01-17 │ 2024-01-17 01:00:00.000000 │
18. │ 17     │ false   │      17 │ 2024-01-18 │ 2024-01-18 01:00:00.000000 │
19. │ 18     │ true    │      18 │ 2024-01-19 │ 2024-01-19 01:00:00.000000 │
20. │ 19     │ false   │      19 │ 2024-01-20 │ 2024-01-20 01:00:00.000000 │
    └────────┴─────────┴─────────┴────────────┴────────────────────────────┘

20 rows in set. Elapsed: 0.010 sec. 

clickhouse1 :) SELECT * FROM icebergS3('http://minio:9000/warehouse/data', 'admin', 'password') where boolean=true

SELECT *
FROM icebergS3('http://minio:9000/warehouse/data', 'admin', 'password')
WHERE boolean = true

Query id: 4eb87dd6-90aa-48c3-b65e-9e68641d612a

Ok.

0 rows in set. Elapsed: 0.011 sec. 

clickhouse1 :) SELECT * FROM icebergS3('http://minio:9000/warehouse/data', 'admin', 'password') where boolean=false

SELECT *
FROM icebergS3('http://minio:9000/warehouse/data', 'admin', 'password')
WHERE boolean = false

Query id: 224f0c61-6b7e-485e-a285-202434b11fd3

    ┌─string─┬─boolean─┬─integer─┬───────date─┬───────────────────datetime─┐
 1. │ 1      │ false   │       1 │ 2024-01-02 │ 2024-01-02 01:00:00.000000 │
 2. │ 3      │ false   │       3 │ 2024-01-04 │ 2024-01-04 01:00:00.000000 │
 3. │ 5      │ false   │       5 │ 2024-01-06 │ 2024-01-06 01:00:00.000000 │
 4. │ 7      │ false   │       7 │ 2024-01-08 │ 2024-01-08 01:00:00.000000 │
 5. │ 9      │ false   │       9 │ 2024-01-10 │ 2024-01-10 01:00:00.000000 │
 6. │ 11     │ false   │      11 │ 2024-01-12 │ 2024-01-12 01:00:00.000000 │
 7. │ 13     │ false   │      13 │ 2024-01-14 │ 2024-01-14 01:00:00.000000 │
 8. │ 15     │ false   │      15 │ 2024-01-16 │ 2024-01-16 01:00:00.000000 │
 9. │ 17     │ false   │      17 │ 2024-01-18 │ 2024-01-18 01:00:00.000000 │
10. │ 19     │ false   │      19 │ 2024-01-20 │ 2024-01-20 01:00:00.000000 │
    └────────┴─────────┴─────────┴────────────┴────────────────────────────┘

10 rows in set. Elapsed: 0.011 sec. 

[alsugiliazova]

From this commit's build test passed 5a685db (18Dec last commit on antalya-25.8 branch)

[alsugiliazova]

Test from this commit passed 02ac2fb

[alsugiliazova]

Test from this commit passed 2b72104

[alsugiliazova]

Failed first from this commit 58b404d

[alsugiliazova]

This pr caused this issue #1232