ROWID is a reserved word in SQLite which seems reasonable.. but it has a synonym OID so if you declare a table with a column called OID then select from that table without using the table name as a prefix, you will not get what you expect.
If you are using an ORM to abstract away the database then you may never realise what is going on..
No comments:
Post a Comment