invantive documentation
Invantive Support ForumsLog In / Sign Up

Release notes of Data Dictionary, 26.0 to 27.0

Driver Release Note - Internal

Data Dictionary driver 27.0, from 26.0

Build Date Description
26.0.4 22-03-2026 first build of release 26.0
27.0.93 10-11-2026 latest build of release 27.0 at the time of writing

The older end is the first build of release 26.0, not its last, because later builds of 26.0 received ports of changes made for 27.0. The data model of a release is the model that a later build of the same release generated.

  • 31 changes
  • 1 can break a statement
  • 3 groups not available

What Changed, by Group

Every change is in one group: the group answers the question that you ask before you upgrade.

  • Data model
    • –
    • not available
    • Do my statements and views still work?
  • Provider attributes
    • –
    • not available
    • Do I have to change my connection string, provider file or settings?
  • Capabilities
    • –
    • not available
    • What can the driver do with a table?
  • Performance
    • 2
    • Is it faster, and does it call the platform less?
  • Bug fixes
    • 8
    • 1 can break a statement
    • Is the defect that I met repaired?
  • Enhancements
    • 21
    • What can I do now that I could not?
  • Log-on and platform
    • 0
    • Do I have to log on again, or change something because of the platform?

Download Changes as CSV | Data Model of Data Dictionary

Before You Upgrade

The data models of this step could not be compared, so changes of tables and columns that break a statement are not known. The data model of this driver comes from build none in the 26.0 workspace and from build 26.1.88-BETA+6212 in the 27.0 workspace; the groups from model files need a model that a build of each release generated, and generating it needs an account that is not at hand.

These changes can stop an existing statement, view, connection string or script from working:

Top 25 Changes

Changes that can break a statement first, then by importance. Columns are summarised per table in the data model.

  1. Correct the name of a misspelt column in the data dictionary
    • Bug fixes
    • Breaks an existing statement or script.
  2. List views, functions and procedures created by users in tools such as SSMS
    • Bug fixes
    • Importance 3 of 5.
  3. Prevent errors and corrupt state when the data dictionary is used by several threads
    • Bug fixes
    • Importance 3 of 5.
  4. Read the data dictionary CSV files with any line ending
    • Bug fixes
    • Importance 3 of 5.
  5. Add views on candidates, partitions and hints of pre-emptive loading
    • Enhancements
    • Importance 3 of 5.
  6. Ignore web errors in the SQL functions to get and post over HTTP
    • Enhancements
    • Importance 3 of 5.
  7. Show rate limits of a connection per data container
    • Enhancements
    • Importance 3 of 5.
  8. Use less memory in the tables view and in the statement statistics
    • Performance
    • Importance 2 of 5.
  9. Durations in the data dictionary keep their fractions of a millisecond
    • Bug fixes
    • Importance 2 of 5.
  10. Fill bytes sent of HTTP downloads and correct the column counts of data dictionary views
    • Bug fixes
    • Importance 2 of 5.
  11. Add views on named locks and atomic values of PL/SQL sessions
    • Enhancements
    • Importance 2 of 5.
  12. Add views with glossaries and glossary terms and list all translation languages
    • Enhancements
    • Importance 2 of 5.
  13. Add views with keys and foreign keys of tables
    • Enhancements
    • Importance 2 of 5.
  14. Register memory allocated and CPU time of threads in execution statistics
    • Enhancements
    • Importance 2 of 5.
  15. Show calls that are still running in the session IO view
    • Enhancements
    • Importance 2 of 5.
  16. Show inbound correlation identifiers of statements and cached HTTP calls
    • Enhancements
    • Importance 2 of 5.
  17. Show technical documentation and capabilities of tables and views in the data dictionary
    • Enhancements
    • Importance 2 of 5.
  18. Show value kind, allowed values and required flag of provider attributes
    • Enhancements
    • Importance 2 of 5.
  19. Show when a partition was selected or deselected
    • Enhancements
    • Importance 2 of 5.
  20. Sort licence modules and execution names faster
    • Performance
    • Importance 1 of 5.
  21. Allow longer argument documentation in the data dictionary
    • Bug fixes
    • Importance 1 of 5.
  22. Show the licence agreement text instead of its title
    • Bug fixes
    • Importance 1 of 5.
  23. Add IPv6 columns to the DUAL table
    • Enhancements
    • Importance 1 of 5.
  24. Add descriptions and short names to data dictionary objects
    • Enhancements
    • Importance 1 of 5.
  25. Let a caller ignore errors when retrieving online help tips
    • Enhancements
    • Importance 1 of 5.

