InterBase XE7 Update 7 Readme

From InterBase
Jump to: navigation, search

Go Up to InterBase Readme

Release Date: May, 2017

This release introduces bug fixes. See Resolved Defects for a complete list of bug fixes.

Note: For the most current version of this document, see InterBase XE7 Update 7 Readme.

This Readme covers the following sections:

New Features and Resolved Issues[edit]

InterBase XE7 Update 7:

  • InterBase XE7 Update 7 updated to use OpenSSL version 1.0.2j.
  • Click here for a list of resolved issues.

InterBase XE7 Update 6:

  • Click here for a list of resolved issues.

InterBase XE7 Update 5:

  • Click here for a list of resolved issues.

InterBase XE7 Update 4:

  • Click here for a list of resolved issues.

InterBase XE7 Update 3:

  • Click here for a list of resolved issues.

InterBase XE7 Update 2:

  • Click here for a list of resolved issues.

InterBase XE7 Update 1: Contains the following new features and enhancements to existing features.

  • Click here for a list of resolved issues.

InterBase 2017: Contains the following new features and enhancements to existing features.

  • Click here for a list of resolved issues.
Note: Click Previous Releases for all releases prior to InterBase XE7.

Sandboxing with InterBase ToGo for Mac OS X[edit]

You can sandbox your RAD Studio Delphi/C++ database applications for Mac OS X. See App Sandboxing with InterBase ToGo for Mac OS X for more information about sandboxing of InterBase applications with RAD Studio.


Updated Workflow for ToGo Edition[edit]

This release includes a ToGo Trial Edition that will expire 30 days after registration. See InterBase ToGo Trial Licenses for licensing information.

Change View Updates[edit]

With this release, Change Views now includes the following updates:

DROP SUBSCRIPTION
SQL Extensions
Known Constraints

DROP SUBSCRIPTION[edit]

The ability to drop a subscription was added to Change Views. The syntax for DROP SUBSCRIPTION is:

DROP SUBSCRIPTION <subscription_name> [RESTRICT | CASCADE];

To eliminate interest in observing a set of change views, a subscription must be dropped.

  • If RESTRICT is specified, then a check of existing subscribers is performed.
  • If there are subscribers, then an error is returned without dropping the subscription.
  • If CASCADE is specified, then all subscribers of this subscription are also dropped.
  • If neither RESTRICT nor CASCADE is specified, then RESTRICT is assumed.

SQL Extensions[edit]

InterBase SQL provides support for Change Views with the IS [NOT] {CHANGED | INSERTED | UPDATED | DELETED} clause.

SET SUBSCRIPTION sub_employee_changes ACTIVE;
SELECT EMP_NO, DEPT_NO, SALARY FROM EMPLOYEE WHERE SALARY IS UPDATED;
EMP_NO     DEPT_NO           SALARY
--------   ----------        ----------
109        600               75000

In the example above we see that EMP_NO=37 employee's department reassignment is not returned since he received no compensation adjustment for a lateral move. The IS CHANGED clause will detect the modification of a column due to any kind of SQL operation.

Known Constraints[edit]

  • Starting with InterBase XE7 Update 1, there is a new requirement on FOR EXECUTE STATEMENT to match every item in the SELECT list with a corresponding item in the INTO list.
  • CREATE SUBSCRIPTION syntax is limited to base tables.
  • CREATE SUBSCRIPTION can be applied to tables only by table owner.

IBConsole Updates[edit]

This release includes several significant updates for the IBConsole feature:

Start Here Tab[edit]

A "Start Here" tab opens when IBConsole is accessed. This tab contains a collection of videos, user guides, and tutorials. It also gives you access to the InterBase website that includes an overview, a description of what's new, frequently asked questions, testimonials, and tutorial videos.

IBConsole Database Pane[edit]

The pane located in the bottom left corner lists the most frequently used databases. The pane displays the database alias with a link to connect to that database; the server name; and the date when the database was last accessed.

Change Views Subscription Support[edit]

