Release Notes for InterBase 2020 Update 2

From InterBase

Go Up to Main Page

You can download InterBase 2020 Update 2 on the new products portal.
Note: Click Previous Releases for all releases prior to 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

ISQL

  • ISQL support to use EXTRACT for showing EUA database setup and EUA user records when connected as database owner.
  • ISQL support to EXTRACT Change View Subscription definitions and their use in Database/Table schemas.
  • Support to EXTRACT Encryption Key definitions when run as user SYSDSO, and database/column encryptions when run as database owner

CTE

  • InterBase already supports Common Table Expressions, this update introduces support for recursive CTE.

IBConsole

  • IBConsole can now set database write attributes when restoring databases.

SEP

  • Using gstat -h or services API now show information about SEP(system encryption password)on the header page statistics.


Migration Issues

Note: Click here for all issues prior to InterBase 2020.

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

None.


Resolved Defects

External Defect # Description
(QC)SalesForce #
Internal Defect #
InterBase 2020 Update 3: April 2022, bugs fixed in version 2020 Update 3, build 14.3.0.707.
SF Case 00915057

INTB-4055

InterBase crashes when using a IN clause and a subquery
SF Case 00914437

INTB-4054

InterBase 2020 Update 2 crashes with syntactically incorrect query
SF Case 00895549

INTB-4036

InterBase 2020 Build 482 crashes when querying System global temporary tables
SF Case 00866648

INTB-3930

IBConsole Diagnose Connection dialog too small and cannot be resized
SF Case 924768

INTB-4091

Restore database with GBAK does not work when spaces in directory name
SF Case 931271

INTB-4091

Online dump remains in TMP$DATABASE when there are no connections
INTB-4081 Error trying to open an ODS15 DB with a high transaction number
SF Case 00927047

INTB-4072

Import of CSV files does not work in IBConsole
SF Case 00917838

INTB-4071

Import of Raw data in IBConsole does not work
INTB-4043 IBConsole: AV in View Editor after deleting column
SF Case 800497, 00912051

INTB-3844

IB 2020 cannot access specific ODS 15 database
INTB-4068 Display licensed CPU count in interbase.log for usage confirmation
InterBase 2020 Update 2: September 2021, bugs fixed in version 2020 Update 2, build 14.2.0.570.
INTB-4034 "CREATE USER foo SET INACTIVE" does not work
INTB-4021 Incremental Online dumps using the DPB method worked in IB2020 and earlier, but was broken around update 1 timeframe.
INTB-4009 "Stack overflow" error returned when using a derived table as part of a JOIN
SF Case 00888133

INTB-3989

InterBase server crash when using a derived table alias in a PLAN syntax
INTB-3981 InterBase installer script on Linux does not work for "Console" mode
SF Case 00882697

INTB-3970

If the IBConsole WISQL window is minimized, it cannot be restored
SF Case 00882510

INTB-3969

Wrong result set returned by query when using tablename qualifier from outer scope in subquery
INTB-3953 For database in Linger mode, if underlying database file is deleted in file system, the loaded database stays resident in memory forever for the server session
INTB-3947 database linger countdown proceeding even if new attachments came in since last garbage collector check
SF Case 00874221, 00879632

INTB-3945

Database write mode not changed with IBConsole Properties
SF Case 00873954

INTB-3942

IBConsole does not display database properties when connection uses Alias DB Alias
IBP-153

INTB-3938

error import csv txt
SF Case 868447

INTB-3936

Dropping a subscription using IBConsole fails to delete permissions from RDB$USER_PRIVILEGES
INTB-3934 Crash when an EUA user activates a subscription tracking deletes
IBP-151

INTB-3931

A syntax error in CTE query crashes the server
SF Case 00866587

INTB-3928

Untrapped Server crash when setting a subscription to active
IBP-150

INTB-3924

Impossible to modify a view in InterBase 2020 with IBConsole
SF Case 00865039

INTB-3923

Atom unlock invalid state level: 1 appearing in interbase.log with build 14.1.0.366
SF Case 00862442

INTB-3921

Examining the metadata of an ODS 17 backup MUCH slower than that of an ODS 18
SF Case 00859749

INTB-3918

Recompile of stored procedures hangs when hundreds of them are done at the same time
SF Case 00858974

INTB-3910

It is not possible to log in to an EUA database if the sysdba password is not the same as server's SYSDBA password
SF Case 00859012

INTB-3907

Unexplained InterBase server crash due to heavy load
SF Case 811739

INTB-3895

A full backup of a database with tablespaces breaks the restore of a tablespace and corrupts the database
SF Case 00811085

INTB-3885

InterBase server crash with UNIONs in Derived Table definition
SF Case 00796052

INTB-3824

Not possible to connect to a database in IBConsole if EUA SYSDBA Password is different from Server password
SF Case 00794471

INTB-3814

Silent installer places superkey slip files in Program Files
SF Case 00789869

INTB-3792

Using invalid column alias in derived table causes server crash
SF Case 00766141

INTB-3732

IBServer crash on update online dump
SF Case 00762676

INTB-3705

Crash on executing selects with derived tables
SF Case 00585868

INTB-3376

IBConsole cannot set up Performance Monitoring Logs on ODS 16 and above
IBP-54

INTB-3294

Derived table column naming
INTB-3018 "Invalid command must specify column name for view select expression" querying count in a CTE expression
InterBase 2020 Update 1 Hotfix 2: October 2020, bugs fixed in version 2020 Update 1 Hotfix 2, build 14.1.0.319.
INTB-3889 Fix isc_info_db_sep_external info item to return status for external, internal, or no SEP.
SF Case 811259

