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. |
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
This Note
Groups
- Data model
- Provider attributes
- Capabilities
- Performance 2
- Bug fixes 8
- Enhancements 21
- Log-on and platform 0
More
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:
- Correct the name of a misspelt column in the data dictionary
- Replace CAN_FILTER_SERVER_SIDE_CONTAINERS by CAN_FILTER_SERVER_SIDE_CONTAINS in statements that select it.
Top 25 Changes
Changes that can break a statement first, then by importance. Columns are summarised per table in the data model.
- Correct the name of a misspelt column in the data dictionary
- Bug fixes
- Breaks an existing statement or script.
- List views, functions and procedures created by users in tools such as SSMS
- Bug fixes
- Importance 3 of 5.
- Prevent errors and corrupt state when the data dictionary is used by several threads
- Bug fixes
- Importance 3 of 5.
- Read the data dictionary CSV files with any line ending
- Bug fixes
- Importance 3 of 5.
- Add views on candidates, partitions and hints of pre-emptive loading
- Enhancements
- Importance 3 of 5.
- Ignore web errors in the SQL functions to get and post over HTTP
- Enhancements
- Importance 3 of 5.
- Show rate limits of a connection per data container
- Enhancements
- Importance 3 of 5.
- Use less memory in the tables view and in the statement statistics
- Performance
- Importance 2 of 5.
- Durations in the data dictionary keep their fractions of a millisecond
- Bug fixes
- Importance 2 of 5.
- Fill bytes sent of HTTP downloads and correct the column counts of data dictionary views
- Bug fixes
- Importance 2 of 5.
- Add views on named locks and atomic values of PL/SQL sessions
- Enhancements
- Importance 2 of 5.
- Add views with glossaries and glossary terms and list all translation languages
- Enhancements
- Importance 2 of 5.
- Add views with keys and foreign keys of tables
- Enhancements
- Importance 2 of 5.
- Register memory allocated and CPU time of threads in execution statistics
- Enhancements
- Importance 2 of 5.
- Show calls that are still running in the session IO view
- Enhancements
- Importance 2 of 5.
- Show inbound correlation identifiers of statements and cached HTTP calls
- Enhancements
- Importance 2 of 5.
- Show technical documentation and capabilities of tables and views in the data dictionary
- Enhancements
- Importance 2 of 5.
- Show value kind, allowed values and required flag of provider attributes
- Enhancements
- Importance 2 of 5.
- Show when a partition was selected or deselected
- Enhancements
- Importance 2 of 5.
- Sort licence modules and execution names faster
- Performance
- Importance 1 of 5.
- Allow longer argument documentation in the data dictionary
- Bug fixes
- Importance 1 of 5.
- Show the licence agreement text instead of its title
- Bug fixes
- Importance 1 of 5.
- Add IPv6 columns to the DUAL table
- Enhancements
- Importance 1 of 5.
- Add descriptions and short names to data dictionary objects
- Enhancements
- Importance 1 of 5.
- 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
- Data model documentation of the driver
- Questions and answers on the forum
- Documentation of the platform
- All release notes
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.