The coalesce function failed in the master version
Opened this issue · 0 comments
weijunlu commented
The coalesce function failed in the master version
Steps to reproduce the behavior:
- 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 (#2655) | 18.10.2022 @ 18:15:31 CST | - 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'); - Create mysql Plugins in Storage label via http://localhost:8047/storage pages
- 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.
- 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 |
+-----------------------------------------------------------+---------------------------+ - apache drill (mysql.test)> select coalesce(null,null,data) from ct1;
+--------+
| EXPR$0 |
+--------+
| ggg |
| aa |
| ss |
+--------+