Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | UPDATE triggers on TEMP tables were broken. (CVS 693) |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
c080ed01ea51628b86050762f097e702 |
User & Date: | danielk1977 2002-07-21 23:09:55.000 |
Context
2002-07-30
| ||
17:20 | Fix for ticket #71: Correctly handle CR and CRLF line terminators in the input files for the COPY command. (CVS 694) (check-in: be1315755e user: drh tags: trunk) | |
2002-07-21
| ||
23:09 | UPDATE triggers on TEMP tables were broken. (CVS 693) (check-in: c080ed01ea user: danielk1977 tags: trunk) | |
2002-07-19
| ||
19:04 | Version 2.6.1 (CVS 691) (check-in: 610b7bc70a user: drh tags: trunk) | |
Changes
Changes to src/update.c.
︙ | ︙ | |||
8 9 10 11 12 13 14 | ** May you find forgiveness for yourself and forgive others. ** May you share freely, never taking more than you give. ** ************************************************************************* ** This file contains C code routines that are called by the parser ** to handle UPDATE statements. ** | | | 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 | ** May you find forgiveness for yourself and forgive others. ** May you share freely, never taking more than you give. ** ************************************************************************* ** This file contains C code routines that are called by the parser ** to handle UPDATE statements. ** ** $Id: update.c,v 1.49 2002/07/21 23:09:55 danielk1977 Exp $ */ #include "sqliteInt.h" /* ** Process an UPDATE statement. */ void sqliteUpdate( |
︙ | ︙ | |||
214 215 216 217 218 219 220 | sqliteVdbeAddOp(v, OP_OpenTemp, newIdx, 0); 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); | | | 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 | sqliteVdbeAddOp(v, OP_OpenTemp, newIdx, 0); 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, (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 ){ sqliteVdbeAddOp(v, OP_Recno, base, 0); }else{ |
︙ | ︙ |
Changes to test/trigger2.test.
︙ | ︙ | |||
50 51 52 53 54 55 56 57 58 59 60 61 62 63 | set testdir [file dirname $argv0] source $testdir/tester.tcl # 1. set ii 0 foreach tbl_defn [ list \ {CREATE 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; } catchsql { DROP TABLE rlog; | > | 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 | set testdir [file dirname $argv0] source $testdir/tester.tcl # 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; } catchsql { DROP TABLE rlog; |
︙ | ︙ |