weijunlu opened a new issue, #2687: URL: https://github.com/apache/drill/issues/2687
The coalesce function failed in the master version Steps to reproduce the behavior: 1. 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'); 2. Create mysql Plugins in Storage label via http://localhost:8047/storage pages 3. 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 | +--------+ -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: dev-unsubscr...@drill.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
