I noticed an odd behavior when inserting a record in a MySQL table. Given a table:
db.define_table('person', Field('name')) inserting some records without specifying the id returns the correct id: >>> db.person.insert(name='John') 1 >>> db.person.insert(name='Bill') 2 But specifying the id when the record is inserted does not: >>> db.person.insert(id=3, name='Fred') 2 >>> db.person.insert(id=10, name='George') 2 even though the records are inserted correctly: >>> print db().select(db.person.ALL) 1 John 2 Bill 3 Fred 10 George Is this unique to MySQL? Is this a bug or is there a logical reason for this? -Jim -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.