IBConsole now supports a subscription editor. This subscription returns data that have changed since the prior transaction in which the implicit view was observed. This allows you to see what data has changed since the last time you viewed it.

  • Right click on a database subscription field and click create to gain access to the Subscription Editor dialog. You can enter the name of an existing subscription. The editor lists the tablename; fieldnames; Change; Insert; Update; and Delete details. You can add or delete these details. You can also enter a description of the edited subscription.

What's New in InterBase 2017

Migration Issues for InterBase XE7[edit]

  • It is important to note that older clients (old IBConsole) will surface exceptions when connecting to newer ODS 16 databases since they will encounter data type not defined as INTEGER. The workaround is to install the newer IBConsole and connect with older and newer InterBase servers. The newer IBConsole is backward compatible for this purpose.
  • The InterBase Lock Table size needs to be increased by changing the IBconfig parameter as every entry occupies more room. To increase the InterBase Lock Table size, edit the ibconfig file and change the V4_LOCK_MEM_SIZE entry.
  • InterBase XE7 is released with ODS 16. The new engine only supports ODS >= 13. So with this change, all supported platforms will support the same ODS versions (13 to 16).
  • Some 64bit UDF libraries built with older Visual Studio versions (2005 and earlier) have been reported to not work with InterBase XE7. If you have any old UDF libraries, please do extra testing of these with the new InterBase version. Or, rebuild your UDF 64-bit libraries with the latest Visual Studio versions.
  • The new keyword ROW is "reserved" as a SQL keyword token.

Migration Issues for InterBase XE3[edit]

Windows Registry and Program Files Changes[edit]

InterBase XE3 introduces changes for better Windows compatibility. InterBase XE3 allows default installation of the product under the "Program Files" location and no longer uses the "Borland" subkey in the Windows Registry hierarchy. It now uses the "Embarcadero" subkey to track instance specific information. We strongly advise and encourage you to migrate your applications to the new environment as soon as possible.

  • Program Files Install Location
  • InterBase versions since 2009 installed the product in a different location other than the default Windows location of "Program Files". This was because of Windows UAC guidelines that put restrictions around applications without administrative privilege from writing under the "Program Files" file system folder. InterBase XE3, for server-based editions, now conforms to the Windows Application compatibility guidelines. The default install location has changed from C:\Embarcadero\InterBase to C:\Program Files\Embarcadero\InterBase.
  • Program Data Location
  • InterBase XE3 now delivers the program data files under %ALLUSERSPROFILE%\Embarcadero\InterBase directory. For each individual instance of an install, a folder is created under this and all files requiring write access are delivered here. For example, if you install InterBase XE3 with the defaults and get 'gds_db' instance, your InterBase write location and files include the following:
    • Directory: %ALLUSERSPROFILE%\Embarcadero\InterBase\gds_db
    • Files:
      • admin.ib (this is where you will deliver an older admin.ib file if you are migrating from an older InterBase version)
      • license/ (this is where you will deliver InterBase license files)
      • Examples subfolder structure with all related files
      • OTW SSL related files under "secure" subfolder
      • runtime created files such as interbase.log, *.lck, *.env

Migration Issues for InterBase XE and earlier[edit]

  • Be sure to back-up all databases, including the security database, before uninstalling the previous version.
  • We recommend that you upgrade your InterBase clients to 10.0.0.292 or above if you are targeting a SUSE 11 SP1 (or above) server. There are known problems with older clients waiting for events from a SUSE 11 SP1 server.
  • Back-up the ibconfig file if it has been customized.
  • This version creates new databases with ODS version 15.
  • Please only provide 64-bit UDF libraries for a 64-bit edition, if any, of InterBase. Note that the 64-bit server will not be able to load any 32-bit UDF libraries that you may have. The UDF library that is provided (OOTB, ib_udf) is already built for 64-bit and is installed with the product.
  • InterBase XE increased the number of records that can be stored in a table. The current count has 32-bit limitations. If you want to get a count of the number of record values beyond 32-bit, you need to take the following steps:
    • If a table does have more than 2G rows then the developer must code a CAST(COUNT(*) AS NUMERIC(18,0)) to get a 64-bit count.
  • InterBase XE implemented stronger password protection. If you have older InterBase clients (locally or from remote systems) communicating with this installation, please note the following while upgrading your system to InterBase XE3:
    • If you have an existing user authentication database (from previous InterBase versions), use that database file (copied to the InterBase XE folder) and authentication for local/remote clients will work correctly.
    • If you use the new admin.ib from InterBase XE, note that this database has "SHA-1" strength passwords (by default). If you want to continue using the (weaker) DES password algorithm (previous InterBase releases), use the ALTER DATABASE command referred to in the Stronger Password Protection topic.
    • If you want to use "stronger password length" (provided in InterBase XE), you will need to recreate your user accounts AND install the new InterBase clients in remote machines connecting to this InterBase XE server. This is because the "old" InterBase clients are not capable of computing the "SHA-1" passwords and thus pass in the "DES" strength passwords which in turn do not match what the InterBase XE server expects. This gives you the error "Your user name and password are not defined...".
  • InterBase XE updated SSL parameter names. The old OTW client properties have been replaced by new OTW properties. Please refer to the Operations Guide"Setting up OTW Encryption" and Table 5.2 located in Chapter 5.
