[
https://issues.apache.org/jira/browse/TRAFODION-2181?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Anoop Sharma resolved TRAFODION-2181.
-------------------------------------
Resolution: Fixed
> 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.15#6346)
