List of changes for portingset: 8.5a.02



MaintBeethoven: # 42926 (BDNT34468): MSSQL db driver crash when using array 
interface for inserts/deletes.

Date: Mon, 4 May 2009 12:16:16 +0200 (CEST)

Created on:  MaintBeethoven
Type:        bugfix

Problem Description (Customer terms)
When using mssql driver with array interface for inserts/deletes enabled
(msql_array_insert:1), the database driver crashes when running session
tpppc4803m000.


Workaround
N/A

Test Procedure
tpppc4803m000

Affected Executables
msql7_srv.exe

Motive source
SDIS:TECH-00000-04913




MaintBeethoven: # 42915 (BDUX34685): unicode: truncated XML value

Date: Fri, 1 May 2009 09:55:28 +0200 (CEST)

Created on:  MaintBeethoven
Type:        bugfix

Problem Description (Customer terms)
Some string values get truncated in unicode environments

Test Procedure
regression tests

Affected Executables
bshell

Motive source
TCS:800-168472




MaintBeethoven: # 42909 (BDUX34681): ERP-00000-56158: Error 206 (ENOTLOCKED) 
after select for update in child transaction

Date: Wed, 29 Apr 2009 12:35:32 +0200 (CEST)

Created on:  MaintBeethoven
Type:        bugfix

Problem Description (Customer terms)
Error 206 (ENOTLOCKED) is issued when a row is delayed locked and an update (or 
delete) is performed on the same row. The problem goes away when setting the
environment variable BDB_ALWAYS_FLUSH=1.

Workaround
Set environment variable BDB_ALWAYS_FLUSH=1.

Test Procedure
See (internal) regression tests.

Affected Executables
bshell

Motive source
SDIS:ERP-00000-56158




MaintBeethoven: # 42825 (BDUX34593): CDI: Classic QP unable to use customer 
defined index

Date: Thu, 16 Apr 2009 16:37:55 +0200 (CEST)

Created on:  MaintBeethoven
Type:        bugfix

Problem Description (Customer terms)
When the index numbers are non-sequential, the classic QP is (sometimes) unable
to find the index name. For example, when a table contains 13 columns and 8
indices and the index numbers are: 1, 2, 3, 4, 5, 6, 9 and 12, then _index12
cannot be used.

The classic QP is used in a Corelli enviroment, also with the "convergence"
porting set (for instance 8.5a).

Test Procedure
See Problem Description (Technical Terms)

Affected Executables
bshell




MaintBeethoven: # 42774 (BDUX34405): TECH-00000-04936: Inconsistency in handling 
roles by select and insert on shared tables

Date: Tue, 7 Apr 2009 15:59:50 +0200 (CEST)

Created on:  MaintBeethoven
Type:        bugfix

Problem Description (Customer terms)
When company mapping (or sharing) is used and one role grants permission for the
logical company number and another role grants permission for the physical 
company number, then a user that works in the logical company is able to insert
data, but is not able to read back the data. This is not according to the general
principle of roles that when there is write permission then there is also read 
permission.

Workaround
Modify the roles so that the permissions for the physical company number are 
included in the role for the logical company number.

Test Procedure
Define two roles, for example:

	TESTLOGIC
	dbtst120:506:W:empno = 10 or empno = 20 or empno = 30

and:

	TESTPHYS
	dbtst120:000:W:empno = 10 or empno = 50

Define a company mapping, where 506 is mapped to 000.

Execute the query "select * from dbtst120" in company 000. It should return
rows 10 and 50.

Execute the query "select * from dbtst120" in company 506. It should return
row 10 only.

Without this fix the query in 506 would return no rows.

Affected Executables
bshell
bsql
jbdb
all database drivers

Motive source
SDIS:TECH-00000-04936




MaintBeethoven: # 42732 (BDUX34485): Manual merge of BDNT34479 (Rexecd crashes 
on windows on free on invalid address)

Date: Tue, 31 Mar 2009 15:57:59 +0200 (CEST)

Created on:  MaintBeethoven
Type:        bugfix

Problem Description (Customer terms)
Rexecd.exe (a.k.a. logic service) crashes on heavy load