Restoring database results in the error "unassigned code"
When restoring a database with InterBase XE, get the error unassigned code. With databases with a long lineage or databases backed up with InterBase 2009 and restored with InterBase XE, each case has different metadata security settings. So when selecting a system table (for example: RDB$RELATIONS) you get the error message: no permission for read/select access to table RDB$RELATIONS by user SYSDBA.
This error occurs with databases which have these criteria:
  • Originally created with a version of InterBase prior to InterBase 6.5.
  • Backed up with a version of InterBase prior to InterBase 2009.
  • Readmeta.sql has not been previously applied.
This behavior is exhibited due to stricter enforcement of meta data rights in InterBase XE during the restore of a database.
Solution
To resolve this problem, execute readmeta.sql against your database before you back it up. readmeta.sql may be found in \examples\security. You can execute readmeta.sql against your database using isql or IBConsole.
Explanation:
The problem occurs with databases that have a long lineage. The two cases are (1) a database has a restore history of IB6->IB7->IB2007->IB2009->IBXE; and (2) a database backed up and restored as IB2009->IBXE. Each case has different metadata security settings. The first instance never had metadata security because it originated from IB6. However with the second instance, it was created (not restored) by IB2009 with a full complement of security privileges for all system tables.
With the first case, the database was backed up and restored and with each succeeding release, the new release would install privileges for the new system tables in that release (think RDB$USERS, RDB$ENCRYPTIONS, RDB$ROLES, etc.). But it could not alter the original system tables because it had no way of knowing if the database owner had already altered their security privileges. For example, a user might have revoked all privileges to RDB$TRIGGERS and RDB$PROCEDURES to conceal their trigger and stored procedure code.
Also, in the first case, a SYSDBA may have run readmeta.sql years ago and refined the metadata from that baseline to a custom security profile. InterBase cannot override that customization by automatically resetting it after the XE restore. InterBase XE cannot assume that every database it restores should unconditionally install the default metadata privileges because it does not know the history of individual databases.
So it is recommended to run readmeta.sql, which sets the default or starting point for configuring it the way you want it. This advice is independent of whether you are migrating to XE.
Example using isql:
isql "path to database"
-USER sysdba -password masterkey -i readmeta.SQL
Executing readmeta.sql with IBConsole
  1. Connect to your database with IBConsole.
  2. Tools | Interactive SQL ...
  3. Query | Load Script, select readmeta.sql, click OK.
Error: No Permission for read/select access to table RDB$XXXX by user SYSDBA
Databases originally created before InterBase 6.5 may have the following error: No permission for read/select access to table RDB$XXXX by user SYSDBA with InterBase XE.
Solution:
InterBase XE enforces tighter meta data security and this error may result from doing meta data operations on databases originally created with versions of InterBase prior to version 6.5. Meta data operations involve requesting information about system objects such as listing system objects or updating them and using the Performance Monitor.
To resolve this error you need to perform two similar operations. The first operation grants rights to system tables. To do so, execute readmeta.sql from the examples\security folder in your InterBase install directory. You can execute readmeta.sql against your database using isql or IBConsole.
Example using isql:
isql "path to database"
-USER sysdba -password masterkey -i readmeta.SQL
Executing readmeta.sql with IBConsole
  1. Connect to your database with IBConsole.
  2. Tools | Interactive SQL ...
  3. Query | Load Script, select readmeta.sql, click OK.
Second, you need to grant rights to system temporary tables if you are going to do performance monitoring. Due to potential security concerns, most installations will want to grant rights for system temporary tables only to sysdba and the database owner, which is what is presented below. If you wish for all users to be able to view system temporary tables, modify this example to GRANT TO PUBLIC. Some installations will want only specific users to have rights, in which case a more customized script may be needed.
To grant rights for system temporary tables, save the following as a text file, then execute it the same as readmeta.sql above.
CREATE PROCEDURE granttmp AS
   DECLARE variable stmt VARCHAR(1024);
   DECLARE variable ownername VARCHAR(66);
   DECLARE variable tablename VARCHAR(66);
 BEGIN
   SELECT rdb$owner_name FROM rdb$relations WHERE rdb$relation_name = 'RDB$RELATIONS'
   INTO :ownername;
For select rdb$relation_name from rdb$relations where rdb$system_flag>0 and rdb$relation_name starts with 'TMP$' into :tablename do begin
stmt = 'grant all on ' || tablename || ' to sysdba';
   EXECUTE statement stmt;
   stmt = 'grant all on ' || tablename || ' to ' || ownername;
   EXECUTE statement stmt;
 END
 END;
 EXECUTE PROCEDURE granttmp;
 DROP PROCEDURE granttemp;
 commit;
 exit;

Known Issues[edit]

  • Change View SQL keywords – The Change View feature adds several reserved keywords which may conflict with SQL objects. The keywords are: CHANGE, CHANGED, INSERTED, UPDATED, and DELETED.
  • It is important to note that older clients (old IBConsole) will surface exceptions when connecting to newer ODS 16 databases since they will encounter data type not defined as INTEGER. The workaround is to install the newer IBConsole and connect with older and newer InterBase servers. The newer IBConsole is backward compatible for this purpose.
  • IBConsole Performance Monitoring provides wrong values for ODS 16, dialect 1 database.
Workaround: There is no workaround for ODS 16 dialect 1. Use dialect 3 database to test IBConsole Performance Monitoring.
  • The 16-bit UNICODE character sets UNICODE_LE and UNICODE_BE only work for Server character sets. These character sets cannot be used as a client character set. If your client needs full UNICODE character support, please use UTF8 instead of UNICODE_LE and UNICODE_BE for the client character set (aka LC_CSET). A client can use the UTF8 (or other native) client character set to connect with a UNICODE database.
  • Windows Error Reporting (WER) dialog pops up intermittently if and when an InterBase server crashes.
Resolution: We are working on fixing any crashes that we are aware of. In the meantime you can disable the Windows Error Reporting dialog from popping up by modifying the Windows Registry thus. Set the registry attribute HKEY_CURRENT_USERS\Software\Microsoft\Windows\Windows Error Reporting\DontShowUI value to 1 to disable. This is as per recommendation of MSDN article http://msdn.microsoft.com/en-us/library/bb513638(VS.85).aspx. We may address this configurable option from within ibserver.exe in future builds by informing WER to disable this only for InterBase server binary.
  • Issue: Hyperthreading: InterBase supports Hyperthreading only on 32-bit Edition on Windows, and on older Intel CPU architectures. It is a known issue that the feature does not work on some of the latest CPU architectures. If your InterBase deployment has licensed less CPU cores than is available on the system, you can customize your installation via the CPU_AFFINITY setting in IBConfig to choose the desired CPU cores for InterBase.

Resolved Defects[edit]

External Defect # Description
(QC)SalesForce #
Internal Defect #
InterBase XE7 Update 7: MAY 2017, bugs fixed in version 12.0.7.
INTB-3287 SELECT COUNT(*) FROM TMP$STATEMENTS conversion error
INTB-3168

Sales Force 536921

InterBase backup hangs at a table with a Change View subscription
INTB-3249

