Re: [sqlite] alter table, other alter category, fails in presence of trigger on 3.25.2

2018-10-04 Thread Thierry Henrio
Hello Keith, On Thu, Oct 4, 2018 at 1:16 AM Keith Medcalf wrote: > > Unrelated, but are you sure that you want the albums "id int primary key" > and did not happen to misspell "integer" so that the declaration should be > "id integer primary key". In the former case, id is an integer that just

[sqlite] alter table, other alter category, fails in presence of trigger on 3.25.2

2018-10-03 Thread Thierry Henrio
Hello, I want to report a bug, I checked https://www.sqlite.org/src/rptview?rn=8 and did not find the same? Let schema be: sqlite> .schema CREATE TABLE albums (id int primary key, title text, score int); CREATE TABLE rates (album_id references albums(id) on delete cascade, comment text, score