[jira] [Comment Edited] (FLINK-15546) Obscure error message from ScalarOperatorGens::generateCast

["Jingsong Lee (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/FLINK-15546?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17016491#comment-17016491 ] 

Jingsong Lee edited comment on FLINK-15546 at 1/16/20 3:27 AM:
---------------------------------------------------------------

[~docete] Yes, do you want to fix this and FLINK-15584 ?


was (Author: lzljs3620320):
[~docete] Yes, do you want to fix this and FLIP-15584 ?

> Obscure error message from ScalarOperatorGens::generateCast
> -----------------------------------------------------------
>
>                 Key: FLINK-15546
>                 URL: https://issues.apache.org/jira/browse/FLINK-15546
>             Project: Flink
>          Issue Type: Improvement
>          Components: Table SQL / API
>            Reporter: Rui Li
>            Priority: Minor
>
> Consider the following case:
> {noformat}
> Flink SQL> describe foo;
> root
>  |-- x: ROW<`f1` DOUBLE, `f2` VARCHAR(10)>
> Flink SQL> insert into foo select row(1.1,'abc');
> [INFO] Submitting SQL update statement to the cluster...
> [ERROR] Could not execute SQL statement. Reason:
> org.apache.flink.table.planner.codegen.CodeGenException: Unsupported cast from 'ROW' to 'ROW'.
> {noformat}
> Users are unlikely to figure out what goes wrong from the above error message. Something like {{Unsupported cast from 'ROW<DECIMAL(2,1), CHAR(3)>' to 'ROW<DOUBLE, VARCHAR(10)>'}} will be more helpful.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)