AW: repeatable signal 11 on update query

Stephan Fudeus wrote:
> 
> Hi,
> 
> I just tried that reproduceable segfault again I tried with 7.5.0.18
and
> no one commented on and it happened again with 7.5.00.23.
> 
> The stacktrace is attached.
> The query that causes the trace was the same as quoted.
> 
> Environment this time:
> Linux i686 2.6.10 SMP
> KERNEL    7.5.0    BUILD 023-121-087-292
> 
> Regards,
> Stephan
> 
> 
> 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?

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)

Elke
SAP Labs Berlin


> >

> > Please see the attached stacktrace.
> >
> > Environment:
> > Linux i686 2.6.8.1 SMP
> >
> > Kernel: MaxDB Kernel    7.5.0    Build 018-121-079-776
> > Driver: MaxDB JDBC Driver, MySQL MaxDB, 7.6.0    Build
000-000-003-034
> >
> > packaged as maxdb-all-linux-32bit-i386-7_5_00_18.tgz
> >
> 
> --
> Stephan Fudeus                   Tel.: +49 631 205-3577
> TU Kaiserslautern                Fax.: +49 631 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