Re: New feather in IDS for NT version 7.3

In article <3i7YUDAoJ4W1Ew5v@smooth1.demon.co.uk>, David Williams <djw@smooth1.demon.co.uk> wrote: > > In article <3556DCB3.6E52@dati.lv>, Leonid Vorontsov > <Leonids.Voroncovs@dati.lv> writes > >The statement > > > > SELECT TABNAME TBNAME,OWNER CREATOR,TABTYPE TYPE,NCOLS COLCOUNT,'' > > REMARKS,"LABEL" LABELS from "informix".SYSTABLES T where > >(USER=T.OWNER or > > USER='informix' or exists(select GRANTEE from "informix".SYSTABAUTH > >where > > (GRANTEE= USER or GRANTEE='public') and TABID=T.TABID and > > (TABAUTH[1,1]='s' or TABAUTH[1,1]='S'))) and (TABTYPE = 'T') and > >not > > ((OWNER='informix' or OWNER='pcuser') and TABNAME in > > ('sysblobs','syschecks','syscolauth', > > 'syscoldepend','syscolumns','sysconstraints','sysdefaults', > > 'sysdepend','sysdistrib', 'sysfragments', 'sysindexes','sysopclstr', > > 'sysprocauth', 'sysprocbody','sysprocedures','sysprocplan', > > 'sysreferences','syssynonyms', 'syssyntable','systabauth', > > 'systables','systriggers','systrigbody', 'sysusers','sysviews', > > 'gtitables','gticonvert1','gticolumns', 'gtiextrtab','gtitabauth', > > 'gticolauth','gtisyssyntab','gtisynonyms', > >'gtiindexes','gticonvert2', > > 'gticonvert3','gticonvert4','gticonvert5', 'gtikeys')) ORDER BY > >TBNAME ASC; > > > >brings server down. > >Any comments? Leonid. ( Leonids.Voroncovs@dati.lv ) > > What does the online.log say? > > -- > David Williams > I've also tested this on 7.3 TC2. It freezes the engine! I could not even shut it down! Have to reboot the machine for it to work again Zandy -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading