List of changes for portingset: 6.1c.07.21



MaintBaanIVc: # 41067 (BDUX33035): Jbdb: Erroneous log message: Error during 
sopen(_, _)

Date: Thu, 23 Oct 2008 11:11:27 +0200 (CEST)

Created on:  MaintBaanIVc
Type:        bugfix

Problem Description (Customer terms)
If I use the ODBC/JDBC connectivity, I get the following event message:

	Env        : Bse (C:\Infor\Baan4\bse)
	Program    : jbdb file \general\lib\al_1\al_fpath.c # 195
	Keyword    : sopen
	Username   : baan type:S language:2
	Process    : 2284
	ProcessSet : jslagt@NLBAWCPM1:2284
	Lasterror  : 123 (The filename, directory name, or volume label syntax is incorrect.)
	Errno      : 22 (Invalid argument)
	BdbErrno   : 0
	Message    :  
	Error during sopen(_, _)
 
This event message seems harmless and the connectivity works as expected.


Test Procedure
Run the ODBC/JDBC connectivity and observe that the mentioned event message does
not occur anymore.

Affected Executables
jbdb




MaintBaanIVc: # 40817 (BDUX32812): LNCPE-...: Support REGEXP_LIKE on Oracle10g 
and LOWER function (easy filtering)

Date: Wed, 1 Oct 2008 12:58:33 +0200 (CEST)

Created on:  MaintBaanIVc
Type:        bugfix

Problem Description (Customer terms)
When using "easy filtering" from the WebTop and the search mode is "Case Insensitive"
the performance is far worse than when using the "Case Sensitive" search mode.

Test Procedure
Execute an SQL statement containing a (regexp) like predicate. Observe that:

	- on Oracle 10g the expression is handled by the database;
	- on older Oracle versions the expression is handled by the database driver;
	- on other databases the expression is handled by the database driver.

For example:

	select deptname from dbtst100 
	where deptname like '[^AEIOU].*'
	order by 1

Execute an SQL statement containing the LOWER function. It should work. For
example:

	select empno from dbtst120 where lower(lastname) alike 'haas%'


Affected Executables
bshell
bsql
all database drivers

Motive source
ScrumStory:LNCPE-000




MaintBaanIVc: # 40596 (BDNT32592): BwPrint: /s option with remote HP LJ P1505 
causes crash

Date: Mon, 15 Sep 2008 11:13:10 +0200 (CEST)

Created on:  MaintBaanIVc
Type:        bugfix

Problem Description (Customer terms)
Windows Server Printer with remote HP LJ P1505 printer causes crash in BwPrint

Test Procedure
Start BwPrint with /s option ('silent'; this option is used by Windows Server Printer),
and print to a remote HP LJ P1505 printer driver.

Affected Executables
bwprint

Motive source
SDIS:TECH-00000-04115




MaintBaanIVc: # 40594 (BDUX32551): oracle hint for delete statements

Date: Mon, 15 Sep 2008 11:10:02 +0200 (CEST)

Created on:  MaintBaanIVc
Type:        porting specific change

Problem Description (Customer terms)
Add-on on project BDUX30757 (March 17, 2008)
'simple' oracle queries get index hints with a table alias, but this alias is not defined in the query.

Test Procedure
Old driver (DBSLOG 400)
	SQL> SELECT /*+FIRST_ROWS(1) INDEX_ASC(a tdbtst106288$idx1)*/ a.t$desc,a.t$int FROM b40c.tdbtst106288 a  WHERE (a.t$int >= :1) ORDER BY 2
	SQL> SELECT /*+  index(a tdbtst106288$idx1) */ t$int,t$desc,t$Refcntd,t$Refcntu FROM b40c.tdbtst106288 WHERE t$int=:1 FOR UPDATE NOWAIT 
	SQL> DELETE /*+ index(a tdbtst106288$idx1) */ FROM b40c.tdbtst106288 WHERE t$int=:1

New driver (DBSLOG 400)
	SQL> SELECT /*+FIRST_ROWS(1) INDEX_ASC(a tdbtst106288$idx1)*/ a.t$desc,a.t$int FROM b40c.tdbtst106288 a  WHERE (a.t$int >= :1) ORDER BY 2
	SQL> SELECT /*+  index(a tdbtst106288$idx1) */ t$int,t$desc,t$Refcntd,t$Refcntu FROM b40c.tdbtst106288 a WHERE t$int=:1 FOR UPDATE NOWAIT 
	SQL> DELETE /*+ index(a tdbtst106288$idx1) */ FROM b40c.tdbtst106288 a WHERE t$int=:1

