Index: src/update.c
==================================================================
--- src/update.c
+++ src/update.c
@@ -10,11 +10,11 @@
 **
 *************************************************************************
 ** This file contains C code routines that are called by the parser
 ** to handle UPDATE statements.
 **
-** $Id: update.c,v 1.48 2002/07/16 17:22:51 drh Exp $
+** $Id: update.c,v 1.49 2002/07/21 23:09:55 danielk1977 Exp $
 */
 #include "sqliteInt.h"
 
 /*
 ** Process an UPDATE statement.
@@ -216,11 +216,11 @@
     sqliteVdbeAddOp(v, OP_ListRewind, 0, 0);
     addr = sqliteVdbeAddOp(v, OP_ListRead, 0, 0);
     sqliteVdbeAddOp(v, OP_Dup, 0, 0);
 
     sqliteVdbeAddOp(v, OP_Dup, 0, 0);
-    sqliteVdbeAddOp(v, OP_Open, base, pTab->tnum);
+    sqliteVdbeAddOp(v, (pTab->isTemp?OP_OpenAux:OP_Open), base, pTab->tnum);
     sqliteVdbeAddOp(v, OP_MoveTo, base, 0);
 
     sqliteVdbeAddOp(v, OP_Integer, 13, 0);
     for(ii = 0; ii < pTab->nCol; ii++){
       if( ii == pTab->iPKey ){

Index: test/trigger2.test
==================================================================
--- test/trigger2.test
+++ test/trigger2.test
@@ -52,10 +52,11 @@
 
 # 1.
 set ii 0
 foreach tbl_defn [ list \
 	{CREATE TABLE tbl (a, b);} \
+	{CREATE TEMP TABLE tbl (a, b);} \
 	{CREATE TABLE tbl (a INTEGER PRIMARY KEY, b);} \
         {CREATE TABLE tbl (a, b PRIMARY KEY);} \
 	{CREATE TABLE tbl (a, b); CREATE INDEX tbl_idx ON tbl(b);} ] {
   incr ii
   catchsql { DROP INDEX tbl_idx; }