Change primary key value

[MartinMuzatko]

• Related Issues: How to change id? #484

Introduction

We tried to update the id (primary key) of a model.

Issue Description

model.forge({id: 1}).save({id: 2}, {method: 'update'})

I get this error:

error Error: Empty .update() call detected! Update data does not contain any values to update. This will result in a faulty query. Table: DeviceInstances. Columns: .
    at QueryCompiler_MySQL._prepUpdate (server/node_modules/knex/lib/query/compiler.js:822:13)
    at QueryCompiler_MySQL.update (server/node_modules/knex/lib/dialects/mysql/query/compiler.js:24:26)
    at QueryCompiler_MySQL.toSQL (server/node_modules/knex/lib/query/compiler.js:64:29)
    at Builder.toSQL (server/node_modules/knex/lib/query/builder.js:77:44)
    at server/node_modules/knex/lib/runner.js:31:36
    at server/node_modules/knex/lib/runner.js:260:24

we also experimented with {patch: true} and {required: false}
No Luck

Steps to reproduce issue

model.forge({id: 1}).save({id: 2}, {method: 'update'})

Expected behaviour

it should perform this SQL statement:

UPDATE model SET id=2 WHERE id = 1

Actual behaviour

Error. See above