[sqlite] Problem with sqldiff

Richard Thanks. That gives me what I would expect. John Gillespie sqlite-src-30902T 573 % ./sqldiff z1.db z2.db ALTER TABLE A ADD COLUMN category; UPDATE A SET category='' WHERE rowid=1; UPDATE A SET category='' WHERE rowid=2; UPDATE A SET category='' WHERE rowid=3; On 7 November 201

[sqlite] Problem with sqldiff

I saw sqldiff mentioned and decided to try it (compiled from sqlite-src-3090200) and got an SQL error. ./sqldiff: SQL statement error: near "1": syntax error "SELECT B.rowid, 1, -- changed row A.id IS NOT B.id, B.id, A."desc" IS NOT B."desc", B."desc" FROM main.A A, aux.A B WHERE

[sqlite] Problem with sqldiff

On 11/7/15, John G wrote: > I saw sqldiff mentioned and decided to try it (compiled from > sqlite-src-3090200) and got an SQL error. > Please try the latest trunk version (https://www.sqlite.org/src/artifact/37ab2cd4f0c8b4f0) and let us know if that fails to solve your problem. -- D. Richard Hi