InterBase Version History

Below is a summary of the highlights added in previous editions of InterBase. For detailed release notes and new features please visit the InterBase DocWiki

The focus is on SQL features in this new release. InterBase 2017 comes with a faster core engine, server-wide performance monitoring.

SQL Derived Table & Common Table Expression Support

SQL derived tables will enhance the ability of existing applications to use InterBase as a backend RDMBS.

A derived table allows developers the expressive flexibility to use a View-like structure without defining a database schema view. It also lets users obtain the same benefit in an ad hoc query without requiring database administration to create a view definition. Derived tables are temporary sets of records that can be used inside other queries. These tables can shorten long queries, or break complex processes into logical steps.

The query expression can be embedded directly in the SQL statement together with a correlation name used to identify the derived table. This is informally known as "common table expressions”.

RECONNECT

New ISQL Scripting Command

New RECONNECT command for use in isql and SQL scripts to reconnect to the latest successfully connected database

-names

New ISQL Command Line Option

isql supports a new command line option, -names . You can use this option to specify the character set to use for the current database connection

Exclusive Isolation Level

Allows transactions to acquire an exclusive lock on a target table, and be the only ones able to execute SELECT, INSERT, UPDATE, and DELETE on a table.

Exclusive isolation level can be used by a tool performing online reorganization of tables that may need temporary exclusive table access to perform its functions. Transactions use exclusive table access to acquire an exclusive lock on a target table, and they are the only ones able to execute SELECT, INSERT, UPDATE, and DELETE on a table. When a transaction acquires an exclusive lock, other transactions with lock requests must wait until the lock is released or downgraded to a compatible level. Transactions that maintain exclusive table access can modify data on a table without interference from other transactions. This isolation level is different from TABLE STABILITY and PROTECTED access because it does not allow other transactions to select from the table

Truncate Table

Command which allows the users and applications to empty the contents of a database table.

Truncate Table is useful for tables where rows require frequent deletion. The Truncate Table command performs faster and requires less I/O. It also journals and archives much less information than an equivalent DELETE FROM table command. ETL applications or other applications can benefit from the combination of TRUNCATE TABLE with the NO RESERVE SPACE table allocation option when they stage large amounts of data that are deleted after use or moved to a more permanent location such as a history table

Transaction Wait Time

Specifies a period transactions wait for acquiring lockable resources.

InterBase transaction lock can wait indefinitely, wait a specified period, or not wait and return an error immediately to acquire lockable resources. When a transaction holds a lock on a resource at a level incompatible with the requested lock level, this resource is inaccessible to other transactions. Lockable resources can be tables, rows, or transaction entities

Single Line Comment

Comment syntax allows programmers to add comments to procedure and trigger code or SQL scripts.

There are two different types of comments that you can use:

  • The SIMPLE comment: A comment that starts with a special symbol and ends with a new line. The simple comment syntax is only available starting with database engine version InterBase 2017.
  • The BRACKETED comment: A comment that starts and ends with a special symbol. It may be multi-line.

Regardless of the type of comment you use, you may start a comment anywhere in a line. However, with a simple comment, you need to keep in mind that the comment area stops after a new line. To use the simple comment syntax for a multi-line comment, you need to start each line with the special symbol.

ODS version 17

Databases created with InterBase 2017 use ODS 17.

Features of ODS 17 include:

  • InterBase 2017 creates databases with ODS version 17 by default.
  • Server-side Performance Monitoring is only available starting with ODS version 17. See "Monitor all online databases" for more detail.
  • Change View Subscriptions now reflect ALTER TABLE changes starting with ODS version 17.
  • Change View retrieval performance is enhanced under ODS version 17.

 

Full details of What’s New in InterBase 2017