update_ref_self_pk

Query: UPDATE self SET id = 9 WHERE id = 1
Error: InvalidInput("row referenced by self.self_id for self.id=2")

Storage:
CREATE TABLE self (
  id INTEGER PRIMARY KEY,
  self_id INTEGER DEFAULT NULL INDEX REFERENCES self,
  value STRING DEFAULT NULL
)
[Integer(1), Integer(1), String("a")]
[Integer(2), Integer(1), String("b")]
[Integer(3), Integer(3), String("c")]
[Integer(4), Null, String("d")]

Index self.self_id
Null => [Integer(4)]
Integer(1) => [Integer(1), Integer(2)]
Integer(3) => [Integer(3)]