MaintBeethoven: # 42722 (BDUX34465): TECH-00000-05016: Parsing big single-ling 
query (16K+) fails

Date: Mon, 30 Mar 2009 16:13:35 +0200 (CEST)

Created on:  MaintBeethoven
Type:        bugfix

Problem Description (Customer terms)
Parsing a big single-line query of more than 16384 bytes fails with the ODBC/
JDBC solution when the query contains the concatenation operator "||". The owlog
file shows the following message:

	[ERROR] CONN_ID '1'
	      , input buffer overflow, can't enlarge buffer because scanner uses REJECT


Workaround
Spread the statement over multiple lines, which is not an option if the statement is 
generated.

Test Procedure
Write a query with a very long line, that starts with --, such as the following:

	select * , 3--0 | xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx...
	from dbtst100

This query contains a comment both in ANSI mode and in non-ANSI mode. Execute
the query with the following commands:

	bsql6.2 -f <query>

and 

	bsql6.2 -p16 -f <query>

Both runs should result in the same row set.

Affected Executables
bshell
bsql
jbdb (technical component for ODBC/JDBC solution)

Motive source
SDIS:TECH-00000-05016




MaintBeethoven: # 42609 (BDUX34279): ODBC/JDBC: Jbdb crashes on statement 
containing non-ASCII character using multi-byte back end

Date: Sat, 14 Mar 2009 10:19:12 +0100 (CET)

Created on:  MaintBeethoven
Type:        bugfix

Problem Description (Customer terms)
The jbdb.exe component may crash when preparing a statement containing a high-ASCII
character and using a multi-byte back end. When using a single-byte or unicode
back end, there is no problem.

Test Procedure
See Problem Description (Customer Terms)

Affected Executables
jbdb6.2/jbdb.exe

Motive source
SDIS:CPM-00000-00973




MaintBeethoven: # 42599 (BDUX34244): 3GL: assignment of space padded values to 
mb symbols

Date: Fri, 13 Mar 2009 11:18:55 +0100 (CET)

Created on:  MaintBeethoven
Type:        bugfix

Problem Description (Customer terms)
Inconsistent behavior between single byte and other setups when handling fixed string symbols

Test Procedure
regression tests

Affected Executables
bshell




MaintBeethoven: # 42580 (BDUX34323): audit: log changes in ttaud as well, except 
ttaud110

Date: Thu, 12 Mar 2009 15:22:17 +0100 (CET)

Created on:  MaintBeethoven
Type:        bugfix

Problem Description (Customer terms)
Tables in module ttaud are not audited.

Affected Executables
bshell

Motive source
SDIS:SM-00000-06633




MaintBeethoven: # 42546 (BDUX34287): Merge failed.

Date: Fri, 6 Mar 2009 16:10:14 +0100 (CET)

Created on:  MaintBeethoven
Type:        bugfix

Problem Description (Customer terms)
Forgot to run bic_yy_aix.makefile.

Workaround
N/A

Test Procedure
chk -V -t tests_bshell/bic_unary_compile_chk.test

Affected Executables
bic6.x

Motive source
TCS:800-167748




MaintBeethoven: # 42486 (BDUX34181): Bic crashed op X++Y

Date: Wed, 4 Mar 2009 13:03:07 +0100 (CET)

Created on:  MaintStrauss
Type:        bugfix

Problem Description (Customer terms)
When compiling code like x++y bic will coredump.

Workaround
N/A

Test Procedure
See bic_unary_compile_chk.test file.

Affected Executables
bic6.2

Motive source
TCS:800-167748




MaintBeethoven: # 42479 (BDUX34132): XML context shared between bshell processes

Date: Mon, 2 Mar 2009 16:33:42 +0100 (CET)

Created on:  MaintBeethoven
Type:        enhancement

Problem Description (Customer terms)
New 3GL function: function global long  xmlSetContextToProcess(long pid )

This function can be used to modify xml structures 'owned' by another process. 
The 'pid' belonging to the current context is returned, so that the 3GL process can switch back.
Note that processes that use this feature must be designed together to avoid ownership conflicts.

Affected Executables
bshell

Motive source
ScrumStory:LNCPE-195