The coalesce function failed in the master version

[weijunlu]

The coalesce function failed in the master version

Steps to reproduce the behavior:

1. The version information is as follows: apache drill> select commit_message, commit_time from sys.version; +----------------------------------------------------------------------------------+---------------------------+ | commit_message | commit_time | +----------------------------------------------------------------------------------+---------------------------+ | DRILL-8314: Add support for automatically retrying and disabling broken storage plugins (https://github.com/apache/drill/pull/2655) | 18.10.2022 @ 18:15:31 CST |
2. Create tables and insert data in mysql database. create table ct1 (id int, data text); INSERT INTO ct1 VALUES (1,'ggg'),(2,'aa'),(3,'ss');
3. Create mysql Plugins in Storage label via http://localhost:8047/storage pages
4. The coalesce function is executed using the mysql plugin: apache drill (mysql.test)> use mysql.test; +------+----------------------------------------+ | ok | summary | +------+----------------------------------------+ | true | Default schema changed to [mysql.test] |

apache drill (mysql.test)> select coalesce(null,null,data) from ct1; Error: SYSTEM ERROR: UnsupportedOperationException: Unsupported type when convertTypeToSpec: ANY Please, refer to logs for more information. [Error Id: f236d97f-dea6-4e38-a7c7-697693988b8c on DESKTOP-PHHB7LC:31010] (state=,code=0)

Additional context But there was no problem with the other commit in the master version.

1. The version information is as follows: apache drill> select commit_message, commit_time from sys.version; +-----------------------------------------------------------+---------------------------+ | commit_message | commit_time | +-----------------------------------------------------------+---------------------------+ | DRILL-8273: Complex typed columns cannot be made implicit | 31.07.2022 @ 14:34:14 CST | +-----------------------------------------------------------+---------------------------+
2. apache drill (mysql.test)> select coalesce(null,null,data) from ct1; +--------+ | EXPR$0 | +--------+ | ggg | | aa | | ss | +--------+