[Babase] Queries that run forever
Karl O. Pinc
kop at meme.com
Wed Apr 4 01:03:19 EDT 2007
Ah,
I think I see the problem.
I may have reloaded/changed the triggers/validation
in babase_copy but not changed the structure of the
groups table. (We went through a change in the
GROUPS.Permanent column a ways back.) The datatype
changed. This probably borked the triggers and
they run forever.
Let me see about fixing this.....
(FYI, sometimes the optimiser does not work so well
when the datatypes don't match up. That's a reason
to _not_ put numbers in quotes (unless they're going
into a text column -- which is why I tell people
to always put stuff in quotes so they don't have to think
about it.))
Karl <kop at meme.com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein
More information about the Babase
mailing list