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 | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: | c080ed01ea51628b86050762f097e702e3aeafdf |
| User & Date: | danielk1977 2002-07-21 23:09:55 |
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: be131575 user: drh tags: trunk | |
|
2002-07-21
| ||
| 23:09 | UPDATE triggers on TEMP tables were broken. (CVS 693) check-in: c080ed01 user: danielk1977 tags: trunk | |
|
2002-07-19
| ||
| 19:04 | Version 2.6.1 (CVS 691) check-in: 610b7bc7 user: drh tags: trunk | |
Changes
Changes to src/update.c.
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
...
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
|
** 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.48 2002/07/16 17:22:51 drh Exp $ */ #include "sqliteInt.h" /* ** Process an UPDATE statement. */ void sqliteUpdate( ................................................................................ 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, 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{ |
|
|
|
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
...
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
|
** 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( ................................................................................ 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;
|