[JBoss JIRA] (TEIIDDES-2916) Create temporary table results in "Error in parsing of sql - null"
by Bram Gadeyne (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2916?page=com.atlassian.jira.plu... ]
Bram Gadeyne updated TEIIDDES-2916:
-----------------------------------
Summary: Create temporary table results in "Error in parsing of sql - null" (was: "Error in parsing of sql - null" when creating a new procedure)
> Create temporary table results in "Error in parsing of sql - null"
> ------------------------------------------------------------------
>
> Key: TEIIDDES-2916
> URL: https://issues.jboss.org/browse/TEIIDDES-2916
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 10.1
> Environment: Windows 7, Eclipse mars.2 64 bit with teiid designer 10.1.0.Final-v20160815-1405-B4103
> Reporter: Bram Gadeyne
> Priority: Critical
>
> Hi,
> I'm trying to create a virtual procedure in a view model.
> I've first developed the procedure script but when I paste it I get the same error over and over again.
> I've then reduced it to the following content (which is the start of the script).
> BEGIN
> create temporary table tmp_cohort(
> patientid integer not null,
> prod boolean not null,
> PRIMARY KEY(patientid)
> );
> END
> The designer does not seem to accept the sql and it fails with the message "ERROR: Error in parsing of sql - null"
> There a no messages in the eclipse log file.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 4 months
[JBoss JIRA] (TEIIDDES-2916) "Error in parsing of sql - null" when creating a new procedure
by Bram Gadeyne (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2916?page=com.atlassian.jira.plu... ]
Bram Gadeyne commented on TEIIDDES-2916:
----------------------------------------
I've found the cause of this issue.
If you write "create local temporary table" in stead of "create temporary table" then it works fine.
> "Error in parsing of sql - null" when creating a new procedure
> ---------------------------------------------------------------
>
> Key: TEIIDDES-2916
> URL: https://issues.jboss.org/browse/TEIIDDES-2916
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 10.1
> Environment: Windows 7, Eclipse mars.2 64 bit with teiid designer 10.1.0.Final-v20160815-1405-B4103
> Reporter: Bram Gadeyne
> Priority: Critical
>
> Hi,
> I'm trying to create a virtual procedure in a view model.
> I've first developed the procedure script but when I paste it I get the same error over and over again.
> I've then reduced it to the following content (which is the start of the script).
> BEGIN
> create temporary table tmp_cohort(
> patientid integer not null,
> prod boolean not null,
> PRIMARY KEY(patientid)
> );
> END
> The designer does not seem to accept the sql and it fails with the message "ERROR: Error in parsing of sql - null"
> There a no messages in the eclipse log file.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 4 months
[JBoss JIRA] (TEIIDDES-2916) "Error in parsing of sql - null" when creating a new procedure
by Bram Gadeyne (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2916?page=com.atlassian.jira.plu... ]
Bram Gadeyne updated TEIIDDES-2916:
-----------------------------------
Environment: Windows 7, Eclipse mars.2 64 bit with teiid designer 10.1.0.Final-v20160815-1405-B4103
> "Error in parsing of sql - null" when creating a new procedure
> ---------------------------------------------------------------
>
> Key: TEIIDDES-2916
> URL: https://issues.jboss.org/browse/TEIIDDES-2916
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 10.1
> Environment: Windows 7, Eclipse mars.2 64 bit with teiid designer 10.1.0.Final-v20160815-1405-B4103
> Reporter: Bram Gadeyne
> Priority: Critical
>
> Hi,
> I'm trying to create a virtual procedure in a view model.
> I've first developed the procedure script but when I paste it I get the same error over and over again.
> I've then reduced it to the following content (which is the start of the script).
> BEGIN
> create temporary table tmp_cohort(
> patientid integer not null,
> prod boolean not null,
> PRIMARY KEY(patientid)
> );
> END
> The designer does not seem to accept the sql and it fails with the message "ERROR: Error in parsing of sql - null"
> There a no messages in the eclipse log file.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 4 months
[JBoss JIRA] (TEIIDDES-2916) "Error in parsing of sql - null" when creating a new procedure
by Bram Gadeyne (JIRA)
Bram Gadeyne created TEIIDDES-2916:
--------------------------------------
Summary: "Error in parsing of sql - null" when creating a new procedure
Key: TEIIDDES-2916
URL: https://issues.jboss.org/browse/TEIIDDES-2916
Project: Teiid Designer
Issue Type: Bug
Affects Versions: 10.1
Reporter: Bram Gadeyne
Priority: Critical
Hi,
I'm trying to create a virtual procedure in a view model.
I've first developed the procedure script but when I paste it I get the same error over and over again.
I've then reduced it to the following content (which is the start of the script).
BEGIN
create temporary table tmp_cohort(
patientid integer not null,
prod boolean not null,
PRIMARY KEY(patientid)
);
END
The designer does not seem to accept the sql and it fails with the message "ERROR: Error in parsing of sql - null"
There a no messages in the eclipse log file.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 4 months
[JBoss JIRA] (TEIIDDES-2856) Designer perspective shown twice
by Bram Gadeyne (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2856?page=com.atlassian.jira.plu... ]
Bram Gadeyne updated TEIIDDES-2856:
-----------------------------------
Affects Version/s: 10.1
> Designer perspective shown twice
> --------------------------------
>
> Key: TEIIDDES-2856
> URL: https://issues.jboss.org/browse/TEIIDDES-2856
> Project: Teiid Designer
> Issue Type: Enhancement
> Affects Versions: 10.0, 10.1
> Reporter: Bram Gadeyne
> Attachments: designer-brackets.png, designer-no-brackets.png
>
>
> Hi,
> The designer perspective is shown twice in the selection list. Is there a difference between both? The first is shown between <> and the second is shown without.
> I've added some screenshots. In the second the database models seem to be greyed out and the default server panel is not shown.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 4 months
[JBoss JIRA] (TEIIDDES-2892) VDB file is not changed after some actions. No errors are shown.
by Bram Gadeyne (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2892?page=com.atlassian.jira.plu... ]
Bram Gadeyne updated TEIIDDES-2892:
-----------------------------------
Affects Version/s: 10.1
> VDB file is not changed after some actions. No errors are shown.
> ----------------------------------------------------------------
>
> Key: TEIIDDES-2892
> URL: https://issues.jboss.org/browse/TEIIDDES-2892
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 10.0, 10.1
> Reporter: Bram Gadeyne
> Assignee: Barry LaFond
> Priority: Blocker
> Fix For: 10.0.2
>
> Attachments: .log, after_reopen.png, after_sync_all.png, rights_still_present.png, take_away_rights.png
>
>
> Hi,
> I'm using teiiddesigner 10.0 and teiid server 9.0.2.
> I've copied a previous vdb file called vdb3.14.vdb to vbd3.15.vdb and changed the version number to 15.
> I've then added a new xmi for a new database which I've generated through JDBC import.
> Now I wanted to change the permissions on this new database but I can't seem to alter the vdb file anymore.
> First off all The vdb shown some models that are not in sync with the model files. Clicking on synchronize all first shows them as beiing updated but closing and reopening the vdb file shows that they are still nog in sync.
> Opening the editor to alter the permissions also seems to work. But when you reopen the panel for the same usergroup the changes are not made.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 4 months
[JBoss JIRA] (TEIIDDES-2856) Designer perspective shown twice
by Bram Gadeyne (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2856?page=com.atlassian.jira.plu... ]
Bram Gadeyne updated TEIIDDES-2856:
-----------------------------------
Summary: Designer perspective shown twice (was: Designer perspective shown twide)
> Designer perspective shown twice
> --------------------------------
>
> Key: TEIIDDES-2856
> URL: https://issues.jboss.org/browse/TEIIDDES-2856
> Project: Teiid Designer
> Issue Type: Enhancement
> Affects Versions: 10.0, 10.1
> Reporter: Bram Gadeyne
> Attachments: designer-brackets.png, designer-no-brackets.png
>
>
> Hi,
> The designer perspective is shown twice in the selection list. Is there a difference between both? The first is shown between <> and the second is shown without.
> I've added some screenshots. In the second the database models seem to be greyed out and the default server panel is not shown.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 4 months
[JBoss JIRA] (TEIIDDES-2524) Enable DDL importer to import Teiid CREATE VIRTUAL PROCEDURE DDL
by Matus Makovy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2524?page=com.atlassian.jira.plu... ]
Matus Makovy closed TEIIDDES-2524.
----------------------------------
Tested today with TD 10.0.0.Alpha2.
Fix works.
Closing - TD JIRA Clean up
> Enable DDL importer to import Teiid CREATE VIRTUAL PROCEDURE DDL
> ----------------------------------------------------------------
>
> Key: TEIIDDES-2524
> URL: https://issues.jboss.org/browse/TEIIDDES-2524
> Project: Teiid Designer
> Issue Type: Enhancement
> Components: Import/Export
> Reporter: Barry LaFond
> Assignee: Barry LaFond
> Fix For: 9.2
>
> Attachments: TEIIDDES-2524_work_in_progress.zip
>
>
> in 9.1, we've added ability to set SQL for imported *CREATE VIEW ....* ddl via ddl importer.
> for 9.2 we'll add ability to import *CREATE VIRTUAL PROCEDURE...* ddl.
> This case is a little more complex since the SQL defined in a procedure transformation will include just the BEGIN .... END part of the SQL, so there's an additional step required to extract the relevant SQL string and apply it to the transformation
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 4 months
[JBoss JIRA] (TEIIDDES-2524) Enable DDL importer to import Teiid CREATE VIRTUAL PROCEDURE DDL
by Matus Makovy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2524?page=com.atlassian.jira.plu... ]
Matus Makovy commented on TEIIDDES-2524:
----------------------------------------
10.0.2.Alpha2 .... sorry
> Enable DDL importer to import Teiid CREATE VIRTUAL PROCEDURE DDL
> ----------------------------------------------------------------
>
> Key: TEIIDDES-2524
> URL: https://issues.jboss.org/browse/TEIIDDES-2524
> Project: Teiid Designer
> Issue Type: Enhancement
> Components: Import/Export
> Reporter: Barry LaFond
> Assignee: Barry LaFond
> Fix For: 9.2
>
> Attachments: TEIIDDES-2524_work_in_progress.zip
>
>
> in 9.1, we've added ability to set SQL for imported *CREATE VIEW ....* ddl via ddl importer.
> for 9.2 we'll add ability to import *CREATE VIRTUAL PROCEDURE...* ddl.
> This case is a little more complex since the SQL defined in a procedure transformation will include just the BEGIN .... END part of the SQL, so there's an additional step required to extract the relevant SQL string and apply it to the transformation
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 4 months