[jira] [Created] (IMPALA-12236) Inaccurate error reporting in incompatible set operations

["Peter Rozsa (Jira)" <ji...@apache.org>]

Peter Rozsa created IMPALA-12236:
------------------------------------

             Summary: Inaccurate error reporting in incompatible set operations
                 Key: IMPALA-12236
                 URL: https://issues.apache.org/jira/browse/IMPALA-12236
             Project: IMPALA
          Issue Type: Bug
          Components: Frontend
    Affects Versions: Impala 4.3.0
            Reporter: Peter Rozsa


In set operations like multiple VALUES clauses, the incompatible column error reports wrong type. The problem arises when the common type is deduced for the set operation and later on this common type is applied (CAST) to every respective column in the set elements. 

Example:
{code:java}
insert into t06(string_col) values(100), (1000.0) 
-
ERROR: AnalysisException: Target table 'default.t06' is incompatible with source expressions.

Expression '100' (type: DECIMAL(5,1)) is not compatible with column 'string_col' (type: STRING){code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org