Resolved Defects

From InterBase

Go Up to Main Page


External Defect # Description
(QC)SalesForce #
Internal Defect #
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 5.
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
  • Click here for a list of resolved defects in InterBase 2017.
  • Click here for a list of resolved defects in InterBase XE7.
  • Click here for a list of resolved defects in InterBase XE3.