Release Notes for InterBase 2020 Update 1

Go Up to Main Page

New Features

Tablespace support for OnlineDump. For more information refer to Physical Database Dump
Updated IBConsole support for Backup, Dump, and Restore operations. For more information refer to Performing Backups and Restores using IBConsole

Other

Linux support for InterBase 2020 Server/Developer Edition.

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

Attempting a Database Dump on ODS 18 databases that contain tablespaces reports a "feature not supported yet" message. Database dumps on InterBase 2020 Update 6 initial release don't support tablespaces yet.

Resolved Defects

External Defect #	Description
(QC)SalesForce #
Internal Defect #
InterBase 2020 Update 6: May 2024, bugs fixed in version 2020 Update 6, build 14.6.0.899
SF Case 01117794 INTB-4397	InterBase Server abnormal termination executing server wide Performance Monitoring on a number of online databases.
SF Case 01112621 INTB-4390	InterBase server abnormal termination on long running COMMIT RETAINING transaction.
SF Case 01111385 INTB-4389	InterBase server hang.
SF Case 01110924 INTB-4388	InterBase server hang running Performance Monitor in AST
SF Case 1111262 INTB-4387	InterBase Server Crash.
INTB-4381	[IBConsole HighDPI] Embedded User Authentication configuration issue.
INTB-4375	Exporting and Importing IBX object format from IBConsole giving errors.
INTB-4367	XSQLVar does not return relation_name for non-aggregate columns when a group by is used.
SF Case 01022599 INTB-4365	In IBConsole, Select stored procedure that performs an update runs in a read only transaction.
SF Case 01021568 INTB-4364	InterBase crashes and hangs.
INTB-4359	How to connect new IBConsole to IBToGo64 full.
INTB-4347	IBConsole Copy Data functionality fails after copying nearly 55 million rows..
SF Case 00976258 INTB-4214	It is not possible to create a database with 64 bit IBConsole when using IBTogo.
SF Case 00944571 INTB-4142	Select stored procedures are slower in InterBase 2020.
SF Case 00944191 INTB-4138	Stream Read Error when importing IBX file.
INTB-4093	Incorrect execution time parameterized query.
SF Case 00884164 INTB-3976	Multithreaded client hangs when using OTW connection
InterBase 2020 Update 5: October 2023, bugs fixed in version 2020 Update 5, build 14.5.0.864
INTB-4328	[IB ODBC] SQLGetTypeInfo returns unsupported type
SF Case 00997126 INTB-4257	IBConsole seems to run select statements in a different transaction.
INTB-4253	On a 64-bit Windows OS, InterBase 64-bit client libraries are not getting installed with a InterBase 32-bit Server Edition installer; ibclient64.dll, ibxml64.dll and ib_util64.dll
INTB-4250	"Transaction is not active" occurs when outputting to a data file with SaveOutput of IBConsle
INTB-4248	InterBase Client errors out during a OTW/SSL connection providing a serverPublicPath if default location for serverPublicFile does not have valid certificate
INTB-4245	ISQL client crashing when displaying SSL error message
INTB-4229	Parameters in UDF calls result in an unknown data type error on prepare.
INTB-4223	GSTAT output "Encoded option" lines under Journal Log items listing
INTB-4219	ISQL status vector warnings not showing when executing DDL
INTB-4218	Corrupted status vector returned when altering a Stored Procedure with DATE data type in a Dialect 1 database
INTB-4216	Secondary file in PRIMARY tablespace not getting created properly in RDB$FILES; backward compatibility broken
SF Case 00976258 INTB-4214	It is not possible to create a database with 64 bit IBConsole when using IBTogo
INTB-4212	TMP$ALLOCATED_PAGES does not reflect changes over time in allocated pages in lingered database
INTB-4211	TMP$ALLOCATED_PAGES does not reflect allocated pages in tablespaces
SF Case 00973062 INTB-4210	InterBase server crash when provided an invalid service ID
SF Case 00971624 INTB-4199	System Global temporary tables contain no records
INTB-4156	During recompile, IBConsole generates wrong alter trigger DDL if trigger name ends in word, create
INTB-3940	Altering size of a DOMAIN of type VARCHAR results in more than expected bytes allocation
INTB-3905	IBConsole database restore service overwrites restored database pagesize different from what is set in the backup file
INTB-3855	Unassigned CODE instead of SQL warning code 301
InterBase 2020 Update 4: December 2022, bugs fixed in version 2020 Update 4, build 14.4.0.804
INTB-4171	IBConsole data modification and export data issues with column names starting with digits
INTB-4170	Access violations when clicking database treeview in IBConsole
INTB-4164	ISQL SHOW DATABASE missing information on SHADOW files with ODS 18
SF Case 00958800 INTB-4162	InterBase 2020 Server crash when canceling a running request
INTB-4125	ISQL extract does not recognize SQL Dialect 1 database global temporary table as such
SF Case 00938128 INTB-4109	InterBase server crash in user table trigger after moving to InterBase 2020 Update 2
SF Case 00944191 INTB-4105	IBConsole Table Data tab doesn't let you modify data
SF Case 00927962 INTB-4077	InterBase 2020 deadlocks and then crashes (Linux)
INTB-4052	InterBase server unresponsive for new connection requests; CPU processor at 100%
SF Case 00897115 INTB-4018	InterBase 2020 is crashing on license reload on Windows 2019
SF Case 00894249 INTB-4002	TMP$POOLS entry goes missing in RDB$RELATIONS leading to corruption report
INTB-3992	New ADO.NET driver does not test for nulls correctly in change views
SF Case 00869064 INTB-3935	IBConsole displays an Access Violation dialog on startup when a VCL style is enabled
SF Case 00799480 INTB-3842	Negative values shown for TMP$DATABASE.TMP$CURRENT_MEMORY
INTB-3835	Can not access EUA database using InterBase 2020 up1 IBconsole
SF Case 00783012 INTB-3771	Performance Monitor cannot deal with external tables
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 IBX files 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 Update 6.
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/.