[JBoss JIRA] (TEIIDDES-2666) Add an option to not widen comparisons to string
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2666?page=com.atlassian.jira.plu... ]
Steven Hawkins deleted TEIIDDES-2666:
-------------------------------------
> Add an option to not widen comparisons to string
> ------------------------------------------------
>
> Key: TEIIDDES-2666
> URL: https://issues.jboss.org/browse/TEIIDDES-2666
> Project: Teiid Designer
> Issue Type: Quality Risk
> Reporter: Steven Hawkins
>
> 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, 8 months
[JBoss JIRA] (TEIIDDES-2664) Add OPTIONS capability to Procedure ResultSet
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2664?page=com.atlassian.jira.plu... ]
Steven Hawkins updated TEIIDDES-2664:
-------------------------------------
Description:
Teiid DDL now supports options for procedure/functions returns clause parameters:
... RETURNS (options ...) type
... RETURNS (options ...) TABLE (...)
was:
Teiid DDL now supports options for procedure/functions returns clause parameters:
> Add OPTIONS capability to Procedure ResultSet
> ---------------------------------------------
>
> Key: TEIIDDES-2664
> URL: https://issues.jboss.org/browse/TEIIDDES-2664
> Project: Teiid Designer
> Issue Type: Enhancement
> Components: Teiid Integration
> Reporter: Ramesh Reddy
>
> Teiid DDL now supports options for procedure/functions returns clause parameters:
> ... RETURNS (options ...) type
> ... RETURNS (options ...) TABLE (...)
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 8 months
[JBoss JIRA] (TEIIDDES-2666) Add an option to not widen comparisons to string
by Steven Hawkins (JIRA)
Steven Hawkins created TEIIDDES-2666:
----------------------------------------
Summary: Add an option to not widen comparisons to string
Key: TEIIDDES-2666
URL: https://issues.jboss.org/browse/TEIIDDES-2666
Project: Teiid Designer
Issue Type: Quality Risk
Components: Teiid Integration
Reporter: Steven Hawkins
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, 8 months
[JBoss JIRA] (TEIIDDES-2665) Add an option to not widen comparisons to string
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2665?page=com.atlassian.jira.plu... ]
Steven Hawkins reassigned TEIIDDES-2665:
----------------------------------------
Assignee: (was: Steven Hawkins)
> 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: Teiid Integration
> Reporter: Steven Hawkins
>
> 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, 8 months
[JBoss JIRA] (TEIIDDES-2664) Add OPTIONS capability to Procedure ResultSet
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2664?page=com.atlassian.jira.plu... ]
Steven Hawkins updated TEIIDDES-2664:
-------------------------------------
Description:
Teiid DDL now supports options for procedure/functions returns clause parameters:
was:
Currently there is no way to add metadata on Procedures return value if the return value is "ResultSet".
Actually you can call _setProperty_ add on _ColumnSet<Procedure>_ metadata object, but _DDLStringFactory_ will not recognize it, also I believe JAVACC file needs to updated for this to recognize.
> Add OPTIONS capability to Procedure ResultSet
> ---------------------------------------------
>
> Key: TEIIDDES-2664
> URL: https://issues.jboss.org/browse/TEIIDDES-2664
> Project: Teiid Designer
> Issue Type: Enhancement
> Components: Teiid Integration
> Reporter: Ramesh Reddy
>
> Teiid DDL now supports options for procedure/functions returns clause parameters:
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 8 months
[JBoss JIRA] (TEIIDDES-2665) Add an option to not widen comparisons to string
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2665?page=com.atlassian.jira.plu... ]
Steven Hawkins moved TEIID-3724 to TEIIDDES-2665:
-------------------------------------------------
Project: Teiid Designer (was: Teiid)
Key: TEIIDDES-2665 (was: TEIID-3724)
Component/s: Teiid Integration
(was: Query Engine)
Fix Version/s: (was: 8.12)
> 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: Teiid Integration
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
>
> 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, 8 months
[JBoss JIRA] (TEIIDDES-2664) Add OPTIONS capability to Procedure ResultSet
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2664?page=com.atlassian.jira.plu... ]
Steven Hawkins moved TEIID-3723 to TEIIDDES-2664:
-------------------------------------------------
Project: Teiid Designer (was: Teiid)
Key: TEIIDDES-2664 (was: TEIID-3723)
Component/s: Teiid Integration
(was: Connector API)
(was: Query Engine)
Fix Version/s: (was: 8.12)
> Add OPTIONS capability to Procedure ResultSet
> ---------------------------------------------
>
> Key: TEIIDDES-2664
> URL: https://issues.jboss.org/browse/TEIIDDES-2664
> Project: Teiid Designer
> Issue Type: Enhancement
> Components: Teiid Integration
> Reporter: Ramesh Reddy
> Assignee: Steven Hawkins
>
> Currently there is no way to add metadata on Procedures return value if the return value is "ResultSet".
> Actually you can call _setProperty_ add on _ColumnSet<Procedure>_ metadata object, but _DDLStringFactory_ will not recognize it, also I believe JAVACC file needs to updated for this to recognize.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 8 months
[JBoss JIRA] (TEIIDDES-2414) Large transformation SQL is not exported to INDEX file.
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2414?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-2414:
----------------------------------------
[~jolee] Can you work with Hisanobu and find out which version of Designer (DV) he wants the patch for?
> Large transformation SQL is not exported to INDEX file.
> -------------------------------------------------------
>
> Key: TEIIDDES-2414
> URL: https://issues.jboss.org/browse/TEIIDDES-2414
> Project: Teiid Designer
> Issue Type: Bug
> Components: Import/Export
> Affects Versions: 8.3.4
> Reporter: Hisanobu Okuda
> Assignee: Paul Richardson
> Fix For: 9.0.5, 9.3
>
> Attachments: test.csv
>
>
> A large transformation SQL of a view model is not exported to INDEX file.
> I have a large transformation SQL > 8192 bytes in my view model. TDesigner fails to convert the xmi to XXXXXXXXXX.INDEX file. There is no transformation SQL in the INDEX file, therefore, deploying my vdb fails and the vdb is inactivated. When you deploy the vdb, you can see the following message in a log file:-
> {code}
> 17:16:11,632 WARN [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31079 View ViewModel.new_table is not defined by a query expression.
> 17:16:11,636 INFO [org.teiid.RUNTIME] (teiid-async-threads - 2) TEIID40073 The metadata for the VDB test.1 is loaded, however it is not valid. Check models for errors. Correct the metadata and re-deploy.
> 17:16:11,637 INFO [org.teiid.RUNTIME] (teiid-async-threads - 2) TEIID40003 VDB test.1 is set to FAILED
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 8 months