[
https://issues.apache.org/jira/browse/IMPALA-10173?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17757745#comment-17757745
]
ASF subversion and git services commented on IMPALA-10173:
----------------------------------------------------------
Commit 08501cef2df16991bbd99656c696b978f08aeebe in impala's branch
refs/heads/master from Peter Rozsa
[ https://gitbox.apache.org/repos/asf?p=impala.git;h=08501cef2 ]
IMPALA-12384: Restore NullLiteral's uncheckedCastTo function signature
This change restores NullLiteral's uncheckedCastTo function's signature
to preserve the external compatibility of the method and make it conform
with changes regarding IMPALA-10173.
Change-Id: Id9c01129d3cdcaeb222ea910521704ce2305fd2e
Reviewed-on: http://gerrit.cloudera.org:8080/20376
Reviewed-by: Impala Public Jenkins <[email protected]>
Tested-by: Impala Public Jenkins <[email protected]>
> Allow implicit casts between numeric and string types when inserting into
> table
> -------------------------------------------------------------------------------
>
> Key: IMPALA-10173
> URL: https://issues.apache.org/jira/browse/IMPALA-10173
> Project: IMPALA
> Issue Type: Improvement
> Components: Frontend
> Reporter: Tim Armstrong
> Assignee: Peter Rozsa
> Priority: Minor
> Labels: 2023Q1, ramp-up, sql-language, supportability
>
> Impala is somewhat stricter than other engines such as Hive when it comes
> into implicit casts. This avoids a lot of ambiguity and edge cases with
> complex SQL, but we could consider loosening it for simple cases like
> inserting into a table where the meaning/intent is pretty straightforward.
> Repro
> {code}
> CREATE TABLE iobt ( c0 FLOAT ) ;
> INSERT INTO iobt(c0) VALUES ('0'), (1562998803);
> {code}
> Error
> {code}
> AnalysisException: Incompatible return types 'STRING' and 'INT' of exprs
> ''0'' and '1562998803'.
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
