Re: repeatable signal 11 on update query

Hi,

Am Montag, 24. Januar 2005 10:05 schrieb Zabach, Elke:
> > Am Dienstag, 5. Oktober 2004 11:00 schrieb Stephan Fudeus:
> > > I found a repeatable segmentation violation when executing the
> > > following query:
> > > update value_rvk_subject vrs
> > > set docfreq=(select count(*) from lr_subject lrs,(select lridref,
> > > published from mb_lrmaintain) lrm where lrs.subjectidref=vrs.vid and
> > > lrm.published=1 and lrm.lridref=lrs.resourceidref).
>
> May I ask for the table/view definitions and the definitions of
> referential constraints value_rvk_subject is part of?


Sure, this is the table-definition:

CREATE TABLE value_rvk_subject
(
  vID           NUMERIC(15,0),
  parent        NUMERIC(15,0),
  docfreq       INTEGER,
  myvalue       VARCHAR(255),

  PRIMARY KEY(vID),
  FOREIGN KEY(vID)    REFERENCES value_subject(vID),
  FOREIGN KEY(parent) REFERENCES value_rvk_subject(vid)
)


And the table is part of two views:

CREATE VIEW value_notation as
  SELECT vID, myvalue from value_swd_subject  UNION
  SELECT vID, myvalue from value_ddc_subject  UNION
  SELECT vID, myvalue from value_msc_subject  UNION
  SELECT vID, myvalue from value_pacs_subject UNION
  SELECT vID, myvalue from value_rvk_subject


create view lr_ClassificationEntry as
select rvk.vid as id, rvk.myvalue as notation,
rvk.parent, rvk.docfreq, sv.myvalue as description
from value_rvk_subject rvk, value_subject sv
where rvk.vid = sv.vid


> BTW: Why do you DEcrease (!) the performance by doing the from-select
> inside the subquery instead of doing this subquery:
> (select count(*) from lr_subject lrs, mb_lrmaintain
> where lrs.subjectidref=vrs.vid and
> mb_lrmaintain.published=1 and mb_lrmaintain.lridref=lrs.resourceidref)

Hmm, nice question ....
I can just guess that this query evolved while trying to work around the 
segfault. However, it keeps segfaulting. 

As you ask:
The query you are proposing is exactly the one we are using to circumvent the 
segfault ...

Bye,
Stephan

-- 
Stephan Fudeus                   Tel.: 0631/205-3577
Universitaet Kaiserslautern      Fax.: 0631/205-3188
Bereichsbibliothek Mathe/Physik

-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx