The table aliases must be unique. ("rowid/$i as id")

[moisseev]

The id alias is used in SELECT query as a local variable. Since it has the name that very common to a column name, it results in alias/column name duplication.

https://github.com/moisseev/sqlite3-rdiff/blob/master/sqlite3-rdiff#L105 There are several lines like that.