A rather huge problem in debugging queries over the years
was the dreaded “ambiguous column” error.
It wasn’t something I ran into a lot, but when I did it always seemed to
come up in rather large queries and was unbelievably hard to figure out which
column.
Now in 23ai we finally have an error message that at least
gives a clue:
ORA-00918: CREATED: column ambiguously specified - appears
in RVD_SCALAR_ALLUSERS and RVD_SCALAR_ALLOBJECTS
Apparently other error messages have also been enhanced to
be more helpful as well. I’ve personally
not bumped into any of them just yet, but this is great news.
Well that only took about 100 years. 😏
No comments:
Post a Comment