[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. >>

[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