Sales Force 554655

Update 6 and trial installer script for Linux has Windows line endings
INTB-3260 Can not execute License Manager Launcher for InterBase XE7 Linux 64bit
INTB-3262 InterBase XE7 Linux 64bits installer will add duplicate "LD_LIBRARY_PATH" configuration in /etc/profile
INTB-3265

Sales Force 558139

Change View subscription may slow down backup performance
INTB-3287 Transaction Inventory Page cleanup could cause database corruption in extreme case
InterBase XE7 Update 6: May 2016, bugs fixed in version 12.0.6.
INTB-3058 [WISE installer] Installer does not respect provided INSTANCE/TCP_PORT values from properties file when /s option is not provided.
INTB-3044 IBConsole does not show proper value for "Page Buffers" in Database Properties form
INTB-3043

IBP-27

IBConsole Trigger Editor returns error when doing CREATE or ALTER TRIGGER
INTB-3032

Sales Force 501670

Change View Subscription causes columns in a group by to be null
INTB-2971 Database corruption during fast expansion of single table from multiple clients
INTB-2970 Deadlock at database header page when enabling database shadowing
INTB-2909

Sales Force 454420

Back up fails when database contains a change view subscription
INTB-2879 Windows 10 update deletes Files in AppData Directory
InterBase XE7 Update 5: November 2015, bugs fixed in version 12.0.5.
INTB-2539

Sales Force 426384

InterBase becomes unresponsive when many clients run repeated select statements against it.
INTB-2747

Sales Force 444712

Incremental Backup cannot be opened or converted to read_write.
INTB-2751

Sales Force 444712

Deadlock on RDB$PAGES when server is shutdown if database has a distinguished dump.
INTB-2537

Sales Force 415479

Following a database crash, journal recovery is interrupted with error message "WAL writer error"
InterBase XE7 Update 4: July 2015, bugs fixed in version 12.0.4.
INTB-2505 SQL parser throws an exception if comments precede certain DDL commands.
INTB-2503

Sales Force 427872

Query with Subquery and + performs 50 times slower in XE7 than XE3.
INTB-2493 InterBase XE7 crashes when trying to activate an incremental backup file.
INTB-2491

Sales Force 427636

Some queries when run in XE7 are much slower than in XE3.
INTB-2460 'CREATE DATABASE' is always DIALECT 1 with IBConsole SQL Window in InterBase XE7.
INTB-1933

Sales Force 418644

.cg_license.loc does not get deleted on Windows 2012.
InterBase XE7 Update 3: May-2015, Bugs Fixed in 12.0.3 Version.
INTB-2488

Sales Force 425423

InterBase crashes in isc_database_info() via use of info item isc_info_read_seq_count on hundreds of tables.
INTB-2476 Performing repeated incremental backups with continuation files will eventually cause InterBase to hang.
INTB-2473

Sales Force 425187

Index corruption reported at non-leaf level of non-unique index in ODS 16 database.

After installing this update, you can validate your existing XE7 related ODS 16 database with "gfix -v -f -no_update" to find if your database is affected by this corruption. If it is, you will want to either rebuild the specific corrupted index, or, backup and restore the whole database so all indexes are restored/created without any corruption with the new engine.

INTB-2470

QC: 131317

Field Collation setting is not respected when comparing/sorting values with prepared parameters.
INTB-2468 Fetching from a subscribed Change View table followed by a ROLLBACK hangs the database engine.
INTB-2456 Make XE7 Change View SQL keywords unreserved.
INTB-2453

Sales Force 423125

String concatenation operators puts unexpected padding spaces for variable length multi-byte charset CHAR fields.
INTB-2425 Android IBToGo cannot fetch data for record size larger than 32KB.
INTB-2421 IBConsole crashes instead of displaying error from an execute statement stored procedure.
INTB-2363 IBConsole SQL Window parsing problem with CREATE DATABASE with USER/PASSWORD.
InterBase XE7 Update 2: April-2015, Bugs Fixed in 12.0.2 Version.
INTB-2450

QC: 130988

Multiple updates to the same record in a single transaction followed by a ROLLBACK does not restore original data.

