Fixes for Oracle 19c: boolean types in query
This fixes the following bug for Oracle:
[13/Feb/2022:17:53:36][8701.7f9f62f0b700][-conn:oacs-5-10-0:default:0:0-] Error: nsoracle.c:1367:OracleSelect: error in `OCIStmtExecute ()': ORA-00920: invalid relational operator
:
: SQL:
:
: select p.package_id,
: p.instance_name,
: n.node_id,
: n.name,
: :subsite_url || n.name as url,
: (select count(*)
: from group_approved_member_map m
: where m.rel_type = 'membership_rel'
: and m.group_id = ag.group_id) as num_members,
: (select min(r2.member_state)
: from group_member_map m2,
: membership_rels r2
: where m2.group_id = ag.group_id
: and m2.member_id = :untrusted_user_id
: and r2.rel_id = m2.rel_id) as member_state,
: g.group_id,
: g.join_policy
: from site_nodes n,
: apm_packages p,
: application_groups ag,
: groups g
: where n.parent_id = :subsite_node_id
: and p.package_id = n.object_id
: and p.package_key in ('acs-subsite')
: and ag.package_id = p.package_id
: and g.group_id = ag.group_id
: and (g.join_policy !>>>!!= 'closed' or acs_permission.permission_p(p.package_id, :untrusted_user_id, 'read'))
: order by lower(instance_name)
:
