[JBoss JIRA] (TEIIDDES-2673) Allow date formatted string literals to be parsed as timestamps
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2673?page=com.atlassian.jira.plu... ]
Steven Hawkins moved TEIID-3737 to TEIIDDES-2673:
-------------------------------------------------
Project: Teiid Designer (was: Teiid)
Key: TEIIDDES-2673 (was: TEIID-3737)
Component/s: Teiid Integration
(was: Query Engine)
Fix Version/s: (was: 8.12)
> Allow date formatted string literals to be parsed as timestamps
> ---------------------------------------------------------------
>
> Key: TEIIDDES-2673
> URL: https://issues.jboss.org/browse/TEIIDDES-2673
> Project: Teiid Designer
> Issue Type: Enhancement
> Components: Teiid Integration
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
>
> For consistency with most major vendors we should support allowing date literals to be parsed as timestamps. For example:
> timestamp_col > '2001-01-01'
> which would prevent the predicate from being resolved as a string comparison.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 6 months
[JBoss JIRA] (TEIIDDES-2614) Add option to remove redundant Unique Constraint in DDL importing if column ID's match a PK
by Matus Makovy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2614?page=com.atlassian.jira.plu... ]
Matus Makovy closed TEIIDDES-2614.
----------------------------------
> Add option to remove redundant Unique Constraint in DDL importing if column ID's match a PK
> -------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2614
> URL: https://issues.jboss.org/browse/TEIIDDES-2614
> Project: Teiid Designer
> Issue Type: Enhancement
> Reporter: Barry LaFond
> Assignee: Barry LaFond
> Labels: release_notes, verified_jbdsis-8.0.4.CR1
> Fix For: 9.0.4, 9.2
>
> Attachments: TeiidDdlImporter.patch
>
>
> Teiid Connection importer will return all PK/UC definitions exposed by the DB. Some DB's auto-create a unique constraint for an defined PK, which is really redundant.
> Teiid Designer has a validation check that looks for PK/UC who share common column ID's and generates an error. This prevents a lot of DDL to end up being imported with errors.
> Suggest looking for this use-case in the Teiid DDL Importer logic and removing the redundant UC prior to generating the XMI model
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 6 months
[JBoss JIRA] (TEIIDDES-2614) Add option to remove redundant Unique Constraint in DDL importing if column ID's match a PK
by Matus Makovy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2614?page=com.atlassian.jira.plu... ]
Matus Makovy updated TEIIDDES-2614:
-----------------------------------
Labels: release_notes verified_jbdsis-8.0.4.CR1 (was: )
> Add option to remove redundant Unique Constraint in DDL importing if column ID's match a PK
> -------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2614
> URL: https://issues.jboss.org/browse/TEIIDDES-2614
> Project: Teiid Designer
> Issue Type: Enhancement
> Reporter: Barry LaFond
> Assignee: Barry LaFond
> Labels: release_notes, verified_jbdsis-8.0.4.CR1
> Fix For: 9.0.4, 9.2
>
> Attachments: TeiidDdlImporter.patch
>
>
> Teiid Connection importer will return all PK/UC definitions exposed by the DB. Some DB's auto-create a unique constraint for an defined PK, which is really redundant.
> Teiid Designer has a validation check that looks for PK/UC who share common column ID's and generates an error. This prevents a lot of DDL to end up being imported with errors.
> Suggest looking for this use-case in the Teiid DDL Importer logic and removing the redundant UC prior to generating the XMI model
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
10 years, 6 months