INTB-3887

It is not possible to fetch alias information simultaneously from multiple clients.
IBP-142

INTB-3881

Multiple service API attachments at the same time crash the server.
INTB-3878 Simultaneous service api attachments causes a server crash in PWD_REQUEST
IBP-141

INTB-3857

Database restore reports "No current record for fetch operation"
SF Case 787085

INTB-3782

InterBase Server crash when executing many simultaneous database alias service requests
InterBase 2020 Update 1 Hotfix 1: June 2020, bugs fixed in version 2020 Update 1 Hotfix1, build 14.1.0.231.
INTB-3820 InterBase 2020 Update 1 32 bit server (build 14.1.0.220) does not start
INTB-3818 InterBase 2020 (build 14.1.0.219) ToGo does not include any files for macOS
INTB-3817 All generators needed by system triggers are returning wrong values
SF Case 792965

INTB-3807

Exception not called from trigger
InterBase 2020 Update 1: May 2020, bugs fixed in version 2020 Update 1.
INTB-3809 IBConsole Database Online Dump with tablespaces not working when targeting a named InterBase instance (not default)
IBB-16

INTB-3789

Backup of primary tablespace gives an error
INTB-3785 Cannot restore database backup coming from ODS 18 to ODS < 18, even without using tablespaces
SF Case 784575

INTB-3775

InterBase server crash on attach database
INTB-3769 Change Views query with LEFT OUTER JOIN returning with SQLIND_INSERT set for generated RHS table record
IBP-127

INTB-3758

Starting IBMGR changes service name to include XE7
INTB-3755 InterBase hangs when performing an online dump
SF Case 770527

INTB-3753

Restore of PRIMARY tablespace not possible
SF Case 774492

INTB-3752

InterBase crashes on receiving WM_DEVICECHANGE message on Windows
INTB-3746 InterBase 2020 PDF documentation is still 2017 version
INTB-3743 Install launcher on Windows has wrong URL to "Setup Information" and Readme
INTB-3742 IBConsole WISQL data grid font not changing as per Edit | Font selection
SF Case 766570

INTB-3738

Derived table using ROWS key word delivers wrong result set
INTB-3719 InterBase server hangs when connecting to a database file following a failed drop database operation on the same database
SF Case 761090

INTB-3718

Customer reports InterBase crash dump is not getting delivered on server crash
INTB-3716 "partner index description not found" error when foreign key table resides in another tablespace
SF Case 764447

INTB-3713

Server crash on using sample UDF BLOB_LINECOUNT
INTB-3682 Ubuntu: ibmgr could not shutdown ibserver normally
SF Case 670588

INTB-3503

Installanywhere installer configures Guardian service startup to manual
INTB-3417 on Installing InterBase 2017, service name "InterBase XE7 Guardian" is shown on service list
IBP-61

INTB-3323

internal gds software consistency while update onlinedump
INTB-3664 Restoring a database with "inactive" option for indexes fails if the index is used in a PLAN inside a SP/Trigger
InterBase 2020: November 2019, bugs fixed in version 2020.
INTB-3729 Dynamic SQL Error on select Tables in IBConsole
INTB-3722 ISQL Extract for Domain check validation code is case sensitive when checking "Check"
INTB-3714 UDF examples: string manipulation function declaration (udf.sql) and definition (udflib.c) not in sync
INTB-3706 replace_tablespace with just PRIMARY mentioned results in "index unexpectedly deleted" error in GBAK
INTB-3704 GBAK reports "gbak: ERROR: Cannot attach to services manager" when given a long string of command line options
SF Case 761484

INTB-3687

IBConsole cannot run SET Subscription
INTB-3675

SF Case 761090

InterBase server crash on highly active system
INTB-3670 IBConsole fails to extract individual database entity metadata, and gives the whole database metadata
INTB-3658

SF Case 757728

InterBase server reports software consistency check error when accessing a newly created Change View subscription in Dialect 1 with SQL extension IS INSERTED clause
INTB-3648 InterBase server hangs during a sort/merge operation
INTB-3645 SELECT returns "Invalid BLOB id" error
INTB-3644 IBConsole Server-wide Performance Monitoring "Find Attachment" button sometimes finds an attachment from a different database
INTB-3641 Dynamic SQL Error on select Tables in IBConsole
INTB-3636 BLOB performance, temporary memory leak issue.
INTB-3525 JDBC API ResultSet.getObject() truncates text blob data instead of returning whole object.
INTB-3505

SF Case 671345

InterBase crashes during short term recovery if GROUP COMMIT is turned on
INTB-3502

SF Case 667105

InterBase server crash when ending transactions
INTB-3501

SF Case 667114

Continuous return of single row using an index for ORDER BY results in client hang
INTB-3493

SF Case 661894

Stored procedure called in a trigger hangs, when only a single row needs to be returned using an index
INTB-3492

SF Case 661330

Change View subscriptions on tables tracking DELETE may result in duplicate/lost rows during GC
INTB-3484

SF Case 657237

Erroneous select from stored procedure causes server crash
INTB-3258 [IBConsole] Admin.ib Performance Monitoring cause key violation
INTB-3096 IBConsole reports "Abstract Error" when launching Performance Monitor against Dialect 1 database
INTB-2928 [IBConsole] Error when using Find in the Text Viewer window.
INTB-1792 IBConsole cannot display Unicode Blobs

Note: Click here for list of resolved defects prior to InterBase 2020.


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/.