[Progress Communities] [Progress OpenEdge ABL] Forum Post: OpenEdge 11.7.5 => 12 Query Not Working

[alex.wiese.pulse]

This query returns YES NO on v11.7.5 when a matching usr record is found, but a matching security record is not. On v12.1 it returns NO NO with the exact same data. I can't find any mention of this breaking change of behaviour in the documentation. Surely this is a bug? FOR FIRST usr NO-LOCK WHERE usr.user_id EQ 'admin', EACH security NO-LOCK WHERE security.users = usr.user_id: END. DISPLAY AVAIL usr AVAIL security. Disabling "server side joins" fixes the problem, so it appears to be a bug with the new "server side joins" feature.

Continue reading...