During transaction isolation tests it was found that a second or third update to the same record were not saved during a rollback and the subsequent update data was abandoned.

INTB-2391

Sales Force 417992

Querying TMP$Attachments when joined to another persistent table causes AST Deadlock errors.
INTB-2439 Parameterized query with placeholder question mark placed at LHS of IN clause returns error "Data type unknown".
INTB-2432 When Selected Client Only, vcredist_x64.exe and vcredist_x86.exe are not installed.
INTB-2283 It is not possible to an OSX application in an App Sandbox running IBLite/IBToGo.
INTB-2435 Error Status message for new statement contains erroneous text from previous Execute Statement call.
INTB-2426 Server crash when querying Performance Monitoring tables for database attachments that had Execute Statement exceptions inside Stored Procedure calls.
INTB-2428 Change View (INSERT, UPDATE, DELETE) with hundreds of subscriptions cause server crash or hang.
INTB-2419

Sales Force: 417996

Erroneous call to an execute statement stored procedure causes memory leak.
INTB-2424 Cannot see deleted changes with subscription setup after pre-existing records.
INTB-2420

Sales Force 413506

Bug in stored procedure causes server crash.
INTB-2404 When the disk containing journal files runs out of disk space, the active journal file cannot be accessed.
InterBase XE7 Update 1: March-2015, Bugs Fixed in 12.0.1 Version.
INTB-2402 Using deleted subscription name again cause some unexpected state.
INTB-2395 DROP DATABASE request through multi-hop claims "Invalid request handle".
INTB-2393 Infinite loop run by worker thread when executing CREATE INDEX statement against subscribed table.
INTB-2389 The example ibserverd file cannot be run on Linux.
INTB-2386 Request Synchronization error when executing commit with active subscription with subscriber against altered table subscription.
INTB-2381 Stored procedure that uses Execute Statement crashes InterBase when called multiple times.
Important: Starting with InterBase XE7 Update 1, there is a new requirement on FOR EXECUTE STATEMENT to match every item in the SELECT list with a corresponding item in the INTO list.
INTB-2375 Comparing indexed CHAR fields with INTL charset requires padding space also.
Sales Force: 408962,

INTB-2361

InterBase XE7 ibguard.exe does not work on Windows XP/2003.
INTB-2357 Combining group by and casting empty string to CHAR makes crash the Linux server.
INTB-2312 Order by with subscription can report wrong type of change.
Sales Force: 400383

INTB-2224

Error "cannot find tip page" during journal recovery.
INTB-1904 IBEvents not working properly with 64 bit Delphi Application.
InterBase XE7: November-2014, Bugs Fixed in 12.0.0 Version.
INTB-2273 Does not delete instance and port information in services file at uninstall.
INTB-2184 When opening "Local Server" node, IBConsole reports exception "Store RDB$FIELDS failed" with "Attempt to modify database from a read-only transaction".
INTB-2016 New IBConfig parameters from versions XE and XE3 not returned in isc_info_svc_get_config item to isc_service_query() API.
INTB-2005 SPB parameter isc_spb_instance_name is not consumed properly, if provided, for Service API calls.
QC: 120208

INTB-1923

Slow query performance on XE3 as compared to 2007/2009 versions of InterBase.
InterBase XE3 Update 4 Hotfix 2: May-2014, Bugs Fixed in 11.0.4.817 Version.
QC: 124104,

INTB-2026

"Extract files only" fails when InterBase instance is disabled by instreg.
QC: 124527,

INTB-2031

XE3 regression report of 2GB database file size limit on Linux.
INTB-2033 Reduced concurrency throughput of multiple simultaneous reads on same page.
INTB-2035 User SYSDBA cannot view metadata or database properties on non-SYSDBA owned database.
InterBase XE3 Update 4 Hotfix 2: May-2014, Bugs Fixed in 11.0.4.816 Version.
INTB-2020 Performance degrades on some newer Windows 64-bit OS versions when accessing large files (size > available RAM) with sync/async database write mode(s).
INTB-2015 Forced sweep operation returns quickly without advancing OIT, and Perf.Mon. queries are stuck, when OIT <-> OAT gap is very large.
INTB-2003 IBConsole: Cannot type database path when adding local database.
InterBase XE3 Update 4: March-2014, Bugs Fixed in 11.0.4 Version.
Salesforce: 374757,

