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

Other

Change View Performance

In InterBase 2020 Update 5 Change View retrieval performance has been enhanced.

Note: This performance enhancement only works on ODS 17 databases.

First Sweep of a Restored Database is now a Fast Sweep

With InterBase 2020 Update 5, any database that you restore is immediately marked as swept, therefore the first sweep of that database is a fast sweep. In order to take advantage of this feature, you need to perform a database restore with InterBase 2020 Update 5 and use either ODS 15 or ODS 16. See Sweep Interval and Automated Housekeeping for more information about sweeping.

Bug Fixes

See Resolved Defects for a list of bug fixes in InterBase 2017 Update 1.

System Requirements/Prerequisites

For system requirements to install and run InterBase, see System Requirements/Prerequisites.

What's New in InterBase 2017 Update 1