Warren Volz <[EMAIL PROTECTED]> writes:
> p debug_query_string output:
> $1 = 0x820caa0 "DELETE FROM session WHERE session_key =
> 'bRUjmnqcb5prUNRE.Bb0sq+fZB69dkdVlCAKNBsb'"
BTW, do you have rules or triggers on that table? The backtrace shows
the system executing a nestloop join, which impli
Tom,
Yeah, there is a trigger. Here are the relevant bits of the schema,
followed by the output of EXPLAIN VERBOSE on a similar query.
Thanks,
Warren
--
-- Table structure for table 'session'
--
CREATE TABLE session (
session_key CHAR(40) PRIMARY KEY,
sis_user_id
Okay, I've extracted a reproducible test case from Warren's info:
Setup:
CREATE TABLE sis_user (
sis_user_id INTEGER PRIMARY KEY,
last_visit DATETIME NOT NULL DEFAULT TEXT 'now');
CREATE TABLE session (
session_key CHAR(40) PRIMARY KEY,
sis_user_id
