[
https://issues.jboss.org/browse/TEIID-4342?page=com.atlassian.jira.plugin...
]
Steven Hawkins resolved TEIID-4342.
-----------------------------------
Resolution: Done
Addressed by ensuring that we don't expect non-returnable anonymous procedures to
return result sets.
I did not see the behavior of not logging - rather the deployment would fail during
validation.
loadMatView afterLoadScript error when calling a function
----------------------------------------------------------
Key: TEIID-4342
URL:
https://issues.jboss.org/browse/TEIID-4342
Project: Teiid
Issue Type: Bug
Components: Query Engine
Reporter: Mark Tawk
Assignee: Steven Hawkins
Priority: Critical
Fix For: 9.1, 9.0.2
I'm using Teiid 9.0.0
Here is the afterloadscript:
"teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" 'execute
implify_dataModel.native(''ALTER TABLE "implify_data"."User"
RENAME TO "implify_data"."User_temp"'');execute
implify_dataModel.native(''ALTER TABLE
"implify_data"."User_stage" RENAME TO
"implify_data"."User"'');execute
implify_dataModel.native(''ALTER TABLE
"implify_data"."User_temp" RENAME TO
"implify_data"."User_stage"'');execute
implify_dataModel.native(''truncate table
"implify_data"."User_stage"''); SELECT
ON_VIEW_LOADED_COMPLETE(''VIEW.B7F553FA-4F52-45FE-82BD-E2C18A4658B2.User'')
'
the call of the following function is causing the exception, but i did not find the log
file where the exception is written
SELECT
ON_VIEW_LOADED_COMPLETE(''VIEW.B7F553FA-4F52-45FE-82BD-E2C18A4658B2.User'')
if I put the function into ON_VDB_DROP_SCRIPT, it is called successfully
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)