Instruction increment trigger may be broken

[mikfire]

I think there's a bug in the database triggers. The auto increment trigger looks like this:

  CREATE TRIGGER inc_ins_num AFTER INSERT ON instruction_in_recipe
  BEGIN
     UPDATE instruction_in_recipe SET instruction_number =
        (SELECT max(instruction_number) FROM instruction_in_recipe WHERE recipe_id = new.recipe_id) + 1
        WHERE rowid = new.rowid;
  END;

I suspect the problem is that there is no column named "rowid". I have no idea if there is an impact from this. I am deep in an interesting idea, or I would otherwise stop and fix it myself.

[rocketman768]

It would be weird if this were not a bug. I'm pretty sure everything in the database is keyed by a field named "id".

[ghost]

In sqlite3 rowid is a special column and is always created by default and doesn't show with .schema command.

[mikfire]

This seems to be working as expected. I will close the bug.