[JBoss JIRA] (TEIIDDES-2383) Transformation editor removes cache hint in SQL
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2383?page=com.atlassian.jira.plu... ]
Ramesh Reddy commented on TEIIDDES-2383:
----------------------------------------
Pushing to Komodo is not a solution IMO, basically we will not have any hint support (not just cache hint) when VDB is designed through Designer.
[~shawkins] By functional hints you mean any hints like /*+cache */, or /*+ UNNEST*/, /*+makedep*/ etc which qualify as the hints. Typically these are at the beginning of the query (in case of cache), or at the JOIN or FROM clause (incase unnest and makedep) etc. I understand, I can get them from command object, now how could I intelligently place them back after resolving? Based on prior comments I am thinking Designer has its own version of SQLStringVisitor, but I am not able to see which comment needs to go where?
> Transformation editor removes cache hint in SQL
> -----------------------------------------------
>
> Key: TEIIDDES-2383
> URL: https://issues.jboss.org/browse/TEIIDDES-2383
> Project: Teiid Designer
> Issue Type: Bug
> Components: Transformations
> Affects Versions: 8.6, 9.0
> Reporter: Jan Stastny
> Fix For: 9.1
>
>
> When adding a comment in transformation editor, the comment disappears after saving its content. It happens with any comment. This disables usage of cache hints.
--
This message was sent by Atlassian JIRA
(v6.3.8#6338)
10 years
[JBoss JIRA] (TEIIDDES-2402) Web Service Input Variables not shown after opening the model
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2402?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2402:
-----------------------------------
Fix Version/s: 9.1
9.0.2
8.6.2
> Web Service Input Variables not shown after opening the model
> -------------------------------------------------------------
>
> Key: TEIIDDES-2402
> URL: https://issues.jboss.org/browse/TEIIDDES-2402
> Project: Teiid Designer
> Issue Type: Bug
> Components: Editors, Web Services Support
> Affects Versions: 8.3.4, 9.0.1
> Reporter: Andrej Šmigala
> Assignee: Barry LaFond
> Priority: Minor
> Fix For: 9.1, 9.0.2, 8.6.2
>
> Attachments: WsVariablesProject.zip
>
>
> When opening a Web Service model editor by double-clicking the model in the model explorer, the Input Variables section is empty, even when there are variable declarations in the procedure SQL.
> Trying to add the variables using the Add or Remove variables button results in multiple identical declarations in the procedure SQL.
> When opening the model editor by double clicking the child interface or operation, the input variables are shown as expected.
--
This message was sent by Atlassian JIRA
(v6.3.8#6338)
10 years
[JBoss JIRA] (TEIIDDES-2402) Web Service Input Variables not shown after opening the model
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2402?page=com.atlassian.jira.plu... ]
Barry LaFond reassigned TEIIDDES-2402:
--------------------------------------
Assignee: Barry LaFond
> Web Service Input Variables not shown after opening the model
> -------------------------------------------------------------
>
> Key: TEIIDDES-2402
> URL: https://issues.jboss.org/browse/TEIIDDES-2402
> Project: Teiid Designer
> Issue Type: Bug
> Components: Editors, Web Services Support
> Affects Versions: 8.3.4, 9.0.1
> Reporter: Andrej Šmigala
> Assignee: Barry LaFond
> Priority: Minor
> Attachments: WsVariablesProject.zip
>
>
> When opening a Web Service model editor by double-clicking the model in the model explorer, the Input Variables section is empty, even when there are variable declarations in the procedure SQL.
> Trying to add the variables using the Add or Remove variables button results in multiple identical declarations in the procedure SQL.
> When opening the model editor by double clicking the child interface or operation, the input variables are shown as expected.
--
This message was sent by Atlassian JIRA
(v6.3.8#6338)
10 years
[JBoss JIRA] (TEIIDDES-2383) Transformation editor removes cache hint in SQL
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2383?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-2383:
----------------------------------------
The t-form framework is one of the more complex elements of Designer. Adding a pre-parser that can intercept the SQL, remove the comments, validate/resolve the remaining SQL and then re-applying the comments so they are visible to the user isn't an easy task. Not impossible, just .... complicated. We'll have more control over SQL parsing and node-definition in Komodo, so I suggest pushing this into the Komodo release timeframe?
> Transformation editor removes cache hint in SQL
> -----------------------------------------------
>
> Key: TEIIDDES-2383
> URL: https://issues.jboss.org/browse/TEIIDDES-2383
> Project: Teiid Designer
> Issue Type: Bug
> Components: Transformations
> Affects Versions: 8.6, 9.0
> Reporter: Jan Stastny
> Fix For: 9.1
>
>
> When adding a comment in transformation editor, the comment disappears after saving its content. It happens with any comment. This disables usage of cache hints.
--
This message was sent by Atlassian JIRA
(v6.3.8#6338)
10 years
[JBoss JIRA] (TEIIDDES-2349) Changes to project imported from zip cached even after deleting and reimporting
by Andrej Šmigala (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2349?page=com.atlassian.jira.plu... ]
Andrej Šmigala updated TEIIDDES-2349:
-------------------------------------
Affects Version/s: 8.3.4
9.0.1
> Changes to project imported from zip cached even after deleting and reimporting
> -------------------------------------------------------------------------------
>
> Key: TEIIDDES-2349
> URL: https://issues.jboss.org/browse/TEIIDDES-2349
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 8.3.4, 8.6.1, 9.0.1
> Environment: JBDS 8.0.0.CR1
> Teiid Designer 8.6.1.Alpha1
> Windows, Linux
> Reporter: Andrej Šmigala
> Assignee: Barry LaFond
> Attachments: ImportProject.zip
>
>
> Changes made to a project imported into the workspace from zip seem to persist even after deleting the project (including contents on disk) and importing it again.
> Closing and reopening the project after the second import or restarting JBDS solves the issue on Windows, on Linux only restarting JBDS helps.
--
This message was sent by Atlassian JIRA
(v6.3.8#6338)
10 years
[JBoss JIRA] (TEIIDDES-2349) Changes to project imported from zip cached even after deleting and reimporting
by Andrej Šmigala (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2349?page=com.atlassian.jira.plu... ]
Andrej Šmigala reopened TEIIDDES-2349:
--------------------------------------
Still seeing this issue on 9.0.1, also on 8.3.4.
When the project is not closed prior to deleting, the issue does not appear.
However, when trying to delete the project without closing it first, I _sometimes_ get error messages saying the project is out of sync with filesystem. Refreshing and deleting works as expected, i. e. the project is then imported correctly.
> Changes to project imported from zip cached even after deleting and reimporting
> -------------------------------------------------------------------------------
>
> Key: TEIIDDES-2349
> URL: https://issues.jboss.org/browse/TEIIDDES-2349
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 8.6.1
> Environment: JBDS 8.0.0.CR1
> Teiid Designer 8.6.1.Alpha1
> Windows, Linux
> Reporter: Andrej Šmigala
> Assignee: Barry LaFond
> Attachments: ImportProject.zip
>
>
> Changes made to a project imported into the workspace from zip seem to persist even after deleting the project (including contents on disk) and importing it again.
> Closing and reopening the project after the second import or restarting JBDS solves the issue on Windows, on Linux only restarting JBDS helps.
--
This message was sent by Atlassian JIRA
(v6.3.8#6338)
10 years
[JBoss JIRA] (TEIIDDES-2349) Changes to project imported from zip cached even after deleting and reimporting
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2349?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-2349:
----------------------------------------
Would suggest re-testing with latest JBDSIS 8.0 Beta1, or upcoming Beta2
> Changes to project imported from zip cached even after deleting and reimporting
> -------------------------------------------------------------------------------
>
> Key: TEIIDDES-2349
> URL: https://issues.jboss.org/browse/TEIIDDES-2349
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 8.6.1
> Environment: JBDS 8.0.0.CR1
> Teiid Designer 8.6.1.Alpha1
> Windows, Linux
> Reporter: Andrej Šmigala
> Assignee: Barry LaFond
> Attachments: ImportProject.zip
>
>
> Changes made to a project imported into the workspace from zip seem to persist even after deleting the project (including contents on disk) and importing it again.
> Closing and reopening the project after the second import or restarting JBDS solves the issue on Windows, on Linux only restarting JBDS helps.
--
This message was sent by Atlassian JIRA
(v6.3.8#6338)
10 years
[JBoss JIRA] (TEIIDDES-2349) Changes to project imported from zip cached even after deleting and reimporting
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2349?page=com.atlassian.jira.plu... ]
Barry LaFond resolved TEIIDDES-2349.
------------------------------------
Resolution: Cannot Reproduce Bug
> Changes to project imported from zip cached even after deleting and reimporting
> -------------------------------------------------------------------------------
>
> Key: TEIIDDES-2349
> URL: https://issues.jboss.org/browse/TEIIDDES-2349
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 8.6.1
> Environment: JBDS 8.0.0.CR1
> Teiid Designer 8.6.1.Alpha1
> Windows, Linux
> Reporter: Andrej Šmigala
> Assignee: Barry LaFond
> Attachments: ImportProject.zip
>
>
> Changes made to a project imported into the workspace from zip seem to persist even after deleting the project (including contents on disk) and importing it again.
> Closing and reopening the project after the second import or restarting JBDS solves the issue on Windows, on Linux only restarting JBDS helps.
--
This message was sent by Atlassian JIRA
(v6.3.8#6338)
10 years
[JBoss JIRA] (TEIIDDES-2349) Changes to project imported from zip cached even after deleting and reimporting
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2349?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-2349:
----------------------------------------
I tried reproducing today and had no luck.
In Teiid Designer, there is a Transformation SQL validation status cache that appears to be getting properly notified when models and projects are closed and/or deleted. In these cases it's clearing the affected info properly.
> Changes to project imported from zip cached even after deleting and reimporting
> -------------------------------------------------------------------------------
>
> Key: TEIIDDES-2349
> URL: https://issues.jboss.org/browse/TEIIDDES-2349
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 8.6.1
> Environment: JBDS 8.0.0.CR1
> Teiid Designer 8.6.1.Alpha1
> Windows, Linux
> Reporter: Andrej Šmigala
> Assignee: Barry LaFond
> Attachments: ImportProject.zip
>
>
> Changes made to a project imported into the workspace from zip seem to persist even after deleting the project (including contents on disk) and importing it again.
> Closing and reopening the project after the second import or restarting JBDS solves the issue on Windows, on Linux only restarting JBDS helps.
--
This message was sent by Atlassian JIRA
(v6.3.8#6338)
10 years