SQL issue between version 4 and version 5

[Mohamed Lrhazi]

oh wow, actually no, there is a difference in the log!!!!

version 5 :

shib-idp;idp-process.log;dev;nothing; SELECT 1 FROM PS_CX_TIMELYCAR_VW WHERE
EMPLID = '$employeeID.get(0)'
shib-idp;idp-process.log;dev;nothing; ) THEN 'true' ELSE 'false' END AS
isTimelycareEligible
shib-idp;idp-process.log;dev;nothing; FROM DUAL yields SELECT CASE WHEN
EXISTS (
shib-idp;idp-process.log;dev;nothing; SELECT 1 FROM PS_CX_TIMELYCAR_VW WHERE
EMPLID = '1400621'
shib-idp;idp-process.log;dev;nothing; ) THEN 'true' ELSE 'false' END AS
isTimelycareEligible
shib-idp;idp-process.log;dev;nothing; FROM DUAL


version 4:



shib-idp;idp-process.log;dev;nothing; SELECT 1 FROM PS_CX_TIMELYCAR_VW WHERE
EMPLID = '$employeeID.get(0)'
shib-idp;idp-process.log;dev;nothing; ) OR '$employeeID.get(0)' IN (
'1400621', '1386568')
shib-idp;idp-process.log;dev;nothing; THEN 'true' ELSE 'false' END AS
isTimelycareEligible
shib-idp;idp-process.log;dev;nothing; FROM DUAL yields SELECT CASE WHEN
EXISTS (
shib-idp;idp-process.log;dev;nothing; SELECT 1 FROM PS_CX_TIMELYCAR_VW WHERE
EMPLID = '1400621'
shib-idp;idp-process.log;dev;nothing; ) OR '1400621' IN ('1400621',
'1386568')
shib-idp;idp-process.log;dev;nothing; THEN 'true' ELSE 'false' END AS
isTimelycareEligible
shib-idp;idp-process.log;dev;nothing; FROM DUAL

On Wed, Dec 18, 2024 at 4:12 PM Cantor, Scott <cantor.2 at osu.edu> wrote:

> There's nothing different about the syntax for using dependencies in query
> templates, but self-evidently if the log proves the query text is resolved
> into the expected string it's not the problem.
>
> -- Scott
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://shibboleth.net/pipermail/users/attachments/20241218/3bc1f302/attachment.htm>