leegean

Results 6 comments of leegean

@filimonov @den-crane I had the same problem with version 22.2.2.1. ![image](https://user-images.githubusercontent.com/9957334/169018546-55afd75b-4c3b-487d-82d7-7b8b69259313.png)

Detailed log information is supplemented as follows: ``` 2022.09.21 17:31:16.064532 [ 708311 ] {d4ae3779-f722-4f5a-a39f-25f9171a7b09} DynamicQueryHandler: Code: 1. DB::Exception: Function 'ip2region': wrong result, expected 0 row(s), actual 1. (UNSUPPORTED_METHOD), Stack trace...

Query it like this `select ip2region(1) r, toTypeName(r);` And here's the result: ![image](https://user-images.githubusercontent.com/9957334/191473625-0288098b-ab74-40c8-a1d3-8baa6cf3ccb0.png) The result is in line with my expectations!

The version of ClickHouse is version 22.2.2.1.

@kitaisreal When I upgraded Clickhouse to version 22.8.5.29,another error occurred: `ClickHouse exception, code: 1002, host: 192.168.6.165, port: 8123; Code: 1. DB::Exception: Function 'ip2region': wrong result, expected 3 row(s), actual 1:...

> Hi @leegean, I think you forgot to dispose a `picture` created there: `picture = recorder.endRecording();`. i's not working.besides,addPicture need it.