The coalesce function failed in the master version
- Dominant language
- Java
- Stars
- 2k
- Forks
- 990
- Avg merge
- 1d 8h
- Merged PRs (30d)
- 5
Description
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 |
+--------+
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.