INTB-1992

SELECT with oversized literal value in WHERE clause and ORDER BY index causes crash.

QC: 122621,

INTB-1984

EXECUTE STATEMENT in stored procedure does not get NULL column value/state.

QC: 122818,

INTB-1983

XE3 takes a long time (20 minutes) to run a query compared to the 2009 version (20 seconds).
Salesforce: 341687,

INTB-1979

InterBase crashes on trying to select rows when another select query is prepared.
INTB-1965 Cannot upgrade a "Client Only" install using IBXE3 Update3 patch installer from IBXE3_Update.exe.

QC: 121770, INTB-1958

SQL Statement with multiple UNIONs crashes server when retrieving PLAN info.
INTB-1942 Performance degradation of multi-level procedure call in InterBase XE3 when compared to InterBase 2009.
INTB-1927 ib_util.dll and ib_util64.dll not included in InterBase ToGo "min" zip files for Windows. This is required for UDF library ib_udf.dll.
INTB-1926 [View Metadata] can't display as SYSDBA. Only a database owner can display it.

QC: 120208, INTB-1923

Slow query performance on XE3 as compared to 2007/2009 versions of InterBase.
INTB-1920 ISQL SET STATS ON output does not include fractional seconds.
INTB-1919 SET PLAN output not redirected to output file.

QC: 119341, INTB-1901

IBConsole uses SERVER login username/password when modifying the EUA database properties.
INTB-1897 IBConsole Performance Monitor truncates TMP$STATEMENTS.TMP$SQL to 1024 bytes in the Statements tab.
INTB-1895 IBConsole: Missing Encryption node when connected as SYSDSO user.
Salesforce: 341530,

INTB-1892

Increased memory usage or possible memory leak reported when migrating VARCHAR data to BLOB via UPDATE statement.
INTB-1889 ODBC: Character sets detection in Embarcadero ODBC driver not working properly.

QC: 111486,

INTB-1824

Character data is truncated in result set for SJIS_0208 column in Embarcadero ODBC driver.

QC: 111118,

INTB-1723

IBConsole shows wrong data when selecting special hidden field RDB$DB_KEY.
INTB-1668 Cannot make local connections to an instance other than "gds_db".
INTB-1525 Creating an index after massive delete and insert operations results in corrupted database.

QC: 106371,

INTB-1468

InterBase crashes updating metadata - database is totally corrupted.
INTB-977 Updated errors in Data Definition Guide.
InterBase XE3 Update 3: August-2013, Bugs Fixed in 11.0.3 Version.

QC: 116299,

INTB-1854

Index is not updated if column is modified by trigger.
INTB-1871 IBConsole is unstable when working with InterBase ToGo.

QC: 116886,

INTB-1862

ODBC driver does not handle meta data names larger than 31 characters.

QC: 116820,

INTB-1859

Access Violation when inserting in a temp table, declared as ON COMMIT DELETE, using a stored procedure.
INTB-1858 isql with SET LIST ON displays garbage data for long field names.

QC: 109214,

INTB-1725

Invalid table Alias use in UNION ALL statement returns no error.
INTB-1772 Pentaho related clash between ResultSetMetaData.getColumnLabel() and getColumnName().
INTB-1773 Invalid transaction reported by PreparedStatement.executeBatch().

QC: 111118,

INTB-1723

IBConsole shows wrong data when selecting special hidden field RDB$DB_KEY.
INTB-1331 Occasional InterBase server hang when multiple clients are very heavily active.
InterBase XE3 Update 2: April-2013, Bugs Fixed in 11.0.2 Version.
INTB-1830 Unlimited user license does not allow more than 4 connections with version 11.0.2.539.
INTB-1820 Maximum user count exceed error occurs when connecting to corrupted database.
INTB-1806 ISQL reports "deadlock" if EXIT is called without COMMIT/ROLLBACK on a global temporary table.
INTB-1784 Querying tmp$triggers against database with concurrent inserts and a journal causes server hang.
INTB-1778 GBAK journal archive recovery, when executed as an InterBase service, does not respect passed-in user credential option values.
INTB-1771 Multihop (two-hop) server connection using SSL in the middle-tier, causes memory leaks in the middle-tier server.
Salesforce: 305183,

