[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 updated TEIIDDES-2665:
-----------------------------------
Fix Version/s: 11.1
(was: 11.0.1)
> 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: Barry LaFond
> Fix For: 11.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
(v7.2.3#72005)
9 years, 3 months
[JBoss JIRA] (TEIIDDES-3021) When creating pojo and the column is byte[], change to define in pojo as byte[]
by Van Halbert (JIRA)
Van Halbert created TEIIDDES-3021:
-------------------------------------
Summary: When creating pojo and the column is byte[], change to define in pojo as byte[]
Key: TEIIDDES-3021
URL: https://issues.jboss.org/browse/TEIIDDES-3021
Project: Teiid Designer
Issue Type: Bug
Components: Modeling
Reporter: Van Halbert
Priority: Critical
Instead of mapping to a ByteString data type, map to byte[].
Example:
@ProtoField(number = 7)
public byte[] getByteArrayValue() {
return byteArrayValue;
}
public void setByteArrayValue(byte[] objectValue) {
this.byteArrayValue = objectValue;
}
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
9 years, 3 months
[JBoss JIRA] (TEIIDDES-3020) Add new materialization properties
by Steven Hawkins (JIRA)
Steven Hawkins created TEIIDDES-3020:
----------------------------------------
Summary: Add new materialization properties
Key: TEIIDDES-3020
URL: https://issues.jboss.org/browse/TEIIDDES-3020
Project: Teiid Designer
Issue Type: Task
Components: Teiid Integration
Reporter: Steven Hawkins
In the teiid_rel namespace several new properties for materialized views have been added:
MATVIEW_LOADNUMBER_COLUMN - references a column name on the materialization target table. Introduced with TEIID-4641 to offer more flexibility in refresh beyond swapping
MATVIEW_WRITE_THROUGH - a boolean to denote whether updates against the view should also write into materialization target as well. Introduced with TEIID-3952
There may be more related to the status table and debezium integration.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
9 years, 3 months