apache/drill

The coalesce function failed in the master version

Opened this issue · 0 comments

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 (#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 |
    +--------+