[teiid-issues] [JBoss JIRA] (TEIID-2858) Database use of char[>1] cause using Convert(x, x) and negates using an index

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-2858?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins resolved TEIID-2858.
-----------------------------------

    Resolution: Rejected


Re-resolving as rejected.  I do not see from the other issue where there is anything that Teiid is doing that is unexpected - that is the design time metadata contains typing issues and converts.  Teiid does not proactively add conversions and the conversions are already present in the plan, so the translator is not involved there.
                
> Database use of char[>1] cause using Convert(x,x) and negates using an index
> ----------------------------------------------------------------------------
>
>                 Key: TEIID-2858
>                 URL: https://issues.jboss.org/browse/TEIID-2858
>             Project: Teiid
>          Issue Type: Bug
>          Components: Misc. Connectors
>    Affects Versions: 8.4.1
>            Reporter: Van Halbert
>            Assignee: Steven Hawkins
>
> When a database defines a char of length greater than 1, a convert(x,x) is being used in the criteria, and thereby, negating the use of an index and causing table scans.  
> Note:  There is no option to change the database schemas, because they are from a COTS product.
> I would think there needs to be a solution in the translator such that if it can be detected that its for a char column and that it does not do the convert. 

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira