[JBoss JIRA] (TEIID-3793) Push Teiid function LOCATE() to SQL Server
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3793?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-3793.
-----------------------------------
Resolution: Done
Added support to SQL Server, but not to sybase as it supports only the two argument form.
> Push Teiid function LOCATE() to SQL Server
> ------------------------------------------
>
> Key: TEIID-3793
> URL: https://issues.jboss.org/browse/TEIID-3793
> Project: Teiid
> Issue Type: Enhancement
> Components: JDBC Connector
> Affects Versions: 8.7.1.6_2
> Environment: JBOSS DV 6.2
> Microsoft SQL Server 10.50.1600.1
> Reporter: Jean-Pierre Matsumoto
> Assignee: Steven Hawkins
> Fix For: 8.13, 8.12.2
>
>
> We have some Teiid views with query similar to:
> SELECT col1
> FROM tableA
> WHERE SUBSTRING(col1, 1, LOCATE(' ', col1)) = 'PREFIX'
> SQL Server receives a full scan of col1 table without WHERE:
> SELECT col1
> FROM tableA
> Because Teiid LOCATE() function is not translated to CHARINDEX() SQL Server function (SUBSTRING is translated).
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 1 month
[JBoss JIRA] (TEIID-3787) ignored properties in dynamic vdb should be flagged with a WARN log entry
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3787?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-3787:
----------------------------------
Fix Version/s: 8.13
> ignored properties in dynamic vdb should be flagged with a WARN log entry
> -------------------------------------------------------------------------
>
> Key: TEIID-3787
> URL: https://issues.jboss.org/browse/TEIID-3787
> Project: Teiid
> Issue Type: Feature Request
> Affects Versions: 8.7.1.6_2
> Reporter: Johnathon Lee
> Assignee: Steven Hawkins
> Fix For: 8.13, 8.12.2
>
>
> Invalid properties are silently ignored, this can be troublesome to diagnose when there is a case mismatch, etc. useConnectorMetadata vs. UseConnectorMetadata
> {code:java}
> <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
> <vdb name="test" version="1">
> <property name="useConnectorMetadata" value="true"/>
> <property name="BREAK ME" value="true"/>
>
> <model name="EMPTY">
>
> </model>
> </vdb>
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 1 month
[JBoss JIRA] (TEIID-3787) ignored properties in dynamic vdb should be flagged with a WARN log entry
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3787?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-3787.
-----------------------------------
Fix Version/s: 8.12.2
Resolution: Done
Added a detail logging specifically for what metadata caching value is used.
> ignored properties in dynamic vdb should be flagged with a WARN log entry
> -------------------------------------------------------------------------
>
> Key: TEIID-3787
> URL: https://issues.jboss.org/browse/TEIID-3787
> Project: Teiid
> Issue Type: Feature Request
> Affects Versions: 8.7.1.6_2
> Reporter: Johnathon Lee
> Assignee: Steven Hawkins
> Fix For: 8.12.2
>
>
> Invalid properties are silently ignored, this can be troublesome to diagnose when there is a case mismatch, etc. useConnectorMetadata vs. UseConnectorMetadata
> {code:java}
> <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
> <vdb name="test" version="1">
> <property name="useConnectorMetadata" value="true"/>
> <property name="BREAK ME" value="true"/>
>
> <model name="EMPTY">
>
> </model>
> </vdb>
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 1 month