Oracle Scratchpad

January 28, 2022

Bug Catalogue

Filed under: Oracle — Jonathan Lewis @ 4:42 pm GMT Jan 28,2022

This is a list of all articles I’ve written that describe bugs. Most of them are version specific and many of them will have been fixed by the latest versions of Oracle so its likely to be only the first few that might be of interestg. Each entry has a date stamp and a short note of the contents. The articles are generally listed most-recent first.

I am currently working backwards through my entire blog adding articles to catalogues as I go, so any individual catalogue may grow very slowly.

  • Char Semantic trouble (August 2022): A combination of varchar2(x CHAR), LOB columns, and transparent data encryption (TDE) trigger an error ORA-12899 on “alter table move”
  • Dropping tablespaces (July 2022): composite partitioning, LOBs, and reusing the names of dropped tablespaces can result in subsequente surprising errors.
  • Join view delete (May 2022): ANSI expansion problems with deletes from join views
  • Why “lag() ignore nulls” is slow (May 2022): and how to work around the problem in some cases (it’s not officially a bug, and there is no anticipated fix, yet).
  • Online redefinition defect (May 2022): using copy_table_dependencies() can produce metadata inconsistencies.
  • Drop column bug (Mar 2022): an interaction with MDSYS that blocks column dropping
    • Drop column bug (Mar 2022): a follow-up to the above using user-defined types.
  • Subquery upgrade (Mar 2022): when 12c unnests a subquery but 19c says it fails validity tests
  • Happy New Year (Jan 2022): wrong results with group by. Bug in 12.2 but patch available
  • Audit trail purge problem (July 2021): a trouble-shooting tip demonstrated by debugging a problem with dbms_audit_mgmt.
  • Join Elimination bug (Mar 2021): inconsistent behaviour when combined with deferrable constraints.
  • Adaptive Plan bug (Feb 2021): An adaptive plan (on partitioned tables with missing statistics) producing wrong results even in 21.3
  • Drop column bug (Jan 2021): introduced in 18c, fixed in 19.10, can do nasty things if you “drop unused columns” and have triggers on the table.
  • Supplemental logging mess (Jan 2021): you need to be a little careful when you add supplemental logging clauses to a table.
  • Aggregate of Expressions (Aug 2020): Wrong results with aggregates of (case) expressions. Fixed in 21.1
  • Group by Elimination (Jan 2020): Wrong results introduced in 12.2 – probably fixed by 19.11 and 21.3
  • Cursor sharing update (Oct 2019): Rediscovery and further comment on the anomaly reported in May 2016

1 Comment »

  1. […] Bug catalogue […]

    Pingback by Catalog Catalogue | Oracle Scratchpad — January 28, 2022 @ 4:43 pm GMT Jan 28,2022 | Reply

RSS feed for comments on this post. TrackBack URI

Comments and related questions are welcome.

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Website Powered by

%d bloggers like this: