Re: MATCHES problem

Posted in 1997

Ian Goddard — Mon, 13 Jan 1997 08:31:22 -0800 — source: Informix-list mailing list archive (1991-1998)

ACE wrote: > > I've encountered a serious error of INFORMIX-ONLINE v. 7.1x, 7.2x > on following platforms: > DYNIX/ptx, SCO UNIX, AIX, DEC OSF UNIX, IRIX, Solaris and HP/UX. > Construction: > select tabid from systables where tabname matches 'sys*' > shows with EXPLAIN ON: SEQUENTIAL SCAN> > select tabid from systables where tabname[1,3]='sys' > shows INDEX SCAN > (Indexes are not used even one use simple 'matches' phrase).> This error doesn't occur in versions 5.x of ONLINE. > Think about table with over 2,000,000 records. I thought about it. This would mean you have 2,000,000 tables in your database. Wow! Ian