Effectively, Sorry about my mistake.
2016-08-17 10:33 GMT+02:00 Richard Hipp <d...@sqlite.org>: > On 8/17/16, flo <der.nair...@gmail.com> wrote: > > > > $ sqlite3 test.db "UPDATE test SET id=0 AND name='new_name' AND age=30 > > WHERE id=1;" > > The above is parsed like this: > > UPDATE test SET id = (0 AND name='new_name' AND age=30) WHERE id=1; > > And since the expression in parentheses always evaluates to 0, the > above is equivalent to: > > UPDATE test SET id=0 WHERE id=1; > > Which is exactly what SQLite is doing. > > -- > D. Richard Hipp > d...@sqlite.org > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
