[ https://issues.apache.org/jira/browse/TRAFODION-2181?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15497201#comment-15497201 ]
ASF GitHub Bot commented on TRAFODION-2181: ------------------------------------------- Github user asfgit closed the pull request at: https://github.com/apache/incubator-trafodion/pull/708 > allow incompatible operations in sql queries > -------------------------------------------- > > Key: TRAFODION-2181 > URL: https://issues.apache.org/jira/browse/TRAFODION-2181 > Project: Apache Trafodion > Issue Type: Improvement > Reporter: Anoop Sharma > Assignee: Anoop Sharma > Priority: Minor > > Many operations between incompatible datatypes are currently > supported through special cqds or are not fully supported. > For example: comparison between numeric and character (where 1 = '2'), > or arithmetic operation between numeric and character ( 1 + '2'), etc. > Areas where incompatible operations can happen are: > -- assignment in insert and update statement. > -- comparison predicates > -- some conversions > -- union or case statement > -- arithmetic operations > -- some string operations (like concat: 'a' || 2 ) > This jira is to enable, externalize and support incompatible operations > wherever possible. It may not be full support for all cases but could be > further enhanced going forward. > It will help in porting and running queries from other databases which > support incompatible operations. -- This message was sent by Atlassian JIRA (v6.3.4#6332)