Readme InterBase 2020 Update 1

From InterBase

Go Up to Main Page

Release Notes for InterBase

Note: Click Previous Releases for all releases prior to InterBase 2020 Update 7.

Release Notes for InterBase 2020

  • This release introduces bug fixes. See Resolved Defects for a complete list of bug fixes.
  • This release introduces new features see New Features for details.


New Features

Tablespace

InterBase multifile database may be interpreted as occupying a single primary tablespace. This tablespace presents a single logical collection of database pages numbered by their sequence in this collection. Starting with InterBase 2020 users can define other named tablespaces that present independent logical collections of pages. For more information refer to Tablespace

ALTER DESCRIPTION Support

InterBase users prior to InterBase 2020 would execute a UPDATE <system_table> SET RDB$DESCRIPTION=<blob_text> WHERE <entity_name>=<user_entity>, for each entity type. This requires the user to know the database system schema in detail for each entity type. The new DDL syntax takes away this complexity, and provides a new ALTER DESCRIPTION FOR syntax that is standard across all database entities supported by InterBase. For more information refer to ALTER DESCRIPTION

TMP$INDICES table

InterBase 2020 introduces TMP$INDICES a new system table included as part of the Performance Monitoring system tables. This table tracks all loaded indices per table in the database with key metrics for monitoring. For more information refer to TMP$INDICES

IBConsole

InterBase 2020 introduces the following enhancements to the IBConsole tool:

Performance Monitor

A new Indices tab that shows a table with details about indices.

Interactive SQL Window

  • Closing the Interactive SQL Window on a read only transaction no longer prompts a commit or rollback dialog, transaction is commited and the window closes.
  • Enhanced support for the RECONNECT clause, it now supports CACHE, lc_ctype and DIALECT.
  • A new Show tab, this tab shows information from isql SHOW statements
  • InterBase 2020 features support (Tablespaces, Alter Description DDL)
  • Change Views subscription context and coloring of change status
  • Syntax highlighting of queries
  • 64-bit IBConsole.exe binary with 64-bit Edition of InterBase
  • Server-wide Performance Monitoring enhancements
  • WISQL SHOW commands

NOT Operator Optimizations

InterBase 2020 introduces optimizations for the NOT operator, for more information refer to NOT Operator Optimizations

Other

InterBase ToGo/IBLite Support

  • Added , macOS 64-bit support for InterBase ToGo/IBLite Edition.
  • Added Android 64-bit support for InterBase ToGo/IBLite Edition.


Migration Issues for InterBase 2020

  • Database backups created with InterBase 2020 Update 1 should be restored with a 2020 Update 1 (or greater) client (gbak) or server (service api) version. If you choose to restore the backup to an older version of the server with an older ODS version, please use the 2020 Update 1 GBAK client to restore.
  • InterBase 2020 creates databases with ODS 18 by default, but it can connect to databases with ODS 13 and later versions for transactional workload.
  • InterBase 2020 allows backup of ODS 11 and ODS 12 databases using the gbak command-line tool only using client/server mode, not service manager mode. You can use this feature when migrating from old InterBase ODS 11 and 12 databases.
  • New InterBase keywords introduced in this release include: COLLATION is a reserved keywords in InterBase 2020.


Known Issues

Resolved Defects

Click here for list of resolved defects in InterBase 2017.

Additional Resources

Embarcadero Technologies Technical Support

If you have a valid maintenance contract with Embarcadero Technologies, the Embarcadero Technical Support team is available to assist you with any problems you have with our applications. Our maintenance contract also entitles registered users of Embarcadero Technologies products to download free software upgrades during the active contract period. Evaluators receive free technical support for the term of their evaluation. We encourage you to visit the Support section of our Web site.

Embarcadero Technologies on the Web

Evaluators receive free technical support for the term of their evaluation. To download evaluations of Embarcadero Technologies products or to learn more about our company and our products, visit us at http://www.embarcadero.com/.
Retrieved from "https://docwiki.embarcadero.com/InterBase/2020/e/index.php?title=Readme_InterBase_2020_Update_1&oldid=30132"