Data model

Do my statements and views still work? Tables, views, table functions, columns, parameters, keys, code values, packages and procedures that appear, disappear, are renamed or change type.

Not available. The data model of this driver comes from build none in the 26.0 workspace and from build 26.1.88-BETA+6212 in the 27.0 workspace; the groups from model files need a model that a build of each release generated, and generating it needs an account that is not at hand.

Provider attributes

Do I have to change my connection string, provider file or settings? Attributes of the connection and settings of the driver that appear, disappear or change default or place where they can be set.

Not available. The data model of this driver comes from build none in the 26.0 workspace and from build 26.1.88-BETA+6212 in the 27.0 workspace; the groups from model files need a model that a build of each release generated, and generating it needs an account that is not at hand.

Capabilities

What can the driver do with a table? Whether a table or table function can be selected from, inserted into, updated and deleted from.

Not available. The data model of this driver comes from build none in the 26.0 workspace and from build 26.1.88-BETA+6212 in the 27.0 workspace; the groups from model files need a model that a build of each release generated, and generating it needs an account that is not at hand.

Performance

Is it faster, and does it call the platform less? Paging, batching, caching, filters and projections sent to the platform, fewer requests, less memory.

  • 2 changes
  • commits

Use less memory in the tables view and in the statement statistics

The tables view reuses boxed values, and the statistics skip executions of which the audit information is already released.

  • importance 2
  • confidence medium
Sort licence modules and execution names faster

Sorting in the licence module and execution views uses in-place sorting and a cheaper search.

  • importance 1
  • confidence medium

Bug fixes

Is the defect that I met repaired? Wrong or missing rows, wrong values, crashes and wrong messages, repaired in a release line that had the defect.

  • 8 changes
  • commits

List views, functions and procedures created by users in tools such as SSMS

A client that lists the objects of a connection, such as the Object Explorer of SSMS, showed no views, functions or procedures created with SQL until something used one. The backing database is now opened when the objects are listed.

  • importance 3
  • confidence high
Prevent errors and corrupt state when the data dictionary is used by several threads

Reading the statement statistics while other statements were running could fail, and opening and closing the backing database at the same time could leave it half closed. Access is now synchronised.

  • importance 3
  • confidence medium
Read the data dictionary CSV files with any line ending

The data dictionary read its built-in CSV data, such as time zones, with a fixed Windows line ending. On a checkout with Unix line endings the whole file was read as one record and the start failed. Any line ending is now accepted, and an invalid CSV configuration is reported with its own message.

  • importance 3
  • confidence medium
Correct the name of a misspelt column in the data dictionary

A column with the name CAN_FILTER_SERVER_SIDE_CONTAINERS is now called CAN_FILTER_SERVER_SIDE_CONTAINS.

What to Do

Replace CAN_FILTER_SERVER_SIDE_CONTAINERS by CAN_FILTER_SERVER_SIDE_CONTAINS in statements that select it.

  • can break a statement
  • importance 2
  • confidence medium
Durations in the data dictionary keep their fractions of a millisecond

Duration columns of several data dictionary views were whole numbers, so short durations were rounded down or shown as zero. They now hold fractional milliseconds.

  • importance 2
  • confidence medium
Fill bytes sent of HTTP downloads and correct the column counts of data dictionary views

The bytes sent of a download were always empty and now hold the number. The numbers of columns declared for several views were corrected to the columns that exist.

  • importance 2
  • confidence medium
Allow longer argument documentation in the data dictionary

The column with the documentation of an argument allowed too few characters. The maximum length was extended.

  • importance 1
  • confidence medium
Show the licence agreement text instead of its title

The licence agreement text property of the data dictionary returned the value of the agreement title. It now returns the text.

  • importance 1
  • confidence medium

Enhancements

What can I do now that I could not? New functions and options that are not a table or a column.

  • 21 changes
  • commits

Add views on candidates, partitions and hints of pre-emptive loading

Three new data dictionary views show what the loader of the connection fetches ahead of the request: the candidates, the partitions being loaded and the hints. The views are empty when loading ahead is off.

  • importance 3
  • confidence high
Ignore web errors in the SQL functions to get and post over HTTP

The SQL functions to get and post over HTTP can ignore web errors, and several threads can use them at the same time. The download history keeps the results.

  • importance 3
  • confidence medium
Show rate limits of a connection per data container

The data containers view shows the limits per second, minute, hour and day, with the remainder and the reset time, as last reported by the platform.

  • importance 3
  • confidence high
Add views on named locks and atomic values of PL/SQL sessions

Two new views show the named locks and the named atomic values of the session, for use with parallel PL/SQL.

  • importance 2
  • confidence high
Add views with glossaries and glossary terms and list all translation languages

Two new views show glossaries and their terms. The translations view now also lists languages that are not loaded in the session.

  • importance 2
  • confidence medium
Add views with keys and foreign keys of tables

New views list the keys and foreign keys per table. For this driver the foreign key view has no rows; it exists so that scripts written for other releases run.

  • importance 2
  • confidence medium
Register memory allocated and CPU time of threads in execution statistics

The views with executions and execution steps have columns for the heap memory allocated and the CPU time of the thread.

  • importance 2
  • confidence high
Show calls that are still running in the session IO view

The session IO view can show a call that has not finished, such as the lookup of the external address, and its columns may be empty meanwhile.

  • importance 2
  • confidence medium
Show inbound correlation identifiers of statements and cached HTTP calls

The views with SQL executions and the cached HTTP calls have a column with the correlation identifiers received with the request, so a call can be followed across systems.

  • importance 2
  • confidence high
Show technical documentation and capabilities of tables and views in the data dictionary

The views with tables and with views now have the technical documentation. The views with views also show the supported operations, documentation, example and static access estimates.

  • importance 2
  • confidence high
Show value kind, allowed values and required flag of provider attributes

The views with provider and data container attributes show the kind of value, the allowed values and whether the attribute is required.

  • importance 2
  • confidence high
Show when a partition was selected or deselected

The partition views have extra columns with the object identifier and the moments the selection was last changed, set and removed.

  • importance 2
  • confidence high
Add IPv6 columns to the DUAL table

The DUAL table has three new columns with an IPv6 address, an IPv4-mapped address and an empty address, for testing.

  • importance 1
  • confidence medium
Add descriptions and short names to data dictionary objects

The views and table functions of the data dictionary have a description and a short name in their definitions.

  • importance 1
  • confidence medium
Let a caller ignore errors when retrieving online help tips

The table function that gets the online help tips has a parameter to ignore errors. The caller then gets no rows instead of an error.

  • importance 1
  • confidence high
Make message identifiers time-ordered

The unique identifier of a message now contains the moment of creation, so messages can be sorted by it.

  • importance 1
  • confidence medium
Record the external port of the client in audit events

Audit events carry the external port with the external IPv6 address of the client.

  • importance 1
  • confidence low
Remove two properties of the retired Windows RSA licence check

The properties that told whether the Windows RSA service was available and whether an operating system update check was needed are gone.

  • importance 1
  • confidence medium
Show since which release a function of a package is available

The view with package functions has a column with the release since which a function exists. The commit subject names the HTTP package.

  • importance 1
  • confidence high
Show the creation and last review date of the driver

The registration of the driver holds the date it was created and the date it was last fully reviewed against the platform.

  • importance 1
  • confidence low
Show the kind of request and natural key of user messages

The user messages view has two new columns: the kind of request and the natural key of the message.

  • importance 1
  • confidence high

Log-on and platform

Do I have to log on again, or change something because of the platform? Log-on and token handling, scopes and permissions, a new version of the platform API, retired endpoints and changed limits.

  • 0 changes
  • commits

No changes in this group.

More Information

How This Note Was Made

  • DataDictionaryProvider.cs: GuiIpV6PortExternal set on the event; the audit events view grew 83 -> 85 columns in 233f6a, probably including it.
  • DataDictionaryProvider.cs: DRIVER_CREATED_ON and DRIVER_LAST_FULL_REVIEW_ON, read by the generic provider. Subject is Improve logging.
  • Commit items were classified by one reader; the model changes are derived and need no reading.
  • Commits: the commits of the driver directory in the range that have no equivalent patch in the older state, without merges and version stamps; each was classified by reading its message and change.
  • Model: the NDJSON files of data-models/database of the workspace of each release are compared record by record; only fields that both models have are compared, and texts are counted, not listed.
  • A model generated from a later build of the same release (for example 26.0.340 for 26.0) stands for the release.
  • 50 links between a change and a source commit are recorded.