List of changes for portingset: 9.3d

------------------------------------------------------------------------


        Mussorgsky: # 80598 (BDUX76884): D693762: QP: Select over
        distributed tables gives wrong result if NULLs are involved


          Date: Thu, 01 Aug 2019 09:46:37 +0200

Created on:  Lalo
Type:        bugfix


_Problem Description (Customer terms)_
In a multi DB environment, REFERS TO clause is not working correctly when one
of the table is present in different database. BSQL6.2 behavior is correct but
QPTOOL output and 3GL program output is wrong.

For example
In table tcibd001 has two items and tdipu001 has only one item.
For the above data set executing the below 3GL, the expected result should not
have any data for tcmcs044.dsca for the second record set... as the refers to
via tdipu001 will not be available. However, when one of the table is present
in a different database (In the below tcmcs061) then the tcmcs044.dsca of the
first item is carried forward even for the second record set. This behavior
need to be fixed.

function main()
{
	domain	tcitem	item.f
	domain	tcitem	item.t

	item.f = "         SRWH-1102495"
	item.t = "         SRWH-1102496"

	select	tcibd001.item
	, tdipu001.item
	, tdipu001.csgp
	, tcibd001.cpln
	, tcmcs044.dsca
	, tcmcs061.dsca
	from	tcibd001
	, tdipu001
	, tcmcs044
	, tcmcs061
	where	tcibd001._index1 inrange {:item.f} and {:item.t}
	and		tcibd001.item refers to tdipu001 unref clear
	and		tdipu001.csgp refers to tcmcs044 unref clear
	and		tcibd001.cpln refers to tcmcs061 unref clear
	selectdo
		message("test")
	endselect 
}



_Test Procedure_
See Problem Description (Customer Terms)

A regression test has been added.

_Affected Executables_
bshell
qptool
database drivers

------------------------------------------------------------------------


        Mussorgsky: # 80492 (BDNT76723): corrupt data dictionary after
        enabling workflows for companies without existing tables.


          Date: Fri, 19 Jul 2019 09:24:41 +0200

Created on:  Lalo
Type:        bugfix


_Problem Description (Customer terms)_
Corrupt data dictionary after enabling workflows for companies without existing tables. bdbreconfig returns error when table does not exist.
Causing session to give error on the total action, leaving the dd in a corrupt state.

_Workaround_
create all tables before doing the convert.

_Test Procedure_
enable workflow for some tables that do not exist in at least one company

_Affected Executables_
bdbreconfig

_Motive source_
InforXtreme:615622

------------------------------------------------------------------------


        Mussorgsky: # 80265 (BDUX76467): D685655: EAMS rules not working
        correctly for Russian range


          Date: Thu, 13 Jun 2019 17:29:23 +0200

Created on:  Lalo
Type:        bugfix


_Problem Description (Customer terms)_
eAMS conditional format for Russian range gives wrong results

_Test Procedure_
In eAMS define a conditional permission on a table field. Use an international
character in the expression.

_Affected Executables_
bshell

_Motive source_
InforXtreme:685655

------------------------------------------------------------------------


        Mussorgsky: # 80157 (BDNT76355): introduce CLOUD_TYPE env var to
        reduce startup time


          Date: Thu, 23 May 2019 15:08:40 +0200

Created on:  Mussorgsky
Type:        bugfix


_Problem Description (Customer terms)_
Initial startup time can be reduced in the Cloud

_Test Procedure_
see Regtests

_Affected Executables_
all

_Motive source_
JIRA:LND2-26678

------------------------------------------------------------------------


        Mussorgsky: # 80111 (BDNT76209): DF683286: MT Cloud, bshell
        crashes with options database actions and bshell messages enabled.


          Date: Thu, 16 May 2019 13:34:36 +0200

Created on:  Lalo
Type:        bugfix


_Problem Description (Customer terms)_
When debugging/tracing the bshell, the bshell will crash when:
- "Internal SQL Functions" is traced
- Option "Bshell messages to trace" is enabled
- A unicode character is read from the database

When Option "Bshell messages to trace" is NOT enabled, then the bshell will not crash, but a TSS error is returned for each string with unicode characters that is read from the database.

_Workaround_
Don't use the trace options combined. 

_Test Procedure_
Run the trace with multi byte karakters.

_Affected Executables_
bshell

_Motive source_
InforXtreme:683286

------------------------------------------------------------------------


        Mussorgsky: # 80056 (BDUX76229): BV2.0: Bshell, bdbpost -A:
        Insert results in staged row even if insert is skipped due to
        duplicate


          Date: Thu, 09 May 2019 16:04:31 +0200

Created on:  Lalo
Type:        bugfix


_Problem Description (Customer terms)_
When creating a table from a sequential dump, while the "Append if Table Exists" option
is ticked, all the rows from the dump are staged, and published, not only the inserted
rows.

Only the inserted rows must be staged and published. Rows that are skipped because they
already exist in the table must not be staged/published.


_Test Procedure_
See Problem Description (Customer terms)

A regression test has been added.

_Affected Executables_
bshell
bdbpost

------------------------------------------------------------------------


        Mussorgsky: # 80016 (BDNT76181): DF676738: assignment between
        record buffers not possible on B40c


          Date: Mon, 06 May 2019 13:39:23 +0200

Created on:  Lalo
Type:        bugfix


_Problem Description (Customer terms)_
Assignment between 2 record buffers with different sizes is not working anymore after migration to 9.x portingset.

_Workaround_
Keep sizes of record buffers the same

_Test Procedure_
Have 2 tables with different amount of fields, and assign the smaller record buffer to the larger record buffer.

_Affected Executables_
bshell

_Motive source_
InforXtreme:676738

------------------------------------------------------------------------


        Mussorgsky: # 79981 (BDUX76167): D682012: Corelli: Bshell crash
        while running a query with index hint with tables stored in
        multiple databases


          Date: Wed, 01 May 2019 15:53:37 +0200

Created on:  Mussorgsky
Type:        bugfix


_Problem Description (Customer terms)_
The bshell crashes on a query that spans two databases, and contains index hints on some
of the tables, but not all.

This problem only occurs in IVc and Corelli mode.

_Workaround_
Add an index hint on the tables that are missing hints.

_Test Procedure_
Customer (Flex) supplied the following information:

	tabledef6.2:
	*:209:oracle8(ORACLE_SERVICE_NAME=HP1ORA12):N
	*:*:oracle8(ORACLE_SID=RH2ERPLN):N

	compnr6.2:
	tccom130:209:212

	User's company is 212.
	When the following program is run, bshell dies.

	table ttccom100, ttccom130
	function main()
	{
		select tccom130.*, tccom100.*
		from tccom130, tccom100
		where
		tccom130._index1 = {tccom100.cadr}
		hint use index 1 on tccom130
		selectdo
			message("hi")
		selectempty
		endselect
	}



_Affected Executables_
Bshell

_Motive source_
InforXtreme:682012