I did some more experimenting with the assembling strings and that didn’t appear to work in general. Would love to know how you got that to run at all. Even this comes out different:
q: length of "this " & " and that"
E: The operator "concatenate" is not defined.
q: preceding text of first ":" of "domain.com:52311/bfmirror/downloads"
q: preceding text of first ":" of "domain.com:52311/ " & "bfmirror/downloads"
On a side note, thought this was really funny:
q: length of "WITH CTE AS ( SELECT A.IssuedTime as 'IssuedTime' , CASE WHEN INSTR(A.[ActionName], '- retry') = 0 THEN A.[ActionName] ELSE SUBSTR(A.[ActionName], 0, INSTR([ActionName], '- retry')) END AS 'SoftwareName', SUBSTR(B.State, INSTR(B.State, ':s=') + 3, INSTR(B.State, ':pr=')-INSTR(B.State, ':s=')-3)" & " as 'Status' , REPLACE(SUBSTR(B.State, INSTR(B.State, ':relevant=') + 10), ':', '') 'Relevant' FROM ACTION_HISTORY A INNER JOIN ACTION_STATE_HISTORY B ON A.ActionID = B.ActionID WHERE A.IssuerName = 'ede_rest_admin' AND (A.ActionName LIKE '%25_I%25' ESCAPE '\' OR A.ActionName LIKE '%25_U%25' ESCAPE '\') AND A.Script = '' ) SELECT MAX(A.IssuedTime) 'IssuedTime' , A.SoftwareName 'SoftwareName' FROM CTE A INNER JOIN (SELECT SoftwareName FROM CTE GROUP BY SoftwareName HAVING COUNT(1) > 1) B ON A.SoftwareName = B.SoftwareName GROUP BY A.SoftwareName"
E: This expression has a very long string.
So that back’s up @AlanM’s note. It’s 845 characters long.