List of changes for portingset: 
6.1c.07.19


MaintBaanIVc: # 39037 (BDUX30949): NQP: Support multiple company_nr filters and 
company_nr column aliasing

Date: Thu, 17 Apr 2008 17:01:53 +0200 (CEST)

Created on:  MaintBaanIVc
Type:        bugfix

Problem Description (Customer terms)
It is not possible to have multiple company_nr IN predicates in one SQL=
 statement=20
specification. For example, the following statement gives an error:

=09select *
=09from ( select * from dbtst120 where company_nr in ( 100, 200, 300 ) =
) dt
=09where dt.company_nr in ( 100, 200 )

This restriction should be lifted.

Also, it is not possible to rename a renamed company_nr column as "comp=
any_nr".=20
For example, the following statement gives an error:

=09select dt."C001" as company_nr
=09from ( select company_nr as "C001" from dbtst120 ) dt

This restriction should be lifted too.

Affected Executables
bshell
bsql
jbdb

Motive source
ScrumStory:LNCPE-99




MaintBaanIVc: # 38749 (BDUX30696): Bisam problems on 6.1c.07.18

Date: Mon, 17 Mar 2008 16:23:23 +0100 (CET)

Created on:  MaintBaanIVc
Type:        bugfix

Problem Description (Customer terms)
bisam in 6.1c.07.18 (first build) did not work.

Affected Executables
all bisam binaries, but the fix is in bflusher...




MaintBaanIVc: # 38746 (BDUX30757): oracle: wrong hint for delete statements

Date: Mon, 17 Mar 2008 16:21:08 +0100 (CET)

Created on:  MaintBaanIVc
Type:        bugfix

Problem Description (Customer terms)
'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(tdbtst106288$idx1) */ t$int,t$desc,t$Refcntd,t$Refcntu FROM b40c.tdbtst106288 WHERE t$int=:1 FOR UPDATE NOWAIT 
	SQL> DELETE /*+ index(tdbtst106288$idx1) */ FROM b40c.tdbtst106288 WHERE t$int=:1


Affected Executables
ora_srv

Motive source
SDIS:ERP-00000-35541