InterBase 2017 Update 1 Readme

From InterBase

Go Up to Main Page

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.

This Readme covers the following sections:

Note: Click Previous Releases for all releases prior to InterBase 2020 Update 5.
Note: Click here to view the resolved issues and the new features of the 2017 release.


New Supported Platforms

InterBase Developer and Server editions now support the following macOS versions:

  • El Capitan
  • Sierra
  • High Sierra

InterBase 2017 Update 1 on macOS now supports 64-bit architecture for both Server and ToGo Editions.

InterBase Developer and Server editions now support the following Windows versions:

  • Windows 10 Creators Update


New Features

Expression Index

  • Support for Expression Indices (called EI in short henceforth) enhance the index definition and optimization of queries. Such an EI definition is open to any valid expressions containing any field(s) from the same base table with normal expression operators that InterBase users are used to provide either as part of a column result set or in WHERE expressions in SELECT statements.

For more information refer to Expression Index

Enhancements to GROUP BY and ORDER BY

  • GROUP BY has been enhanced to take in an ordinal value (INT) referring to a select list item position.
  • GROUP BY and ORDER BY have been enhanced to take in an "expr" that would result in a single value.

For more information refer to Enhancements to GROUP BY and ORDER BY



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

  • On macOS, InterBase Server Edition, Japanese Language installer brings up the English UI. Current diagnosis indicates this is a problem with the InstallAnywhere version used by us and there is no workaround.
  • Issue:Server-side Performance Monitoring via admin.ib works using ISQL command-line tool, but throws a "Key violation" exception when used via IBConsole Performance Monitoring UI

Resolved Defects

Click here for list of resolved defects in InterBase XE7

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 "http://docwiki.embarcadero.com/InterBase/2020/e/index.php?title=InterBase_2017_Update_1_Readme&oldid=29615"