Hello!
We are trying to execute following query:
select o.org,d.dog,s.stran ,count(*) as cnt ,sum(dlitrazg/60) as
sum_dlitrazg ,sum(smr) as sum_smr
from ( select vlog.*,replace(nomer,'','') as nmb
from vlog where '2004-06-01'<=bymd and
bymd<='2004-06-30' and ltrim(nomer) like '810%' ) as l
,strang s
,vdog d ,org o ,vlog_strang as vkskml
where l.nmb like s.kod&'%' and d.kod=l.vdog_kod and o.kod=d.org_kod and vkskml.kod=l.kod and
vkskml.strang_kod_max_length=length(s.kod)
group by o.org,d.dog,s.stran
order by count(*) desc,o.org,d.dog,s.stran
And vlog_strans is view:
CREATE VIEW "VLOG_STRANG"
(
"KOD",
"STRANG_KOD_MAX_LENGTH"
)
AS SELECT VLOG.KOD,MAX(LENGTH(STRANG.KOD)) AS STRANG_KOD_MAX_LENGTH FROM
VLOG,STRANG WHERE NOMER LIKE '810%' AND REPLACE(NOMER,' ','') LIKE STRANG.KOD || '%' GROUP BY VLOG.KOD
We get following error:
General error;-9206 POS(1) System error: AK Duplicate catalog information:FF00005F0000030100B100.
This problem is not specific for 7.0.5.16, it also exists in 7.3...
Any ideas?
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
