We have found a very strange behaviour in maxdb 7.5.0.18 while using it in Oracle mode
If we issue this query
SELECT
chres.e_hum_res_k_human_resource FROM COMPANY_HUMAN_RESOURCE chres
inner join COMPANY comp on (chres.E_COMPANY_K_COMPANY=comp.K_COMPANY)
inner join COMPANY_NAME compName on (comp.K_COMPANY=compName.E_COMPANY_K_COMPANY)
WHERE
chres.E_COMPANY_K_COMPANY=500 AND
chres.E_HUM_RES_K_HUMAN_RESOURCE=1000 AND
chres.D_START=to_date('15/11/2002','dd/mm/yyyy')
The data are set so that a record come out. Fine
if we put the last condition as the first condition
SELECT
chres.e_hum_res_k_human_resource FROM COMPANY_HUMAN_RESOURCE chres
inner join COMPANY comp on (chres.E_COMPANY_K_COMPANY=comp.K_COMPANY)
inner join COMPANY_NAME compName on (comp.K_COMPANY=compName.E_COMPANY_K_COMPANY)
WHERE
chres.D_START=to_date('15/11/2002','dd/mm/yyyy') AND
chres.E_COMPANY_K_COMPANY=500 AND
chres.E_HUM_RES_K_HUMAN_RESOURCE=1000
NO DATA CAME OUT!!
In this situation if we extract another column (comp.k_company) instead of the previous one the data again come out again...
Unfortunately we cannot reproduce the problem because
we have created a second user on the same db (to provide it for bug reproduction)
exporting and reimporting the data with loadercli but in the second db
everything works correctly!
Any idea of what may cause this very very strange behaviour for a database?
Thanks in advance
--
____________________________________________________________
Stefano Ghezzi ICTeam S.p.A
tel 035 4232129 fax 035 4522034
email [EMAIL PROTECTED] url http://www.icteam.com
mobile 335 7308587 ....if you want to reach me online look at...
skype://stefanoghezzi yahoo://stefanoghezzzi
msn://[EMAIL PROTECTED] aim://stefanoghezzzi
____________________________________________________________
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
