[ https://issues.jboss.org/browse/TEIID-1554?page=com.atlassian.jira.plugin... ] Mark Addleman commented on TEIID-1554: -------------------------------------- We've applied patches to 1492, 1529 and 1545. I can test against stock 7.3 if that will help. Below is the plan output (sorry about the bad log formatting) [13:23:11.649][info][talledLocalContainer] 13:23:11,649 INFO [PLANNER] [13:23:11.649][info][talledLocalContainer] ============================================================================ [13:23:11.649][info][talledLocalContainer] USER COMMAND: [13:23:11.650][info][talledLocalContainer] SELECT C.SYSID, C.USERID, C.NAME, (SELECT COUNT(*) FROM (SELECT * FROM notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME SECURITY.BASEUSER, XMLATTRIBUTES(C.SYSID AS SYSID, C.USERID AS USERID)) AS String)) AS foo) AS CHORUS_C_notesForObject, CHORUS_J0.APPNAME AS "SYSOFUSER@APPNAME", C.UID, C.SUSPEND, C.PROC, 'SECURITY.BASEUSER' AS "__objecttype__" FROM SECURITY.BASEUSER AS C LEFT OUTER JOIN security.sysinfo AS CHORUS_J0 ON CHORUS_J0.sysid = C.sysid ORDER BY C.NAME LIMIT 990, 10 [13:23:11.650][info][talledLocalContainer] [13:23:11.650][info][talledLocalContainer] ---------------------------------------------------------------------------- [13:23:11.650][info][talledLocalContainer] OPTIMIZE: [13:23:11.650][info][talledLocalContainer] SELECT C.SYSID, C.USERID, C.NAME, (SELECT COUNT(*) FROM (SELECT * FROM notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME SECURITY.BASEUSER, XMLATTRIBUTES(C.SYSID AS SYSID, C.USERID AS USERID)) AS String)) AS foo) AS CHORUS_C_notesForObject, CHORUS_J0.APPNAME AS "SYSOFUSER@APPNAME", C.UID, C.SUSPEND, C.PROC, 'SECURITY.BASEUSER' AS "__objecttype__" FROM SECURITY.BASEUSER AS C LEFT OUTER JOIN security.sysinfo AS CHORUS_J0 ON CHORUS_J0.sysid = C.sysid ORDER BY C.NAME LIMIT 990, 10 [13:23:11.650][info][talledLocalContainer] [13:23:11.650][info][talledLocalContainer] ---------------------------------------------------------------------------- [13:23:11.650][info][talledLocalContainer] GENERATE CANONICAL: [13:23:11.650][info][talledLocalContainer] SELECT C.SYSID, C.USERID, C.NAME, (SELECT COUNT(*) FROM (SELECT * FROM notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME SECURITY.BASEUSER, XMLATTRIBUTES(C.SYSID AS SYSID, C.USERID AS USERID)) AS String)) AS foo) AS CHORUS_C_notesForObject, CHORUS_J0.APPNAME AS "SYSOFUSER@APPNAME", C.UID, C.SUSPEND, C.PROC, 'SECURITY.BASEUSER' AS "__objecttype__" FROM SECURITY.BASEUSER AS C LEFT OUTER JOIN security.sysinfo AS CHORUS_J0 ON CHORUS_J0.sysid = C.sysid ORDER BY C.NAME LIMIT 990, 10 [13:23:11.650][info][talledLocalContainer] [13:23:11.650][info][talledLocalContainer] CANONICAL PLAN: [13:23:11.650][info][talledLocalContainer] TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=10, OFFSET_TUPLE_COUNT=990}) [13:23:11.650][info][talledLocalContainer] Sort(groups=[SECURITY.BASEUSER AS C], props={SORT_ORDER=ORDER BY C.NAME}) [13:23:11.650][info][talledLocalContainer] Project(groups=[SECURITY.BASEUSER AS C, security.sysinfo AS CHORUS_J0], props={PROJECT_COLS=[C.SYSID, C.USERID, C.NAME, (SELECT COUNT(*) FROM (SELECT * FROM notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME SECURITY.BASEUSER, XMLATTRIBUTES(C.SYSID AS SYSID, C.USERID AS USERID)) AS String)) AS foo) AS CHORUS_C_notesForObject, CHORUS_J0.APPNAME AS "SYSOFUSER@APPNAME", C.UID, C.SUSPEND, C.PROC, 'SECURITY.BASEUSER' AS "__objecttype__"]}) [13:23:11.650][info][talledLocalContainer] Join(groups=[SECURITY.BASEUSER AS C, security.sysinfo AS CHORUS_J0], props={JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[CHORUS_J0.sysid = C.sysid], JOIN_TYPE=LEFT OUTER JOIN}) [13:23:11.650][info][talledLocalContainer] Source(groups=[SECURITY.BASEUSER AS C]) [13:23:11.650][info][talledLocalContainer] Source(groups=[security.sysinfo AS CHORUS_J0]) [13:23:11.650][info][talledLocalContainer] [13:23:11.650][info][talledLocalContainer] [13:23:11.650][info][talledLocalContainer] ---------------------------------------------------------------------------- [13:23:11.651][info][talledLocalContainer] OPTIMIZE: [13:23:11.651][info][talledLocalContainer] SELECT COUNT(*) FROM (SELECT * FROM notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME SECURITY.BASEUSER, XMLATTRIBUTES(C.SYSID AS SYSID, C.USERID AS USERID)) AS String)) AS foo [13:23:11.651][info][talledLocalContainer] [13:23:11.651][info][talledLocalContainer] ---------------------------------------------------------------------------- [13:23:11.651][info][talledLocalContainer] GENERATE CANONICAL: [13:23:11.651][info][talledLocalContainer] SELECT COUNT(*) FROM (SELECT * FROM notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME SECURITY.BASEUSER, XMLATTRIBUTES(C.SYSID AS SYSID, C.USERID AS USERID)) AS String)) AS foo [13:23:11.651][info][talledLocalContainer] [13:23:11.651][info][talledLocalContainer] CANONICAL PLAN: [13:23:11.651][info][talledLocalContainer] Project(groups=[], props={PROJECT_COLS=[COUNT(*)]}) [13:23:11.651][info][talledLocalContainer] Group(groups=[]) [13:23:11.651][info][talledLocalContainer] Source(groups=[foo], props={SYMBOL_MAP={FOO.ID=notes.RETRIEVE_NOTES.ID, FOO.NOTE=notes.RETRIEVE_NOTES.NOTE, FOO.USER_ID=notes.RETRIEVE_NOTES.USER_ID, FOO.NOTES_TYPE=notes.RETRIEVE_NOTES.NOTES_TYPE, FOO.ACCESS_MODE=notes.RETRIEVE_NOTES.ACCESS_MODE, FOO.CREATED_ON=notes.RETRIEVE_NOTES.CREATED_ON, FOO.OBJECT_PKEY=notes.RETRIEVE_NOTES.OBJECT_PKEY}, NESTED_COMMAND=SELECT * FROM notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME SECURITY.BASEUSER, XMLATTRIBUTES(C.SYSID AS SYSID, C.USERID AS USERID)) AS String)}) [13:23:11.651][info][talledLocalContainer] Project(groups=[notes.RETRIEVE_NOTES], props={PROJECT_COLS=[notes.RETRIEVE_NOTES.ID, notes.RETRIEVE_NOTES.NOTE, notes.RETRIEVE_NOTES.USER_ID, notes.RETRIEVE_NOTES.NOTES_TYPE, notes.RETRIEVE_NOTES.ACCESS_MODE, notes.RETRIEVE_NOTES.CREATED_ON, notes.RETRIEVE_NOTES.OBJECT_PKEY]}) [13:23:11.651][info][talledLocalContainer] Select(groups=[notes.RETRIEVE_NOTES], props={SELECT_CRITERIA=OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME SECURITY.BASEUSER, XMLATTRIBUTES(C.SYSID AS SYSID, C.USERID AS USERID)) AS String)}) [13:23:11.651][info][talledLocalContainer] Source(groups=[notes.RETRIEVE_NOTES], props={SYMBOL_MAP={notes.RETRIEVE_NOTES.ID=X.ID, notes.RETRIEVE_NOTES.NOTE=X.NOTE, notes.RETRIEVE_NOTES.USER_ID=X.USER_ID, notes.RETRIEVE_NOTES.NOTES_TYPE=X.NOTES_TYPE, notes.RETRIEVE_NOTES.ACCESS_MODE=X.ACCESS_MODE, notes.RETRIEVE_NOTES.CREATED_ON=X.CREATED_ON, notes.RETRIEVE_NOTES.OBJECT_PKEY=notes.RETRIEVE_NOTES.OBJECT_PKEY}, NESTED_COMMAND=SELECT X.*, notes.RETRIEVE_NOTES.OBJECT_PKEY AS OBJECT_PKEY FROM (EXEC notes.RETRIEVE_NOTES(notes.RETRIEVE_NOTES.OBJECT_PKEY)) AS X}) [13:23:11.651][info][talledLocalContainer] Project(groups=[X], props={PROJECT_COLS=[X.ID, X.NOTE, X.USER_ID, X.NOTES_TYPE, X.ACCESS_MODE, X.CREATED_ON, notes.RETRIEVE_NOTES.OBJECT_PKEY AS OBJECT_PKEY]}) [13:23:11.651][info][talledLocalContainer] Source(groups=[X], props={SYMBOL_MAP={X.ID=ID, X.NOTE=NOTE, X.USER_ID=USER_ID, X.NOTES_TYPE=NOTES_TYPE, X.ACCESS_MODE=ACCESS_MODE, X.CREATED_ON=CREATED_ON}, NESTED_COMMAND=EXEC notes.RETRIEVE_NOTES(notes.RETRIEVE_NOTES.OBJECT_PKEY)}) [13:23:11.651][info][talledLocalContainer] Project(groups=[], props={PROJECT_COLS=[ID, NOTE, USER_ID, NOTES_TYPE, ACCESS_MODE, CREATED_ON]}) [13:23:11.651][info][talledLocalContainer] Source(groups=[notes.RETRIEVE_NOTES], props={VIRTUAL_COMMAND=EXEC notes.RETRIEVE_NOTES(notes.RETRIEVE_NOTES.OBJECT_PKEY)}) [13:23:11.652][info][talledLocalContainer] [13:23:11.652][info][talledLocalContainer] [13:23:11.652][info][talledLocalContainer] ============================================================================ [13:23:11.652][info][talledLocalContainer] EXECUTING PlaceAccess [13:23:11.652][info][talledLocalContainer] [13:23:11.652][info][talledLocalContainer] AFTER: [13:23:11.652][info][talledLocalContainer] Project(groups=[], props={PROJECT_COLS=[COUNT(*)]}) [13:23:11.652][info][talledLocalContainer] Group(groups=[]) [13:23:11.652][info][talledLocalContainer] Source(groups=[foo], props={SYMBOL_MAP={FOO.ID=notes.RETRIEVE_NOTES.ID, FOO.NOTE=notes.RETRIEVE_NOTES.NOTE, FOO.USER_ID=notes.RETRIEVE_NOTES.USER_ID, FOO.NOTES_TYPE=notes.RETRIEVE_NOTES.NOTES_TYPE, FOO.ACCESS_MODE=notes.RETRIEVE_NOTES.ACCESS_MODE, FOO.CREATED_ON=notes.RETRIEVE_NOTES.CREATED_ON, FOO.OBJECT_PKEY=notes.RETRIEVE_NOTES.OBJECT_PKEY}, NESTED_COMMAND=SELECT * FROM notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME SECURITY.BASEUSER, XMLATTRIBUTES(C.SYSID AS SYSID, C.USERID AS USERID)) AS String)}) [13:23:11.652][info][talledLocalContainer] Project(groups=[notes.RETRIEVE_NOTES], props={PROJECT_COLS=[notes.RETRIEVE_NOTES.ID, notes.RETRIEVE_NOTES.NOTE, notes.RETRIEVE_NOTES.USER_ID, notes.RETRIEVE_NOTES.NOTES_TYPE, notes.RETRIEVE_NOTES.ACCESS_MODE, notes.RETRIEVE_NOTES.CREATED_ON, notes.RETRIEVE_NOTES.OBJECT_PKEY]}) [13:23:11.652][info][talledLocalContainer] Select(groups=[notes.RETRIEVE_NOTES], props={SELECT_CRITERIA=OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME SECURITY.BASEUSER, XMLATTRIBUTES(C.SYSID AS SYSID, C.USERID AS USERID)) AS String)}) [13:23:11.652][info][talledLocalContainer] Source(groups=[notes.RETRIEVE_NOTES], props={ACCESS_PATTERNS=[Access Pattern: Unsatisfied [notes.RETRIEVE_NOTES.OBJECT_PKEY] History [[notes.RETRIEVE_NOTES.OBJECT_PKEY]]], SYMBOL_MAP={notes.RETRIEVE_NOTES.ID=X.ID, notes.RETRIEVE_NOTES.NOTE=X.NOTE, notes.RETRIEVE_NOTES.USER_ID=X.USER_ID, notes.RETRIEVE_NOTES.NOTES_TYPE=X.NOTES_TYPE, notes.RETRIEVE_NOTES.ACCESS_MODE=X.ACCESS_MODE, notes.RETRIEVE_NOTES.CREATED_ON=X.CREATED_ON, notes.RETRIEVE_NOTES.OBJECT_PKEY=notes.RETRIEVE_NOTES.OBJECT_PKEY}, NESTED_COMMAND=SELECT X.*, notes.RETRIEVE_NOTES.OBJECT_PKEY AS OBJECT_PKEY FROM (EXEC notes.RETRIEVE_NOTES(notes.RETRIEVE_NOTES.OBJECT_PKEY)) AS X}) [13:23:11.652][info][talledLocalContainer] Project(groups=[X], props={PROJECT_COLS=[X.ID, X.NOTE, X.USER_ID, X.NOTES_TYPE, X.ACCESS_MODE, X.CREATED_ON, notes.RETRIEVE_NOTES.OBJECT_PKEY AS OBJECT_PKEY]}) [13:23:11.652][info][talledLocalContainer] Source(groups=[X], props={SYMBOL_MAP={X.ID=ID, X.NOTE=NOTE, X.USER_ID=USER_ID, X.NOTES_TYPE=NOTES_TYPE, X.ACCESS_MODE=ACCESS_MODE, X.CREATED_ON=CREATED_ON}, NESTED_COMMAND=EXEC notes.RETRIEVE_NOTES(notes.RETRIEVE_NOTES.OBJECT_PKEY)}) [13:23:11.652][info][talledLocalContainer] Project(groups=[], props={PROJECT_COLS=[ID, NOTE, USER_ID, NOTES_TYPE, ACCESS_MODE, CREATED_ON]}) [13:23:11.652][info][talledLocalContainer] Access(groups=[notes.RETRIEVE_NOTES]) [13:23:11.652][info][talledLocalContainer] Source(groups=[notes.RETRIEVE_NOTES], props={VIRTUAL_COMMAND=EXEC notes.RETRIEVE_NOTES(notes.RETRIEVE_NOTES.OBJECT_PKEY)}) [13:23:11.652][info][talledLocalContainer] [13:23:11.652][info][talledLocalContainer] [13:23:11.652][info][talledLocalContainer] ============================================================================ [13:23:11.653][info][talledLocalContainer] EXECUTING PushSelectCriteria [13:23:11.653][info][talledLocalContainer] [13:23:11.653][info][talledLocalContainer] AFTER: [13:23:11.653][info][talledLocalContainer] Project(groups=[], props={PROJECT_COLS=[COUNT(*)]}) [13:23:11.653][info][talledLocalContainer] Group(groups=[]) [13:23:11.653][info][talledLocalContainer] Source(groups=[foo], props={SYMBOL_MAP={FOO.ID=notes.RETRIEVE_NOTES.ID, FOO.NOTE=notes.RETRIEVE_NOTES.NOTE, FOO.USER_ID=notes.RETRIEVE_NOTES.USER_ID, FOO.NOTES_TYPE=notes.RETRIEVE_NOTES.NOTES_TYPE, FOO.ACCESS_MODE=notes.RETRIEVE_NOTES.ACCESS_MODE, FOO.CREATED_ON=notes.RETRIEVE_NOTES.CREATED_ON, FOO.OBJECT_PKEY=notes.RETRIEVE_NOTES.OBJECT_PKEY}, NESTED_COMMAND=SELECT * FROM notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME SECURITY.BASEUSER, XMLATTRIBUTES(C.SYSID AS SYSID, C.USERID AS USERID)) AS String)}) [13:23:11.653][info][talledLocalContainer] Project(groups=[notes.RETRIEVE_NOTES], props={PROJECT_COLS=[notes.RETRIEVE_NOTES.ID, notes.RETRIEVE_NOTES.NOTE, notes.RETRIEVE_NOTES.USER_ID, notes.RETRIEVE_NOTES.NOTES_TYPE, notes.RETRIEVE_NOTES.ACCESS_MODE, notes.RETRIEVE_NOTES.CREATED_ON, notes.RETRIEVE_NOTES.OBJECT_PKEY]}) [13:23:11.653][info][talledLocalContainer] Select(groups=[notes.RETRIEVE_NOTES], props={SELECT_CRITERIA=OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME SECURITY.BASEUSER, XMLATTRIBUTES(C.SYSID AS SYSID, C.USERID AS USERID)) AS String), IS_PHANTOM=true}) [13:23:11.653][info][talledLocalContainer] Source(groups=[notes.RETRIEVE_NOTES], props={SYMBOL_MAP={notes.RETRIEVE_NOTES.ID=X.ID, notes.RETRIEVE_NOTES.NOTE=X.NOTE, notes.RETRIEVE_NOTES.USER_ID=X.USER_ID, notes.RETRIEVE_NOTES.NOTES_TYPE=X.NOTES_TYPE, notes.RETRIEVE_NOTES.ACCESS_MODE=X.ACCESS_MODE, notes.RETRIEVE_NOTES.CREATED_ON=X.CREATED_ON, notes.RETRIEVE_NOTES.OBJECT_PKEY=notes.RETRIEVE_NOTES.OBJECT_PKEY}, NESTED_COMMAND=SELECT X.*, notes.RETRIEVE_NOTES.OBJECT_PKEY AS OBJECT_PKEY FROM (EXEC notes.RETRIEVE_NOTES(notes.RETRIEVE_NOTES.OBJECT_PKEY)) AS X}) [13:23:11.653][info][talledLocalContainer] Project(groups=[X], props={PROJECT_COLS=[X.ID, X.NOTE, X.USER_ID, X.NOTES_TYPE, X.ACCESS_MODE, X.CREATED_ON, notes.RETRIEVE_NOTES.OBJECT_PKEY AS OBJECT_PKEY]}) [13:23:11.653][info][talledLocalContainer] Select(groups=[], props={SELECT_CRITERIA=notes.RETRIEVE_NOTES.OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME SECURITY.BASEUSER, XMLATTRIBUTES(C.SYSID AS SYSID, C.USERID AS USERID)) AS String)}) [13:23:11.653][info][talledLocalContainer] Source(groups=[X], props={SYMBOL_MAP={X.ID=ID, X.NOTE=NOTE, X.USER_ID=USER_ID, X.NOTES_TYPE=NOTES_TYPE, X.ACCESS_MODE=ACCESS_MODE, X.CREATED_ON=CREATED_ON}, NESTED_COMMAND=EXEC notes.RETRIEVE_NOTES(notes.RETRIEVE_NOTES.OBJECT_PKEY)}) [13:23:11.653][info][talledLocalContainer] Project(groups=[], props={PROJECT_COLS=[ID, NOTE, USER_ID, NOTES_TYPE, ACCESS_MODE, CREATED_ON]}) [13:23:11.653][info][talledLocalContainer] Access(groups=[notes.RETRIEVE_NOTES]) [13:23:11.653][info][talledLocalContainer] Source(groups=[notes.RETRIEVE_NOTES], props={VIRTUAL_COMMAND=EXEC notes.RETRIEVE_NOTES(notes.RETRIEVE_NOTES.OBJECT_PKEY)}) [13:23:11.653][info][talledLocalContainer] [13:23:11.653][info][talledLocalContainer] [13:23:11.653][info][talledLocalContainer] ============================================================================ [13:23:11.653][info][talledLocalContainer] EXECUTING MergeVirtual [13:23:11.654][info][talledLocalContainer] [13:23:11.654][info][talledLocalContainer] AFTER: [13:23:11.654][info][talledLocalContainer] Project(groups=[], props={PROJECT_COLS=[COUNT(*)]}) [13:23:11.654][info][talledLocalContainer] Group(groups=[]) [13:23:11.654][info][talledLocalContainer] Select(groups=[notes.RETRIEVE_NOTES], props={SELECT_CRITERIA=OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME SECURITY.BASEUSER, XMLATTRIBUTES(C.SYSID AS SYSID, C.USERID AS USERID)) AS String), IS_PHANTOM=true}) [13:23:11.654][info][talledLocalContainer] Source(groups=[notes.RETRIEVE_NOTES], props={SYMBOL_MAP={notes.RETRIEVE_NOTES.ID=X.ID, notes.RETRIEVE_NOTES.NOTE=X.NOTE, notes.RETRIEVE_NOTES.USER_ID=X.USER_ID, notes.RETRIEVE_NOTES.NOTES_TYPE=X.NOTES_TYPE, notes.RETRIEVE_NOTES.ACCESS_MODE=X.ACCESS_MODE, notes.RETRIEVE_NOTES.CREATED_ON=X.CREATED_ON, notes.RETRIEVE_NOTES.OBJECT_PKEY=notes.RETRIEVE_NOTES.OBJECT_PKEY}, NESTED_COMMAND=SELECT X.*, notes.RETRIEVE_NOTES.OBJECT_PKEY AS OBJECT_PKEY FROM (EXEC notes.RETRIEVE_NOTES(notes.RETRIEVE_NOTES.OBJECT_PKEY)) AS X}) [13:23:11.654][info][talledLocalContainer] Project(groups=[X], props={PROJECT_COLS=[X.ID, X.NOTE, X.USER_ID, X.NOTES_TYPE, X.ACCESS_MODE, X.CREATED_ON, notes.RETRIEVE_NOTES.OBJECT_PKEY AS OBJECT_PKEY]}) [13:23:11.654][info][talledLocalContainer] Select(groups=[], props={SELECT_CRITERIA=notes.RETRIEVE_NOTES.OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME SECURITY.BASEUSER, XMLATTRIBUTES(C.SYSID AS SYSID, C.USERID AS USERID)) AS String)}) [13:23:11.654][info][talledLocalContainer] Source(groups=[X], props={SYMBOL_MAP={X.ID=ID, X.NOTE=NOTE, X.USER_ID=USER_ID, X.NOTES_TYPE=NOTES_TYPE, X.ACCESS_MODE=ACCESS_MODE, X.CREATED_ON=CREATED_ON}, NESTED_COMMAND=EXEC notes.RETRIEVE_NOTES(notes.RETRIEVE_NOTES.OBJECT_PKEY)}) [13:23:11.654][info][talledLocalContainer] Project(groups=[], props={PROJECT_COLS=[ID, NOTE, USER_ID, NOTES_TYPE, ACCESS_MODE, CREATED_ON]}) [13:23:11.654][info][talledLocalContainer] Access(groups=[notes.RETRIEVE_NOTES]) [13:23:11.654][info][talledLocalContainer] Source(groups=[notes.RETRIEVE_NOTES], props={VIRTUAL_COMMAND=EXEC notes.RETRIEVE_NOTES(notes.RETRIEVE_NOTES.OBJECT_PKEY)}) [13:23:11.654][info][talledLocalContainer] [13:23:11.654][info][talledLocalContainer] [13:23:11.654][info][talledLocalContainer] ============================================================================ [13:23:11.654][info][talledLocalContainer] EXECUTING CleanCriteria [13:23:11.654][info][talledLocalContainer] [13:23:11.654][info][talledLocalContainer] AFTER: [13:23:11.654][info][talledLocalContainer] Project(groups=[], props={PROJECT_COLS=[COUNT(*)]}) [13:23:11.654][info][talledLocalContainer] Group(groups=[]) [13:23:11.654][info][talledLocalContainer] Source(groups=[notes.RETRIEVE_NOTES], props={SYMBOL_MAP={notes.RETRIEVE_NOTES.ID=X.ID, notes.RETRIEVE_NOTES.NOTE=X.NOTE, notes.RETRIEVE_NOTES.USER_ID=X.USER_ID, notes.RETRIEVE_NOTES.NOTES_TYPE=X.NOTES_TYPE, notes.RETRIEVE_NOTES.ACCESS_MODE=X.ACCESS_MODE, notes.RETRIEVE_NOTES.CREATED_ON=X.CREATED_ON, notes.RETRIEVE_NOTES.OBJECT_PKEY=notes.RETRIEVE_NOTES.OBJECT_PKEY}, NESTED_COMMAND=SELECT X.*, notes.RETRIEVE_NOTES.OBJECT_PKEY AS OBJECT_PKEY FROM (EXEC notes.RETRIEVE_NOTES(notes.RETRIEVE_NOTES.OBJECT_PKEY)) AS X}) [13:23:11.655][info][talledLocalContainer] Project(groups=[X], props={PROJECT_COLS=[X.ID, X.NOTE, X.USER_ID, X.NOTES_TYPE, X.ACCESS_MODE, X.CREATED_ON, notes.RETRIEVE_NOTES.OBJECT_PKEY AS OBJECT_PKEY]}) [13:23:11.655][info][talledLocalContainer] Select(groups=[], props={SELECT_CRITERIA=notes.RETRIEVE_NOTES.OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME SECURITY.BASEUSER, XMLATTRIBUTES(C.SYSID AS SYSID, C.USERID AS USERID)) AS String)}) [13:23:11.655][info][talledLocalContainer] Source(groups=[X], props={SYMBOL_MAP={X.ID=ID, X.NOTE=NOTE, X.USER_ID=USER_ID, X.NOTES_TYPE=NOTES_TYPE, X.ACCESS_MODE=ACCESS_MODE, X.CREATED_ON=CREATED_ON}, NESTED_COMMAND=EXEC notes.RETRIEVE_NOTES(notes.RETRIEVE_NOTES.OBJECT_PKEY)}) [13:23:11.655][info][talledLocalContainer] Project(groups=[], props={PROJECT_COLS=[ID, NOTE, USER_ID, NOTES_TYPE, ACCESS_MODE, CREATED_ON]}) [13:23:11.655][info][talledLocalContainer] Access(groups=[notes.RETRIEVE_NOTES]) [13:23:11.655][info][talledLocalContainer] Source(groups=[notes.RETRIEVE_NOTES], props={VIRTUAL_COMMAND=EXEC notes.RETRIEVE_NOTES(notes.RETRIEVE_NOTES.OBJECT_PKEY)}) [13:23:11.655][info][talledLocalContainer] [13:23:11.655][info][talledLocalContainer] [13:23:11.655][info][talledLocalContainer] ============================================================================ [13:23:11.655][info][talledLocalContainer] EXECUTING RaiseAccess [13:23:11.655][info][talledLocalContainer] [13:23:11.655][info][talledLocalContainer] AFTER: [13:23:11.655][info][talledLocalContainer] Project(groups=[], props={PROJECT_COLS=[COUNT(*)]}) [13:23:11.655][info][talledLocalContainer] Group(groups=[]) [13:23:11.655][info][talledLocalContainer] Source(groups=[notes.RETRIEVE_NOTES], props={SYMBOL_MAP={notes.RETRIEVE_NOTES.ID=X.ID, notes.RETRIEVE_NOTES.NOTE=X.NOTE, notes.RETRIEVE_NOTES.USER_ID=X.USER_ID, notes.RETRIEVE_NOTES.NOTES_TYPE=X.NOTES_TYPE, notes.RETRIEVE_NOTES.ACCESS_MODE=X.ACCESS_MODE, notes.RETRIEVE_NOTES.CREATED_ON=X.CREATED_ON, notes.RETRIEVE_NOTES.OBJECT_PKEY=notes.RETRIEVE_NOTES.OBJECT_PKEY}, NESTED_COMMAND=SELECT X.*, notes.RETRIEVE_NOTES.OBJECT_PKEY AS OBJECT_PKEY FROM (EXEC notes.RETRIEVE_NOTES(notes.RETRIEVE_NOTES.OBJECT_PKEY)) AS X}) [13:23:11.655][info][talledLocalContainer] Project(groups=[X], props={PROJECT_COLS=[X.ID, X.NOTE, X.USER_ID, X.NOTES_TYPE, X.ACCESS_MODE, X.CREATED_ON, notes.RETRIEVE_NOTES.OBJECT_PKEY AS OBJECT_PKEY]}) [13:23:11.655][info][talledLocalContainer] Select(groups=[], props={SELECT_CRITERIA=notes.RETRIEVE_NOTES.OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME SECURITY.BASEUSER, XMLATTRIBUTES(C.SYSID AS SYSID, C.USERID AS USERID)) AS String)}) [13:23:11.655][info][talledLocalContainer] Source(groups=[X], props={SYMBOL_MAP={X.ID=ID, X.NOTE=NOTE, X.USER_ID=USER_ID, X.NOTES_TYPE=NOTES_TYPE, X.ACCESS_MODE=ACCESS_MODE, X.CREATED_ON=CREATED_ON}, NESTED_COMMAND=EXEC notes.RETRIEVE_NOTES(notes.RETRIEVE_NOTES.OBJECT_PKEY)}) [13:23:11.655][info][talledLocalContainer] Project(groups=[], props={PROJECT_COLS=[ID, NOTE, USER_ID, NOTES_TYPE, ACCESS_MODE, CREATED_ON]}) [13:23:11.656][info][talledLocalContainer] Access(groups=[notes.RETRIEVE_NOTES], props={MODEL_ID=__TEMP__}) [13:23:11.656][info][talledLocalContainer] Source(groups=[notes.RETRIEVE_NOTES], props={VIRTUAL_COMMAND=EXEC notes.RETRIEVE_NOTES(notes.RETRIEVE_NOTES.OBJECT_PKEY)}) [13:23:11.656][info][talledLocalContainer] [13:23:11.656][info][talledLocalContainer] [13:23:11.656][info][talledLocalContainer] ============================================================================ [13:23:11.656][info][talledLocalContainer] EXECUTING PushAggregates [13:23:11.656][info][talledLocalContainer] [13:23:11.656][info][talledLocalContainer] AFTER: [13:23:11.656][info][talledLocalContainer] Project(groups=[], props={PROJECT_COLS=[COUNT(*)]}) [13:23:11.656][info][talledLocalContainer] Group(groups=[]) [13:23:11.656][info][talledLocalContainer] Source(groups=[notes.RETRIEVE_NOTES], props={SYMBOL_MAP={notes.RETRIEVE_NOTES.ID=X.ID, notes.RETRIEVE_NOTES.NOTE=X.NOTE, notes.RETRIEVE_NOTES.USER_ID=X.USER_ID, notes.RETRIEVE_NOTES.NOTES_TYPE=X.NOTES_TYPE, notes.RETRIEVE_NOTES.ACCESS_MODE=X.ACCESS_MODE, notes.RETRIEVE_NOTES.CREATED_ON=X.CREATED_ON, notes.RETRIEVE_NOTES.OBJECT_PKEY=notes.RETRIEVE_NOTES.OBJECT_PKEY}, NESTED_COMMAND=SELECT X.*, notes.RETRIEVE_NOTES.OBJECT_PKEY AS OBJECT_PKEY FROM (EXEC notes.RETRIEVE_NOTES(notes.RETRIEVE_NOTES.OBJECT_PKEY)) AS X}) [13:23:11.656][info][talledLocalContainer] Project(groups=[X], props={PROJECT_COLS=[X.ID, X.NOTE, X.USER_ID, X.NOTES_TYPE, X.ACCESS_MODE, X.CREATED_ON, notes.RETRIEVE_NOTES.OBJECT_PKEY AS OBJECT_PKEY]}) [13:23:11.656][info][talledLocalContainer] Select(groups=[], props={SELECT_CRITERIA=notes.RETRIEVE_NOTES.OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME SECURITY.BASEUSER, XMLATTRIBUTES(C.SYSID AS SYSID, C.USERID AS USERID)) AS String)}) [13:23:11.656][info][talledLocalContainer] Source(groups=[X], props={SYMBOL_MAP={X.ID=ID, X.NOTE=NOTE, X.USER_ID=USER_ID, X.NOTES_TYPE=NOTES_TYPE, X.ACCESS_MODE=ACCESS_MODE, X.CREATED_ON=CREATED_ON}, NESTED_COMMAND=EXEC notes.RETRIEVE_NOTES(notes.RETRIEVE_NOTES.OBJECT_PKEY)}) [13:23:11.656][info][talledLocalContainer] Project(groups=[], props={PROJECT_COLS=[ID, NOTE, USER_ID, NOTES_TYPE, ACCESS_MODE, CREATED_ON]}) [13:23:11.656][info][talledLocalContainer] Access(groups=[notes.RETRIEVE_NOTES], props={MODEL_ID=__TEMP__}) [13:23:11.656][info][talledLocalContainer] Source(groups=[notes.RETRIEVE_NOTES], props={VIRTUAL_COMMAND=EXEC notes.RETRIEVE_NOTES(notes.RETRIEVE_NOTES.OBJECT_PKEY)}) [13:23:11.656][info][talledLocalContainer] [13:23:11.656][info][talledLocalContainer] [13:23:11.656][info][talledLocalContainer] ============================================================================ [13:23:11.656][info][talledLocalContainer] EXECUTING PlanProcedures [13:23:11.657][info][talledLocalContainer] [13:23:11.657][info][talledLocalContainer] AFTER: [13:23:11.657][info][talledLocalContainer] Project(groups=[], props={PROJECT_COLS=[COUNT(*)]}) [13:23:11.657][info][talledLocalContainer] Group(groups=[]) [13:23:11.657][info][talledLocalContainer] Source(groups=[notes.RETRIEVE_NOTES], props={SYMBOL_MAP={notes.RETRIEVE_NOTES.ID=X.ID, notes.RETRIEVE_NOTES.NOTE=X.NOTE, notes.RETRIEVE_NOTES.USER_ID=X.USER_ID, notes.RETRIEVE_NOTES.NOTES_TYPE=X.NOTES_TYPE, notes.RETRIEVE_NOTES.ACCESS_MODE=X.ACCESS_MODE, notes.RETRIEVE_NOTES.CREATED_ON=X.CREATED_ON, notes.RETRIEVE_NOTES.OBJECT_PKEY=notes.RETRIEVE_NOTES.OBJECT_PKEY}, NESTED_COMMAND=SELECT X.*, notes.RETRIEVE_NOTES.OBJECT_PKEY AS OBJECT_PKEY FROM (EXEC notes.RETRIEVE_NOTES(notes.RETRIEVE_NOTES.OBJECT_PKEY)) AS X}) [13:23:11.657][info][talledLocalContainer] Project(groups=[X], props={PROJECT_COLS=[X.ID, X.NOTE, X.USER_ID, X.NOTES_TYPE, X.ACCESS_MODE, X.CREATED_ON, notes.RETRIEVE_NOTES.OBJECT_PKEY AS OBJECT_PKEY]}) [13:23:11.657][info][talledLocalContainer] Source(groups=[X], props={SYMBOL_MAP={X.ID=ID, X.NOTE=NOTE, X.USER_ID=USER_ID, X.NOTES_TYPE=NOTES_TYPE, X.ACCESS_MODE=ACCESS_MODE, X.CREATED_ON=CREATED_ON}, NESTED_COMMAND=EXEC notes.RETRIEVE_NOTES(notes.RETRIEVE_NOTES.OBJECT_PKEY)}) [13:23:11.657][info][talledLocalContainer] Project(groups=[], props={PROJECT_COLS=[ID, NOTE, USER_ID, NOTES_TYPE, ACCESS_MODE, CREATED_ON]}) [13:23:11.657][info][talledLocalContainer] Access(groups=[notes.RETRIEVE_NOTES], props={PROCEDURE_DEFAULTS=[null], PROCEDURE_CRITERIA=notes.RETRIEVE_NOTES.OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME SECURITY.BASEUSER, XMLATTRIBUTES(C.SYSID AS SYSID, C.USERID AS USERID)) AS String), MODEL_ID=__TEMP__, IS_DEPENDENT_SET=true, PROCEDURE_INPUTS=[notes.RETRIEVE_NOTES.OBJECT_PKEY]}) [13:23:11.657][info][talledLocalContainer] Source(groups=[notes.RETRIEVE_NOTES], props={VIRTUAL_COMMAND=EXEC notes.RETRIEVE_NOTES(notes.RETRIEVE_NOTES.OBJECT_PKEY)}) [13:23:11.657][info][talledLocalContainer] [13:23:11.657][info][talledLocalContainer] [13:23:11.657][info][talledLocalContainer] ============================================================================ [13:23:11.657][info][talledLocalContainer] EXECUTING CalculateCost [13:23:11.657][info][talledLocalContainer] [13:23:11.657][info][talledLocalContainer] AFTER: [13:23:11.657][info][talledLocalContainer] Project(groups=[], props={EST_CARDINALITY=1.0, PROJECT_COLS=[COUNT(*)]}) [13:23:11.657][info][talledLocalContainer] Group(groups=[], props={EST_CARDINALITY=1.0}) [13:23:11.657][info][talledLocalContainer] Source(groups=[notes.RETRIEVE_NOTES], props={EST_CARDINALITY=-1.0, SYMBOL_MAP={notes.RETRIEVE_NOTES.ID=X.ID, notes.RETRIEVE_NOTES.NOTE=X.NOTE, notes.RETRIEVE_NOTES.USER_ID=X.USER_ID, notes.RETRIEVE_NOTES.NOTES_TYPE=X.NOTES_TYPE, notes.RETRIEVE_NOTES.ACCESS_MODE=X.ACCESS_MODE, notes.RETRIEVE_NOTES.CREATED_ON=X.CREATED_ON, notes.RETRIEVE_NOTES.OBJECT_PKEY=notes.RETRIEVE_NOTES.OBJECT_PKEY}, NESTED_COMMAND=SELECT X.*, notes.RETRIEVE_NOTES.OBJECT_PKEY AS OBJECT_PKEY FROM (EXEC notes.RETRIEVE_NOTES(notes.RETRIEVE_NOTES.OBJECT_PKEY)) AS X}) [13:23:11.658][info][talledLocalContainer] Project(groups=[X], props={EST_CARDINALITY=-1.0, PROJECT_COLS=[X.ID, X.NOTE, X.USER_ID, X.NOTES_TYPE, X.ACCESS_MODE, X.CREATED_ON, notes.RETRIEVE_NOTES.OBJECT_PKEY AS OBJECT_PKEY]}) [13:23:11.658][info][talledLocalContainer] Source(groups=[X], props={EST_CARDINALITY=-1.0, SYMBOL_MAP={X.ID=ID, X.NOTE=NOTE, X.USER_ID=USER_ID, X.NOTES_TYPE=NOTES_TYPE, X.ACCESS_MODE=ACCESS_MODE, X.CREATED_ON=CREATED_ON}, NESTED_COMMAND=EXEC notes.RETRIEVE_NOTES(notes.RETRIEVE_NOTES.OBJECT_PKEY)}) [13:23:11.658][info][talledLocalContainer] Project(groups=[], props={EST_CARDINALITY=-1.0, PROJECT_COLS=[ID, NOTE, USER_ID, NOTES_TYPE, ACCESS_MODE, CREATED_ON]}) [13:23:11.658][info][talledLocalContainer] Access(groups=[notes.RETRIEVE_NOTES], props={PROCEDURE_DEFAULTS=[null], PROCEDURE_CRITERIA=notes.RETRIEVE_NOTES.OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME SECURITY.BASEUSER, XMLATTRIBUTES(C.SYSID AS SYSID, C.USERID AS USERID)) AS String), MODEL_ID=__TEMP__, EST_CARDINALITY=-1.0, IS_DEPENDENT_SET=true, PROCEDURE_INPUTS=[notes.RETRIEVE_NOTES.OBJECT_PKEY]}) [13:23:11.658][info][talledLocalContainer] Source(groups=[notes.RETRIEVE_NOTES], props={EST_CARDINALITY=-1.0, VIRTUAL_COMMAND=EXEC notes.RETRIEVE_NOTES(notes.RETRIEVE_NOTES.OBJECT_PKEY)}) [13:23:11.658][info][talledLocalContainer] [13:23:11.658][info][talledLocalContainer] [13:23:11.658][info][talledLocalContainer] ============================================================================ [13:23:11.658][info][talledLocalContainer] EXECUTING AssignOutputElements [13:23:11.658][info][talledLocalContainer] [13:23:11.658][info][talledLocalContainer] AFTER: [13:23:11.658][info][talledLocalContainer] Project(groups=[], props={EST_CARDINALITY=1.0, OUTPUT_COLS=[COUNT(*)], PROJECT_COLS=[COUNT(*)]}) [13:23:11.658][info][talledLocalContainer] Group(groups=[], props={EST_CARDINALITY=1.0, OUTPUT_COLS=[COUNT(*)]}) [13:23:11.658][info][talledLocalContainer] Source(groups=[notes.RETRIEVE_NOTES], props={EST_CARDINALITY=-1.0, OUTPUT_COLS=[notes.RETRIEVE_NOTES.ID], SYMBOL_MAP={notes.RETRIEVE_NOTES.ID=X.ID}, NESTED_COMMAND=SELECT X.*, notes.RETRIEVE_NOTES.OBJECT_PKEY AS OBJECT_PKEY FROM (EXEC notes.RETRIEVE_NOTES(notes.RETRIEVE_NOTES.OBJECT_PKEY)) AS X}) [13:23:11.658][info][talledLocalContainer] Project(groups=[X], props={EST_CARDINALITY=-1.0, OUTPUT_COLS=[X.ID], PROJECT_COLS=[X.ID]}) [13:23:11.658][info][talledLocalContainer] Source(groups=[X], props={EST_CARDINALITY=-1.0, OUTPUT_COLS=[X.ID], SYMBOL_MAP={X.ID=ID}, NESTED_COMMAND=EXEC notes.RETRIEVE_NOTES(notes.RETRIEVE_NOTES.OBJECT_PKEY)}) [13:23:11.658][info][talledLocalContainer] Project(groups=[], props={EST_CARDINALITY=-1.0, OUTPUT_COLS=[ID], PROJECT_COLS=[ID]}) [13:23:11.658][info][talledLocalContainer] Access(groups=[notes.RETRIEVE_NOTES], props={PROCEDURE_DEFAULTS=[null], PROCEDURE_CRITERIA=notes.RETRIEVE_NOTES.OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME SECURITY.BASEUSER, XMLATTRIBUTES(C.SYSID AS SYSID, C.USERID AS USERID)) AS String), MODEL_ID=__TEMP__, EST_CARDINALITY=-1.0, IS_DEPENDENT_SET=true, OUTPUT_COLS=[ID, NOTE, USER_ID, NOTES_TYPE, ACCESS_MODE, CREATED_ON], PROCEDURE_INPUTS=[notes.RETRIEVE_NOTES.OBJECT_PKEY]}) [13:23:11.659][info][talledLocalContainer] Source(groups=[notes.RETRIEVE_NOTES], props={EST_CARDINALITY=-1.0, OUTPUT_COLS=[ID], VIRTUAL_COMMAND=EXEC notes.RETRIEVE_NOTES(notes.RETRIEVE_NOTES.OBJECT_PKEY)}) [13:23:11.659][info][talledLocalContainer] [13:23:11.659][info][talledLocalContainer] [13:23:11.659][info][talledLocalContainer] ============================================================================ [13:23:11.659][info][talledLocalContainer] EXECUTING MergeCriteria [13:23:11.659][info][talledLocalContainer] [13:23:11.659][info][talledLocalContainer] AFTER: [13:23:11.659][info][talledLocalContainer] Project(groups=[], props={EST_CARDINALITY=1.0, OUTPUT_COLS=[COUNT(*)], PROJECT_COLS=[COUNT(*)]}) [13:23:11.659][info][talledLocalContainer] Group(groups=[], props={EST_CARDINALITY=1.0, OUTPUT_COLS=[COUNT(*)]}) [13:23:11.659][info][talledLocalContainer] Source(groups=[notes.RETRIEVE_NOTES], props={EST_CARDINALITY=-1.0, OUTPUT_COLS=[notes.RETRIEVE_NOTES.ID], SYMBOL_MAP={notes.RETRIEVE_NOTES.ID=X.ID}, NESTED_COMMAND=SELECT X.*, notes.RETRIEVE_NOTES.OBJECT_PKEY AS OBJECT_PKEY FROM (EXEC notes.RETRIEVE_NOTES(notes.RETRIEVE_NOTES.OBJECT_PKEY)) AS X}) [13:23:11.659][info][talledLocalContainer] Project(groups=[X], props={EST_CARDINALITY=-1.0, OUTPUT_COLS=[X.ID], PROJECT_COLS=[X.ID]}) [13:23:11.659][info][talledLocalContainer] Source(groups=[X], props={EST_CARDINALITY=-1.0, OUTPUT_COLS=[X.ID], SYMBOL_MAP={X.ID=ID}, NESTED_COMMAND=EXEC notes.RETRIEVE_NOTES(notes.RETRIEVE_NOTES.OBJECT_PKEY)}) [13:23:11.659][info][talledLocalContainer] Project(groups=[], props={EST_CARDINALITY=-1.0, OUTPUT_COLS=[ID], PROJECT_COLS=[ID]}) [13:23:11.659][info][talledLocalContainer] Access(groups=[notes.RETRIEVE_NOTES], props={PROCEDURE_DEFAULTS=[null], PROCEDURE_CRITERIA=notes.RETRIEVE_NOTES.OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME SECURITY.BASEUSER, XMLATTRIBUTES(C.SYSID AS SYSID, C.USERID AS USERID)) AS String), MODEL_ID=__TEMP__, EST_CARDINALITY=-1.0, IS_DEPENDENT_SET=true, OUTPUT_COLS=[ID, NOTE, USER_ID, NOTES_TYPE, ACCESS_MODE, CREATED_ON], PROCEDURE_INPUTS=[notes.RETRIEVE_NOTES.OBJECT_PKEY]}) [13:23:11.659][info][talledLocalContainer] Source(groups=[notes.RETRIEVE_NOTES], props={EST_CARDINALITY=-1.0, OUTPUT_COLS=[ID], VIRTUAL_COMMAND=EXEC notes.RETRIEVE_NOTES(notes.RETRIEVE_NOTES.OBJECT_PKEY)}) [13:23:11.659][info][talledLocalContainer] [13:23:11.659][info][talledLocalContainer] [13:23:11.659][info][talledLocalContainer] ============================================================================ [13:23:11.659][info][talledLocalContainer] EXECUTING PlanSorts [13:23:11.659][info][talledLocalContainer] [13:23:11.660][info][talledLocalContainer] AFTER: [13:23:11.660][info][talledLocalContainer] Project(groups=[], props={EST_CARDINALITY=1.0, OUTPUT_COLS=[COUNT(*)], PROJECT_COLS=[COUNT(*)]}) [13:23:11.660][info][talledLocalContainer] Group(groups=[], props={EST_CARDINALITY=1.0, OUTPUT_COLS=[COUNT(*)]}) [13:23:11.660][info][talledLocalContainer] Source(groups=[notes.RETRIEVE_NOTES], props={EST_CARDINALITY=-1.0, OUTPUT_COLS=[notes.RETRIEVE_NOTES.ID], SYMBOL_MAP={notes.RETRIEVE_NOTES.ID=X.ID}, NESTED_COMMAND=SELECT X.*, notes.RETRIEVE_NOTES.OBJECT_PKEY AS OBJECT_PKEY FROM (EXEC notes.RETRIEVE_NOTES(notes.RETRIEVE_NOTES.OBJECT_PKEY)) AS X}) [13:23:11.660][info][talledLocalContainer] Project(groups=[X], props={EST_CARDINALITY=-1.0, OUTPUT_COLS=[X.ID], PROJECT_COLS=[X.ID]}) [13:23:11.660][info][talledLocalContainer] Source(groups=[X], props={EST_CARDINALITY=-1.0, OUTPUT_COLS=[X.ID], SYMBOL_MAP={X.ID=ID}, NESTED_COMMAND=EXEC notes.RETRIEVE_NOTES(notes.RETRIEVE_NOTES.OBJECT_PKEY)}) [13:23:11.660][info][talledLocalContainer] Project(groups=[], props={EST_CARDINALITY=-1.0, OUTPUT_COLS=[ID], PROJECT_COLS=[ID]}) [13:23:11.660][info][talledLocalContainer] Access(groups=[notes.RETRIEVE_NOTES], props={PROCEDURE_DEFAULTS=[null], PROCEDURE_CRITERIA=notes.RETRIEVE_NOTES.OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME SECURITY.BASEUSER, XMLATTRIBUTES(C.SYSID AS SYSID, C.USERID AS USERID)) AS String), MODEL_ID=__TEMP__, EST_CARDINALITY=-1.0, IS_DEPENDENT_SET=true, OUTPUT_COLS=[ID, NOTE, USER_ID, NOTES_TYPE, ACCESS_MODE, CREATED_ON], PROCEDURE_INPUTS=[notes.RETRIEVE_NOTES.OBJECT_PKEY]}) [13:23:11.660][info][talledLocalContainer] Source(groups=[notes.RETRIEVE_NOTES], props={EST_CARDINALITY=-1.0, OUTPUT_COLS=[ID], VIRTUAL_COMMAND=EXEC notes.RETRIEVE_NOTES(notes.RETRIEVE_NOTES.OBJECT_PKEY)}) [13:23:11.660][info][talledLocalContainer] [13:23:11.660][info][talledLocalContainer] [13:23:11.660][info][talledLocalContainer] ============================================================================ [13:23:11.660][info][talledLocalContainer] EXECUTING CollapseSource [13:23:11.660][info][talledLocalContainer] [13:23:11.660][info][talledLocalContainer] AFTER: [13:23:11.660][info][talledLocalContainer] Project(groups=[], props={EST_CARDINALITY=1.0, OUTPUT_COLS=[COUNT(*)], PROJECT_COLS=[COUNT(*)]}) [13:23:11.660][info][talledLocalContainer] Group(groups=[], props={EST_CARDINALITY=1.0, OUTPUT_COLS=[COUNT(*)]}) [13:23:11.660][info][talledLocalContainer] Source(groups=[notes.RETRIEVE_NOTES], props={EST_CARDINALITY=-1.0, OUTPUT_COLS=[notes.RETRIEVE_NOTES.ID], SYMBOL_MAP={notes.RETRIEVE_NOTES.ID=X.ID}, NESTED_COMMAND=SELECT X.*, notes.RETRIEVE_NOTES.OBJECT_PKEY AS OBJECT_PKEY FROM (EXEC notes.RETRIEVE_NOTES(notes.RETRIEVE_NOTES.OBJECT_PKEY)) AS X}) [13:23:11.660][info][talledLocalContainer] Project(groups=[X], props={EST_CARDINALITY=-1.0, OUTPUT_COLS=[X.ID], PROJECT_COLS=[X.ID]}) [13:23:11.660][info][talledLocalContainer] Source(groups=[X], props={EST_CARDINALITY=-1.0, OUTPUT_COLS=[X.ID], SYMBOL_MAP={X.ID=ID}, NESTED_COMMAND=EXEC notes.RETRIEVE_NOTES(notes.RETRIEVE_NOTES.OBJECT_PKEY)}) [13:23:11.661][info][talledLocalContainer] Project(groups=[], props={EST_CARDINALITY=-1.0, OUTPUT_COLS=[ID], PROJECT_COLS=[ID]}) [13:23:11.661][info][talledLocalContainer] Access(groups=[notes.RETRIEVE_NOTES], props={ATOMIC_REQUEST=EXEC notes.RETRIEVE_NOTES(notes.RETRIEVE_NOTES.OBJECT_PKEY), PROCEDURE_DEFAULTS=[null], PROCEDURE_CRITERIA=notes.RETRIEVE_NOTES.OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME SECURITY.BASEUSER, XMLATTRIBUTES(C.SYSID AS SYSID, C.USERID AS USERID)) AS String), MODEL_ID=__TEMP__, EST_CARDINALITY=-1.0, IS_DEPENDENT_SET=true, OUTPUT_COLS=[ID, NOTE, USER_ID, NOTES_TYPE, ACCESS_MODE, CREATED_ON], PROCEDURE_INPUTS=[notes.RETRIEVE_NOTES.OBJECT_PKEY]}) [13:23:11.661][info][talledLocalContainer] [13:23:11.661][info][talledLocalContainer] [13:23:11.661][info][talledLocalContainer] ============================================================================ [13:23:11.661][info][talledLocalContainer] EXECUTING AccessPatternValidation [13:23:11.661][info][talledLocalContainer] [13:23:11.661][info][talledLocalContainer] AFTER: [13:23:11.661][info][talledLocalContainer] Project(groups=[], props={EST_CARDINALITY=1.0, OUTPUT_COLS=[COUNT(*)], PROJECT_COLS=[COUNT(*)]}) [13:23:11.661][info][talledLocalContainer] Group(groups=[], props={EST_CARDINALITY=1.0, OUTPUT_COLS=[COUNT(*)]}) [13:23:11.661][info][talledLocalContainer] Source(groups=[notes.RETRIEVE_NOTES], props={EST_CARDINALITY=-1.0, OUTPUT_COLS=[notes.RETRIEVE_NOTES.ID], SYMBOL_MAP={notes.RETRIEVE_NOTES.ID=X.ID}, NESTED_COMMAND=SELECT X.*, notes.RETRIEVE_NOTES.OBJECT_PKEY AS OBJECT_PKEY FROM (EXEC notes.RETRIEVE_NOTES(notes.RETRIEVE_NOTES.OBJECT_PKEY)) AS X}) [13:23:11.661][info][talledLocalContainer] Project(groups=[X], props={EST_CARDINALITY=-1.0, OUTPUT_COLS=[X.ID], PROJECT_COLS=[X.ID]}) [13:23:11.661][info][talledLocalContainer] Source(groups=[X], props={EST_CARDINALITY=-1.0, OUTPUT_COLS=[X.ID], SYMBOL_MAP={X.ID=ID}, NESTED_COMMAND=EXEC notes.RETRIEVE_NOTES(notes.RETRIEVE_NOTES.OBJECT_PKEY)}) [13:23:11.661][info][talledLocalContainer] Project(groups=[], props={EST_CARDINALITY=-1.0, OUTPUT_COLS=[ID], PROJECT_COLS=[ID]}) [13:23:11.661][info][talledLocalContainer] Access(groups=[notes.RETRIEVE_NOTES], props={ATOMIC_REQUEST=EXEC notes.RETRIEVE_NOTES(notes.RETRIEVE_NOTES.OBJECT_PKEY), PROCEDURE_DEFAULTS=[null], PROCEDURE_CRITERIA=notes.RETRIEVE_NOTES.OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME SECURITY.BASEUSER, XMLATTRIBUTES(C.SYSID AS SYSID, C.USERID AS USERID)) AS String), MODEL_ID=__TEMP__, EST_CARDINALITY=-1.0, IS_DEPENDENT_SET=true, OUTPUT_COLS=[ID, NOTE, USER_ID, NOTES_TYPE, ACCESS_MODE, CREATED_ON], PROCEDURE_INPUTS=[notes.RETRIEVE_NOTES.OBJECT_PKEY]}) [13:23:11.661][info][talledLocalContainer] [13:23:11.661][info][talledLocalContainer] [13:23:11.661][info][talledLocalContainer] ============================================================================ [13:23:11.661][info][talledLocalContainer] CONVERTING PLAN TREE TO PROCESS TREE [13:23:11.661][info][talledLocalContainer] [13:23:11.661][info][talledLocalContainer] PROCESS PLAN = [13:23:11.662][info][talledLocalContainer] ProjectNode(1) output=[COUNT(*)] [COUNT(*)] [13:23:11.662][info][talledLocalContainer] GroupingNode(2) output=[COUNT(*)] null [13:23:11.662][info][talledLocalContainer] ProjectNode(3) output=[notes.RETRIEVE_NOTES.ID] [X.ID] [13:23:11.662][info][talledLocalContainer] ProjectNode(4) output=[X.ID] [ID] [13:23:11.662][info][talledLocalContainer] DependentProcedureAccessNode(5) output=[ID, NOTE, USER_ID, NOTES_TYPE, ACCESS_MODE, CREATED_ON] EXEC notes.RETRIEVE_NOTES(notes.RETRIEVE_NOTES.OBJECT_PKEY) [13:23:11.662][info][talledLocalContainer] [13:23:11.662][info][talledLocalContainer] ============================================================================ [13:23:11.662][info][talledLocalContainer] [13:23:11.662][info][talledLocalContainer] ---------------------------------------------------------------------------- [13:23:11.662][info][talledLocalContainer] OPTIMIZATION COMPLETE: [13:23:11.662][info][talledLocalContainer] PROCESSOR PLAN: [13:23:11.662][info][talledLocalContainer] ProjectNode(1) output=[COUNT(*)] [COUNT(*)] [13:23:11.662][info][talledLocalContainer] GroupingNode(2) output=[COUNT(*)] null [13:23:11.662][info][talledLocalContainer] ProjectNode(3) output=[notes.RETRIEVE_NOTES.ID] [X.ID] [13:23:11.662][info][talledLocalContainer] ProjectNode(4) output=[X.ID] [ID] [13:23:11.662][info][talledLocalContainer] DependentProcedureAccessNode(5) output=[ID, NOTE, USER_ID, NOTES_TYPE, ACCESS_MODE, CREATED_ON] EXEC notes.RETRIEVE_NOTES(notes.RETRIEVE_NOTES.OBJECT_PKEY) [13:23:11.662][info][talledLocalContainer] [13:23:11.662][info][talledLocalContainer] ============================================================================ [13:23:11.662][info][talledLocalContainer] [13:23:11.662][info][talledLocalContainer] ============================================================================ [13:23:11.662][info][talledLocalContainer] EXECUTING PlaceAccess [13:23:11.663][info][talledLocalContainer] [13:23:11.663][info][talledLocalContainer] AFTER: [13:23:11.663][info][talledLocalContainer] TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=10, OFFSET_TUPLE_COUNT=990}) [13:23:11.663][info][talledLocalContainer] Sort(groups=[SECURITY.BASEUSER AS C], props={SORT_ORDER=ORDER BY C.NAME}) [13:23:11.663][info][talledLocalContainer] Project(groups=[SECURITY.BASEUSER AS C, security.sysinfo AS CHORUS_J0], props={PROJECT_COLS=[C.SYSID, C.USERID, C.NAME, (SELECT COUNT(*) FROM (SELECT * FROM notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME SECURITY.BASEUSER, XMLATTRIBUTES(C.SYSID AS SYSID, C.USERID AS USERID)) AS String)) AS foo) AS CHORUS_C_notesForObject, CHORUS_J0.APPNAME AS "SYSOFUSER@APPNAME", C.UID, C.SUSPEND, C.PROC, 'SECURITY.BASEUSER' AS "__objecttype__"]}) [13:23:11.663][info][talledLocalContainer] Join(groups=[SECURITY.BASEUSER AS C, security.sysinfo AS CHORUS_J0], props={JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[CHORUS_J0.sysid = C.sysid], JOIN_TYPE=LEFT OUTER JOIN}) [13:23:11.663][info][talledLocalContainer] Access(groups=[SECURITY.BASEUSER AS C]) [13:23:11.663][info][talledLocalContainer] Source(groups=[SECURITY.BASEUSER AS C]) [13:23:11.663][info][talledLocalContainer] Access(groups=[security.sysinfo AS CHORUS_J0]) [13:23:11.663][info][talledLocalContainer] Source(groups=[security.sysinfo AS CHORUS_J0]) [13:23:11.663][info][talledLocalContainer] [13:23:11.663][info][talledLocalContainer] [13:23:11.663][info][talledLocalContainer] ============================================================================ [13:23:11.663][info][talledLocalContainer] EXECUTING RuleRemoveOptionalJoins [13:23:11.663][info][talledLocalContainer] [13:23:11.663][info][talledLocalContainer] AFTER: [13:23:11.663][info][talledLocalContainer] TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=10, OFFSET_TUPLE_COUNT=990}) [13:23:11.663][info][talledLocalContainer] Sort(groups=[SECURITY.BASEUSER AS C], props={SORT_ORDER=ORDER BY C.NAME}) [13:23:11.664][info][talledLocalContainer] Project(groups=[SECURITY.BASEUSER AS C, security.sysinfo AS CHORUS_J0], props={PROJECT_COLS=[C.SYSID, C.USERID, C.NAME, (SELECT COUNT(*) FROM (SELECT * FROM notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME SECURITY.BASEUSER, XMLATTRIBUTES(C.SYSID AS SYSID, C.USERID AS USERID)) AS String)) AS foo) AS CHORUS_C_notesForObject, CHORUS_J0.APPNAME AS "SYSOFUSER@APPNAME", C.UID, C.SUSPEND, C.PROC, 'SECURITY.BASEUSER' AS "__objecttype__"]}) [13:23:11.664][info][talledLocalContainer] Join(groups=[SECURITY.BASEUSER AS C, security.sysinfo AS CHORUS_J0], props={JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[CHORUS_J0.sysid = C.sysid], JOIN_TYPE=LEFT OUTER JOIN}) [13:23:11.664][info][talledLocalContainer] Access(groups=[SECURITY.BASEUSER AS C]) [13:23:11.664][info][talledLocalContainer] Source(groups=[SECURITY.BASEUSER AS C]) [13:23:11.664][info][talledLocalContainer] Access(groups=[security.sysinfo AS CHORUS_J0]) [13:23:11.664][info][talledLocalContainer] Source(groups=[security.sysinfo AS CHORUS_J0]) [13:23:11.664][info][talledLocalContainer] [13:23:11.664][info][talledLocalContainer] [13:23:11.664][info][talledLocalContainer] ============================================================================ [13:23:11.664][info][talledLocalContainer] EXECUTING PushNonJoinCriteria [13:23:11.664][info][talledLocalContainer] [13:23:11.664][info][talledLocalContainer] AFTER: [13:23:11.664][info][talledLocalContainer] TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=10, OFFSET_TUPLE_COUNT=990}) [13:23:11.664][info][talledLocalContainer] Sort(groups=[SECURITY.BASEUSER AS C], props={SORT_ORDER=ORDER BY C.NAME}) [13:23:11.664][info][talledLocalContainer] Project(groups=[SECURITY.BASEUSER AS C, security.sysinfo AS CHORUS_J0], props={PROJECT_COLS=[C.SYSID, C.USERID, C.NAME, (SELECT COUNT(*) FROM (SELECT * FROM notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME SECURITY.BASEUSER, XMLATTRIBUTES(C.SYSID AS SYSID, C.USERID AS USERID)) AS String)) AS foo) AS CHORUS_C_notesForObject, CHORUS_J0.APPNAME AS "SYSOFUSER@APPNAME", C.UID, C.SUSPEND, C.PROC, 'SECURITY.BASEUSER' AS "__objecttype__"]}) [13:23:11.664][info][talledLocalContainer] Join(groups=[SECURITY.BASEUSER AS C, security.sysinfo AS CHORUS_J0], props={JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[CHORUS_J0.sysid = C.sysid], JOIN_TYPE=LEFT OUTER JOIN}) [13:23:11.664][info][talledLocalContainer] Access(groups=[SECURITY.BASEUSER AS C]) [13:23:11.664][info][talledLocalContainer] Source(groups=[SECURITY.BASEUSER AS C]) [13:23:11.664][info][talledLocalContainer] Access(groups=[security.sysinfo AS CHORUS_J0]) [13:23:11.665][info][talledLocalContainer] Source(groups=[security.sysinfo AS CHORUS_J0]) [13:23:11.665][info][talledLocalContainer] [13:23:11.665][info][talledLocalContainer] [13:23:11.665][info][talledLocalContainer] ============================================================================ [13:23:11.665][info][talledLocalContainer] EXECUTING CopyCriteria [13:23:11.665][info][talledLocalContainer] [13:23:11.665][info][talledLocalContainer] AFTER: [13:23:11.665][info][talledLocalContainer] TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=10, OFFSET_TUPLE_COUNT=990}) [13:23:11.665][info][talledLocalContainer] Sort(groups=[SECURITY.BASEUSER AS C], props={SORT_ORDER=ORDER BY C.NAME}) [13:23:11.665][info][talledLocalContainer] Project(groups=[SECURITY.BASEUSER AS C, security.sysinfo AS CHORUS_J0], props={PROJECT_COLS=[C.SYSID, C.USERID, C.NAME, (SELECT COUNT(*) FROM (SELECT * FROM notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME SECURITY.BASEUSER, XMLATTRIBUTES(C.SYSID AS SYSID, C.USERID AS USERID)) AS String)) AS foo) AS CHORUS_C_notesForObject, CHORUS_J0.APPNAME AS "SYSOFUSER@APPNAME", C.UID, C.SUSPEND, C.PROC, 'SECURITY.BASEUSER' AS "__objecttype__"]}) [13:23:11.665][info][talledLocalContainer] Join(groups=[SECURITY.BASEUSER AS C, security.sysinfo AS CHORUS_J0], props={IS_COPIED=true, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[CHORUS_J0.sysid = C.sysid], JOIN_TYPE=LEFT OUTER JOIN}) [13:23:11.665][info][talledLocalContainer] Access(groups=[SECURITY.BASEUSER AS C]) [13:23:11.665][info][talledLocalContainer] Source(groups=[SECURITY.BASEUSER AS C]) [13:23:11.665][info][talledLocalContainer] Access(groups=[security.sysinfo AS CHORUS_J0]) [13:23:11.665][info][talledLocalContainer] Source(groups=[security.sysinfo AS CHORUS_J0]) [13:23:11.665][info][talledLocalContainer] [13:23:11.665][info][talledLocalContainer] [13:23:11.665][info][talledLocalContainer] ============================================================================ [13:23:11.665][info][talledLocalContainer] EXECUTING CleanCriteria [13:23:11.665][info][talledLocalContainer] [13:23:11.666][info][talledLocalContainer] AFTER: [13:23:11.666][info][talledLocalContainer] TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=10, OFFSET_TUPLE_COUNT=990}) [13:23:11.666][info][talledLocalContainer] Sort(groups=[SECURITY.BASEUSER AS C], props={SORT_ORDER=ORDER BY C.NAME}) [13:23:11.666][info][talledLocalContainer] Project(groups=[SECURITY.BASEUSER AS C, security.sysinfo AS CHORUS_J0], props={PROJECT_COLS=[C.SYSID, C.USERID, C.NAME, (SELECT COUNT(*) FROM (SELECT * FROM notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME SECURITY.BASEUSER, XMLATTRIBUTES(C.SYSID AS SYSID, C.USERID AS USERID)) AS String)) AS foo) AS CHORUS_C_notesForObject, CHORUS_J0.APPNAME AS "SYSOFUSER@APPNAME", C.UID, C.SUSPEND, C.PROC, 'SECURITY.BASEUSER' AS "__objecttype__"]}) [13:23:11.666][info][talledLocalContainer] Join(groups=[SECURITY.BASEUSER AS C, security.sysinfo AS CHORUS_J0], props={IS_COPIED=true, JOIN_STRATEGY=NESTED_LOOP, JOIN_CRITERIA=[CHORUS_J0.sysid = C.sysid], JOIN_TYPE=LEFT OUTER JOIN}) [13:23:11.666][info][talledLocalContainer] Access(groups=[SECURITY.BASEUSER AS C]) [13:23:11.666][info][talledLocalContainer] Source(groups=[SECURITY.BASEUSER AS C]) [13:23:11.666][info][talledLocalContainer] Access(groups=[security.sysinfo AS CHORUS_J0]) [13:23:11.666][info][talledLocalContainer] Source(groups=[security.sysinfo AS CHORUS_J0]) [13:23:11.666][info][talledLocalContainer] [13:23:11.666][info][talledLocalContainer] [13:23:11.666][info][talledLocalContainer] ============================================================================ [13:23:11.666][info][talledLocalContainer] EXECUTING RaiseAccess [13:23:11.666][info][talledLocalContainer] [13:23:11.666][info][talledLocalContainer] AFTER: [13:23:11.666][info][talledLocalContainer] TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=10, OFFSET_TUPLE_COUNT=990}) [13:23:11.666][info][talledLocalContainer] Sort(groups=[SECURITY.BASEUSER AS C], props={SORT_ORDER=ORDER BY C.NAME}) [13:23:11.666][info][talledLocalContainer] Project(groups=[SECURITY.BASEUSER AS C, security.sysinfo AS CHORUS_J0], props={PROJECT_COLS=[C.SYSID, C.USERID, C.NAME, (SELECT COUNT(*) FROM (SELECT * FROM notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME SECURITY.BASEUSER, XMLATTRIBUTES(C.SYSID AS SYSID, C.USERID AS USERID)) AS String)) AS foo) AS CHORUS_C_notesForObject, CHORUS_J0.APPNAME AS "SYSOFUSER@APPNAME", C.UID, C.SUSPEND, C.PROC, 'SECURITY.BASEUSER' AS "__objecttype__"]}) [13:23:11.666][info][talledLocalContainer] Access(groups=[SECURITY.BASEUSER AS C, security.sysinfo AS CHORUS_J0], props={MODEL_ID=Schema name=security, nameInSource=null, uuid=mmuuid:066587c1-3747-48dc-92fb-fc9a71acf11b}) [13:23:11.667][info][talledLocalContainer] Join(groups=[SECURITY.BASEUSER AS C, security.sysinfo AS CHORUS_J0], props={IS_COPIED=true, JOIN_STRATEGY=NESTED_LOOP, MODEL_ID=Schema name=security, nameInSource=null, uuid=mmuuid:066587c1-3747-48dc-92fb-fc9a71acf11b, JOIN_CRITERIA=[CHORUS_J0.sysid = C.sysid], JOIN_TYPE=LEFT OUTER JOIN}) [13:23:11.667][info][talledLocalContainer] Source(groups=[SECURITY.BASEUSER AS C]) [13:23:11.667][info][talledLocalContainer] Source(groups=[security.sysinfo AS CHORUS_J0]) [13:23:11.667][info][talledLocalContainer] [13:23:11.667][info][talledLocalContainer] [13:23:11.667][info][talledLocalContainer] ============================================================================ [13:23:11.667][info][talledLocalContainer] EXECUTING PlanJoins [13:23:11.667][info][talledLocalContainer] [13:23:11.667][info][talledLocalContainer] AFTER: [13:23:11.667][info][talledLocalContainer] TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=10, OFFSET_TUPLE_COUNT=990}) [13:23:11.667][info][talledLocalContainer] Sort(groups=[SECURITY.BASEUSER AS C], props={SORT_ORDER=ORDER BY C.NAME}) [13:23:11.667][info][talledLocalContainer] Project(groups=[SECURITY.BASEUSER AS C, security.sysinfo AS CHORUS_J0], props={PROJECT_COLS=[C.SYSID, C.USERID, C.NAME, (SELECT COUNT(*) FROM (SELECT * FROM notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME SECURITY.BASEUSER, XMLATTRIBUTES(C.SYSID AS SYSID, C.USERID AS USERID)) AS String)) AS foo) AS CHORUS_C_notesForObject, CHORUS_J0.APPNAME AS "SYSOFUSER@APPNAME", C.UID, C.SUSPEND, C.PROC, 'SECURITY.BASEUSER' AS "__objecttype__"]}) [13:23:11.667][info][talledLocalContainer] Access(groups=[SECURITY.BASEUSER AS C, security.sysinfo AS CHORUS_J0], props={MODEL_ID=Schema name=security, nameInSource=null, uuid=mmuuid:066587c1-3747-48dc-92fb-fc9a71acf11b}) [13:23:11.667][info][talledLocalContainer] Join(groups=[SECURITY.BASEUSER AS C, security.sysinfo AS CHORUS_J0], props={IS_COPIED=true, JOIN_STRATEGY=NESTED_LOOP, MODEL_ID=Schema name=security, nameInSource=null, uuid=mmuuid:066587c1-3747-48dc-92fb-fc9a71acf11b, JOIN_CRITERIA=[CHORUS_J0.sysid = C.sysid], JOIN_TYPE=LEFT OUTER JOIN}) [13:23:11.667][info][talledLocalContainer] Source(groups=[SECURITY.BASEUSER AS C]) [13:23:11.667][info][talledLocalContainer] Source(groups=[security.sysinfo AS CHORUS_J0]) [13:23:11.667][info][talledLocalContainer] [13:23:11.667][info][talledLocalContainer] [13:23:11.667][info][talledLocalContainer] ============================================================================ [13:23:11.668][info][talledLocalContainer] EXECUTING PushSelectCriteria [13:23:11.668][info][talledLocalContainer] [13:23:11.668][info][talledLocalContainer] AFTER: [13:23:11.668][info][talledLocalContainer] TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=10, OFFSET_TUPLE_COUNT=990}) [13:23:11.668][info][talledLocalContainer] Sort(groups=[SECURITY.BASEUSER AS C], props={SORT_ORDER=ORDER BY C.NAME}) [13:23:11.668][info][talledLocalContainer] Project(groups=[SECURITY.BASEUSER AS C, security.sysinfo AS CHORUS_J0], props={PROJECT_COLS=[C.SYSID, C.USERID, C.NAME, (SELECT COUNT(*) FROM (SELECT * FROM notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME SECURITY.BASEUSER, XMLATTRIBUTES(C.SYSID AS SYSID, C.USERID AS USERID)) AS String)) AS foo) AS CHORUS_C_notesForObject, CHORUS_J0.APPNAME AS "SYSOFUSER@APPNAME", C.UID, C.SUSPEND, C.PROC, 'SECURITY.BASEUSER' AS "__objecttype__"]}) [13:23:11.668][info][talledLocalContainer] Access(groups=[SECURITY.BASEUSER AS C, security.sysinfo AS CHORUS_J0], props={MODEL_ID=Schema name=security, nameInSource=null, uuid=mmuuid:066587c1-3747-48dc-92fb-fc9a71acf11b}) [13:23:11.668][info][talledLocalContainer] Join(groups=[SECURITY.BASEUSER AS C, security.sysinfo AS CHORUS_J0], props={IS_COPIED=true, JOIN_STRATEGY=NESTED_LOOP, MODEL_ID=Schema name=security, nameInSource=null, uuid=mmuuid:066587c1-3747-48dc-92fb-fc9a71acf11b, JOIN_CRITERIA=[CHORUS_J0.sysid = C.sysid], JOIN_TYPE=LEFT OUTER JOIN}) [13:23:11.668][info][talledLocalContainer] Source(groups=[SECURITY.BASEUSER AS C]) [13:23:11.668][info][talledLocalContainer] Source(groups=[security.sysinfo AS CHORUS_J0]) [13:23:11.668][info][talledLocalContainer] [13:23:11.668][info][talledLocalContainer] [13:23:11.668][info][talledLocalContainer] ============================================================================ [13:23:11.668][info][talledLocalContainer] EXECUTING RaiseAccess [13:23:11.668][info][talledLocalContainer] [13:23:11.668][info][talledLocalContainer] AFTER: [13:23:11.668][info][talledLocalContainer] TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=10, OFFSET_TUPLE_COUNT=990}) [13:23:11.668][info][talledLocalContainer] Sort(groups=[SECURITY.BASEUSER AS C], props={SORT_ORDER=ORDER BY C.NAME}) [13:23:11.669][info][talledLocalContainer] Project(groups=[SECURITY.BASEUSER AS C, security.sysinfo AS CHORUS_J0], props={PROJECT_COLS=[C.SYSID, C.USERID, C.NAME, (SELECT COUNT(*) FROM (SELECT * FROM notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME SECURITY.BASEUSER, XMLATTRIBUTES(C.SYSID AS SYSID, C.USERID AS USERID)) AS String)) AS foo) AS CHORUS_C_notesForObject, CHORUS_J0.APPNAME AS "SYSOFUSER@APPNAME", C.UID, C.SUSPEND, C.PROC, 'SECURITY.BASEUSER' AS "__objecttype__"]}) [13:23:11.669][info][talledLocalContainer] Access(groups=[SECURITY.BASEUSER AS C, security.sysinfo AS CHORUS_J0], props={MODEL_ID=Schema name=security, nameInSource=null, uuid=mmuuid:066587c1-3747-48dc-92fb-fc9a71acf11b}) [13:23:11.669][info][talledLocalContainer] Join(groups=[SECURITY.BASEUSER AS C, security.sysinfo AS CHORUS_J0], props={IS_COPIED=true, JOIN_STRATEGY=NESTED_LOOP, MODEL_ID=Schema name=security, nameInSource=null, uuid=mmuuid:066587c1-3747-48dc-92fb-fc9a71acf11b, JOIN_CRITERIA=[CHORUS_J0.sysid = C.sysid], JOIN_TYPE=LEFT OUTER JOIN}) [13:23:11.669][info][talledLocalContainer] Source(groups=[SECURITY.BASEUSER AS C]) [13:23:11.669][info][talledLocalContainer] Source(groups=[security.sysinfo AS CHORUS_J0]) [13:23:11.669][info][talledLocalContainer] [13:23:11.669][info][talledLocalContainer] [13:23:11.669][info][talledLocalContainer] ============================================================================ [13:23:11.669][info][talledLocalContainer] EXECUTING ChooseJoinStrategy [13:23:11.669][info][talledLocalContainer] [13:23:11.669][info][talledLocalContainer] AFTER: [13:23:11.669][info][talledLocalContainer] TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=10, OFFSET_TUPLE_COUNT=990}) [13:23:11.669][info][talledLocalContainer] Sort(groups=[SECURITY.BASEUSER AS C], props={SORT_ORDER=ORDER BY C.NAME}) [13:23:11.669][info][talledLocalContainer] Project(groups=[SECURITY.BASEUSER AS C, security.sysinfo AS CHORUS_J0], props={PROJECT_COLS=[C.SYSID, C.USERID, C.NAME, (SELECT COUNT(*) FROM (SELECT * FROM notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME SECURITY.BASEUSER, XMLATTRIBUTES(C.SYSID AS SYSID, C.USERID AS USERID)) AS String)) AS foo) AS CHORUS_C_notesForObject, CHORUS_J0.APPNAME AS "SYSOFUSER@APPNAME", C.UID, C.SUSPEND, C.PROC, 'SECURITY.BASEUSER' AS "__objecttype__"]}) [13:23:11.669][info][talledLocalContainer] Access(groups=[SECURITY.BASEUSER AS C, security.sysinfo AS CHORUS_J0], props={MODEL_ID=Schema name=security, nameInSource=null, uuid=mmuuid:066587c1-3747-48dc-92fb-fc9a71acf11b}) [13:23:11.669][info][talledLocalContainer] Join(groups=[SECURITY.BASEUSER AS C, security.sysinfo AS CHORUS_J0], props={IS_COPIED=true, JOIN_STRATEGY=NESTED_LOOP, MODEL_ID=Schema name=security, nameInSource=null, uuid=mmuuid:066587c1-3747-48dc-92fb-fc9a71acf11b, JOIN_CRITERIA=[CHORUS_J0.sysid = C.sysid], JOIN_TYPE=LEFT OUTER JOIN}) [13:23:11.669][info][talledLocalContainer] Source(groups=[SECURITY.BASEUSER AS C]) [13:23:11.670][info][talledLocalContainer] Source(groups=[security.sysinfo AS CHORUS_J0]) [13:23:11.670][info][talledLocalContainer] [13:23:11.670][info][talledLocalContainer] [13:23:11.670][info][talledLocalContainer] ============================================================================ [13:23:11.670][info][talledLocalContainer] EXECUTING ChooseDependent [13:23:11.670][info][talledLocalContainer] [13:23:11.670][info][talledLocalContainer] AFTER: [13:23:11.670][info][talledLocalContainer] TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=10, OFFSET_TUPLE_COUNT=990}) [13:23:11.670][info][talledLocalContainer] Sort(groups=[SECURITY.BASEUSER AS C], props={SORT_ORDER=ORDER BY C.NAME}) [13:23:11.670][info][talledLocalContainer] Project(groups=[SECURITY.BASEUSER AS C, security.sysinfo AS CHORUS_J0], props={PROJECT_COLS=[C.SYSID, C.USERID, C.NAME, (SELECT COUNT(*) FROM (SELECT * FROM notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME SECURITY.BASEUSER, XMLATTRIBUTES(C.SYSID AS SYSID, C.USERID AS USERID)) AS String)) AS foo) AS CHORUS_C_notesForObject, CHORUS_J0.APPNAME AS "SYSOFUSER@APPNAME", C.UID, C.SUSPEND, C.PROC, 'SECURITY.BASEUSER' AS "__objecttype__"]}) [13:23:11.670][info][talledLocalContainer] Access(groups=[SECURITY.BASEUSER AS C, security.sysinfo AS CHORUS_J0], props={MODEL_ID=Schema name=security, nameInSource=null, uuid=mmuuid:066587c1-3747-48dc-92fb-fc9a71acf11b}) [13:23:11.670][info][talledLocalContainer] Join(groups=[SECURITY.BASEUSER AS C, security.sysinfo AS CHORUS_J0], props={IS_COPIED=true, JOIN_STRATEGY=NESTED_LOOP, MODEL_ID=Schema name=security, nameInSource=null, uuid=mmuuid:066587c1-3747-48dc-92fb-fc9a71acf11b, JOIN_CRITERIA=[CHORUS_J0.sysid = C.sysid], JOIN_TYPE=LEFT OUTER JOIN}) [13:23:11.670][info][talledLocalContainer] Source(groups=[SECURITY.BASEUSER AS C]) [13:23:11.670][info][talledLocalContainer] Source(groups=[security.sysinfo AS CHORUS_J0]) [13:23:11.670][info][talledLocalContainer] [13:23:11.670][info][talledLocalContainer] [13:23:11.670][info][talledLocalContainer] ============================================================================ [13:23:11.670][info][talledLocalContainer] EXECUTING PushLimit [13:23:11.670][info][talledLocalContainer] [13:23:11.670][info][talledLocalContainer] AFTER: [13:23:11.670][info][talledLocalContainer] TupleLimit(groups=[], props={MAX_TUPLE_LIMIT=10, OFFSET_TUPLE_COUNT=990}) [13:23:11.670][info][talledLocalContainer] Sort(groups=[SECURITY.BASEUSER AS C], props={SORT_ORDER=ORDER BY C.NAME}) [13:23:11.671][info][talledLocalContainer] Project(groups=[SECURITY.BASEUSER AS C, security.sysinfo AS CHORUS_J0], props={PROJECT_COLS=[C.SYSID, C.USERID, C.NAME, (SELECT COUNT(*) FROM (SELECT * FROM notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME SECURITY.BASEUSER, XMLATTRIBUTES(C.SYSID AS SYSID, C.USERID AS USERID)) AS String)) AS foo) AS CHORUS_C_notesForObject, CHORUS_J0.APPNAME AS "SYSOFUSER@APPNAME", C.UID, C.SUSPEND, C.PROC, 'SECURITY.BASEUSER' AS "__objecttype__"]}) [13:23:11.671][info][talledLocalContainer] Access(groups=[SECURITY.BASEUSER AS C, security.sysinfo AS CHORUS_J0], props={MODEL_ID=Schema name=security, nameInSource=null, uuid=mmuuid:066587c1-3747-48dc-92fb-fc9a71acf11b}) [13:23:11.671][info][talledLocalContainer] Join(groups=[SECURITY.BASEUSER AS C, security.sysinfo AS CHORUS_J0], props={IS_COPIED=true, JOIN_STRATEGY=NESTED_LOOP, MODEL_ID=Schema name=security, nameInSource=null, uuid=mmuuid:066587c1-3747-48dc-92fb-fc9a71acf11b, JOIN_CRITERIA=[CHORUS_J0.sysid = C.sysid], JOIN_TYPE=LEFT OUTER JOIN}) [13:23:11.671][info][talledLocalContainer] Source(groups=[SECURITY.BASEUSER AS C]) [13:23:11.671][info][talledLocalContainer] Source(groups=[security.sysinfo AS CHORUS_J0]) [13:23:11.671][info][talledLocalContainer] [13:23:11.671][info][talledLocalContainer] [13:23:11.671][info][talledLocalContainer] ============================================================================ [13:23:11.671][info][talledLocalContainer] EXECUTING CalculateCost [13:23:11.671][info][talledLocalContainer] [13:23:11.671][info][talledLocalContainer] AFTER: [13:23:11.671][info][talledLocalContainer] TupleLimit(groups=[], props={EST_CARDINALITY=10.0, MAX_TUPLE_LIMIT=10, OFFSET_TUPLE_COUNT=990}) [13:23:11.671][info][talledLocalContainer] Sort(groups=[SECURITY.BASEUSER AS C], props={EST_CARDINALITY=-1.0, SORT_ORDER=ORDER BY C.NAME}) [13:23:11.671][info][talledLocalContainer] Project(groups=[SECURITY.BASEUSER AS C, security.sysinfo AS CHORUS_J0], props={EST_CARDINALITY=-1.0, PROJECT_COLS=[C.SYSID, C.USERID, C.NAME, (SELECT COUNT(*) FROM (SELECT * FROM notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME SECURITY.BASEUSER, XMLATTRIBUTES(C.SYSID AS SYSID, C.USERID AS USERID)) AS String)) AS foo) AS CHORUS_C_notesForObject, CHORUS_J0.APPNAME AS "SYSOFUSER@APPNAME", C.UID, C.SUSPEND, C.PROC, 'SECURITY.BASEUSER' AS "__objecttype__"]}) [13:23:11.671][info][talledLocalContainer] Access(groups=[SECURITY.BASEUSER AS C, security.sysinfo AS CHORUS_J0], props={MODEL_ID=Schema name=security, nameInSource=null, uuid=mmuuid:066587c1-3747-48dc-92fb-fc9a71acf11b, EST_CARDINALITY=-1.0}) [13:23:11.671][info][talledLocalContainer] Join(groups=[SECURITY.BASEUSER AS C, security.sysinfo AS CHORUS_J0], props={IS_COPIED=true, JOIN_STRATEGY=NESTED_LOOP, MODEL_ID=Schema name=security, nameInSource=null, uuid=mmuuid:066587c1-3747-48dc-92fb-fc9a71acf11b, EST_CARDINALITY=-1.0, JOIN_CRITERIA=[CHORUS_J0.sysid = C.sysid], JOIN_TYPE=LEFT OUTER JOIN}) [13:23:11.671][info][talledLocalContainer] Source(groups=[SECURITY.BASEUSER AS C], props={EST_CARDINALITY=-1.0}) [13:23:11.671][info][talledLocalContainer] Source(groups=[security.sysinfo AS CHORUS_J0], props={EST_CARDINALITY=-1.0}) [13:23:11.671][info][talledLocalContainer] [13:23:11.671][info][talledLocalContainer] [13:23:11.672][info][talledLocalContainer] ============================================================================ [13:23:11.672][info][talledLocalContainer] EXECUTING AssignOutputElements [13:23:11.672][info][talledLocalContainer] [13:23:11.672][info][talledLocalContainer] AFTER: [13:23:11.672][info][talledLocalContainer] TupleLimit(groups=[], props={EST_CARDINALITY=10.0, OUTPUT_COLS=[C.SYSID, C.USERID, C.NAME, (SELECT COUNT(*) FROM (SELECT * FROM notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME SECURITY.BASEUSER, XMLATTRIBUTES(C.SYSID AS SYSID, C.USERID AS USERID)) AS String)) AS foo) AS CHORUS_C_notesForObject, CHORUS_J0.APPNAME AS "SYSOFUSER@APPNAME", C.UID, C.SUSPEND, C.PROC, 'SECURITY.BASEUSER' AS "__objecttype__"], MAX_TUPLE_LIMIT=10, OFFSET_TUPLE_COUNT=990}) [13:23:11.672][info][talledLocalContainer] Sort(groups=[SECURITY.BASEUSER AS C], props={EST_CARDINALITY=-1.0, OUTPUT_COLS=[C.SYSID, C.USERID, C.NAME, (SELECT COUNT(*) FROM (SELECT * FROM notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME SECURITY.BASEUSER, XMLATTRIBUTES(C.SYSID AS SYSID, C.USERID AS USERID)) AS String)) AS foo) AS CHORUS_C_notesForObject, CHORUS_J0.APPNAME AS "SYSOFUSER@APPNAME", C.UID, C.SUSPEND, C.PROC, 'SECURITY.BASEUSER' AS "__objecttype__"], SORT_ORDER=ORDER BY C.NAME}) [13:23:11.672][info][talledLocalContainer] Project(groups=[SECURITY.BASEUSER AS C, security.sysinfo AS CHORUS_J0], props={EST_CARDINALITY=-1.0, OUTPUT_COLS=[C.SYSID, C.USERID, C.NAME, (SELECT COUNT(*) FROM (SELECT * FROM notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME SECURITY.BASEUSER, XMLATTRIBUTES(C.SYSID AS SYSID, C.USERID AS USERID)) AS String)) AS foo) AS CHORUS_C_notesForObject, CHORUS_J0.APPNAME AS "SYSOFUSER@APPNAME", C.UID, C.SUSPEND, C.PROC, 'SECURITY.BASEUSER' AS "__objecttype__"], PROJECT_COLS=[C.SYSID, C.USERID, C.NAME, (SELECT COUNT(*) FROM (SELECT * FROM notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME SECURITY.BASEUSER, XMLATTRIBUTES(C.SYSID AS SYSID, C.USERID AS USERID)) AS String)) AS foo) AS CHORUS_C_notesForObject, CHORUS_J0.APPNAME AS "SYSOFUSER@APPNAME", C.UID, C.SUSPEND, C.PROC, 'SECURITY.BASEUSER' AS "__objecttype__"]}) [13:23:11.672][info][talledLocalContainer] Access(groups=[SECURITY.BASEUSER AS C, security.sysinfo AS CHORUS_J0], props={MODEL_ID=Schema name=security, nameInSource=null, uuid=mmuuid:066587c1-3747-48dc-92fb-fc9a71acf11b, EST_CARDINALITY=-1.0, OUTPUT_COLS=[C.SYSID, C.USERID, C.NAME, CHORUS_J0.APPNAME, C.UID, C.SUSPEND, C.PROC]}) [13:23:11.672][info][talledLocalContainer] Join(groups=[SECURITY.BASEUSER AS C, security.sysinfo AS CHORUS_J0], props={IS_COPIED=true, JOIN_STRATEGY=NESTED_LOOP, MODEL_ID=Schema name=security, nameInSource=null, uuid=mmuuid:066587c1-3747-48dc-92fb-fc9a71acf11b, EST_CARDINALITY=-1.0, OUTPUT_COLS=[C.SYSID, C.USERID, C.NAME, CHORUS_J0.APPNAME, C.UID, C.SUSPEND, C.PROC], JOIN_CRITERIA=[CHORUS_J0.sysid = C.sysid], JOIN_TYPE=LEFT OUTER JOIN}) [13:23:11.672][info][talledLocalContainer] Source(groups=[SECURITY.BASEUSER AS C], props={EST_CARDINALITY=-1.0, OUTPUT_COLS=[C.sysid, C.USERID, C.NAME, C.UID, C.SUSPEND, C.PROC]}) [13:23:11.672][info][talledLocalContainer] Source(groups=[security.sysinfo AS CHORUS_J0], props={EST_CARDINALITY=-1.0, OUTPUT_COLS=[CHORUS_J0.sysid, CHORUS_J0.APPNAME]}) [13:23:11.672][info][talledLocalContainer] [13:23:11.672][info][talledLocalContainer] [13:23:11.672][info][talledLocalContainer] ============================================================================ [13:23:11.672][info][talledLocalContainer] EXECUTING ImplementJoinStrategy [13:23:11.672][info][talledLocalContainer] [13:23:11.673][info][talledLocalContainer] AFTER: [13:23:11.673][info][talledLocalContainer] TupleLimit(groups=[], props={EST_CARDINALITY=10.0, OUTPUT_COLS=[C.SYSID, C.USERID, C.NAME, (SELECT COUNT(*) FROM (SELECT * FROM notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME SECURITY.BASEUSER, XMLATTRIBUTES(C.SYSID AS SYSID, C.USERID AS USERID)) AS String)) AS foo) AS CHORUS_C_notesForObject, CHORUS_J0.APPNAME AS "SYSOFUSER@APPNAME", C.UID, C.SUSPEND, C.PROC, 'SECURITY.BASEUSER' AS "__objecttype__"], MAX_TUPLE_LIMIT=10, OFFSET_TUPLE_COUNT=990}) [13:23:11.673][info][talledLocalContainer] Sort(groups=[SECURITY.BASEUSER AS C], props={EST_CARDINALITY=-1.0, OUTPUT_COLS=[C.SYSID, C.USERID, C.NAME, (SELECT COUNT(*) FROM (SELECT * FROM notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME SECURITY.BASEUSER, XMLATTRIBUTES(C.SYSID AS SYSID, C.USERID AS USERID)) AS String)) AS foo) AS CHORUS_C_notesForObject, CHORUS_J0.APPNAME AS "SYSOFUSER@APPNAME", C.UID, C.SUSPEND, C.PROC, 'SECURITY.BASEUSER' AS "__objecttype__"], SORT_ORDER=ORDER BY C.NAME}) [13:23:11.673][info][talledLocalContainer] Project(groups=[SECURITY.BASEUSER AS C, security.sysinfo AS CHORUS_J0], props={EST_CARDINALITY=-1.0, OUTPUT_COLS=[C.SYSID, C.USERID, C.NAME, (SELECT COUNT(*) FROM (SELECT * FROM notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME SECURITY.BASEUSER, XMLATTRIBUTES(C.SYSID AS SYSID, C.USERID AS USERID)) AS String)) AS foo) AS CHORUS_C_notesForObject, CHORUS_J0.APPNAME AS "SYSOFUSER@APPNAME", C.UID, C.SUSPEND, C.PROC, 'SECURITY.BASEUSER' AS "__objecttype__"], PROJECT_COLS=[C.SYSID, C.USERID, C.NAME, (SELECT COUNT(*) FROM (SELECT * FROM notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME SECURITY.BASEUSER, XMLATTRIBUTES(C.SYSID AS SYSID, C.USERID AS USERID)) AS String)) AS foo) AS CHORUS_C_notesForObject, CHORUS_J0.APPNAME AS "SYSOFUSER@APPNAME", C.UID, C.SUSPEND, C.PROC, 'SECURITY.BASEUSER' AS "__objecttype__"]}) [13:23:11.673][info][talledLocalContainer] Access(groups=[SECURITY.BASEUSER AS C, security.sysinfo AS CHORUS_J0], props={MODEL_ID=Schema name=security, nameInSource=null, uuid=mmuuid:066587c1-3747-48dc-92fb-fc9a71acf11b, EST_CARDINALITY=-1.0, OUTPUT_COLS=[C.SYSID, C.USERID, C.NAME, CHORUS_J0.APPNAME, C.UID, C.SUSPEND, C.PROC]}) [13:23:11.673][info][talledLocalContainer] Join(groups=[SECURITY.BASEUSER AS C, security.sysinfo AS CHORUS_J0], props={IS_COPIED=true, JOIN_STRATEGY=NESTED_LOOP, MODEL_ID=Schema name=security, nameInSource=null, uuid=mmuuid:066587c1-3747-48dc-92fb-fc9a71acf11b, EST_CARDINALITY=-1.0, OUTPUT_COLS=[C.SYSID, C.USERID, C.NAME, CHORUS_J0.APPNAME, C.UID, C.SUSPEND, C.PROC], JOIN_CRITERIA=[CHORUS_J0.sysid = C.sysid], JOIN_TYPE=LEFT OUTER JOIN}) [13:23:11.673][info][talledLocalContainer] Source(groups=[SECURITY.BASEUSER AS C], props={EST_CARDINALITY=-1.0, OUTPUT_COLS=[C.sysid, C.USERID, C.NAME, C.UID, C.SUSPEND, C.PROC]}) [13:23:11.673][info][talledLocalContainer] Source(groups=[security.sysinfo AS CHORUS_J0], props={EST_CARDINALITY=-1.0, OUTPUT_COLS=[CHORUS_J0.sysid, CHORUS_J0.APPNAME]}) [13:23:11.673][info][talledLocalContainer] [13:23:11.673][info][talledLocalContainer] [13:23:11.673][info][talledLocalContainer] ============================================================================ [13:23:11.673][info][talledLocalContainer] EXECUTING MergeCriteria [13:23:11.673][info][talledLocalContainer] [13:23:11.673][info][talledLocalContainer] AFTER: [13:23:11.673][info][talledLocalContainer] TupleLimit(groups=[], props={EST_CARDINALITY=10.0, OUTPUT_COLS=[C.SYSID, C.USERID, C.NAME, (SELECT COUNT(*) FROM (SELECT * FROM notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME SECURITY.BASEUSER, XMLATTRIBUTES(C.SYSID AS SYSID, C.USERID AS USERID)) AS String)) AS foo) AS CHORUS_C_notesForObject, CHORUS_J0.APPNAME AS "SYSOFUSER@APPNAME", C.UID, C.SUSPEND, C.PROC, 'SECURITY.BASEUSER' AS "__objecttype__"], MAX_TUPLE_LIMIT=10, OFFSET_TUPLE_COUNT=990}) [13:23:11.673][info][talledLocalContainer] Sort(groups=[SECURITY.BASEUSER AS C], props={EST_CARDINALITY=-1.0, OUTPUT_COLS=[C.SYSID, C.USERID, C.NAME, (SELECT COUNT(*) FROM (SELECT * FROM notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME SECURITY.BASEUSER, XMLATTRIBUTES(C.SYSID AS SYSID, C.USERID AS USERID)) AS String)) AS foo) AS CHORUS_C_notesForObject, CHORUS_J0.APPNAME AS "SYSOFUSER@APPNAME", C.UID, C.SUSPEND, C.PROC, 'SECURITY.BASEUSER' AS "__objecttype__"], SORT_ORDER=ORDER BY C.NAME}) [13:23:11.673][info][talledLocalContainer] Project(groups=[SECURITY.BASEUSER AS C, security.sysinfo AS CHORUS_J0], props={EST_CARDINALITY=-1.0, OUTPUT_COLS=[C.SYSID, C.USERID, C.NAME, (SELECT COUNT(*) FROM (SELECT * FROM notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME SECURITY.BASEUSER, XMLATTRIBUTES(C.SYSID AS SYSID, C.USERID AS USERID)) AS String)) AS foo) AS CHORUS_C_notesForObject, CHORUS_J0.APPNAME AS "SYSOFUSER@APPNAME", C.UID, C.SUSPEND, C.PROC, 'SECURITY.BASEUSER' AS "__objecttype__"], PROJECT_COLS=[C.SYSID, C.USERID, C.NAME, (SELECT COUNT(*) FROM (SELECT * FROM notes.RETRIEVE_NOTES WHERE OBJECT_PKEY = XMLSERIALIZE(XMLELEMENT(NAME SECURITY.BASEUSER, XMLATTRIBUTES(C.SYSID AS SYSID, C.USERID AS USERID)) AS String)) AS foo) AS CHORUS_C_notesForObject, CHORUS_J0.APPNAME AS "SYSOFUSER@APPNAME", C.UID, C.SUSPEND, C.PROC, 'SECURITY.BASEUSER' AS "__objecttype__"]}) [13:23:11.673][info][talledLocalContainer] Access(groups=[SECURITY.BASEUSER AS C, security.sysinfo AS CHORUS_J0], props={MODEL_ID=Schema name=security, nameInSource=null, uuid=mmuuid:066587c1-3747-48dc-92fb-fc9a71acf11b, EST_CARDINALITY=-1.0, OUTPUT_COLS=[C.SYSID, C.USERID, C.NAME, CHORUS_J0.APPNAME, C.UID, C.SUSPEND, C.PROC]}) [13:23:11.674][info][talledLocalContainer] Join(groups=[SECURITY.BASEUSER AS C, security.sysinfo AS CHORUS_J0], props={IS_COPIED=true, JOIN_STRATEGY=NESTED_LOOP, MODEL_ID=Schema name=security, nameInSource=null, uuid=mmuuid:066587c1-3747-48dc-92fb-fc9a71acf11b, EST_CARDINALITY=-1.0, OUTPUT_COLS=[C.SYSID, C.USERID, C.NAME, CHORUS_J0.APPNAME, C.UID, C.SUSPEND, C.PROC], JOIN_CRITERIA=[CHORUS_J0.sysid = C.sysid], JOIN_TYPE=LEFT OUTER JOIN}) [13:23:11.674][info][talledLocalContainer] Source(groups=[SECURITY.BASEUSER AS C], props={EST_CARDINALITY=-1.0, OUTPUT_COLS=[C.sysid, C.USERID, C.NAME, C.UID, C.SUSPEND, C.PROC]}) [13:23:11.674][info][talledLocalContainer] Source(groups=[security.sysinfo AS CHORUS_J0], props={EST_CARDINALITY=-1.0, OUTPUT_COLS=[CHORUS_J0.sysid, CHORUS_J0.APPNAME]}) [13:23:11.674][info][talledLocalContainer] [13:23:11.674][info][talledLocalContainer] [13:23:11.674][info][talledLocalContainer] ============================================================================ [13:23:11.674][info][talledLocalContainer] EXECUTING PlanSorts [13:23:11.674][info][talledLocalContainer] [13:23:11.674][info][talledLocalContainer] AFTER: [13:23:11.674][info][talledLocalContainer] null [13:23:11.674][info][talledLocalContainer] [13:23:11.674][info][talledLocalContainer] ============================================================================ [13:23:11.674][info][talledLocalContainer] EXECUTING CollapseSource [13:23:11.674][info][talledLocalContainer] [13:23:11.674][info][talledLocalContainer] 13:23:11,673 ERROR [PROCESSOR] Unexpected exception for request d8e/tMDp2Hy3.0 [13:23:11.674][info][talledLocalContainer] java.lang.NullPointerException [13:23:11.674][info][talledLocalContainer] at org.teiid.query.optimizer.relational.plantree.NodeEditor.findAllNodesHelper(NodeEditor.java:123) [13:23:11.674][info][talledLocalContainer] at org.teiid.query.optimizer.relational.plantree.NodeEditor.findAllNodes(NodeEditor.java:102) [13:23:11.674][info][talledLocalContainer] at org.teiid.query.optimizer.relational.rules.RuleCollapseSource.execute(RuleCollapseSource.java:85) [13:23:11.675][info][talledLocalContainer] at org.teiid.query.optimizer.relational.RelationalPlanner.executeRules(RelationalPlanner.java:458) [13:23:11.675][info][talledLocalContainer] at org.teiid.query.optimizer.relational.RelationalPlanner.optimize(RelationalPlanner.java:227) [13:23:11.675][info][talledLocalContainer] at org.teiid.query.optimizer.QueryOptimizer.optimizePlan(QueryOptimizer.java:148) [13:23:11.675][info][talledLocalContainer] at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:429) [13:23:11.675][info][talledLocalContainer] at org.teiid.dqp.internal.process.Request.processRequest(Request.java:452) [13:23:11.675][info][talledLocalContainer] at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:372) [13:23:11.675][info][talledLocalContainer] at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:174) [13:23:11.675][info][talledLocalContainer] at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49) [13:23:11.675][info][talledLocalContainer] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:188) [13:23:11.675][info][talledLocalContainer] at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:116) [13:23:11.675][info][talledLocalContainer] at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:290) [13:23:11.675][info][talledLocalContainer] at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) [13:23:11.675][info][talledLocalContainer] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) [13:23:11.675][info][talledLocalContainer] at java.lang.Thread.run(Thread.java:619) -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

[ https://issues.jboss.org/browse/TEIID-1554?page=com.atlassian.jira.plugin... ] Mark Addleman commented on TEIID-1554: -------------------------------------- That's right: I don't get the NPE without the patches. My collegue, Gaurav, will answer your question regarding the tests. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

[ https://issues.jboss.org/browse/TEIID-1554?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-1554: --------------------------------------- If you don't get this error with 7.4 beta2, then this issue can be closed. More than likely it's an issue with patch application. As for resolving your issues with the patch, for now just get TestSortOptimization running. I don't believe that would require any changes to TestOptimizer. You'll want all of the testProjectionRaising* tests to run correctly to validate you're patch of RulePlanSorts. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

[ https://issues.jboss.org/browse/TEIID-1554?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-1554: --------------------------------------- Reproduce the error in 7.4 beta2. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

[ https://issues.jboss.org/browse/TEIID-1554?page=com.atlassian.jira.plugin... ] Mark Addleman commented on TEIID-1554: -------------------------------------- Apply the TEIID-1554 patch to 7.3 fixes the NPE we're aware of. Thanks -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira