[BUGS] query execution time

2000-11-30 Thread Gena Gurchonok
Hello I've found a strange behavior in query execution: I have really big table fti_author (>4 000 000 records) and i want to find ID intersection of ones contain '^clarke' and '^arthur' I've created 2 methods 1 select all with '^clarke' into temp table select intersection of ones with '^arth

Re: [BUGS] Both cross-named & compound foreign key constaints fail

2000-11-30 Thread Stephan Szabo
Okay. On current sources, this seems to work with only a few changes. You need unique or primary key constraints on the columns being referenced (this is part of the spec but was not checked in 7.0) A couple of other things, currently constraints don't inherit very well. So, you'd probably wan

[BUGS] Cross-named & compound foreign key constraints fail

2000-11-30 Thread Steffen C. Hulegaard
/* $Id$ + | No Copyright. Public Domain. + | | bug.sql Cross named and compound foreign key constraint bug test | | Description: Run this

[ADMIN] Support for SQLkit

2000-11-30 Thread Karla Peralta
Hi, I have a little problem with SQLkit and I don't know who can help me, I sent a mail to the programer Thomas Griffin <[EMAIL PROTECTED]> but it doesn't exist. Anyone knows something about it ?? Any way, I'll send a description of the problem: I have a diskless system. This is what I have:

[BUGS] Both cross-named & compound foreign key constraints fail

2000-11-30 Thread Steffen C. Hulegaard
/* $Id$ + | No Copyright. Public Domain. + | | bug.sql Cross named and compound foreign key constraint bug test | | Description: Run this