Trace-Wizard icon indicating copy to clipboard operation
Trace-Wizard copied to clipboard

SQL Statement parsing does not handle newlines

Open tslater2006 opened this issue 8 years ago • 0 comments

Example:

PSAPPSRV.5922 (776) 1-1269 10.31.21 0.104118 Cur#2.5922.HR91SYS RC=0 Dur=0.096857 COM Stmt=select * from ( select rownum rnum, a.* from (SELECT 'T', MGR.EMPLID "MGR_EMPLID", N_MGR.NAME "MGR_NAME", MGR.SUPERVISOR_ID, EMP.EMPLID, EMP.EMPL_RCD, N_EMP.FIRST_NAME, N_EMP.LAST_NAME, N_EMP.NAME,

TraceWizard only shows "select *" on this. We should continue looking at subsequent lines untill we find one that matches the Context Marker regex. All lines in between should be counted as part of the SQL statement.

tslater2006 avatar Jan 16 '17 16:01 tslater2006