On 11/30/15, Stuffer Oskar <oskar at sad.it> wrote: > Hallo, > > I'm using the sqldiff tool with the --primarykey option to generate a diff > between two databases > with the "WITHOUT ROWID" optimization. > sqldiff from sqlite 3.9.1 and 3.9.2 produces SQL statements with an > incorrect WHERE clause. > > > In the attachment you will find my fix to the > sqlite-src-3090100/tool/sqldiff.c file that solves this problem. >
This mailing list strips attachments. But I wonder your suggested patch has not already been implemented at https://www.sqlite.org/src/info/e0ed4c3e376248df - can you check and see please. Better still, recompile using the latest sqldiff.c sources from https://www.sqlite.org/src/artifact/653db1a9294e0b34 -- D. Richard Hipp drh at sqlite.org