The following line: r = cnnctn.execute(insert(t), {'xkey': 'k1','yval':1}, {'xkey': 'k2','yval':2}, {'xkey': 'k3'})
Cause the following : INSERT INTO `A` (xkey, yval) VALUES (%s, %s) [['k1', 1], ['k2', 2], ['k3', 1]] i.e. the unspecified value in the 3rd dict is copied from the 1st one. This is quite surprising as I would have expected null() to be used in such cases. Is there a rationale behind this? Is there a way to have some non-full dicts as in the above example so that it will behave as I expected? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---