SQLite Forum

update-from on without rowid virtual tables
Login
Thanks for the quick patch, I have incorporated and still can't get it to work (see other post).

I've done some debugging now, and think the problem is that sqlite3_value_nochange does not appear to be working as I am expecting in the case of the update from.

The vtab is declared as

```
create table t (name text, old_name text, value text, primary key(name)) without rowid
```

Specifically, when I do the normal update which works, I get the following args to xUpdate

```
Update arg 0 (nochange: 0): 'XMLFilePrecision'
Update arg 1 (nochange: 1): NULL
Update arg 2 (nochange: 1): NULL
Update arg 3 (nochange: 1): NULL
Update arg 4 (nochange: 0): '8'
```

(Note, this is an update with arg1 as null, see [](https://marc.info/?l=sqlite-users&m=156570172529056&w=2))

When I do the update from, I get the following args to xUpdate

```
Update arg 0 (nochange: 0): 'XMLFilePrecision'
Update arg 1 (nochange: 0): 'XMLFilePrecision'
Update arg 2 (nochange: 0): 'XMLFilePrecision'
Update arg 3 (nochange: 0): ''
Update arg 4 (nochange: 0): '8'
```

The args themselves are correct in value - as in the new value of the row would be correct, but I am expecting sqlite3_value_nochange to return true for both args 2 and 3, because those columns haven't changed by the update.