I agree this is strange but this seems a database problem to me.
On Nov 19, 6:49 am, Hans Murx <murxun...@googlemail.com> wrote:
> Hi,
>
> given this legacy informix table:
> ~~~~~~~~~~~~~~~~~~~~~~~
> create table kperson
> (
> name varchar(80, 1) not NULL,
> age integer not NULL,
> primary key (name)
> );
>
> I did:
> ~~~~>>> db.define_table("kperson",
>
> ... Field("name"),
> ... Field("age"),
> ... primarykey=["name"],
> ... migrate=False
> ... )
>
> Inserting one row:
> ~~~~~~~~~~~~~>>> db.kperson.insert(name="Oli1", age=23)
>
> {'name': 'Oli1'}
>
> Ok!
>
> inserting another row:
> ~~~~~~~~~~~~~~~~>>> db.kperson.insert(name="Oli2", age=23)
>
> {'name': 'Oli2'}
>
> Ok!
>
> trying to update the first row:
> ~~~~~~~~~~~~~~~~~~~~~>>> db(db.kperson.name=="Oli1").update(name="Oli2")
>
> Traceback (most recent call last):
> File "<console>", line 1, in <module>
> File "/root/web2py-1439/gluon/sql.py", line 3091, in update
> self._db._execute(query)
> File "/root/web2py-1439/gluon/sql.py", line 1086, in <lambda>
> self._execute = lambda a: self._cursor.execute(a[:-1])
> IntegrityError: SQLCODE -268 in EXECUTE:
> 23000: Integrity constraint violation
> IX000: ISAM error: duplicate value for a record with unique key.
>
> Ok, this IntegrityError was expected, because we tried to update name
> to a value that already existed in the table.
>
> But trying to insert a row with an already existing name:
>
> >>> db.kperson.insert(name="Oli2", age=23)
>
> does not give an error message at all - although the same constraint
> violation occurs!?
>
> Why is there no IntegrityError exception raised in this case? Same
> strange behavior with appadmin: you can 'insert' new rows with
> appadmin that violate constraints and therefore are not really
> inserted into the table without even getting an error message. I don't
> think that this behavior is consistent.
>
> Regards
>
> Hans
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
