What's New in InterBase 2017 Update 1

From InterBase
Jump to: navigation, search

Go Up to Main Page


InterBase 2017 Update 1 includes new features and bug fixes.

See the following sections for more information:


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 2017 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 2017, 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 2017 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.

Personal tools
Previous Releases:
In other languages