Affected Executables
ora8_srv

Motive source
SDIS:TECH-00000-04252




MaintBaanIVc: # 40512 (BDUX32556): Bshell: SQL select items cannot be bound to 
array elements

Date: Wed, 10 Sep 2008 15:05:53 +0200 (CEST)

Created on:  MaintBaanIVc
Type:        bugfix

Problem Description (Customer terms)
The following construct compiles successfully, but it is not properly executed:

	select firstnme :1, lastname :2
	from dbtst120
	where empno = 10
	selectbind(1,names(1,1))
	selectbind(2,names(1,2))
	selectdo
		ASSERTSEQ( strip$(names(1,1)), "CHRISTINE" )
		ASSERTSEQ( strip$(names(1,2)), "HAAS" )
	selectempty
		ASSERT( 0 )
	endselect

Only one of the array elements is updated, the other remains untouched.

Workaround
Bind to a variable, and in the "selectdo" copy from the variable to the array
element.

Test Procedure
Write a construct such as in the Problem Description (Customer terms) and observe
that the array elements are properly filled.

Affected Executables
bshell

Motive source
TCS:800-166525




MaintBaanIVc: # 40491 (BDUX32510): SQL: Support generic value expressions as 
LIKE pattern

Date: Tue, 9 Sep 2008 15:02:03 +0200 (CEST)

Created on:  MaintStrauss
Type:        bugfix

Problem Description (Customer terms)
The following SQL statement (ANSI dialect) is not accepted by the SQL processor:

	select distinct "tfgld008"."leac" "n_9569"  
	from "tfgld008" "tfgld008" 
	where "tfgld008"."company_nr" in (519) 
		and lower ("tfgld008"."leac") like lower ('10') || '%' 
	order by 1 asc 

It replies with the following error message:

	Unexpected token 'lower', SQLState='42I00', VendorCode=302


Workaround
Try to rewrite the query so that the pattern of the LIKE predicate is either a 
string literal or a parameter.

Test Procedure
Execute an SQL statement such as in the Problem Description (Customer terms).

Affected Executables
bsql
bshell
jbdb (the component used by the ODBC/JDBC integrations, aka the DB Connector)




MaintBaanIVc: # 40446 (BDUX32499): change dump limit bdbpre

Date: Thu, 4 Sep 2008 12:56:15 +0200 (CEST)

Created on:  MaintBaanIVc
Type:        bugfix

Problem Description (Customer terms)
Hi, we are using the session copy data tccom0214m000 to rename the companies within files created by a database export.  We have noticed that when it is ran against very large files, i.e. split over two or three .S files then the first file is deleted and lost.  

Workaround
use smaller files or the cp action of the OS

Test Procedure
create a file of 2147483647 bytes large and do a file.cp

Affected Executables
bshell

Motive source
SDIS:erp-00000-44334




MaintBaanIVc: # 40391 (BDNT32441): Disabled/removed microsoft JDK enabled 
products

Date: Fri, 29 Aug 2008 14:20:20 +0200 (CEST)

Created on:  MaintBaanIVc
Type:        porting specific change

Problem Description (Customer terms)
Existance of MS JVM support by bshell.

Workaround
Move to SUN JRE.




MaintBaanIVc: # 40092 (BDUX32143): retry_delay does not work

Date: Tue, 22 Jul 2008 15:38:10 +0200 (CEST)

Created on:  MaintBaanIVc
Type:        bugfix

Problem Description (Customer terms)
retry_delay does not work.

Affected Executables
bshell




MaintBaanIVc: # 39958 (BDUX31969): SQL: Crash on nested derived tables with 
select distinct

Date: Wed, 9 Jul 2008 16:49:08 +0200 (CEST)

Created on:  MaintStrauss
Type:        bugfix

