[sqlite] sqldiff ---primarykey bug

2015-12-01 Thread Stuffer Oskar
On 11/30/2015 06:54 PM, Richard Hipp wrote: > On 11/30/15, Stuffer Oskar 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

[sqlite] sqldiff ---primarykey bug

2015-12-01 Thread Stuffer Oskar
> 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. You are right, the patch I suggested is already implemented at

[sqlite] sqldiff ---primarykey bug

2015-11-30 Thread Stuffer Oskar
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. For example: UPDATE tt_dati SET codCommerciale='555' WHERE

[sqlite] sqldiff ---primarykey bug

2015-11-30 Thread Richard Hipp
On 11/30/15, Stuffer Oskar 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