INTB-1768

Journal archives prematurely swept, causes archive recovery to fail.
INTB-1766 Aggregated Page I/O performance monitoring data missing for Tables, Procedures, and Triggers.
INTB-1753 OTW parameters meant to reach a middle-tier client in a multi-hop connection does not get there.

QC: 111447,

INTB-1724

Server does not recognize or use DUMMY_PACKET_INTERVAL setting in ibconfig file.

QC: 110482,

INTB-1719

Server crash when defining a COMPUTED BY field with CAST and CASE combination.
INTB-1710 Databases in external SEP condition cannot be backed up or restored using InterBase Services.

QC: 110553,

INTB-1706

IBConsole gives a "cannot attach to service manager" on a lone multi-instance install.
INTB-1694 Server manager with startup mode of Automatic and not running as a service does not start the server.
INTB-1681 Files from security folder from XE not installed.
INTB-1630 Repeated Delete/Rollback results in corrupted database.
INTB-1395 Deadlock reported on Windows local connections (IPC) when using SELECT ...FOR UPDATE statement.
InterBase XE3 Update 1: October-2012, Bugs Fixed in 11.0.1 Version.
INTB-1693 Trying to encrypt a database with AES puts database in an unusable state if "strong encryption" is not licensed (as in Developer Edition).
INTB-1660 XE3 client library cannot connect locally via IPC to XE server.
INTB-1656 InterBase installer on Windows does not install examples database backup files (files are zero size).

QC: 108767,

INTB-1634

ODBC Driver does not work with Microsoft Access 2007 when used against a UTF8 database.
INTB-1628 INSERT after massive DELETE causes Deadlock error.
INTB-1592 Error when trying to do an ORDER BY on a column that is the result of a coalesce expression.
INTB-1521 InterBase clients do not write interbase.log messages in the APPDATA_DIRECTORY folder.
INTB-1455 Corrupted admin.ib through OTW for constant connect/disconnect testing.
INTB-1336 Deadlock error after deleting and re-inserting large numbers of rows.
InterBase XE3: August-2012, Bugs Fixed in 11.0. Version.
INTB-1569 InterBase tools cannot use service name SERVICE_MGR in uppercase form; lowercase "service_mgr" works.
INTB-1566 Calling isc_dsql_batch_execute_immed with 128K+ batch data, causes server CPU loop.
INTB-1524 Database files accessed with different path names on Windows (for example admin.ib) produce server hang.

QC: 106427,

INTB-1467

Database shutdown does not prevent non-SYSDBA users from connecting.
INTB-1464 SQL Optimizer makes an inaccurate estimate of table cardinality for large records.

QC: 7952,

INTB-1462

Release the lock on a file used by an external file after drop table.
INTB-1459 iblockpr fails on Windows. If a .lck file exists, running iblockpr.exe on Windows always resulted in the error: "unable to access lock table - file too small".
Salesforce: 265124,

INTB-1440

SQL Optimizer chooses a less optimal plan in XE as compared to InterBase 2007 when using multiple JOIN conditions.

QC: 106199,

INTB-1431

JIRA Issue INTB-1407 has been resolved but Blob retrieval for large blobs was still a problem. This issue has now been resolved as well.

QC: 105905,

INTB-1410

Incremental database dump fails to report error when target database is in use.

QC: 106199,

INTB-1407

Get an error when inserting a binary file larger than 32kb to a BLOB field. When directly using InterClient classes, the application hangs until it is manually terminated. When using Hibernate on top of it, the interbase.interclient.CommunicationException appears.
INTB-1361 TCS: BUG_8189 causes request synchronization error when executing through IPC connections.

QC: 98872,

INTB-1239

"IB server manager" option appears on the remote Windows server.

Additional Resources[edit]

Embarcadero Technologies Technical Support[edit]

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[edit]

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