List of changes for portingset: 9.0b.01 ------------------------------------------------------------------------ Elgar: # 66587 (BDUX60533): installer: do not automatically enable row versioning Date: Mon, 03 Aug 2015 13:09:10 +0200 Created on: Elgar Type: bugfix _Problem Description (Customer terms)_ Full installs using the 9.0b porting set automatically set the bdb_use_row_version:1 resource. This resource influences the delayed locking mechanism. Older application versions (before LN 10.4) make wrong assumptions about the layout of the record buffers, causing problems in combination with row versioning, DBCM or record timestamps. As row versioning is enabled for all tables, it is much more sensitive to application bugs than the other features. To avoid problems, the 9.0b.01 porting set will not automatically set bdb_use_row_version:1 anymore. At a later point in time we will enable row versioning for LN 10.4 and higher again. _Workaround_ For full installs using the 9.0b porting set that install application versions up to LN 10.3.x 1. Install the porting set only. 2. Modify $BSE/lib/default/db_resource file: Disable/delete bdb_use_row_version resource. 3. Continue the installation of the Tools & Apps _Test Procedure_ full install and verify that $BSE/lib/defaults/db_resource does not contain bdb_use_row_version:1, except for EDB. _Affected Executables_ installer ------------------------------------------------------------------------ Elgar: # 66531 (BDUX60466): Bshell: Crash on subquery in SELECT clause returning NULL values Date: Tue, 28 Jul 2015 16:15:17 +0200 Created on: Elgar Type: bugfix _Problem Description (Customer terms)_ If the SELECT clause of a SELECT statement contains a subquery, and the subquery results in a NULL value on a string column, then the bshell may crash. _Test Procedure_ Write a small 3GL program with a query such as the following. Verify that it runs without problems: function main() { string max_s(20) select ( select max(strcol) from table where 1=0 ):max_s from table selectdo endselect } The program should return empty string in the variable max_s. _Affected Executables_ bshell ------------------------------------------------------------------------ Elgar: # 66495 (BDUX60435): Oracle 12.1.0.2: create index with advanced compression gives unexpected error Date: Mon, 27 Jul 2015 13:57:25 +0200 Created on: Elgar Type: bugfix _Problem Description (Customer terms)_ Oracle 12.1.0.2 with index compression gives ORA-25195 (bdberrno 26195) on MLE shadow tables. _Test Procedure_ Regression tests on Oracle 12.1.0.2 or later _Affected Executables_ ora_srv ------------------------------------------------------------------------ Elgar: # 66440 (BDUX60210): Sensitivity Label Not Working for Specific Company. Date: Tue, 21 Jul 2015 15:13:54 +0200 Created on: Eyck Type: bugfix _Problem Description (Customer terms)_ Sensitivity labeling not working for extended company numbers. _Workaround_ N/A _Test Procedure_ ed test script "chk_extended_comp_sensitivity.test" _Affected Executables_ Bshell _Motive source_ InforXtreme:506510 ------------------------------------------------------------------------ Elgar: # 66354 (BDUX60135): D508448: Running Create Tables for a large range of companies takes hours (and get slower and slower) Date: Thu, 09 Jul 2015 15:50:49 +0200 Created on: Elgar Type: bugfix _Problem Description (Customer terms)_ Running Create Tables or Check Tables for a large range of companies takes hours, and it becomes dramatically slower. _Workaround_ Only check a few companies at a time, and restart the bshell after each check. Alternatively, set up a few batch jobs for this task. Each job must be handled by a fresh bshell. _Test Procedure_ Run the Create Tables and Check Tables sessions for a large number of companies. Observe that the processes keep their pace. _Affected Executables_ bshell all database drivers _Motive source_ InforXtreme:508448 ------------------------------------------------------------------------ Elgar: # 66346 (BDUX60080): Change Bshell trace destination directory in multi-tenant cloud Date: Thu, 09 Jul 2015 07:49:04 +0200 Created on: Eyck Type: bugfix _Problem Description (Customer terms)_ bshell trace files in tenant mode should appear in $BSE/log and not in $BSE/tmp any more Also hostnames should not appear when %h is specified _Affected Executables_ bshell6.2 _Motive source_ JIRA:LND2-4151 JIRA:LND2-4554 ------------------------------------------------------------------------ Elgar: # 66313 (BDUX60081): Made combo-driver buffer dynamic Date: Fri, 03 Jul 2015 14:02:43 +0200 Created on: Elgar Type: porting specific change _Problem Description (Customer terms)_ Combo driver raises: Buffer overflow in combined Bshell/driver _Workaround_ use db.flush() or db.commit() more often. The db.flush() does not affect the transaction but just pushes the transaction buffer from the client (bshell) to the database driver and results in a fresh/cleaned up buffer. _Test Procedure_ Transactions in the combo driver are now not limited to a fixed size (1024*4kB) but to the system imposed (memory allocation) limits. _Affected Executables_ bshell and all other database clients. ------------------------------------------------------------------------ Elgar: # 66276 (BDNT60045): String compare in unicode Date: Tue, 30 Jun 2015 14:44:17 +0200 Created on: Elgar Type: bugfix _Problem Description (Customer terms)_ Compare Issue wth string variables. When doing a compare of 2 strings: string1 < string2 and the stings have values like 01E020268 and 01 then the result is other then expected. when setting a trim function around the strings it's working fine. _Workaround_ set a trim around the string, or declare these as fixed. _Test Procedure_ test with below kind of script. #string compare not working CONFIG include unicode.config /CONFIG BAAN3GL function main() { long ret, ret2 string strabc(3) string strab(3) strabc = "23a" strab = "23" ret = 2 if strabc < strab then ret = 0 endif if trim$(strabc) < trim$(strab) then ret = 1 endif ASSERTSEQ(ret, 2) } /BAAN3GL _Affected Executables_ bshell ------------------------------------------------------------------------ Elgar: # 66234 (BDUX60077): D508448: Running Create Tables for a large range of companies takes hours Date: Fri, 26 Jun 2015 15:30:20 +0200 Created on: Elgar Type: bugfix _Problem Description (Customer terms)_ Using the session Create Tables to create all tables in a number of companies takes too much time, and the process gets slower and slower. The effect is observable from the 2nd company. When more than 10 companies are processed, it becomes evident. _Test Procedure_ Use the Create Tables session to create all tables in a number of companies. The process should keep going at more or less the same rate. _Affected Executables_ All database drivers _Motive source_ DF:508448 ------------------------------------------------------------------------ Elgar: # 66216 (BDUX59908): bshcmd does not work correctly with combo driver Date: Thu, 25 Jun 2015 13:45:07 +0200 Created on: Elgar Type: bugfix _Problem Description (Customer terms)_ bshcmd doesn't work on combo drivers _Affected Executables_ bshell, db drivers, bshcmd _Motive source_ JIRA:LND2-3254 ------------------------------------------------------------------------ Elgar: # 66180 (BDUX59996): Installer: Installation of BaanIV/Corelli fails (row versioning is not supported) Date: Fri, 19 Jun 2015 15:17:52 +0200 Created on: Elgar Type: bugfix _Problem Description (Customer terms)_ The installation of BaanIV and Corelli fails with the 9.0b porting set. During the installation the following resource is set in the $BSE/lib/defaults/db_resource file: bdb_use_row_version:1 The IVc and Corelli Tools do not support row versioning. _Workaround_ The following work-around can be used: * install the porting set only. * remove the "bdb_use_row_version:1" line from the db_resource filel. * continue the installation. _Test Procedure_ Install IVc or Corelli. The installation should succeed. Verify that the $BSE/lib/defaults/db_resource file does *not* have the following line: bdb_use_row_version:1 Install LN and verify that the $BSE/lib/defaults/db_resource file contains the line above. _Affected Executables_ ora8_adm db2v5_adm msql_adm ------------------------------------------------------------------------ Elgar: # 66076 (BDUX59767): SQL: SELECT MAX( ) gives bad performance Date: Fri, 12 Jun 2015 09:53:04 +0200 Created on: Elgar Type: enhancement _Problem Description (Customer terms)_ A SQL statement that contains a set function specification (aggregate) on an element of an array column is not handled by the database. The database driver evaluates the grouping, which may result in a severe performance penalty. _Test Procedure_ Set DBSLOG=400 and use bsql to execute a query as the following: select max(phoneno(1)) from dbtst120 Observe that the statement sent to the database contains the MAX() expression. _Affected Executables_ All database drivers ------------------------------------------------------------------------ Elgar: # 66032 (BDNT59845): Relaxed behavior for snap-in Date: Mon, 08 Jun 2015 16:45:01 +0200 Created on: Elgar Type: bugfix _Problem Description (Customer terms)_ Added ASM 1.9.1 and prior versions backward compatibility. _Workaround_ NA. ------------------------------------------------------------------------ Elgar: # 65958 (BDUX59738): handle.report.pool.string.scan returns incorrect field count Date: Wed, 03 Jun 2015 15:20:20 +0200 Created on: Elgar Type: bugfix _Problem Description (Customer terms)_ Message: Error in sort nr fields scanned ... expected ... _Affected Executables_ bshell6.2 _Motive source_ TCS:800-204392 ------------------------------------------------------------------------ Elgar: # 65928 (BDNT59748): BaanIV username cannot contain high ascii chars anymore. Date: Tue, 02 Jun 2015 14:53:48 +0200 Created on: Elgar Type: bugfix _Problem Description (Customer terms)_ Convergence problem. BaanIV username cannot contain high ascii chars anymore. _Workaround_ N/A _Test Procedure_ Create username that contains a high ascii char. _Motive source_ InforXtreme:485452 ------------------------------------------------------------------------