On 10/09/13 14:22 +0200, Nicolas Évrard wrote: > * Cédric Krier [2013-09-10 13:59 +0200]: > > >I would like to bring some light on this issue: > >https://code.google.com/p/python-sql/issues/detail?id=10 > > > >So I made a patch to use the table name as alias name for such queries > >but I would like to know if anybody has a better idea. > > I guess it was impossible to set an alias on t1 so that the alias in > the subquery was the one of t1 in the update statement, wasn't it?
SQLite doesn't allow alias for the updated table: https://www.sqlite.org/lang_update.html -- Cédric Krier B2CK SPRL Rue de Rotterdam, 4 4000 Liège Belgium Tel: +32 472 54 46 59 Email/Jabber: [email protected] Website: http://www.b2ck.com/
pgp45VejC8DuI.pgp
Description: PGP signature