Problem Description (Customer terms)
The following query results in a crash of the database client (jbdb, bshell, bsql),
or in a crash of the database driver:

	select "WarehouseCurrencies20"."HomeCurrency2" "C0"  
	from (
			  select distinct 
						 "tcmcs00318"."cwar" "Warehouse" , 
						 "tcmcs00318"."dsca" "Warehouse_Description" , 
						 "tcemm17019"."fcua" "HomeCurrency1" , 
						 "tcemm17019"."fcub" "HomeCurrency2" , 
						 "tcemm17019"."fcuc" "HomeCurrency3"
			  from (
						 select 
									"tcmcs003"."cwar" "cwar" , 
									"tcmcs003"."dsca" "dsca" , 
									"tcmcs003"."comp" "comp" , 
									"tcmcs003"."company_nr" "company_nr"  
						 from "tcmcs003" "tcmcs003" 
						 where "tcmcs003"."company_nr" in (590)
			       ) "tcmcs00318"
			       , 
			       (
						 select 
									"tcemm170"."comp" "comp" , 
									"tcemm170"."fcua" "fcua" , 
									"tcemm170"."fcub" "fcub" , 
									"tcemm170"."fcuc" "fcuc" , 
									"tcemm170"."company_nr" "company_nr"  
						 from "tcemm170" "tcemm170"
						 where "tcemm170"."company_nr" in (590)
			       ) "tcemm17019" 
			  where "tcmcs00318"."cwar" in ('WHMUFS') 
			  and "tcmcs00318"."comp" = "tcemm17019"."comp" 
			  and "tcmcs00318"."company_nr" = "tcemm17019"."company_nr"
	) "WarehouseCurrencies20"
 
The following characteristics are required:

	- nested derived tables;
	- the outermost select clause does not select all columns from the contained 
	  derived tables;
	- a derived table specifies the "distinct" keyword in the select clause, and
	  selects columns from another derived table.

Test Procedure
Execute a query such as above, or a query that resembles the following:

	select "Sex"
	from (
		select distinct
			"dbtst120"."sex" "Sex"
			, "dbtst120"."workdept" "WorkDept"
		from (
			select 
				"dbtst120"."sex"
				, "dbtst120"."workdept" "workdept"
			from "dbtst120" "dbtst120"
		) "dbtst120"
	) "dbtst120"

Affected Executables
bshell
bsql
jbdb
all database drivers




MaintBaanIVc: # 39821 (BDUX31861): Oracle 11 support

Date: Thu, 26 Jun 2008 09:16:17 +0200 (CEST)

Created on:  MaintBaanIVc
Type:        porting specific change

Problem Description (Customer terms)
Oracle 11 support

Test Procedure
Regression tests

Affected Executables
ora8_srv
ora8_inst

Motive source
ScrumStory:LNPLA-172




MaintBaanIVc: # 39589 (BDUX31617): SQL: Error 312 (Invalid parameter type) on 
multi-company join

Date: Mon, 2 Jun 2008 16:53:10 +0200 (CEST)

Created on:  DevStrauss
Type:        bugfix

Problem Description (Customer terms)
The following query:

	SELECT    tirou001.cwoc, tirou001.dsca, tirou001.nomc, tirou001.noop, tirou001.crmp, tirou001.ccap,          
						  tcemm124.grid :dgrid, tcmcs065.ccal :deccal, tgbrg030.ccal :euccal   
	FROM       tirou001 join tcemm124 on tcemm124._index1 = {198, tctypd.workcentre, tirou001.cwoc}   
						  join tcmcs065 on tcmcs065._index1 = {tirou001.cwoc}   
						  left join tgbrg000 on 1=1   
						  left join tgbrg035 on (tgbrg035._compnr = tgbrg000.comp AND 1=1)   
						  left join tgbrg030 on (tgbrg030._compnr = tgbrg000.comp AND tgbrg030._index1 = {tgbrg035.motp, tgbrg035.erfm, tgbrg035.vers, tcemm124.grid})  
	WHERE     tirou001._index1 INRANGE {""}  AND {"ZZZZZZZZZZZZZ"}  AND 
						  tirou001.kowc INRANGE tckowc.main.wc    AND 
						  tckowc.subcontracting     AND 
						  tgbrg035.motp = tgbrg.mdtp.project.model  AND 
						  tirou001.stty = tirou.stty.not.appl

result in the error:

	SqlState=QP010, 'SQL: Invalid parameter type', NativeError=312


Test Procedure
Execute the query in the Problem Description (Customer Terms). The query should 
run without problems.

Affected Executables
bshell
bsql
jbdb