pre RU16 hits no ORA-00918 ==>since RU17 ORA-00918 is raised
Oracle 19c, RU17
Hi, with new RU17 a bug was fixed, which caused so far, that an ambiguously defined column not raised an ORA-00918.
I wrote this, because I think that many applications maybe has wrong SQL which were tolerated bei parser until RU16, but with RU17 not.
Here is the way to reproduce the behavior:
create table t1 (id int);
create table t2 (id int);
insert into t1 values(1);
insert into t1 values(2);
insert into t2 values(1);
insert into t2 values(2);
commit;
>>POST RU17 (correct behavior)
select a_t2.id from t1 a_t1
inner join t2 a_t2 on a_t1.id=a_t2.id