F.mangiacrapa wrote: > > Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed > Column not found;-4005 POS(668) Unknown column name:S_ANCHOR > > > Why this error, when execute query????? > How can I fix this problem? > > > Declare c cursor for > With recursive px (A_ANNOTATIONID, S_ANCHOR, E_ANCHOR, found) as > ( > select A.annotationid, A.start, A.end, decode (A.VALUE, 'ih', 'YES', 'NO') > From (select annotation.annotationid, start, end, value > from annotation inner join feauture on > annotation.annotationid=feauture.annotationid > where feauture.value='hv' and type='phn') AS A, > > (select annotation.annotationid, start, end > from annotation inner join feauture on > annotation.annotationid=feauture.annotationid > where feauture.value='dcl' and type='phn') AS B > where A.end=B.start > > union all > > select annotation.annotationid, s_anchor, end, decode (VALUE, > 'ih', 'YES', 'NO') > from px, annotation inner join feauture on > annotation.annotationid=feauture.annotationid > where e_anchor = annotation.start > and type='phn' and annotation.start <= (select start from annotation inner > join feauture on annotation.annotationid=feauture.annotationid where > value='dcl') > ) > > select annotation.annotationid, found > from annotation inner join px on annotation.annotationid=a_annotationid > inner join feauture on > annotation.annotationid=feauture.annotationid > >
Just now I do not know the reason for the problem. I will check. But to overcome the problem you should change the beginning of the statement like this: WITH RECURSIVE PX (A_ANNOTATIONID, S_ANCHOR, E_ANCHOR, FOUND) AS ( SELECT A.ANNOTATIONID A_ANNOTATIONID, A.START S_ANCHOR, A."end" E_ANCHOR, DECODE (A."value", 'ih', 'YES', 'NO') FOUND .... Elke SAP Labs Berlin > > > many thanks, > > Francesco > > > > > > > > > > > > > > > > > > > > > > > > > > > > How can I fix this problem? > > > -- > Email.it, the professional e-mail, gratis per te: http://www.email.it/f > > Sponsor: > Hai dei virus sul tuo PC ma non sai come eliminarli? Allora impara subito > come rimuovere ogni tipo di virus - clicca qui > Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=3211&d=20060223 > > > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
