[
https://issues.apache.org/jira/browse/TRAFODION-2181?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15494266#comment-15494266
]
ASF GitHub Bot commented on TRAFODION-2181:
-------------------------------------------
GitHub user anoopsharma00 opened a pull request:
https://github.com/apache/incubator-trafodion/pull/708
jira TRAFODION-2181 Enable incompatible operations in sql queries
Incompatible operations are defined as opers between datatypes
that belong to different categories.
For ex, comparison of numeric to string. In these cases, one side
need to be converted to the other before doing the comparison.
This checkin enables following incompatible operations:
-- assignment between incompatible datatypes
-- conversion between incompatible datatypes
-- comparison between incompatible datatypes
-- arith between incompatible datatypes
-- string operation on incompatible datatypes
The infrastructure changes to support was added as part of
a previous jira. Dev regressions have since then been running with
incomp opers enabled.
These operations are on by default now and some operations that
previously failed will no longer fail.
Changes are been tested as much as possible and any issues that
show up during runs will be fixed as a regular bug fix.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/anoopsharma00/incubator-trafodion
ansharma_trafr21_incomp
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-trafodion/pull/708.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #708
----
commit 4fea08efc9013eb62f766286afe77c6246a4c472
Author: Anoop Sharma <anoop.sha...@esgyn.com>
Date: 2016-09-15T19:11:15Z
jira TRAFODION-2181 Enable incompatible operations in sql queries
Incompatible operations are defined as opers between datatypes
that belong to different categories.
For ex, comparison of numeric to string. In these cases, one side
need to be converted to the other before doing the comparison.
This checkin enables following incompatible operations:
-- assignment between incompatible datatypes
-- conversion between incompatible datatypes
-- comparison between incompatible datatypes
-- arith between incompatible datatypes
-- string operation on incompatible datatypes
The infrastructure changes to support was added as part of
a previous jira. Dev regressions have since then been running with
incomp opers enabled.
These operations are on by default now and some operations that
previously failed will no longer fail.
Changes are been tested as much as possible and any issues that
show up during runs will be fixed as a regular bug fix.
----
> 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)
