SQL : ROUTINE ERROR when inserting from another table
Following the documentation to insert into tableA from tableB in the SQL query box from the Management Portal :
INSERT INTO tableA (col1, col2)
SELECT col1, col2
FROM tableB
This straightforward query raises the following error :
Error #5475: routine compilation error : %sqlcq.TESTuNAMESPACE.cls305. Errors: %sqlcq.TESTuNAMESPACE.cls305.cls
ERROR: %sqlcq.TESTuNAMESPACE.csl305.1(14) :
<UNDEFINED>parseExtFrom+19^%qaqcmx
*mt("f", "1^TABLEA") :
Could someone help me decipher this error message ? Thanks for your help.
Comments
IF tableb is a linked table from another namespace, you will get a failure like this.
John
Both tables belong to the same namespace TEST_NAMESPACE.
Is there a chance this raises an error because of the content of the strings in one of the columns ? E.g : if the string is too long (though it's capped to max length 2000) or special characters are in it (like single quotes that might interfere with SQL queries).
I´ve got the same error when trying to compile the query and both tables are in the same namespace.
What else can be causing this?
WRC has identified as a possible uintended limitation and filed a report with development (Jira DP-426592).
I tried it with a small example:
.png)
I could not find any problem. Generally this variant works from my point of view.
Exceute a "PURGE CACHED QUERIES" and retry, maybe this will help.
Andreas
By the way, why is SQL not available for selection in the codesnippets?.png)
isn't SQL a first class citizen on the iris dataplatform?? ;-)
Hey Andre, thank you for mentioning that! We have this planned and will add SQL there soon!