[JBoss JIRA] (TEIIDDES-2665) Add an option to not widen comparisons to string
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2665?page=com.atlassian.jira.plu... ]
Barry LaFond reassigned TEIIDDES-2665:
--------------------------------------
Assignee: Dan Florian (was: Paul Richardson)
> Add an option to not widen comparisons to string
> ------------------------------------------------
>
> Key: TEIIDDES-2665
> URL: https://issues.jboss.org/browse/TEIIDDES-2665
> Project: Teiid Designer
> Issue Type: Quality Risk
> Components: Patch Release, Teiid Integration
> Reporter: Steven Hawkins
> Assignee: Dan Florian
> Fix For: 10.0.2, 9.2.1
>
>
> Our resolving logic considers anything with an implicit conversion to string to be a valid widening conversion in a comparison. For example:
> int_col = '1a'
> will effectively become cast(int_col as string) = '1a'
> Or with timestamps:
> timestamp_col = '1970-01-01'
> becomes cast(timestamp_col as string) = '1970-01-01'
> In equality cases the optimizer will infer that the predicate is simply false, but when used with greater/less than comparison we'll still attempt the query with the widening conversion.
> This is most likely not the intent of the user. It would be best to provide an option that would allow an exception to be thrown rather than assuming a query that may not match the user's expectations.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 11 months
[JBoss JIRA] (TEIIDDES-2817) Unable to export DDL for table/view for a selected database type
by Van Halbert (JIRA)
Van Halbert created TEIIDDES-2817:
-------------------------------------
Summary: Unable to export DDL for table/view for a selected database type
Key: TEIIDDES-2817
URL: https://issues.jboss.org/browse/TEIIDDES-2817
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 9.0.6, 10.0.2
Reporter: Van Halbert
Priority: Blocker
At one time, was able to export a view/table to DDL. As part of the export process, select the database dialect to have the syntax based on. The resulting file should be a ddl file that can be executed on the database. This is important to the external materialization process.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 11 months