Question

4
Replies
53
Views
Close popover
Haruka Kondo (HarukaK6)
Kondo

Kondo
HarukaK6 Member since 2015 5 posts
Kondo
Posted: November 1, 2017
Last activity: November 5, 2017
Closed
Solved

Inquiry about SQL using at Pega7.2 product

Hi,

There is Oracle database bug 21387771 (Wrong result with subquery coalesce even with fix for bug 20871556), and we need to know Pega 7.2 product is using such kind of SQL or not by 11/8.
We understand there is Patch for this bug, but because of our client policy, we need to check that there is any impact for Pega 7.2 by this bug.

<<Subquery coalesce example>>
U1@ora> select * from test;
ID1 ID2
--------------- --------------------
1 1
U1@ora> select * from test2;
ID1 ID2
--------------- --------------------
1 2
U1@ora> select *
from test where id1 in (select id1 from test2) <-- This subquery is ignored.
or (id1, id2) in (select id1, id2 from test2);
0 rows.

Best Regards

Data Integration
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.