]
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.